how do I find the IP of the 2005 sql server instance?

• marwenG

  Right there with Babe

  Points: 763

  More actions

  May 9, 2010 at 3:15 am

  #1164677

  Hi,

  I had experiment u suggestion with[] but still not working.I don't understand u last point about errorlogfile.

  Thanks

• NazerMohamed

  Mr or Mrs. 500

  Points: 502

  More actions

  June 2, 2010 at 8:01 am

  #1175306

  Hi Everyone,

  Please note that you can run two instances of SQL server and make it listen on two different IP address.

  You need to go to SQL Configuration manager and choose - Protocols for <<Instance NAME> -> TCP/IP -> Right Click and properties.

  In the properties window Choose Listen all -> Yes (by default)

  You can change that and in the next tab.

  Next connectivity issues, SSMS connect using any one enabled protocol. Application can normally connect only using Named pipes or TCP/IP. so you need to enable that in the same window.

  NM