Home Forums SQL Server 2005 Administering DNS solution for sql server running in named instance or different port RE: DNS solution for sql server running in named instance or different port

  • @ Elliott W and CirquedeSQLeil

    I got the problem. My sql server instance is installed in the port 1434. Since the sql browser is reserved to use the port 1434 and as sql server is running on that port there is no use if the sql browser is running.:crying:

    Somewhere this mistake had happen and I am looking for a remedy:blink:

    Right now, I am unable to change the port of sql sever from 1434 to some other port. Since many critical application is pointing to the server using that port. If I change the sql browser to some other port, will I be able to connect to the sql server instance without specifying the port?

    @ CirquedeSQLeil

    I would recommend that you (for the sake of sanity) standardize ports being used - each instance has a specific port. For example applicationinstance1 would have port 1463 in dev, qa and production. This can be configured even after the instance has been in use for some time.

    Can you please provide more explanation or reference?

    ---------------------------------------------------
    Thanks,
    Satheesh.