SQL Server:Cannot open user default database

programming
1

Hello.

My problem conserns Microsoft SQL Server.
When I try to connect SQL Server get the error message : "Cannot open user default database"
What is it?
Can anyone suggest me for SQL database fix?

Regards,
Garry

2

can anyone help me??

3

Hi GarryWitt.
The user default database is unavailable at the time of connection. It is possible that the database is in suspect mode or no longer exists. To avoid the error when the user’s default database is unavailable, try to log on as a user who can modify logins. Then, change the user’s default database to a database that is currently available for a connection. If it useless try a special tool - SQL Server Fix Toolbox.
https://www.fixtoolbox.com/sqlserverfix.html
It recovers databases of SQL Server format.

Good luck

1 Like
5

Thanks for helpful info friend