enable remote connection for sql server 2000

[eyeseetee]

Hi does any1 know how to enable remote connection for sql server 2000? thanks

[Sun Rays]

Hey, try this link[^]

Thanks, Sun Rays To get something you must have to try once. My Articles

[eyeseetee]

thanks for the reply however i have already googles and cannot find the suitable answer most results bring up the solution for sql server 2005 any1 else?

[imsathy]

Register the database server in you local systems enterpirse manager using SQL authentication. ^[^]

Sathy

[eyeseetee]

Hi thanks for the articles One thing i have noticed is that in the error log there is not trace of the connections attempts i have tried to make from the web sever is there a reason for this? thanks again

[imsathy]

Can you tell me the steps you followed to register the server database ??

Sathy

[eyeseetee]

thanks for the reply I am not the database administrator however and he is not contactable today Shall I give you a detail of what I have done so far to try and connect the web server to the sql server which are on different machines. Our firewall is not blocking any ports web server is not blocking any ports from being accessed The port 1433 and IP address 172.16.0.10 can be pinged from my machine The same can be done using telnet, both are successful I have checked my connection string that I am using and it seems to be correct. TCP/IP and Named Pipes are both enabled on SQL Server any help would be great thanks

[imsathy]

Do you have SQL authentication username and password for the database server ??

Sathy

[eyeseetee]

yes i think so i have access to the sql server, where would i find this ifnormation? in the connection string would I just use the normal login and password for the database? thanks

[eyeseetee]

ok Im getting a new error message now it was the 500 error message when i try and run the code but now i turned friendly error messages off its: No suitable nodes are available to serve your request.

[dojohansen]

Yes, how about this rebuttal: This is the ASP.NET forum. Not the ADO.NET one. Nor the SQL Server one. Try googling for "surface area configuration" sql 2005 and you might get lucky.

[eyeseetee]

Its not an ado.net or sql server forum!!? You could have fooled me, is that why it says Forum: ASP.NET at the top of the screen! Thanks for the suggestion but I'm using SQL 2000

[dojohansen]

ASP.NET is the web part of the .net framework. Not the database part. So indeed, you are absolutely right, it says clearly on top of the screen that this is NOT the ADO.NET (which is the data access part of the .net framework) or the SQL Server forum. In SQL Server 2000 remote connections are enabled by default. Its from the time when MS felt that security should be an option for people with special interests.

[eyeseetee]

and did you know Microsoft Word is a product of Microsoft and an apple mac computer is made by wait for it... Apple I'm joining in with you as it must be "Day to give obvious comments day" Yes Microsoft has got over excited about security(see Vista or any new product after 2004)

[dojohansen]

I disagree. It is high time it's taken seriously. Mocking me for pointing out that you're posting to an inappropriate forum however is not overdue.