OK, I've installed SQL 2k5, and I'm sure I selected Advanced>Samples
however I cannot see the AdventureWorks database attached.
I have tried opening SQL Server manager>right click on databases>Attach>Add but this only brings up a Folder explorer, not a file explorer.
I can navigate to where the AdventureWorks samples are but SQL Server manager is not able to attach them because it is a Folder explore. also, I have the samples in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data but I am only able to browse to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\
How then can I attach the database?
(later on...) Ok I still cant browse to the Data directory, but I copied the contents of this directory into its parent directory which I can browse to. I still could not see the files in the directory because it is a tree view with no way to see files, so I typed in the name of the AdventureWorks database that I wanted to attach.
Then I got a permissions error - I wasnt able to attach the DB even though I had connected using windows permissions.
This is really starting to frustrate me - I have wasted many hours on something that should be straight forward.
You should find the sample Db under the following directory.
C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP
|||See the book online section:
It contains detailed steps to get the AdventureWorks DB samples installed.
|||The sample db is in 90\Tools location ok but I seem not to get the step 9. in the Setup post installation procedure which says
"To install and attach the sample databases, from Sample Databases Setup, select Install and attach sample databases, and then click Next.
The database files are created and stored in the folder <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. The database is attached and ready for use."
(there's just a cert in MSSQL.1\MSSQL\Data)
No comments:
Post a Comment