When I try to connect SQL Server I get this error: database cannot be opened
I'm hoping someone here has experience in this and knows how to make sql db fix
The solution to log on is: From the Connect to Server dialog, click Options. Change value of Connect to database: to any valid database on the server. The permanent solution to fix the server is to run SQL like: ALTER LOGIN [test] WITH DEFAULT_DATABASE = master GO. Other method to troubleshoot this is - https://www.fixtoolbox.com/sqlserverfix.html