[quoted text, click to view] "Stren Assaf" wrote:
> 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.
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 --
Posted using the
http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
http://www.dbforumz.com/ODBC-Help-IIS-fails-connect-MSSQL-server-nother-computer-ftopict230553.html
