Re: Cannot see database engine behind a firewall

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

If they are named instances then port 1433 will not be used. They will each get their own port or you can assign a specific one. That is a good start if you can ping the server itself. Identify the ports they instances are using and try to connect using those particular ports first. If you can then you have a problem with the browser or seeing the browser. See if these help as well.

http://www.kbalertz.com/Feedback_914277.aspx
http://msdn2.microsoft.com/en-us/library/ms345318.aspx

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Djeff" <Djeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0F134E77-17C0-4FE7-83D5-E753D626F7AA@xxxxxxxxxxxxxxxx
i have two named instances i can ping the server from the client they are in
the same domainbut there is a firewaal between the sql server and the rest of
the servers. the sql browser service is running
The clients are virtual hyper-v servers
"Andrew J. Kelly" wrote:

1434 is only needed if you are using the browser service to find the
instance and port. Is the SQL Browser service on? Can you ping the IP of
the machine the instance is on? Is this a default instance or a named
instance? What happens if you try to connect using the IP address and the
port directly?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"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