Sql server does not exist or access denied

[spud101]

I've had to re-install my w2000 server operating system and SQL 7, but i can't connect to the SQL server over the internet. Things were working before the re-install and I am wondering whether I missed a step or something.

After installing SP4 and running the client & server network utilities i get an "sql server does not exist or access denied" message when i try to make a connection to the server from an ASP page using a connection string like this:

"Provider=SQLOLEDB;DataSource=24.42.142.136;uid=sa;pwd=;Database=testconnect"

I ensured the server utility had TCP as a server library and the client utility had TCP under protocals. DO i have to setup an alias for the client?

I can connect to the database locally by changing the connection string datasource=computername.

Thanks for any help

 

[JBaileys]

I had a similar problem connecting to an instance of sql server. I added tcp/ip protocol and named pipes and now the connectivity works.

 

[softboy12]

Hi all

i encounter the same problem (i use a Access 2000 based Frontend) i checked also the ODBC Connection on the client and Server (-> V2.8, Test say's all is ok) if i a open the Access 2000 FrontEnd on the server it works fine, but if i use the Frontend from a W2K Client the message above appears

--> the Tables from the MS SQL Server are linked into the Access Front End

what coud be the problem?

BTW: TCP/IP Connection (telnet on the 1433 Port works fine)