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 (60.34 KiB) Viewed 28330 times
2. Change the “Enable” option to Yes.
- SQL2.png (19.92 KiB) Viewed 28330 times
3. Click the “IP Address” tab, scroll down to the bottom.
Under the “IPAII” section, enter “1433” for TCP Port, then click OK.
- SQL3.png (32.92 KiB) Viewed 28330 times
4. Cick SQL Server Service, right click “SQL Server (Your SQL Server)” and click Restart.
- SQL4.png (95.91 KiB) Viewed 28330 times
5. Open Windows Defender Firewall with Advanced Security.
- SQL5.png (193.87 KiB) Viewed 28330 times
6. Click Inbound Rules > New Rule….
- SQL6.png (141.13 KiB) Viewed 28330 times
7. Select Port and click Next.
- SQL7.png (49.02 KiB) Viewed 28330 times
8. Choose TCP, then choose Specific local ports, enter "1433” and click Next.
- SQL8.png (41.56 KiB) Viewed 28330 times
- SQL9.png (65.03 KiB) Viewed 28330 times
10. Enable all three options and click Next.
- SQL10.png (47.49 KiB) Viewed 28330 times
11. Enter a preferred name for the rule and click Finish.
- SQL11.png (26.92 KiB) Viewed 28330 times
12. Open Microsoft SQL Server Management Studio and login.
Under your SQL server, right click Databases and click New Database.
- SQL12.png (71.52 KiB) Viewed 28330 times
13. Enter a preferred name for the database and click OK.
- SQL13-1.png (55.67 KiB) Viewed 28330 times
- SQL13-2.png (30.47 KiB) Viewed 28330 times
14. Open Control Center, click Configure > Setup > System Configure.
- SQL14.png (27.57 KiB) Viewed 28330 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 (26.54 KiB) Viewed 28330 times
Reference:
[ TVS - 202211248003-L ] Control Center_AI Watch Connect Fail