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

Question

Post reply

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

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

marwenG Right there with Babe Points: 763 More actions · Answer 1

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 · Answer 2

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