RE: How to access to SQL Server from Internet

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 09/02/02


From: lideng@online.microsoft.com (linda deng[MS])
Date: Mon, 02 Sep 2002 03:33:23 GMT


Hi Ricardo,

According to Brian's suggestion, you should check what TCP port the SQL
Server is listening on. You can view the SQL Server error log file to find
the TCP port. There are two possible methods to view the log files. One is
to open these files directly under C:\Program Files\Microsoft SQL
Server\MSSQL\LOG, the other is to view these files in the Enterprise
Manger/Management/SQL Server Logs.

If there is a firewall between the clients and the SQL Server, you should
also guarantee that this TCP port is open on the firewall. For more
information, please refer to Microsoft SQL Server Books Online with keyword
'Connections to SQL Server over the Internet' as the search topic.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.



Relevant Pages

  • Re: SQL Server 2000 behind ZoneAlarm Pro 4
    ... >it is creating a log file which is not manageable. ... ZoneAlarm is not really the best thing to protect a server. ... should have a hardware firewall for better ... allow SQL Server to access Trusted, and act as server for Trusted ...
    (comp.security.firewalls)
  • Re: Slow performance after restarting
    ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... Detach/Rename/Re-attach gets me a much smaller transaction ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction Log Failure
    ... A maintenance plan can not create a log file, ... then bring up sql server. ... > maintenance plan that would create a transaction log file every hour. ... > 2004-12-14 21:00:43.51 backup BACKUP failed to complete the command ...
    (microsoft.public.sqlserver.server)
  • Re: Slow performance after restarting
    ... without the hotfix but the problem disappeared when the hotfix ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL Server Registration Ports...
    ... SQL Server always listens on the network address that the firewall is ... Default instances of SQL Server use TCP port 1433 by default. ...
    (microsoft.public.sqlserver.connect)