Help - IIS fails to connect to MSSQL server on a nother co..

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 RemoveThis @nipendo.com

Stern Assaf.

Make sure that you have SP3 for sql 2000. If you do then try adding a host record. I just made this same post a minute ago. Make a host record on the machine that you are trying to connect to the sql server.Go to c:\WINNT\System32\drivers\etc\host. open it in notepad and at the bottom put in the ip address and computer name of the SQL server. I had this same problem just the other day.


First thing I would do though is make sure that you have SP3 for SQL installed. Cause if you dont it may not have the default port open. You can check that by opening a command prompt on the SQL server and type in:

tasklist
and then look for sqlserver.exe Once you find that look at the number on the right and that is your process id. Now type in:

netstat -nao | findstr LIST

And then look to the far right hand side and try to find that process ID. If you do not have it, You more than likely do not have SP3. You can download it here.

http://www.microsoft.com/sql/downloads/2000/sp3.asp