| Author |
Topic |
|
NarayanaMoorthy
Starting Member
19 Posts |
 Posted - 2007-11-22 : 09:04:55
|
| Hai,I'm using SQL Server 2005 Standard Edition in my windows XP SP2 machine. I have only 1 server to which my 4 client machines are connected. Whenever I'm connecting to my SSMS using my domain account I get an error message indicating ' Login failed for user 'domain name\account name'.(Microsoft SQL Server, Error: 18456).I have tried with Microsoft's KB Article ID: 889646 and all other kind of stuffs. It's not helping me to sort out this problem. Could anyone help me outta here.Narayanamoorthy |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-22 : 10:31:30
|
| So when you log onto your XP2 machine, can you create objects with your domain account username? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 16:38:57
|
| Do you use windows or sql authentication? Sql authentication doesn't work with 'domain name\account name' while windows authentication doesn't need 'domain name\account name'. And ensure you added 'domain name\account name' as sql login in sql server. |
|
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-11-22 : 23:45:03
|
quote:
Originally posted by rmiao
Do you use windows or sql authentication? Sql authentication doesn't work with 'domain name\account name' while windows authentication doesn't need 'domain name\account name'. And ensure you added 'domain name\account name' as sql login in sql server.
Hai rmiao,I added my domain account in sql login in sql server.I too checked it out. I'm logging into my domain account with XP SP2 and while connecting to SSMS I get this messasge.Narayanamoorthy |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 03:19:28
|
| Ok, i'll re-phrase my question. If you log in to the Server with the same account you use for your XP SP2 machine, can you connect ok and create objects? |
|
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-11-23 : 04:06:05
|
quote:
Originally posted by RickD
Ok, i'll re-phrase my question. If you log in to the Server with the same account you use for your XP SP2 machine, can you connect ok and create objects?
No, I cannot connect to SSMS. Before connecting it throws this error message.Narayanamoorthy |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 04:44:08
|
| Ok, do you have the admin account for the server? It would seem that the account you are using is not the admin account, so it could be that you haven't set this account up with access correctly. Please log in using a sa level account and check your security settings. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-24 : 00:52:05
|
| Did you connect to sql with windows authentication? Is instance name correct? |
|
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-11-26 : 23:35:02
|
quote:
Originally posted by rmiao
Did you connect to sql with windows authentication? Is instance name correct?
Hai rmiao,Yeah I connected sql using windows authentication.Instance name is exactly correct. I checked it too !Narayanamoorthy |
|
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-11-26 : 23:36:07
|
quote:
Originally posted by rmiao
Did you connect to sql with windows authentication? Is instance name correct?
Hai rmiao,Yeah I connected sql using windows authentication.Instance name is exactly correct. I checked it too !Narayanamoorthy |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-27 : 02:01:44
|
| Then you shouldn't get that error. |
|
|
|
NarayanaMoorthy
Starting Member
19 Posts |
Posted - 2007-11-28 : 08:11:19
|
quote:
Originally posted by rmiao
Then you shouldn't get that error.
I'm getting the error when I hit connect button in SSMS.Narayana Moorthy |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-29 : 02:11:25
|
| That means something we mentioned above is not correct even you said them are all right. |
|
|
|
|
Microsoft SQL Server, Error: 18456