HISTORY_XDB;DB Error (4001): Source: Microsoft OLE DB Provider for SQL Server, Description: [DBNETLIB][ConnectOpen (Connect())]SQL Server does not exist or access denied.
|Related Products||BMS Server 2.0|
|Description||The NETx BMS Server cannot connect ot the historical SQL database.|
- The MS SQL database instance is not installed or not running.
- The username/password combination to access the MS SQL instance is not correct.
- Verify that the MS SQL database instance is correctly installed and running. Check the database instance name by looking at BMS Studio / Server / System configuration / XDB / Database instance name. Within the Windows Services there a service called SQL Server (<your instance name>) must exist. Verify that this service is in state Running. If no such service exist, install a new MS SQL database instance. The MS SQL 2014 setup can be found within the ZIP file C:\Program Files (x86)\NETxAutomation\NETx.BMS.Server.2.0\Setup\MSSQL2014.zip.
- Check whether BMS Studio / Server / System configuration / XDB / Database User and Database Password is correct and that Use integrated security is unchecked.If it is still not working, set the password again. A detailed description can be found here.