March 12, 2013 at 8:36 am
Any idea on this?
user is part of active directory and has windows authentication and still getting this error....any thoughts?
master is default db..
from sql error log : sql error 18456 severity 14 state 16
thanks
--------------------------------------------------------------------------------
March 12, 2013 at 8:46 am
Double-check the login's default database. Error message is saying it's not available.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2013 at 8:52 am
I checked and master is default db and is there...
any idea?
March 12, 2013 at 10:43 am
Is the user a member of any groups that have logins in the database with different default databases?
In fact, check all the logins, see if any have a default database that no longer exists.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2013 at 10:51 am
Does this login have access to master? They have to be mapped to a user (or guest).
I might change it to a database that they have access in, say the one for an application.
March 12, 2013 at 12:31 pm
In fact, check all the logins, see if any have a default database that no longer exists.
I don't know if you were able to resolve this yet, but I think Gail's advice here is a good query to run and review every so often.
SELECT sl.name
FROM master.sys.server_principals sl
WHERE NOT EXISTS (SELECT 1
FROM sys.databases sd
WHERE sd.name = sl.default_database_name)
AND sl.type = 'S'
ORDER BY sl.name;
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy