Re: How does IP1, IP2, IPAll work in the IP Adddresses tab?
- From: "Jens K. Suessmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 11 Feb 2007 14:40:34 +0100
As I replied to the mentioned topic, I will try to answer you to qour question here:
Does sys.dm_exec_connections get the information from those registries?
Well directly, no. The settings in the dynamic view is based on the runtime values of the system. Lets assume that you are starting SQL Server and it listens on port 1112. You connect with a client and query the view, you will the 1112. You disconnect again. Some administrator changes the port in the configuration manager (or the registry) to port 1444), but does not restart the service. Although the entry is a different one from the configured one, the service will listen to port 1112 until you do a new restart. You connect with a client and query the view, you will the 1112. You disconnect again. The service is restarted on the server. You connect with a client and query the view, you will the 1444.
So, it does not get its values directly from the registry.
HTH, Jens K. Suessmeyer.
---
http://www.sqlserver2005.de
---
"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9D419B7C-122E-4EC5-A27A-367E59AD6880@xxxxxxxxxxxxxxxx
Hi Rick,
Thanks for the information. I have just posted any thread "Registry for SQL
Server Express Instance". If you can reply that one, it will be great.
Does sys.dm_exec_connections get the information from those registries?
Peter
"Rick Byham, (MSFT)" wrote:
This dialog box is a bit confusing. Sorry about that.
Yes, I think your named instance is listening on dynamic ports and it is
currently listening on 1121. However there are problems updating this
information. I remember walking to different buildings with my laptop and
getting different IP addresses with the wireless connection, and then
checking to see if the information was updated. Often the answer was no.
Try connecting to the instance with TCP/IP and then running this query.
SELECT net_transport, local_net_address, local_tcp_port
FROM sys.dm_exec_connections
WHERE session_id = @@SPID;
That should tell you how you are really connected and provide the port
number that you are using.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A090C79-C1EB-41D9-8772-0CF86407A7FB@xxxxxxxxxxxxxxxx
>I want to understand the IP Addresses tab of the TCP/IP Properties in >SQL
> Server Configuration Manager. The following settings are from the > default
> named instance of SQL Server 2005 Express (computername\SQLEXPRESS) on > a
> Windows XP SP2 machine with IP Address 192.168.1.151.
>
> IP1 has the following settings:
>
> Active: Yes
> Enabled: No
> IP Address: 192.168.1.151
> TCP Dynamic Ports: 0
> TCP Port: 1433
>
> IP2 has the following settings:
>
> Active: Yes
> Enabled: No
> IP Address: 127.0.0.1
> TCP Dynamic Ports: 0
> TCP Port:
>
> IPAll
>
> TCP Dynamic Ports: 1121
> TCP Port:
>
> Is the instance using Dynamic Port or Static Port? Normally, I will > see
> blank for TCP Port when TCP Dynamic Ports is 0 in IP1 but in this case,
> TCP
> Port has 1433.
>
> My guess is that the instance is using Dynamic Port and the port is > 1121.
>
> Besides checking the SQL Server log and the IP Addresses tab, how can I
> tell
> which port the instance is listening to?
>
>
.
- References:
- Re: How does IP1, IP2, IPAll work in the IP Adddresses tab?
- From: Rick Byham, \(MSFT\)
- Re: How does IP1, IP2, IPAll work in the IP Adddresses tab?
- From: Peter
- Re: How does IP1, IP2, IPAll work in the IP Adddresses tab?
- Prev by Date: Re: Named pipe error 53
- Next by Date: Re: How to make different instances of SQL Server visible to each other?
- Previous by thread: Re: How does IP1, IP2, IPAll work in the IP Adddresses tab?
- Next by thread: RE: Unable to connect to SQL Express DB without using User Instanc
- Index(es):
Relevant Pages
|
