Re: Connecting to SQL2005 named instance through firewall

servername,portnumber

When you specify a port number, you don't specify the instance name (the port number serves as "identification" of where to go.

Or, have SQL Server Browser started on the server machine and let port 1434 UDP through the firewall. Now you can connect using servername\instancename. This way you don't have to specify a different port number of the instance decides to use something different.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Nick Gilbert" <nickg@xxxxxxxxxxxxxxxx> wrote in message news:%23N7YFtE2HHA.5316@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I'm trying to connect to a SQL2005 named instance through a firewall with no success.

I can telnet to the port the SQL Server instance is listening on and it connects (so SQL Server and firewall settings are OK) but I cannot work out how to actually specify the port to connect to in the New Server Registration dialog on the machine I'm connecting *from*. Where do you actually put the instance name and network port?

I've tried
server\SQL2005
server:4929\SQL2005
server\SQL2005:4929
server 4929
etc etc etc

I think I've tried everything, but if you can't specify the port anywhere, I can't see how this can work!

Any help would be greatly appreciated.

Nick...

.

Relevant Pages

  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... Queries to the Data Engine must go to the port that SQL Server is ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2008 remote connection problem
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... default instance of the SQL Server Database Engine listens on TCP port 1433", ... > I was trying to establish a remote connection to SQL Server 2008 from ... The server is running the XP firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server connection problem
    ... no firewall is installed? ... Also i have check that port 1433 is not ... Will SQL server only connect to this ... > to configure the firewall to permit connections to SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
Quantcast