ports - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

ports

Author

Topic

mobasha
Starting Member

45 Posts

Posted - 2007-07-24 : 05:59:05

hi every on am searching for a file which contains information about
the instance in my sql server and the ports that this instances are running on ,am sure that there is a file like this but i cant find it please if u know it answer me ,,, and thanks alot for ur time//

MobashA

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-24 : 06:09:47

default port that sql server uses is 1433.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

mobasha
Starting Member

45 Posts

Posted - 2007-07-24 : 07:11:16

i get that but if i have more than one instance do they both use the same port,
and i need to find the file which sql server keep this information in .

MobashA

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-24 : 14:36:53

No, named instance will use dynamic port number by default.

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-07-24 : 19:19:06

quote:
Originally posted by mobasha
the instance in my sql server and the ports MobashA...

Try
SSMS->Management->SQL Server logs

------------------------
I think, therefore I am - Rene Descartes

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-24 : 19:52:51

You can get this information programmatically from the registry by using xp_regread.

Here is where to get it for SQL Server 2000 default instance (it changes a little for named instance and I believe even for 2005):

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp

Tara Kizer
http://weblogs.sqlteam.com/tarad/

mobasha
Starting Member

45 Posts

Posted - 2007-07-25 : 03:37:03

am trying to use xp_regread , i have found this sysntax
EXECUTE master..xp_regread [@rootkey=]'rootkey',
[@key=]'key'
[, [@value_name=]'value_name']
[, [@value=]@value OUTPUT]

but am not familiar with registery and i don know nothing about the proc inputs @rootkey,@key,@value_name
could u please explain them and if u can with example.

MobashA

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-25 : 11:12:23

Then just look at sql server configuration manager or sql server log.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-25 : 11:43:48

There are plenty of examples of xp_regread if you just googled it.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources