SQL Management Studio with SQL 2005 behind Firewall

2 Feb 2006 5:20 PM

kevinsharp69

I'm having some difficulties with remote management of our SQL server which
resides behind our firewall. I'm trying to connect using the tools from my
local station but it does not return the server state, so I cannot start/stop
SQL and I also cannot connect to the integration service. I have the
following ports open on the firewall (TCP 1433, UDP 1434, TCP 2383) and all
windows ports such as Netbios, Smb, Rpc, Etc. I have looked at the firewall
log and noticed a port that was being blocked so I added it in, but once the
server reboots it changes to a different port. Is there any way to set the
ports static, or is there a specific group of ports I should leave open in
order for it to communicate properly.

Any help would be much appreciated.

4 Feb 2006 6:41 PM

John T

I'm a sql2k5 newbie...but, have you tried CREATE ENDPOINT?

Show quote

"kevinsharp69" wrote:

> I'm having some difficulties with remote management of our SQL server which
> resides behind our firewall. I'm trying to connect using the tools from my
> local station but it does not return the server state, so I cannot start/stop
> SQL and I also cannot connect to the integration service. I have the
> following ports open on the firewall (TCP 1433, UDP 1434, TCP 2383) and all
> windows ports such as Netbios, Smb, Rpc, Etc. I have looked at the firewall
> log and noticed a port that was being blocked so I added it in, but once the
> server reboots it changes to a different port. Is there any way to set the
> ports static, or is there a specific group of ports I should leave open in
> order for it to communicate properly.
>
> Any help would be much appreciated.

8 Feb 2006 7:18 PM

Sethu Srinivasan [MSFT]

You could set a static port for your SQL 2005 instance using SQL Server
configuration Manager

You could refer to MSDN documentation by following these links
How to: Configure a Server to Listen on a Specific TCP Port (SQL Server
Configuration Manager)
http://msdn2.microsoft.com/en-us/library/ms177440.aspx

http://msdn2.microsoft.com/en-us/library/ms189083(en-US,SQL.90).aspx

Thanks
Sethu

--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Show quote

"kevinsharp69" <kevinshar***@discussions.microsoft.com> wrote in message
news:0EC1A9E9-3B91-4074-98ED-78BC9BF26C24@microsoft.com...
> I'm having some difficulties with remote management of our SQL server
> which
> resides behind our firewall. I'm trying to connect using the tools from my
> local station but it does not return the server state, so I cannot
> start/stop
> SQL and I also cannot connect to the integration service. I have the
> following ports open on the firewall (TCP 1433, UDP 1434, TCP 2383) and
> all
> windows ports such as Netbios, Smb, Rpc, Etc. I have looked at the
> firewall
> log and noticed a port that was being blocked so I added it in, but once
> the
> server reboots it changes to a different port. Is there any way to set the
> ports static, or is there a specific group of ports I should leave open in
> order for it to communicate properly.
>
> Any help would be much appreciated.