I detached a database from sql server 2005 to an mdf file. I am able to logon to this mdf file from server management studio within sqlexpress instance using the sql user/pwd with no problem.
Within Visual Studio however, if I try to connect useing ÃÂ the Server Explorer, I receive the error:
"Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed."
I went into Advanced Properties and changed User Instance to False, and then get this error:
"Create Database Permission denied in database "master". An attempt to attach an auto-named database for file "c:\......mdf" failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I opened the database again in management studio and detached it from sqlexpress, but still get same errors.
This issue is similar to the one posted here
but unfortunately for me, none of the suggestions in that po
View Complete Post