Posts

Analysis Services Guidance Package and VSTemplate

i trying build ssas guidance package department @ work roll out new project items common analysis services project build. add recipes can used in specific instances. see vstemplates <projecttype> expecting csharp/visualbasic/jsharp/web. know if there vstemplate ssas? after research in file system , documentation conclude creation of ssas projects done using vsdir/vsz technology , not using vstemplates , suchlike. relevant files seem in folder c:\program files\microsoft visual studio 9.0\common7\ide\privateassemblies in subfolders such "business intelligence projects" , "business intelligence wizards" , "projectitems/analysisservicesproject". therefore not hoping find official or semi-official guidance package artifacts govern creation of ssas projects. SQL Server  >  ...

Instant file initialization with TDE

hi, tde disables instant file intialization. https://support.microsoft.com/en-us/kb/2574695 i tested on sql server 2012 enterprise edition. adding 5gb existing database file takes 50 milliseconds instant file initialization. after enabling tde on database, same operation takes 20 seconds. any workarounds? any plans make faster? karoly károly tde encrypts data @ rest data on disk , take time obvious. tde encrypt  data , log file stored on disk @ page level.  this tde overhead, not aware of ways remove , imo cannot. cheers, shashank please mark reply answer if solved issue or vote helpful if helped other forum members can benefit my technet wiki articles mvp SQL Server  >  SQL Server Security ...

Using the PivotViewer Control on SharePoint?

i've been using awesome pivotviewer control @ work data visualization, , want deploy company intranet.  i'm not trying dynamic yet, can't figure out how load pivotviewer collection onto server such silverlight app can see it. i've tested silverlight webpart simple 'hello world' app, , got work, can't figure out how load data external xap sharepoint, or how load cxml , deepzoom images in first place. what best practice here?  is there other way load pivotviewer data sharepoint, or need hosted separately, locally iis? sincerely, brett where will data comes data? data sharepoint list? if sharepoint list worth have in sharepoint. if data in sql plain sl iis fast enough. if data sql sharepoint act role of iis of sharepoint features cannot used. so decision based on datasource is. Silverlight  >  ...

Rda - User Account what

hi!   i'm using rda windows mobile. on developer computer i've set anonymous authentication against iis. want set real. access should rdauser account have that use in iis to be able work correct against sql server 2005? user group preveliges ok? in sql server 2005 need add rdauser server logins , map against database?   /magnus are using integrated authentication or sql server authentication rda user? if sql server security, sql server account in rda remoteconnectionstring passed on database server. SQL Server  >  SQL Server Compact

I can't write data to sql 2005

  i have big problem now, can me? i have program used asp+sql2000 ,the connection string : strconnection = "provider=sqloledb;server=boun\windows,1005;user id=training;password=training22;database=ourtraining;" everything works fine, can insert data, delete or modify. but since changed sql2000 server sql 2005 express, can read data can't insert data(write data sql 2005) i checked permission correct on sql 2005, program correct, looks good, can't write data sql2005     can me???? you have changed database schema. here's problem:   error details:- microsoft ole db provider sql server cannot insert value null column 'thread_id', table 'windtraining.dbo.tblthread'; column not allow nulls. insert fails. table tblthread not allow null inserted thread_id. believe primary key column. please check application/database consistency: either make sure application not trying insert null or allow nulls inserted in column ...

Unable to Remotely login into member servers 2008 R2

i have made server 2008 r2 memeber server of 2008 r2 domain (all set vertual mechine test lab in our organaization) when trying login remotely my desktop (this desktop belongs company network , domain ---this company network have access in vertual network) 1.when trying login local server accont   posible 2.when trying login vertual domain account .it not directly login server rather that  fisrt  geting local authentication windows after succesvely login that  server 2008 login window .so have use swtch user then  domain\username ... password   able get  domain account desktop. could sugest solution done following things also 1.1.created  smsadmin user 2.create  sccm  group 3.added sccm group administrators group 4.added sccm group remote desktop users 5.added sccm group remote desktop option in memebre server finaly 6.enabled "allow log on locally policy" 7.enabled remote de...

policy problems with screen saver policy

hello. i have read 100 posts on technet , other places issue. client needs security compliance have computers ask password after 15 minutes of inactivity. going set screen saver settings in gpo. testing have ou test user in it. create new gpo "enable screen saver - enabled", "password protect screen saver - enabled", "screen saver timeout - enabled", "number of seconds wait enable screen saver - seconds: 900". policy enabled , linked. run gpupdate / force @ test user command prompt. know settings being applied because settings set in control panel grayed out , showing should be. registry hive showing correct settings. "screensaveactive 1", "screensaverissecure 1", "screensavetimeout 900". screen saver never engages. has missing. have ideas? thanks jeff tucker engineer hi  what dc os , client os? if dc 2008 r2 , client win7 check these one https://support.microsoft.com/en-us/kb/2616727 a...