Configure MSSQL to allow remote connections on Windows Dedicated Hosting

[carl owen]

Before you start following these steps to configure MSSQL to allow remote connections on Windows Dedicated Hosting, please note that these steps are to configure MSSQL 2005 on Windows Dedicated Servers.

1. Login to the server through RDP (Remote Desktop Protocol).

2. Click Start and then select Microsoft SQL Server 2005 after selecting Programs.

3. Once done, select SQL Server Management Studio Express.

4. Some information will now be required in order to proceed. The information required is given below:

Server Type:
Server Name:
Authentication:

For server type, select Database Engine, Server Name should be kept as the same as populated and for Authentication, you can keep Windows Authentication.

5. You will get Server Name after you select Connect.

6. After you get Server Name, right click on it and select Properties.

7. Click on Security and you will get Server Authentication.

8. Then select SQL Server and Windows Authentication Mode and finally cilck Ok.

9. Right click the Server name and select Restart.

Note:- You will have to wait for some time so that the service restarts and you can proceed.

10. Again, go to the Start option and then select Programs.

11. Select Configuration Tools after you choose Microsoft SQL Server 2005.

12. Now, select SQL Server Surface Area Configuration and then click on Surface Area Configuration for Services and Connections.

13. Select Expand SQL Server Browser and change the startup type to Automatic.

14. Click Apply and then Start.

15. Click Ok and you are done

Hope this helps...

[Fletcher]

Thanks for the steps.

I guess the steps involved for Linux Os are much more simpler than that of the Windows one.

Good one Carl :dancing:

[carl owen]

You are most welcome

Yes, the steps for Linux Dedicated Servers are simpler in comparison to the steps for Windows Dedicated Servers. However, the steps become even more simpler if you consider cPanel/WHM control panel with the Linux Dedicated Servers and hence it is recommended to consider a control panel with the Dedicated Server.

If you wish to Setup Remote MySQL on Linux Dedicated Servers, you can refer the link given below:

Setup Remote MySQL on Linux Dedicated Hosting