August 2, 2012 at 9:23 am
Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx\xxxx'.
How to trouble shoot and restore the access?
Do any one know this?
August 2, 2012 at 9:32 am
something missing from your post is the state
with the state, you know what the actual problem is:
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
ERROR STATE ERROR DESCRIPTION
2 and 5 Invalid userid
6 Attempt to use a Windows login name with SQL Authentication
7 Login disabled and password mismatch
8 Password mismatch
9 Invalid password
11 and 12 Valid login but server access failure
13 SQL Server service paused
18 Change password required
Lowell
August 2, 2012 at 10:18 am
not really a whole lot of information to work with. looks like your username or password is incorrect, or someone has removed access to the database instance for that particular account.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply