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.
| Author |
Topic |
|
Aiby
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-04 : 03:41:35
|
| Can we find out IP Address of MS SQL Server, Some how? |
|
|
sudeeptaganguly
Starting Member
1 Post |
Posted - 2010-08-04 : 04:36:11
|
| Do you want to know the IP address on which the SQL Server is listen on?Open SQL Server Configuration Manager, Go to SQL Server Network Configuration --> Protocols for MSSQLServer. Double click on TCP/IP protocol. Go to the tab IP Address, Check for the IP address with Active & Enabled parameter is set as Yes.Also, if you look at the SQL Server log, you will find the IP address and port number on which the server is listening.Hope, this may help.Thanks & Regards,Sudeepta. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-08-04 : 04:40:53
|
if you need to do this via the T-SQL,can't really remember is there any other way other than this . . .run ipconfig in xp_cmdshell and parse the resultexec master..xp_cmdshell 'ipconfig'
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Aiby
Yak Posting Veteran
71 Posts |
Posted - 2010-08-04 : 04:47:48
|
Ipconfig - Will list all the IP address for a particular networking device! This will list more than one IPs if connected, from which we could not figure out in which one the Database base is mounded. quote:
Originally posted by khtan
if you need to do this via the T-SQL,can't really remember is there any other way other than this . . .run ipconfig in xp_cmdshell and parse the resultexec master..xp_cmdshell 'ipconfig'
KH[spoiler]Time is always against us[/spoiler]
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-08-04 : 04:59:05
|
The database is not mounted to any ip address. It is the Server Network Interface layer that is binding to the IP Address.Only for SQL 2005 onwards you can define what is the IP Addr that the Network Interface layer will listen on, not on SQL 2000.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Aiby
Yak Posting Veteran
71 Posts |
Posted - 2010-08-04 : 06:14:36
|
:) Yes, I am trying to find the SQL Server!Again... dbo in master can only master..xp_cmdshellquote:
Originally posted by khtan
The database is not mounted to any ip address. It is the Server Network Interface layer that is binding to the IP Address.Only for SQL 2005 onwards you can define what is the IP Addr that the Network Interface layer will listen on, not on SQL 2000.
KH[spoiler]Time is always against us[/spoiler]
|
|
|
|
|
|
|
|
|
IP Address of Sever Machine