data_engine cannot connect to SQL Server 2014
Document ID :
Last Modified Date :
Show Technical Document Details
CA Unified Infrastructure Management
UIM - DATA_ENGINE:UIMDEG
--- Problem ---
Data_engine cannot connect to MS SQL 2014 -?(
SQL Server does not exist or access denied)
--- Additional Info ---
? It is possible to log in to the DB directly
? no special characters in the password
? ODBC > works from primary hub
? Not a permission issue (tested SA)
? Data_engine "Test Connection" gives error:
data_engine schema version: n/a COM Error [0x80004005] Unspecified error - [Microsoft OLE DB Provider for SQL Server] [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.(1)
--- Resolution ----
SQL configuration was missing the default port '1433'
After setting the port?in the SQL Server Configuration Manager data_engine could connect to the DB:
1- go to the MS SQLConfiguration Manager
2-?in the 'SQL server Network configuration, go to "Protocols for <UIM_DB>"
3- ?in the TCP/IP "properties", set TCP port to 1433 for "IPAll".
4- ?restart SQL Server service
keywords: data_engine cannot can't connect to DB?
Microsoft OLE DB Provider for SQL Server?DBNETLIB?Test Connection?MS SQL 2014?SQL Server does not exist or access denied
Was this information helpful?