Changing SQL TCP Port from 1433

rust
rust Member Posts: 27
edited 2008-08-26 in SQL General
Hi
I am Installing SQL 2005 with NAV 5.0 sp1 in Windows Server 2003.

My User does not want to use the SQL default port 1433.

I have try changing the port from 1433 to 1434 using SQL Server configuration Manager, restarted the services and firewall port is opened.

However only the Server is able to connect, other PC in the network is unable.

I would like to check with you guys is it possible to change the port ?
How Can i do it?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Or you put in the services file which port that SQL server is using, or you can try to connect to the SQL server by putting "SQLSERVER:1434" in the servername.

    Did never try any of these but this seems a logical solution.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • garak
    garak Member Posts: 3,263
    Do you have set it under IPALL :?:

    test following:

    configure alias using the SQL Server Configuration Manager and configure the port number in the alias. (alias = YourServername, Portno = YourNewPort, Servername = YourServername)

    other question: is NAV the only application which can't connect :?: Or can you also not connect from other PC with SQL Server Manager to your SQL server :?:

    Regards
    Do you make it right, it works too!

Categories