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 |
|
rodniko
Starting Member
1 Post |
 Posted - 2006-08-13 : 09:26:38
|
| I work with Microsoft visual studio 2005.i get data from a table by ADO.NET :SqlConnection sqlConn = new SqlConnection(strConnectionString);sqlConn.Open();.....it works fine.but when i open the SQL Server 2005 express edition and connect to the server (inside the same computer) and run the code again ,the Open() function fails with the exception :Cannot open user default database. Login failed.disconnecting the server doesn't help and even closing the SQL Server 2005 application doesn't help.Only restarting the computer enables the Open() command to work again.Why ? |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-08-14 : 06:37:21
|
| my guess would be that your default database (for the user you log onto SQL Server 2005 express edition with) no longer exists.For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
error: Cannot open user default database