What should be the owner of the sample databases installed by SQL Server 2008
-
11 April 2009 4:58I have installed the sample databases using SQL2008.AdventureWorks_All_Databases.x86.msi from http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407.
The AdventureWorksAS2008 and AdventureWorksAS databases are not installed. Are they installed only if Analysis Service is installed?
All the other sample databases installed are owned by NT AUTHORITY\SYSTEM. Is this by design or did I miss a step in the installation which I suppose to provide the owner info?
Semua Balasan
-
13 April 2009 15:59 With the SR1 version of the installers, the AS cubes are not created automatically (neither standard and enterprise versions, nor 2005 or 2008). We plan to change this with the SR2 version of the installers which are in development now, along with lots of bug fixes to the product samples and documentation.
If you have AS installed, you will have to manually deploy and process them using BIDS.
The database owner is the account which was used to create the databases. Because it's most likely that you executed the the MSI without prior elevation, the SQLCMD process which created the databases via a trusted connection defaulted to SYSTEM as the owner. You're welcome to change the ownership, if you wish.
David Reed - MSFT - Microsoft Certified Architect|SQL Server - http://blogs.msdn.com/reedme/- Ditandai sebagai Jawaban oleh David Reed - Glacier Peak 13 April 2009 16:00
