Connecting to a sql server database and specifying port number RRS feed

  • Question

  • I am trying to connect to a database and i was given a port number that coincides with it.

    Ex Servername:


    PortNumber: 1482

    Would I then connect in Enterprise manager is the following way or is there some different syntax?

    TESTSQLServer, 1482

    Wednesday, April 4, 2012 10:27 PM


  • Hi,

    If you would like to specify the port number when connecting to the SQL Server instance, then yes your connection string syntax example is correct


    To connect, you'll still need to have been granted access to the SQL Server instance and database you would like to use. If you are remote connecting, then the firewall should be configured to allow access via the supplied port number & SQL Server set to allow remote connections.

    If you were connecting to SQL Server Analysis Services using a port number, then you would use a colon instead e.g. TESTSQLServer:1482

    • Proposed as answer by Sunil Gure Friday, April 6, 2012 7:55 AM
    • Marked as answer by Stephanie Lv Wednesday, April 11, 2012 7:14 AM
    Thursday, April 5, 2012 12:03 AM