sql-server-linked-server-creation-error-ole-db-provider-sqlncli11-for-linked-server

Setp-1

Setp-2

Setp-3

Setp-4

Setp-5

Setp-6

Setp-7

LINKED SERVER CONNECTION  QUERY:: 

SELECT QUERY

SELECT *

FROM [192.168.1.110].XX_GROUP.XX_TABLE

INSERT QUERY

DECLARE @EmpID INT,@Name VARCHAR(50)

INSERT INTO [192.168.1.150].DBL_GROUP.dbo.XX_GROUP.XX_TABLE(EmployeeId, Name)

Select @EmpID,@Name 

OPENSQL OLEDB DATA SOURCE CONNECTION :: 

You Must be copy this  Below Code and  Run into SQL SERVER Management Studio.

==========================================================

EXEC sp_configure 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'ad hoc distributed queries', 1

RECONFIGURE WITH OVERRIDE

GO

Include OPENDATASOURCE Query This Way

SELECT TOP 1 * FROM OPENDATASOURCE ('SQLOLEDB', 'Data Source=192.168.1.110;User ID=XX;Password=XXX').TESTDATABASE.dbo.TAST_TABLE

Create Link Server ::
https://blog.sqlauthority.com/2015/10/03/sql-server-linked-server-creation-error-ole-db-provider-sqlncli11-for-linked-server-returned-message-invalid-authorization-specification/


Error Link Server ::
https://blog.sqlauthority.com/2017/12/28/sql-server-linked-server-error-tcp-provider-no-connection-made-target-machine-actively-refused/

Fix Link Server ::
https://blog.sqlauthority.com/2016/06/21/sql-server-fix-linked-server-error-7416-access-remote-server-denied-no-login-mapping-exists/