My problem is connected to the SQL Server Enterprise Managager. I worked with it for a day testing a database attaching/detaching it and after I closed the Manager the following problem occured.
The local database seems to be dissapeared. However, the applications through the network reach it because they can open it and modify it etc. When I open the EM and press the connect on the SQL server group it drops en error.
"The connection cannot be established to (LOCAL).
Reason: Cannot open user default database. Login failed.
Please verify SQL Server is running and check your SQL server registration properties"
The strangest thing that nothing seems to be changed at all there. We used Windows authentication for years now, the SQL server group is set at the Server group.
My aim would be to reach the live databases through this console again, but I do not know what should I do. I have been searching for the solution for days now.
Similar things happen if I try to open the Query Analyzer. Error message:
"[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open user default database. Login Failed".
What should I do? Make another server registration? What will happen with the current one?
Sorry for opening a new thread about my problem but I did not found another one similar to this. If it may happen, please ignore the upper text and link the forum topic here.
Thank you for your patience and understanding!