What special permission(s) do I need in order to view the
information? I need to find out what port my instance is
on.Typically, the admin on the machine would be viewing/chaning the ports SQL
is listening on.
You need to be able to read the following registry key;
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\SuperSocketNet
Lib\Tcp
After SQL Server starts, you can determine what port it is using by
reviewing the SQL Errorlogs and the NT Application Eventlogs.
Also, running netstat -an will give you the port information as well.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you very much! I found my port information. I do
have another question. Do you know if there is a way to
change the port to the default port 1433? Do you see any
problems with doing this?
quote:
>--Original Message--
>Typically, the admin on the machine would be
viewing/chaning the ports SQL
quote:
>is listening on.
>You need to be able to read the following registry key;
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLSe
rver\SuperSocketNet
quote:
>Lib\Tcp
>After SQL Server starts, you can determine what port it
is using by
quote:
>reviewing the SQL Errorlogs and the NT Application
Eventlogs.
quote:
>Also, running netstat -an will give you the port
information as well.
quote:
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
quote:|||Question:
>
>.
>
Do you know if there is a way to
change the port to the default port 1433? Do you see any
problems with doing this?
Answer:
You can use the Server Network Utility to change the port. The only
problem with doing this is that then you also would need to modify each
client to connect to the new port. All clients will by default send
traffic to 1433. If you change this, then each client would need an alias
created to reflect the change, or you would need to modify the connection
string. Ex.
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=myuser;Initial Catalog=Northwind;Data
Source=MySQLServerName,4500;Network Library=DBMSSOCN
(Where 4500 is the new port)
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you!
quote:
>--Original Message--
>Question:
>Do you know if there is a way to
>change the port to the default port 1433? Do you see
any
quote:
>problems with doing this?
>Answer:
>You can use the Server Network Utility to change the
port. The only
quote:
>problem with doing this is that then you also would need
to modify each
quote:
>client to connect to the new port. All clients will by
default send
quote:
>traffic to 1433. If you change this, then each client
would need an alias
quote:
>created to reflect the change, or you would need to
modify the connection
quote:
>string. Ex.
>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security
quote:
>Info=False;User ID=myuser;Initial Catalog=Northwind;Data
>Source=MySQLServerName,4500;Network Library=DBMSSOCN
> (Where 4500 is the new port)
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
quote:|||You're welcome.
>
>.
>
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
No comments:
Post a Comment