Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-05-27 : 05:39:13
|
| Hello All,I have a domain group account that I'm trying to connect to the database using SQL Server Management Studio and I get this error message "Microsoft SQL Server, Error: 18456". I'm able to connect to the database with my own credential, but not with the group domain account, does anybody know how to fix this problem? Please. Thanks. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-05-27 : 09:34:22
|
| What is the STATE as given in the SQL errorlog? |
 |
|
|
nalini
Starting Member
1 Post |
Posted - 2009-05-29 : 06:45:39
|
quote:
Originally posted by mcrowley
What is the STATE as given in the SQL errorlog?
I have the same problem and the STATE is 1 |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-05-29 : 09:37:34
|
| Sounds like you have SQL 2000. State codes only began helping in SQL 2005:http://sqldbpool.wordpress.com/2009/04/24/error-18456-severity-14-login-failed-states/ |
|
|
|
|
|
|
Login failed Error 18456