SQL Connectivity Issue with IP

  • HI,

    I have installed SQL Server 2012 Named instance and i am able to connect with server name but i am unable to connect with system IP(10.10.10.10\SQL1) .

    TCP/IP also enabled for this server,

    Can i need enable any other services?

  • Funny some times we face viceversa.

    Have you confirmed that you are using the correct IP? Ping once and check.

    Regards
    Durai Nagarajan

  • durai nagarajan (3/19/2014)


    Funny some times we face viceversa.

    Have you confirmed that you are using the correct IP? Ping once and check.

    that is correct ip because default instance is connecting with that IP only.

  • do you have a firewall enabled?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Do you have SQL Browser started? If not then you will need to add a port number to your connection string, eg 10.10.10.10\SQL1:5133

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 5 posts - 1 through 4 (of 4 total)

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