Windows 10
SSMS 13.0 (2016)
64 bit driver
Connected to local SQLExpress SQL Server
ODBC 64bit data source set up and "Test Connection" returns a success.
I get this error when I create a linked server:
Checking / Unchecking Allow Inprocess on MSDASQL does not make a difference.An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "SQLNCLI11" for linked server "MYSFMCINSTANCE" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "MYSFMCINSTANCE". (Microsoft SQL Server, Error: 7399)
Any idea what the issue could be?