473,570 Members | 2,909 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Setting up SQL Server for Remote Clients

Hi,

I am having a hard time setting up an SQL Server 2000 Developer
Edition instance for remote clients. The instance is running well and
I can connect to it on the local computer. When I try connecting from
another computer using Enterprise Manager with the server's IP as the
instance name, I always get the usual "Specified SQL Server not found"
error. I have used Enterprise Manager many times to connect to local
and remote servers (which were set up by someone else obviously).

I used the client network utility on the client to make an alias for
this server and have it use the TCP/IP library for port 1433.

I understand that SQL Server listens on port 1433 for connections. I
have a firewall on the server and setup 1433 forwarding. But when I
use Enterprise Manager to try to register the server, the firewall
doesn't even show a connection attempt on port 1433 (it logs all
connection attempts).

When I use telnet to port 1433, the firewall logs the attempt but
there is still no connection, as if the server isn't actually
listening on 1433 at all. I can't seem to find any help on getting the
server listening, as if it supposed to be easy to set up so I don't
know what I'm missing. I guess I have the following questions:

1) Does anything have to be done on the server side to set it up to
listen for remote client connections?
2) How do I set the port on which the server listens in case I want to
change from 1433?
3) Does anything have to be set up on the client side other than using
the client network utility?
4) Why does Enterprise Manager not seem to even attempt a connection
on port 1433 when I try to register this server?

Any help is appreciated.
Jul 20 '05 #1
2 10849
In article <dd************ **************@ posting.google. com>,
kl*****@hotmail .com says...
Hi,

I am having a hard time setting up an SQL Server 2000 Developer
Edition instance for remote clients. The instance is running well and
I can connect to it on the local computer. When I try connecting from
another computer using Enterprise Manager with the server's IP as the
instance name, I always get the usual "Specified SQL Server not found"
error. I have used Enterprise Manager many times to connect to local
and remote servers (which were set up by someone else obviously).

I used the client network utility on the client to make an alias for
this server and have it use the TCP/IP library for port 1433.

I understand that SQL Server listens on port 1433 for connections. I
have a firewall on the server and setup 1433 forwarding. But when I
use Enterprise Manager to try to register the server, the firewall
doesn't even show a connection attempt on port 1433 (it logs all
connection attempts).

When I use telnet to port 1433, the firewall logs the attempt but
there is still no connection, as if the server isn't actually
listening on 1433 at all. I can't seem to find any help on getting the
server listening, as if it supposed to be easy to set up so I don't
know what I'm missing. I guess I have the following questions:

1) Does anything have to be done on the server side to set it up to
listen for remote client connections?
2) How do I set the port on which the server listens in case I want to
change from 1433?
3) Does anything have to be set up on the client side other than using
the client network utility?
4) Why does Enterprise Manager not seem to even attempt a connection
on port 1433 when I try to register this server?

Any help is appreciated.


1433 is for data, 1434 is for communications. If you open your firewall
to allow 1433 and 1434 you are going to get hacked. At the very least,
you need to only open the ports to fixed IP addresses of your users
(their fixed internet address).

You need to force them to use a VPN to connect, even a simple PPTP
tunnel is better than opening the ports to the entire world.

You should also tell us what firewall - it would be easier to tell you
what rules to create.

--
--
sp*********@rro hio.com
(Remove 999 to reply to me)
Jul 20 '05 #2
Thanks for the reply.

The firewall is a Netgear FVS318. I understand that leaving the server
on the default ports is not a good idea so I would also like to know how
to change that and lock things down more. But for now I can't seem to
connect to it at all even on the default ports so I am not convinced
that it is just a firewall issue, it still doesn't seem to be listening
on 1433/1434 (I have opened 1434 as well).

As for the VPN idea, I have not looked into that at all yet, would it
still be possible to use DB tools like DTS if the clients are forced to
VPN first?

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3869
by: John | last post by:
Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql server and then link the tables to access front-end...
1
4931
by: Jeff | last post by:
I am new to web services and want to expose a C# program through web services (soap or otherwise) that will have a service with cached data running on a server that clients can make requests to without instanciating the (data) classes locally. I see many examples of using web services where the server really just handles requests to point to...
6
3713
by: Ken Allen | last post by:
I am relatively new to .Net and C#, but I hav ebeen programing in other languages and done some COM work for a number of years. I am attempting to understand how to map an older program architecture into .Net -- not looking to do it at this time, just to understand how I would achieve it. In the old environment, we had two classes, a client...
7
5088
by: agold79 | last post by:
I am about to take my first crack at C# and would like some suggestions/best practices for approaching the app I am looking to build. Here's a simplified description of the problem : The client application will handle displaying a countdown timer that will be controlled by a remote administration console. I would like to be able to assign...
7
2370
by: Colin | last post by:
I'm writing a little console socket server but I'm having some difficulty. Can I ask your advice - where is the best place to get some help on that topic? It would be nice if some people who knew what they were doing could take a look at my code and tell me where and why I'm going wrong. Any suggestions of groups or forums?
7
5020
by: jane | last post by:
HI, I have a question... I have a bunch of instances... Is there any way to tell which instance is client instance? Your help is very appreciated. Thanks.
4
19964
by: kuladeep.mohan | last post by:
Hi I am trying to consume a web service from asp.net web page through HTTP POST method and I am getting the following error message "System.Net.WebException: The remote server returned an error: (500) Internal Server Error." I have been searchign the web and followed all the options which worked
3
2795
by: Prakash | last post by:
Hello All, We have installed UDB 9.5 on HP-UX IA64 machine. We would like to install DB2 8.2 client on HP-UX PA-RISC V11.11. We want to install only on HPUX V 11.11 since we have licensed version MF Cobol on this. My question is: Can DB2 8.2 client talk to DB2 server 9.5? Please let me know asap.
14
2632
by: Guillermo_Lopez | last post by:
Hello, Our company has developed several Access applications for our clients and we wish to expand to use a database server. We wish to use Access as the front end application and SQL Server 2005 as the back end Databes Server. Making a Server-Client application database. I'm very new to SQL Server so my concern is how the licensing works...
0
7950
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7702
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8000
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6332
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5523
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5247
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3684
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3671
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1238
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.