| Stren Assaf 2005-06-08, 7:23 am |
| Hello all.
I am having a pretty serious problem and I tried almost every thing (I
know…) but still with no success.
There are 2 computer on a workgroup (lets call them A and B). On A there is
an MSSQL Server 2000 with windows and QSL mixed authentication on Windows
2003 machine. On B I set up an ODBC as system DNS that points to one of the
databases exists on the MSSQQL sever on A using an SQL authentication (user &
password). The connection is working (the “test connection” step at the end
of the wizard is successful) and I can access the database using SQL Server
Enterprise Manager and the SQL Query Analyzer. I also using this DSN with
other desktop application running from B. BUT when I’m running a web service
server on the IIS that is located on B using the same ODBC connection and
passing the user name and the password I get the error: “Sql Server does not
exist or access denied”. (Machine B is running Windows XP OS)
Why is that and how can I solve it?
Thanks for your answers.
My email is: assaf@nipendo.com
Stern Assaf.
|