| Author |
Topic |
|
frpsqlserve
Starting Member
6 Posts |
 Posted - 2010-09-22 : 12:00:17
|
| Hello, I am developing an application using SQL Server 2008 Express and C# Express. Everything works fine until I use the Management Studio to work with the database (queries, etc). After using the Management Studio for any reason, I need to restart SQL Server even though the indication is that it is already started. I've worked with full versions of SQL Server and C# and have not encountered this problem. Thank you for the help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frpsqlserve
Starting Member
6 Posts |
Posted - 2010-09-22 : 13:03:11
|
| Sorry about the lack of details... the application works - it connects to the database - during testing. If I use the Management Studio for any reason, I need to restart SQLEXPRESS or else the application indicates it cannot connect to the database. When I use the Configuration Manager to restart SQLEXPRESS, it indicates it is already started. I re-start it, and everything is fine again. Thank You for the help. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frpsqlserve
Starting Member
6 Posts |
Posted - 2010-09-22 : 13:44:39
|
| The error received in C# Express, when the application attempts to connect with the database is:"Cannot open user default database. Login failed. Login failed for user "sysadmin121\sysadmin62".There is nothing in the SQL Server Express error log. All connections appear correct. Again, when I restart SQLEXPRESS, all is well... Thank You! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frpsqlserve
Starting Member
6 Posts |
Posted - 2010-09-22 : 13:52:48
|
| not sure how to reset the default... I'm working on it... Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frpsqlserve
Starting Member
6 Posts |
Posted - 2010-09-22 : 14:13:04
|
| It was already set to Master, so I set it to the application's database I created. I had to restart SQLEXPRESS, this time it made no difference... the application failed. I reset the default to Master, and again had to restart SQLEXPRESS, before the application executed without error..Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
frpsqlserve
Starting Member
6 Posts |
Posted - 2010-09-22 : 14:28:42
|
| Very wacky is the truth .... I'll be working away to solve it though... Thank You very much for the help! |
|
|
|
|
Need to restart server