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 |
|
Keshaba
Yak Posting Veteran
52 Posts |
 Posted - 2007-11-07 : 07:19:12
|
| I Am Using Sql Server Express Edition 2005 .I Am using two different Operating System Windows Vista and Windows XP.I am trying to connect Sql Server 2005 Express Edition located in another machine(Sql server named ADMIN-PC\SQLEXPRESS) through ODBC.I Had made a DSNNamed : FleetDSN In The Combo Box (Which Sql server do you want to connect to) IHad Choosen The name of Sqlserver which i want to connect to thatis ADMIN-PC\SQLEXPRESS .I had choosen With Windows Authentication using the network login ID.And I had check marked The connect to SQL Server to obtain default settings for the additional configuration options .In the disabled text It was written Admin-PC/AdminWhen i Click next.....I get the error message**********Connection failed SQLstate 28000 sql server error:18456[Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]Login ailed for user Admin-PC\Guest.Please Help why i m gettin this errorKeshab |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-07 : 22:56:15
|
| Did you add Admin-PC\Guest as sql login in ADMIN-PC\SQLEXPRESS yet? |
 |
|
|
Keshaba
Yak Posting Veteran
52 Posts |
Posted - 2007-11-08 : 00:21:53
|
| I had not added Admin-PC\Guest in login .I added ADmin-PC Guest and I got The solution. thanksKeshab |
|
|
|
|
|
|
Sql state 28000Login failed or User Admin_PC\Guest