Unable to open any databases (Microsoft SQL SERVER, Error 4046)

I tried login with the master and tempdb databases and alter the login using the below command:

Use master
GO

ALTER LOGIN [MonitorDB] WITH DEFAULT_DATABASE = TempDB
GO

Any suggestion. Thanks

September 11th, 2015 4:27pm

Have you tried using the GUI?  Right click the login.  Click on Properties and update the database default?
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 4:33pm

Could you describe you problem in detail? There is not much information in your post. Also, I can't find any error 4046 in sys.messages. Please include the full error message you get - and what you are trying to do when you get it.

September 11th, 2015 5:07pm

ALTER LOGIN [MonitorDB] WITH DEFAULT_DATABASE master
GO

check and confirm.

Free Windows Admin Tool Kit Click here and download it now
September 12th, 2015 3:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics