Re: Cannot see database engine behind a firewall

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



i configured remote and local tcp connection there is two named instances but
none of them can be found. it is a sql server 2005 enterprise x64 on a
windows server 2008 x64

"Rick Byham, (MSFT)" wrote:

Is the database configured for remote connections?
http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
Is it a named instance or the default instance? If a named instance, did you
open UDP port 1434. (i.e: not TCP port 1434.)
Also there are some operating systems situations that might apply. What is
the OS of the client and the server?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Djeff" <Djeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A303A1EC-7B1D-4A78-9B1E-821F58B43EF7@xxxxxxxxxxxxxxxx
Hello all i cannot see my SQL Server 2005 database engine Behind a
firewall
i opened port 1433 and 1434.
Do you know whitch ports to open else ?

.



Relevant Pages

  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
    (microsoft.public.sqlserver.setup)
  • Port Assignments : Multiple Instances : SSPI context issue
    ... A SQL server has the initial instance installed as a named instance ... Internet app is using 1433 to talk to the named instance. ... the install utility for the app does not work against ... By default it too is assigned port 1433!! ...
    (microsoft.public.sqlserver.server)
  • TCP-Portnummern bei mehreren SQL Server Instanzen auf einem Computer
    ... wenn eine Firewall aktiv ist. ... the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. ... Wenn man eine Anwendung schreibt die eine Named Instance verwendet, die man weitergeben möchte, ohne zu wissen welche SQL Server ...
    (microsoft.public.de.sqlserver)
  • Re: Instances and ports
    ... Each named instance must have its own unique port number. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.setup)