Why NCS server cannot connect to SQL server?

Symptom

When user tried to connect to SQL server, it pops up the warning message of '' Fail to connect to SQL ODBC data source '' message.

 
Cause
1. Set the wrong password or IP address of SQL server.
2. Setup incorrect configuration in "SQL Server Configuration Manager" after installing SQL server.

Solution
1. Please see if the IP address and password of SQL server are correct. The password has been decided when you installed SQL server.


If you forget it, please remove below SQL server's components reinstall it again to reset SQL password.

Here are some notes need to be notified when you reinstall SQL server:

(1) Please execute the "install.bat" in path \CMS install pack\Main SW\SQLEXPR_SP2. Otherwise the relevant instance for NCS system will not be built. 

(2) Un-check the box "Hide advanced configuration options". It will skip the sa password setup step if you check it.

(3) Make sure the instance name is "CMAlarmLog", otherwise it cannot connect to NCS server.

 

(4) Select method a or b to connect to SQL server.

a. Type "(local)" to connect the SQL server in your local host PC.

b. Drag drop down list and pick up a server name which include "CMALARMLOG" which should be the same as the instance name you setup before.

2. Please refer to CMS user’s manual p.17 to see if how to setup SQL server.
Note: Before NCS 2.10, it supports SQL server 2005 only. After that, it supports SQL server 2014.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.