Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


how to configure sql 2000 server allow remote access


how to configure sql 2000 server allow remote access

Author
Message
Frances L
Frances L
Old Hand
Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)

Group: General Forum Members
Points: 357 Visits: 299
I do not have ms sql 2005 installed in my server at all.
Key DBA
Key DBA
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 655
Frances,

My apologies for reading the posting too quickly.


All I have been able to find is a reference on page 388 in the ebook:

http://books.google.com/books?id=G2YqBS9CQ0AC&pg=PA388&lpg=PA388&dq=sql+server+enable+remote+connection+-2005+-desktop&source=web&ots=ZuMVFpFUaN&sig=6k4sCuHomxiLX_hDJsL95FRc31E#PPA388,M1

After executing:

exec sp_configure 'remote access', 1
reconfigure

The paragraph below also states "After enabling remote access, you'll need to shut down and restart each server".

There are also notes on how the database user(s) need to be configured on pages 388 and 389+

Hopefully these steps will help.

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Tony Mungor
Tony Mungor
SSC-Enthusiastic
SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)SSC-Enthusiastic (120 reputation)

Group: General Forum Members
Points: 120 Visits: 240
When you open SQL Server's "Server Network Utility" what protocols are enabled? It sounds like you need Named Pipes enabled as that is what your error message is complaining about. I have TCPIP and Named Piples enabled.

Can you connect to this SQL Server instance from a remote machine using Enterprise Manager?

Another common problem I've seen is DNS server sending your connection requests to the wrong machine. I have a server right now that everytime I try to connect to it from one area of our network I actaully connect to a sales person's laptop and not the server I want. The DNS folks are looking into it, but most likely the DNS tables are just messed up. I figured it out by using remote desktop to make the connection and realized it was not the machine I was expecting. OK, I also kicked the guy off of is machine when I logged on and he was logged out, but that story is for another day...

I now you said you can't install SQL Server 2000 SP4 because you are running on NT 4.0, how about SQL Server SP3. I know on Windows2000 you had to be on at least SQL Server SP3 otherwise the network connections were disabled. I'm not sure what SQL Server's support is for NT 4.0.

-Tony
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47137 Visits: 44346
You said that
http://computername/HRHSKeyContact/HRHSKeyContact.aspx
works, but
http://computername/HRHSKeyContact/HRHSKeyContact.aspx?hid=2
doesn't.

If you look at the aspx page, what's done differently if the querystring is passed, compared to not passed. Can you post the relevant portions of the code from the aspx page?

Is the web server on the same machine as the SQL server?
Is SQL Native access client installed on the web server (if it is, it would explain why you're getting a 2005-related error with a 2000 server.)

The particular error that you're getting is the generic 'server not found or access is denied' message that a 2005 client library will generate if it can't connect. Often is has nothing to do with remote access not been enabled. Especially on a SQL 2000 machine, where remote access is enabled by default.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


Frances L
Frances L
Old Hand
Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)Old Hand (357 reputation)

Group: General Forum Members
Points: 357 Visits: 299
<aspBigGrinetailsView ID="dvInfo" runat="server" DefaultMode=ReadOnly AutoGenerateRows="False"
DataSourceID="dsKeyContact" HeaderText="Review the info and make the necessary change" DataKeyNames="HID"
Width="692px" OnItemUpdated="dvInfo_ItemUpdated" OnDataBound="dvInfo_DataBound" Font-Bold="True" Font-Size="Large">
























<aspBigGrinropDownList id="dpBusUnit" runat="server"
                        DataSourceID="dsBusUnit"
                        
                      DataTextField="BusUnit" DataValueField="BusUnit"
                      SelectedValue='
                  











<aspBigGrinropDownList id="dpDept" runat="server"
                        DataSourceID="dsDept"
                        
                      DataTextField="Dept" DataValueField="Dept"
                      SelectedValue='
                  

















<asp:CustomValidator ID="ValidPhoneLength" runat="server" ControlToValidate =txtOfficePhone ClientValidationFunction="ValidPhoneLenght"
ErrorMessage="The length of the phone should not more than 10">*
















































<asp:RegularExpressionValidator ID="vrREmail" runat="server" ErrorMessage="Check the email again. It must contain @" ControlToValidate =txtEmail
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*
















"
SelectCommand="SELECT [HName], [Title], [BusUnit], [Department], [OfficePhone], [Mobile], [Pager], [Home], [AlternatePhone], [Email], [LastUpdate], [HID] FROM [KeyContactPhone] WHERE ([HID] = @HID)"
UpdateCommand="UPDATE KeyContactPhone SET Title =@Title, HName =@HName, BusUnit =@BusUnit, Department =@Department, OfficePhone =@OfficePhone, Mobile =@Mobile , Pager =@Pager, Home =@Home, AlternatePhone =@AlternatePhone, Email =@Email WHERE ([HID] = @HID)" ProviderName="


















"
SelectCommand="SELECT Dept from Dept order by Dept " ProviderName="



"
SelectCommand="SELECT BusUnit from BusUnit order by BusUnit " ProviderName="





When you open SQL Server's "Server Network Utility" what protocols are enabled? It sounds like you need Named Pipes enabled as that is what your error message is complaining about. I have TCPIP and Named Piples enabled.

The 'remote access is set up as 1 already.

You said that
http://computername/HRHSKeyContact/HRHSKeyContact.aspx
works, but
http://computername/HRHSKeyContact/HRHSKeyContact.aspx?hid=2
doesn't.

What I tried to say is the web server did not have problem to display the web site.
Here is my aspx code. The query string should not be issue. Since
http://localhost/HRHSKeyContact/HRHSKeyContact.aspx?hid=2
will show the result as I expected.
forsqlserver
forsqlserver
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1222 Visits: 2044
Dear Frances I have also the same problem

Failed to connect to server ajayg\ajayg2000. (Microsoft.SqlServer.ConnectionInfo)

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)


Yet I am not doing it using programming I am doing directly to sql server.

Thanks
anooperoth
anooperoth
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 0
Thanks a lot...You saved my time...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search