April 4, 2011 at 3:58 am
Hi
I want to find out the sqlserver instance ip address.
if i run the ping command using instance name and its shows "could not find the instance name"
Ex: ping sqval17\sqldev_1
Could you please help me, how to find the ip address of these instances.
Regards
Balaji G
April 4, 2011 at 4:08 am
balaji.ganga 68339 (4/4/2011)
HiI want to find out the sqlserver instance ip address.
if i run the ping command using instance name and its shows "could not find the instance name"
Ex: ping sqval17\sqldev_1
Could you please help me, how to find the ip address of these instances.
Regards
Balaji G
Balaji,
It looks like you have a named instance. (SQVAL17\SQLDEV_1).
PING checks the existance of a physical host and the fact as to whether or not it is active. In this case, you need to ping SQVAL17.
SQLDEV_1 is an instance of SQL Server on top of the host SQLVAL17. The SQL instance will NEVER respond to a PING request.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
April 4, 2011 at 4:32 am
Nakul Vachhrajani (4/4/2011)
balaji.ganga 68339 (4/4/2011)
HiI want to find out the sqlserver instance ip address.
if i run the ping command using instance name and its shows "could not find the instance name"
Ex: ping sqval17\sqldev_1
Could you please help me, how to find the ip address of these instances.
Regards
Balaji G
Balaji,
It looks like you have a named instance. (SQVAL17\SQLDEV_1).
PING checks the existance of a physical host and the fact as to whether or not it is active. In this case, you need to ping SQVAL17.
SQLDEV_1 is an instance of SQL Server on top of the host SQLVAL17. The SQL instance will NEVER respond to a PING request.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply