Re: Connecting to Remote SQL Server

From: Milos Milovanovic (milos.milovanovic_at_etf.bg.ac.yu)
Date: 02/17/05


Date: Thu, 17 Feb 2005 11:58:22 -0800

You have to open port 1433 (or other port where your SQL server is) at
the computer where you SQL Server is, for computers in LAN. Go to
Control Panel/Windows Firewall/Exceptions/Add Port... and add that port.

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



Relevant Pages

  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing sql server
    ... port, select All ports, in Remote port, select Fixed port and input 1433 ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... | I have now checked and I can access the sql server when creating an ODBC ...
    (microsoft.public.windows.server.sbs)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Failover problems on 2 active/active SQK 2k clusters on Windows 2003
    ... If you don't set the port numbers with SNU, the ports change each time the ... Microsoft SQL Server MVP ... I recently deployed 2 new SQL clusters for our web environments. ... The first cluster has instance names DBSERVER1 and DBSERVER2\DBSERVER2, ...
    (microsoft.public.sqlserver.clustering)