Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Attach database error
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01464705
Message ID:
01464778
Views:
24
>I wanted to move a database from one computer to another. I detached the database on one; copied to the drive on the other.
>
>Then on the one where I want to attach database, I do the following:
>Open SSMS -> Databases -> Right Mouse click > Attach.
>On Attach window I click on Add (thinking that it should let me navigate to the folder where I saved the database files). But get error:
>Failed to retrieve data for this request.
>The server principal "PCName/Dmitry"is not able to access the database "model" under the current security context.
>
>What am I missing? TIA.

Why are you trying to attach and detach Model database? I would understand doing it with user's database, but why Model?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform