Re: Remote connection to SQL Server 2005

Only the default (un-named) instance listens on port 1433. If you have a
named instance or are running SQL Express, which is a named instance named
(SQLEXPRESS) you are listening on dynamic ports.
For more ideas, run through my short connectivity tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318(SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

<bostonguy@xxxxxxxxx> wrote in message
news:1147702273.174968.231850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am unable to connect to a SQL Server 2005 instance running remotely
on a Windows 2003 Server machine behind a router. I can connect to the
instance via SQL Server Management Studio Express when I place the
server machine in the DMZ, but I cannot connect when I forward traffic
on port 1433. Note that I am able to forward Remote Desktop requests to
my server, so I know that port forwarding works in other cases.

Any suggestions? I'd rather not leave my server machine in the DMZ.
Thanks for the help.



.

Relevant Pages

  • Re: SQL Management Studio will not connect to x64 bit SP2 server
    ... Management studio communicates over the port that SQL is listening on. ... Management Studio on the x64 bit server with named instance. ...
    (microsoft.public.sqlserver.connect)
  • sql browser and named instance connection issue
    ... Checking file permisisons on:\Program Files\Microsoft SQL ... Restart SQLBrowser and then your named instance. ... The suggestions in the blog post include setting the Port property in SSAS ...
    (microsoft.public.sqlserver.olap)
  • Re: connect to named instance in a cluster
    ... SQL will decide on a port when the service restarts unless it is a default instance or you have locked SQL to a specific port number. ... I had problem connecting to the named instance. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Remote connection to SQL Server 2005
    ... configuring a static port for a named instance like? ... Rick Byham wrote: ... on a Windows 2003 Server machine behind a router. ...
    (microsoft.public.sqlserver.connect)
  • Re: AS2005: Cant access named instance / sqlbrowser issue...
    ... C:\Program Files\Microsoft SQL Server\90\Shared ... The SQLBrowser service was unable to establish Analysis Services ... I can't access my named instance of Analysis services. ... I can access my AS server if I specify the port in the connection (like ...
    (microsoft.public.sqlserver.olap)
Loading