Hi All , I have one Domin user and which have SYSDMIN Permission on SQL Sevrer instance but i am gettin the login failure message Message Login failed for user 'USASTELLAS \ SQLAdmin'. [CLIENT:> 10.202.1.54] Error: 18456, Severity: 14, State: 16. Can any one has idea why this alert is cooming.. Thanks Basit Khan
State 16 (
http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx) means that the default database assigned to the user is not accessible - I suggest you review the default database for that login, and either change it to an accessible database, or make the inaccessible database accessible. > State 16, which only occurs prior to SQL Server 2008, means that the default database was inaccessible. This could be because the database has been removed, renamed, or is offline (it may be set to AutoClose). This state does not indicate a reason in the error log. In 2008 and beyond, this is reported as state 40 (see below), with a reason. In SQL Server 2005, this state may also be reported if the user's default database is online but the database they explicitly requested is not available for the reasons stated above (also see state 27).