lyn.buchanan (3/28/2014)
Why would you point users to the master database = only administrators should be able to access that database.
What a nonsence!
Everybody has access to master database by default.
If the default database doesn't exist or is unavailable you will fail to login.
What will happen if you are working with two different applications and its databases are on the same server?
Lets say your default database is the db from app1
Now it crashes. What will happen when you start app2?
Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)