Error #11170
Server: Msg 7399, Level 16,
State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. [OLE/DB
provider returned message: [INTERSOLV][ODBC SQL Server driver][SQL
Server]ct_connect(): protocol specific layer: external error: The attempt to
connect to the server failed.] [OLE/DB provider returned message:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Login failed.] OLE DB error
trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:
].
State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. [OLE/DB
provider returned message: [INTERSOLV][ODBC SQL Server driver][SQL
Server]ct_connect(): protocol specific layer: external error: The attempt to
connect to the server failed.] [OLE/DB provider returned message:
[INTERSOLV][ODBC SQL Server driver][SQL Server]Login failed.] OLE DB error
trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:
].
User's solution
This works!