Large Scale Monitoring
How to set up SQL Server for Control Center V4.X?
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.
2. Change the
“Enable”option to
Yes.
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.
4. Cick
SQL Server Service, right click
“SQL Server (Your SQL Server)”and click
Restart.
5. Open
Windows Defender Firewall with Advanced Security.
6. Click
Inbound Rules>
New Rule….
7. Select
Portand click
Next.
8. Choose
TCP, then choose
Specific local ports, enter
"1433”and click
Next.
9. Choose
Allow the connectionand click
Next.
10. Enable all three options and click
Next.
11. Enter a preferred name for the rule and click
Finish.
12. Open
Microsoft SQL Server Management Studioand login.
Under your SQL server, right click
Databasesand click
New Database.
13. Enter a preferred name for the database and click
OK.
14. Open Control Center, click
Configure>
Setup>
System Configure.
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
Enablefor Activation and click
OK.