data_engine cannot connect to SQL Server 2014

Document ID : KB000033913
Last Modified Date : 14/02/2018
Show Technical Document Details
--- 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)

User-added image



--- 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

User-added image

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