August 25, 2010 at 8:56 am
Hi All
My error log is showing a login failure exactly every ten minutes with with an error code of:
Error:18456, Severity 14, State 16
I have a web server hosting a site where the web.config references the database on my SQL2005 server via a connection string using a SQL login. The login has db_owner permissions on the user db. I have the correct password in the connection string and have verified this by an odbc connection.
After confirming this I ran SQL server profiler and found that this failed connection was to the master db rather than the user db.
The SQL login has master set as it's default database, is a sysadmin and can once again connect to master via ODBC. However the error log is showing a login failure exactly every 10 minutes.
If anyone has any suggestions or ideas then they will be much appreciated.
Thanks. John
August 26, 2010 at 12:09 am
State=16 means that the incoming user does not have permissions to log into the target database. So for example say you create a user FOO and set FOO's default database to master, but FOO does not have permissions to log into master.
This can also happen if for example the default database for user FOO is not online (for example the database is marked suspect).
So to check on this theory, try logging the user into some other database and then try using the USE DATABASE command to switch to the target database, you will get a better error message as to the root cause of the failure.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 12:11 am
Check this link
http://www.sqlservercentral.com/Forums/Topic570042-5-1.aspx#bm571110
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 26, 2010 at 2:59 am
Thanks Bhuvnesh, but I've already read this resolution at
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
I've also previously read the feed from http://www.sqlservercentral.com/Forums/Topic570042-5-1.aspx#bm571110
but I've tried everything suggested in these posts.
The sql account has permissions to master, has master set as it's default database and I can verify the login to master via a successful odbc connection, but my error log reports of a login failure exactly every 10 minutes from my web server. The web.config on the web server also has no connection string referring to master.
All system and user databases are online and not suspect. Plus there are no other errors in the error log.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply