How do I setup sql server to allow a remote user a way to connect?

[WestSide2003]

Hi,

I am trying to setup the following:

SQL Server 2000 so a user can connect from the outside (externally).

How do I set this up so the user can connect from an sql client?

Thanks,

WestSide

 

[SQLBill]

On the server side, make sure they have the proper permissions.

On the client side, create an ODBC connection to the database.

-SQLBill

 

[WestSide2003]

Hi,

Anything about port numbers?

We have our db behind firewall.

Will an external user be able to access it?

Thanks,

-WestSide

 

[tlbroadbent]

Check these links.

Connections to SQL Server Over the Internet

http://msdn.microsoft.com/library/en-us/adminsql/ad_1_server_1zuc.asp

INF: TCP Ports Needed for Communication to SQL Server Through a Firewall

http://support.microsoft.com/default.aspx?scid=kb;en-us;287932

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[SQLBill]

SQL Server normally listens on port 1433 (and every 'bad' guy knows this). Your firewall has to allow traffic through that port. When you set up (install) SQL Server you have the option to set the port that you want the instance to listen on. Then when the ODBC connection is set up, you tell it to use that port.

-SQLBill