Large Scale Monitoring


:
from
to
Question:


How to set up SQL Server for Control Center V4.X?


Answer:


Please follow the instructions below.

1. Open 

SQL Server Configuration Manager,

 click 

SQL Server Network Configuration

 > 

Protocols for your SQL Server

, then double click 

TCP/IP

.

SQL1.png
SQL1.png (60.34 KiB) Viewed 187 times

2. Change the 

“Enable”

 option to 

Yes

.

SQL2.png
SQL2.png (19.92 KiB) Viewed 187 times

3. Click the 

“IP Address”

 tab, scroll down to the bottom.

Under the 

“IPAII”

 section, enter [b[“1433”[/b] for 

TCP Port

, then click 

OK

.

SQL3.png
SQL3.png (32.92 KiB) Viewed 187 times

4. Cick 

SQL Server Service

, right click 

“SQL Server (Your SQL Server)”

 and click 

Restart

.

SQL4.png
SQL4.png (95.91 KiB) Viewed 187 times

5. Open 

Windows Defender Firewall with Advanced Security

.

SQL5.png
SQL5.png (193.87 KiB) Viewed 187 times

6. Click 

Inbound Rules

 > 

New Rule…

.

SQL6.png
SQL6.png (141.13 KiB) Viewed 187 times

7. Select 

Port

 and click 

Next

.

SQL7.png
SQL7.png (49.02 KiB) Viewed 187 times

8. Choose 

TCP

, then choose 

Specific local ports

, enter 

"1433”

 and click 

Next

.

SQL8.png
SQL8.png (41.56 KiB) Viewed 187 times

9. Choose 

Allow the connection

 and click 

Next

.

SQL9.png
SQL9.png (65.03 KiB) Viewed 187 times

10. Enable all three options and click 

Next

.

SQL10.png
SQL10.png (47.49 KiB) Viewed 187 times

11. Enter a preferred name for the rule and click 

Finish

.

SQL11.png
SQL11.png (26.92 KiB) Viewed 187 times

12. Open 

Microsoft SQL Server Management Studio

 and login.

Under your SQL server, right click 

Databases

 and click 

New Database

.

SQL12.png
SQL12.png (71.52 KiB) Viewed 187 times

13. Enter a preferred name for the database and click 

OK

.

SQL13-1.png
SQL13-1.png (55.67 KiB) Viewed 187 times
SQL13-2.png
SQL13-2.png (30.47 KiB) Viewed 187 times

14. Open Control Center, click 

Configure

 > 

Setup

 > 

System Configure

.

SQL14.png
SQL14.png (27.57 KiB) Viewed 187 times

15. Click the 

“System Log “

 tab.

- Address: Enter the IP address of your SQL Server.

- Name: Enter the database name.

- Account / Password: Enter your SQL Server credentials.

- Choose 

Enable

 for Activation and click 

OK

.

SQL15.png

Footer navigation