How to Allow remote ASP scripts to access the server.

[chrigil]

After much messing about with Microsofts favorite error message:

"Login failed for user 'chris'. Reason: Not associated with a trusted SQL Server connection."

I am finally having some success which I haven't had previously, namely I can use a newly created Account to login to the SQL Server SQL Analyser but it still gives me the same old error message if I try using the account to access it from an ASP script hosted on another machine on my network.
I am assuming that the problem is something to do with the fact that IIS is running the script on one computer and SQL Server is running on the other.
This is really annoying and by the looks of the forums out there 100's of people are having similar problems.

Can somebody please tell me how to sort this problem out.



Thanks in advance,

Chris

 

[chrigil]

I understand that and I'm 99% sure there is nothing blocking the connection.

Why, when I have TCP/IP enabled is it not saying:

SQL server listening on Shared Memory, TCP/IP, Named Pipes.

OR anything about

listening on 10.0.0.9:1433

Thanks in advance,

Chris

 

[chrigil]

UPDATE

Problem Solved.

The problem or should I say solution was to install SP3 from the following link:

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

Solved it straight away

Thanks to all who have answered my questions and helped out.

Chris

 

[JamesLean]

Glad you solved it. Out of interest, did you see a specific article advising what the issue was or did you just try installing SP3 on the off-chance?

--James

 

[chrigil]

Yeah I saw it in a article but I can't remember where.

You know the scenario, 150 Firefox Tabs all open at the same time...

(10 minutes later...)

I found it, its a JSP site but its talking about SQL Server:

http://forum.java.sun.com/thread.jspa?messageID=3200706

Chris