| Author |
SQL Server 2005 Port Number (Named Instance)
|
|
| Amos Soma 2006-03-30, 11:23 am |
| We have SQL Server 2005 installed on a box with SQL 2000. When we installed
SQL 2005 we created a named instance. I think when creating named instances
port 1433 is not used. How can I determine what port SQL 2005 is using? I
need this so we can set the firewall correctly.
Thanks,
Amos
| |
| John Bell 2006-03-30, 11:23 am |
| Hi
In SQL Server configuration manager you will find the ports used under the
TCP/IP protocol for the instance you have in the network configuration
section.
John
"Amos Soma" wrote:
> We have SQL Server 2005 installed on a box with SQL 2000. When we installed
> SQL 2005 we created a named instance. I think when creating named instances
> port 1433 is not used. How can I determine what port SQL 2005 is using? I
> need this so we can set the firewall correctly.
>
> Thanks,
>
> Amos
>
>
>
| |
| Jeff Clausius 2006-03-31, 9:23 am |
| Amos:
In addition to John's post, if you use dynamically allocated ports,
you'll need to make sure the SQL Server Browser is up and running for
remote computers to connect to the SQL Server instance.
Jeff Clausius
SourceGear
"Amos Soma" <amos_j_soma@yahoo.com> wrote in
news:uX4x1cBVGHA.5248@TK2MSFTNGP10.phx.gbl:
> We have SQL Server 2005 installed on a box with SQL 2000. When we
> installed SQL 2005 we created a named instance. I think when creating
> named instances port 1433 is not used. How can I determine what port
> SQL 2005 is using? I need this so we can set the firewall correctly.
>
> Thanks,
>
> Amos
|
|
|
|