I am unable to attach adventureworks to sql mgmt studio 2005 because of 916 error.
I have SQL Server Management Studio Express 2005. I am trying to learn SQL at home instead of at work so needed a server so I downloaded:SQLEXPR_ADV. After I was able to connect to the newly installed server I downloaded and ran AdventureWorksLT_x64 and AdventureWorksDBCI_x64. I right click on the databases from object explorer and click add, where I get stuck with a 916 error. I have Windows 7, have read multiple threads in a number of places but can not seem to get through this part. I am frustrated as I already know a fair amount of SQL coding, but can not even get a sample db set up to practice on. Any help would be greatly appreciated. Thanks
Error 916 is a permissions error and is not specific to the AdventureWorks databases. Please verify that the account name returned in the error has read permissions on the database data and log files (.mdf and .ldf). In addition, you might try posting a question to the SQL Express forum specifically about error 916.
Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights