SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to configure SQL server 2000 for remote access
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

siva
Starting Member

5 Posts

Posted - 08/24/2006 :  14:31:38  Show Profile  Reply with Quote
Hi ,

we have SQL Server 2000 under windows 2003 adv server.
we need to connect to remote SQL Server from the local SQL server.

can u plz furnish the detailed steps to configure the local SQL Server in such a way that it could be able to connect the remote SQL Server and access the database.

Ur help would be appreciated..!!!

regards
siva

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 08/24/2006 :  14:56:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
There is nothing that needs to be configured for SQL Server to allow remote connections. For SQL Server to SQL Server access, are you referring to linked server? Are you getting an error?

Tara Kizer
Go to Top of Page

igorblackbelt
Constraint Violating Yak Guru

USA
407 Posts

Posted - 08/24/2006 :  15:09:33  Show Profile  Click to see igorblackbelt's MSN Messenger address  Reply with Quote
I believe he's saying that he needs to access the server from the users PC, correct siva ?
If so, you need to install the Connectivity Tools for SQL server, that can be found on the same CD that you installed SQL Server from. And, if the Server is not on the same network that your PCs are, you'll need port 1433 open.

Hope this helps.


---
"There's no sexy way to carry a lunch bag." My boss
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37157 Posts

Posted - 08/24/2006 :  15:16:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by igorblackbelt

I believe he's saying that he needs to access the server from the users PC, correct siva ?
If so, you need to install the Connectivity Tools for SQL server, that can be found on the same CD that you installed SQL Server from. And, if the Server is not on the same network that your PCs are, you'll need port 1433 open.

Hope this helps.


---
"There's no sexy way to carry a lunch bag." My boss



You don't need the "Connectivity Tools" to be installed on the client PC in order to connect to SQL Server. You just need MDAC on the PC. Now if siva is referring to Query Analyzer and/or Enterprise Manager, then yes the Client Tools need to be installed, but neither of those tools was mentioned in the original post.

If your server isn't on the same network as the PC, then you shouldn't be using 1433 anyway. You should be using a port that is greater than 10000.

Tara Kizer
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 08/24/2006 :  17:24:12  Show Profile  Reply with Quote
try this

Add your remote server to the client network utility tool and enabale TCP/IP, undeer the alias tab. then click apply.

Register the remote server in EM.

And try connecting. Should work if the port is open

Afrika
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000