question

basit 1 avatar image
basit 1 asked

login failure alert in sqlserver log

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
sql-server-2005error-message
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

robbin avatar image robbin commented ·
have you tried a Logoff and then Login into windows with that user?
0 Likes 0 ·
basit 1 avatar image basit 1 commented ·
Robbin, we are getting the alert from 2 days and we have tried this also. the alert is comming from the host machine only..
0 Likes 0 ·
robbin avatar image robbin commented ·
Are you using SSMS to login? Can you please check the connection properties of the SSMS login dialog pointing to the defaultdb? What happens if you change it to master db?
0 Likes 0 ·
basit 1 avatar image basit 1 commented ·
Robbin , we found the issue...the issue was one job that was trying to access the Database which was deleted by the Application team, but they forgot to delete that job from the instance
0 Likes 0 ·

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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).
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

basit 1 avatar image basit 1 commented ·
Kev , The Default Database is master and i have mapped this user and give public access on master database.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.