>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