troubleshooting Question

SQL Server Problem. "Error: 18456, Severity: 14, State 11

Avatar of SQL_DB
SQL_DB asked on
Microsoft SQL Server 2005
9 Comments1 Solution1948 ViewsLast Modified:
Hi,
   I have been moving my Databases from SQL 2000 to SQL 2005. I use following steps
 Make a back up of DB in 2000 on Server A. Restore the Backup file in 2005 on server B.

 The problem I am having is when user try to odbc connection to SQL server 2005 on server B they are getting error
Connection failed:
SQL State: '28000'
On the SQL server event Log it says "Error: 18456, Severity: 14, State 11"

I am unable to connect using windows authentication but if i use SQL Server Authentication and give the user id and password for "SA" account I am able to connect.

Any help will be appreciated
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros