none
Changing default ports

    Question


  • I understand how to change the default port in SQL server but my question is if i do change it how would one connect to it via Sql Server Mgmt studio or from VS 2012 when developing?  Thanks.
    Monday, January 20, 2014 5:58 PM

Answers

  • Hello,

    On Visual Studio you can specify the port number you assigned to SQL Server on the connection string, separated by comma

    sqlserver01\instancename1, 1533           where 1533 is the port number you assigned.

    On SQL Server Management Studio,  is the same, just add a comma and the port number:

    tcp:sqlserver01\instancename1,1533


    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, January 20, 2014 6:49 PM
    Moderator