Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BellaScout
Starting Member
25 Posts |
 Posted - 2009-02-20 : 16:38:02
|
| 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 herehttp://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/ec9f1ded-1b9e-476d-acd9-77caf79a47b4/but unfortunately for me, none of the suggestions in that post work!Would appreciate any help any one can give. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Authentication within SQLExpress Not Able to C