Connecting to MsSql Server remotely using SSMSE Version 17.

You need to install Sql Server Management Studio Edition Version 17 from microsoft's site, once this is installed please follow the below options to configure SSMS to use port 1435/1437. We block port 1433 due to automated scripts that try hack mssql servers, a remote user needs to use the alternat ports we have setup by using an alias server name with the correct port.

 

1) Click Start > All Programs > Sql Server vNEXT CTP2.0 (If this does not exist please see the article SSMS 17 and Windows 10 issues)

2) Click on configuration tools > Open the Sql Server vNEXT   CTP2.0 Configuration manager

3) Click on sql native client 11.0 configuration (depending on your operating system select the 32bit or 64bit configuration option)

4) Right click on aliases and select add new alias.

5) Give it a name ie hostworxsql

6) Change the port to 1435 or 1437

7) Protocol must be "tcpip"

8) Server is "mssql.yourdomainsname" Replace yourdomainname, with your own domains name.

9) Click ok

 

Then open up SSMS17 and in the server name field use the alias name you created above "HostworXMsSql" for the server name, and enter the db username and password that you setup in the control panel.



  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Connection Strings (MSSQL 2005, MSSQL 2008, MySQL5, MS Access Database)

MSSQL2005Set conn = Server.CreateObject("ADODB.Connection")conn.Open "Provider=SQLOLEDB; Data...

Getting "The 'microsoft.jet.OLEDB.4.0' provider is not registered on the local machine."

When you host on the 64bit servers you might get an "The 'microsoft.jet.OLEDB.4.0' provider is...

How do I use an Access database on my site?

Microsoft Access is part of the Microsoft Office suite of applications and is a database that is...

Import Export MySQL database using PhpMyAdmin

Do the following steps for import/export mysql database: Open phpMyAdmin.by going to...