MS SQL Activation

MS SQL Machine Activation

Before you start backing up your MS SQL databases by FGS Backup, you will need to do the following preparations on the computer running the MS SQL Server:

  1. Open your MS SQL Server configuration Manager → Click MS SQL Server Network Configuration on the left panel → Click Protocols for MSSQLSERVER.
[object object] - act1 - MS SQL Activation

2. Double-click the Named Pipes protocol to open the Named Pipes Properties window → From Enabled, select Yes → Click OK.

[object object] - act2 - MS SQL Activation

3. Double-click the TCP/IP protocol to open the TCP/IP Properties window → On the Protocol tab, ensure Yes is selected for Enabled → Go to the IP addresses tab → Refer to the IPAll section → Make sure the TCP Dynamic Ports field is empty and TCP Port is 1433 → Click OK.

[object object] - act3 - MS SQL Activation
[object object] - act4 - MS SQL Activation

4. From Microsoft SQL Server Management Studio →  Right-click on the server name → Click on  Properties.

[object object] - act5 - MS SQL Activation

5. Click Connections on the left panel of the Server Properties window → Check the Allow remote access to MS SQL server option → Click OK.

[object object] - act6 - MS SQL Activation

6. Restart the Server.

7. Open the MS SQL Server configuration Manager → Click MS SQL Server Services on the left panel → Right-click MS SQL Server (MSSQLSERVER) →  Restart.

[object object] - act7 - MS SQL Activation

Leave a Reply