{"id":33808,"date":"2017-05-12T05:34:25","date_gmt":"2017-05-12T12:34:25","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/33808\/how-to-establish-a-connection-with-sql-server-instance-configured-to-listen-on-non-standard-port\/"},"modified":"2017-05-25T02:07:40","modified_gmt":"2017-05-25T09:07:40","slug":"how-to-establish-a-connection-with-sql-server-instance-configured-to-listen-on-non-standard-port","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/33808\/how-to-establish-a-connection-with-sql-server-instance-configured-to-listen-on-non-standard-port\/","title":{"rendered":"How to establish a connection with SQL Server instance configured to listen on non-standard port"},"content":{"rendered":"

\t\t\t<\/p>\n

\n
\n

Overview<\/h3>\n
\n

You can customize the Port<\/i> number on which your SQL Server instance is configured as may be required by your organization’s security guidelines and policies.<\/p>\n

This article explains the steps to establish a connection with SQL Server instance configured to listen on non-standard port (customized port number).<\/p>\n<\/div><\/div>\n

\n

Who should read this?<\/h3>\n
\n
    \n
  • Database Administrators<\/li>\n
  • System Administrators<\/li>\n
  • TopTeam Administrators<\/li>\n<\/ul>\n<\/div><\/div>\n
    \n

    Method 1. Establish a connection with SQL Server instance configured to listen on non-standard port using Management Console<\/h3>\n<\/p><\/div>\n
    \n

    For TopTeam Application Server<\/h3>\n<\/p><\/div>\n
    \n

    Open TopTeam Application Server Management Console, go to Database Settings<\/h3>\n
    \n\"wpid33809-media_1494502687751.png\"\n<\/div>\n
    \n

    Enter “<<Server Name>>, <<Port number>>”<\/i> separated by a comma<\/i> <\/font>to connect TopTeam Application Server<\/i> to SQL Server configured to listen on non-standard port.<\/p>\n<\/div><\/div>\n

    \n

    For TopTeam Web Server<\/h3>\n<\/p><\/div>\n
    \n

    Open TopTeam Web Server Management Console, go to Database Settings<\/h3>\n
    \n\"wpid33810-media_1494502907673.png\"\n<\/div>\n
    \n

    Enter “<<Server Name>>, <<Port number>>”<\/i> separated by a comma<\/i> <\/font>to connect TopTeam Web Server<\/i> to SQL Server configured to listen on non-standard port.<\/p>\n<\/div><\/div>\n

    \n

    Method 2. Establish a connection with SQL Server instance configured to listen on non-standard port using Alias<\/h3>\n<\/p><\/div>\n
    \n

    Step 1. Open SQL Server Configuration Manager<\/h3>\n
    \n\"wpid33811-media_1494503477867.png\"\n<\/div>\n<\/p><\/div>\n
    \n

    SQL Server Configuration Manager opens<\/h3>\n
    \n\"wpid33813-media_1494585460720.png\"\n<\/div>\n<\/p><\/div>\n
    \n

    Step 2. Expand SQL Native Client Configuration<\/h3>\n
    \n\"wpid33814-media_1494585528231.png\"\n<\/div>\n<\/p><\/div>\n
    \n

    Step 3. Create a new Alias<\/h3>\n
    \n\"wpid33815-media_1494585624571.png\"\n<\/div>\n<\/p><\/div>\n
    \n

    Step 4. Enter Alias details and click Apply<\/h3>\n
    \n\"wpid33816-media_1494585749970.png\"\n<\/div>\n<\/p><\/div>\n
    \n

    Alias is created with non-standard port<\/h3>\n
    \n\"wpid33817-media_1494585879426.png\"\n<\/div>\n
    \n

    NOTE<\/strong>: In case you have SQL Native Client Configuration <\/i>for both 32bit <\/i>and 64bit, <\/i>then follow the same process to create an Alias<\/i> for 64bit <\/i>configuration.<\/p>\n<\/div><\/div>\n

    \n

    Step 5. Open TopTeam Application Server Management Console, go to Database Settings<\/h3>\n
    \n\"wpid33812-media_1494564334479.png\"\n<\/div>\n<\/p><\/div>\n
    \n
    \n

    Revised: May 12th, 2017<\/p>\n<\/div><\/div>\n<\/p><\/div>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Overview You can customize the Port number on which your SQL Server instance is configured as may be required by your organization’s security guidelines and policies. This article explains the steps to establish a connection with SQL Server instance configured to listen on non-standard port (customized port number). Who should read this? Database Administrators System Administrators TopTeam Administrators Method 1. Establish a connection with SQL Server instance configured to listen on non-standard port using Management Console For TopTeam Application Server Open TopTeam Application Server Management Console, go to Database Settings Enter “<<Server Name>>, <<Port number>>” separated by a comma to <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[283,281,9,52],"class_list":["post-33808","post","type-post","status-publish","format-standard","hentry","category-database","tag-application-server","tag-database","tag-sql-server","tag-web-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-8Ni","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/33808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=33808"}],"version-history":[{"count":2,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/33808\/revisions"}],"predecessor-version":[{"id":34177,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/33808\/revisions\/34177"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=33808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=33808"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=33808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}