I have a user set up for readOnly privileges to the database. He was running SQL 2000 Query Analyser but could not login to the database even though he had all of the appropriate permissions. So, one suggestion was to upgrade to SQL Server Management Studio. Now we get the following:
Error: 4064 – Cannot open user default database. Login failed. Login failed for user
I have found a workaround by doing the following:
First click on Option>> Button of “Connect to Server” Prompt.
Now change the connect to database to any existing database on your server like master or msdb.
However, is there anything dangerous about changing this setting to <Master>?
I read a forum that this should resolve the issue however after login in under <Master> it also says to do the following:
Once you login in the system run following statement for your username and it should fix your problem. Make sure to replace [test] with your username and master with yourdatabase name.
Is there anything that can go wrong? I am getting confused as to what MASTER database the user will connect into. Thanks in advance.d