ODBC connection fails

I'm running SQL 2000/SP3 on a W2k server. I have a database with a standard
user (dbo rights). From any of my workstations I can create an ODBC
connection using SQL authentication.
When I try to create an ODBC connection on the server itself with the same
credentials, I get an error msg "login failed, username is not associated
with a trusted server connection". Using Windows authentication with another
user that has access to the SQL server works fine.
This doesn't make sense to me. What am I overlooking here? Any help/hint
would be appreciated.
Thanks
Claus"cjobes" <cjobes@.nova-tech.org> wrote in message
news:O6t6OxyBEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I'm running SQL 2000/SP3 on a W2k server. I have a database with a
standard
> user (dbo rights). From any of my workstations I can create an ODBC
> connection using SQL authentication.
> When I try to create an ODBC connection on the server itself with the same
> credentials, I get an error msg "login failed, username is not associated
> with a trusted server connection". Using Windows authentication with
another
> user that has access to the SQL server works fine.
> This doesn't make sense to me. What am I overlooking here? Any help/hint
> would be appreciated.
The user account itself needs to have access to the server running SQL
Server. One way to verify, temporarily enable (don't leave it that way ;)
the server GUEST account.
Steve|||Hello,
Define user id "sa" and set pwd for sa account on sql server and try to
login that account on odbc connection.
i hope it will working fine.
Thanks,
Warm Regards,
Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Actually that is a not a good idea (at least as a permanent solution) as sql
security is sent over the network in clear text.
Steve
"Ayaz Ahmed" <ayaz@.csquareonline.com> wrote in message
news:e4EAqBkDEHA.2712@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Define user id "sa" and set pwd for sa account on sql server and try to
> login that account on odbc connection.
> i hope it will working fine.
>
> Thanks,
> Warm Regards,
> Ayaz Ahmed
> Software Engineer & Web Developer
> Creative Chaos (Pvt.) Ltd.
> "Managing Your Digital Risk"
> http://www.csquareonline.com
> Karachi, Pakistan
> Mobile +92 300 2280950
> Office +92 21 455 2414
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!