"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.

"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.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!