how to configure sql 2000 server allow remote access

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » how to configure sql 2000 server allow remote...

16 posts, Page 1 of 2

1 2 »»

how to configure sql 2000 server allow remote access

Rate Topic

Display Mode

Topic Options

Author

Message

Frances L

Posted Friday, January 11, 2008 12:04 PM

Old Hand

Group: General Forum Members
Last Login: Sunday, September 18, 2011 6:11 PM
Points: 355, Visits: 299

how to configure sql 2000 server allow remote access

Post #441949

Tony Mungor

Posted Friday, January 11, 2008 12:09 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:02 AM
Points: 112, Visits: 235

If you are not on SP4, apply it. That may resolve your issue.

Post #441952

Frances L

Posted Monday, January 14, 2008 9:03 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, September 18, 2011 6:11 PM
Points: 355, Visits: 299

I think you mean sql 2000 sp4.

http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

According to above link
Important: SQL Server 2000 Service Pack 4 is not supported on Windows NT 4.0, Windows Millennium Edition and Windows 98 platforms.

Post #442486

SQL ORACLE

Posted Monday, January 14, 2008 2:23 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

Run
sp_configure

you can see "remote access"

Turn it on (set the value to 1 to enable the remote access).

Post #442694

Frances L

Posted Tuesday, January 15, 2008 6:12 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, September 18, 2011 6:11 PM
Points: 355, Visits: 299

I used SP_CONFIGURE to check remote acces config_value is 1 realdy. so.. why I still get the error.

checked
remote access 0 1 1 1

Post #442938

GilaMonster

Posted Tuesday, January 15, 2008 6:17 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

What error are you getting?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #442940

Frances L

Posted Tuesday, January 15, 2008 7:02 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, September 18, 2011 6:11 PM
Points: 355, Visits: 299

it is web application.

application connect to the remote sql2000 server

http://localhost:2132/HRHSKeyContact/HRHSKeyContact.aspx?HID=1 viewable in the local machine

http://webserver(computername)/HRHSKeyContact/HRHSKeyContact.aspx?HID=1 not viewable in the local machine

I just do not understand the difference.

error msg:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I used the vb 2.0 to access the remote sql 2000 server.

Post #442971

GilaMonster

Posted Tuesday, January 15, 2008 7:08 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

I find that particular error message very misleading. I've seen it several times where the problem had nothing to do with remote access.

It could be that the server name is incorrect in the web app's connection string
It could be that the server is offline (but if you're querying it, that's not the case)
It could be incorrect password.

That error is the 2005 version of the old message
"SQL Server does not exist or access is denied"

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #442976

Frances L

Posted Tuesday, January 15, 2008 9:25 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, September 18, 2011 6:11 PM
Points: 355, Visits: 299

I do not think the error is connection string

http://localhost:2132/HRHSKeyContact/HRHSKeyContact.aspx?hid=2

it is view. it connected to remote database.

http://computername/HRHSKeyContact/HRHSKeyContact.aspx (html file)

it is viewable. web server is working.

http://computername/HRHSKeyContact/HRHSKeyContact.aspx?hid=2

it has database connection problem.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I do not have ms sql 2005 install in that server at all.

Post #443102

Key DBA

Posted Wednesday, January 16, 2008 7:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655

If you are working with SQL Server 2005 and used the "SQL Server Surface Area Configuration" Tool ...

Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Surface Area Configuration >> Surface Area Configuration for Services and Connections >> Remote Connections >> (default is: Local connections only)

... and make any changes, it will give a warning window that states that you will have to restart the SQL Server Service for changes to take effect. In my experience, restarting the SQL Server service has not worked. I have had to reboot the server for those changes to allow remote connections to that instance.

Note that Remote Connections are DISABLED by default, for SQL Server 2005.

Hope This Helps

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Post #443657

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions