Post reply

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

  • 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

  • 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

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

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