So I do not think it already had another instace and for some reason I can't see it under Databases when I expand the tree. This is the new instace of Express edition I downloaded and this is the first time I am trying to attach the AdventureWorks datbase I am trying to attach the database to Sql server instance under 'Databases' in my Sql Express Management Studio. What this means and where and what option I need to check to satisfy this condition. When I searched online I see that I need to make sure that an account Sql Server runs under has permission on 'Microsoft Sql Server\MSSQL.1\Data\AdventureWorks_Data.mdf' and this could be done in Configuration Manager. ()ĬREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf'. ()Īn exception occurred while executing a Transact-SQL statement or batch. TITLE: Microsoft SQL Server Management Studio Expressįailed to retrieve data for this request. I am getting this message when I try to attach I have downloaded the AdventureWorks database and now I am trying to attach it to my instance of Sql Server 2005 Express edition but no luck with it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |