October 5, 2015 at 11:13 pm
Hi All,
I just observer there are two logins attempt to connect one of my SQL Server instance.
In the SQL Server logs, not much information about the error, only mention the two error below:
1. Login failed for user 'xx\xxxx'. [CLIENT: xx.xx.xx.xxx]
2. Error: 18456, Severity: 14, State: 16.
I am aware that the error could be due to the default database, I have validated and ensured that the login (service account) has a default database assigned to it and the database doesn't has auto-close configured.
The error persist even though it configured with:
- granted with SA
- granted sysdba for server role
- added into builtin\administrator group
Need help. Thanks.
Regards,monkeyDBAWe dont grow when things are easy; We grow when we face challenges.
October 6, 2015 at 1:45 am
Is the default database online?
Does the state of the database change at any point during the day when the users could be accessing the DB? Daily refresh or something like that?
The user has SysAdmin rights?
October 6, 2015 at 2:56 am
Thanks for your response.
The default database is "master". So, I don't think there's any changes on the database.
Would it be possible for us to track which databases the login try to connect?
Regards,monkeyDBAWe dont grow when things are easy; We grow when we face challenges.
October 6, 2015 at 3:07 am
Can run a profile trace for login failed events to see what its trying to do.
October 6, 2015 at 3:28 am
Database mirroring in use ?
With regards to Error 18456 I always use Aaron Bertrand's article: Troubleshooting Error 18456
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply