Hi,
Kindly assist me...
I have setup a linked server between one SQL Server 2008 Enterprise edition server and with the other (as source) which is a SQL Server 2008 Std Edition.
EXEC master.dbo.sp_addlinkedserver @server = N'LINKED6', @srvproduct=N'SQLOLEDB', @provider=N'SQLNCLI', @datasrc=N'XXXXXX\SQL2008',
@catalog=N'AdventureWorks2008R2'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LINKED6',@useself=N'False',@locallogin=NULL,@rmtuser=N'linked_login_test',@rmtpassword='########'
While executing the below query, I am getting the error..
Please assist me ASAP to fix the issue...!
exec sp_serveroption 'LINKED6','Data Access', 'True'
SELECT *
FROM OPENQUERY(LINKED4, 'SELECT * FROM [XXXXXXX\SQL2008].[AdventureWorks2008R2].[dbo].[Customers]')
Error Msg:
OLE DB provider "SQLNCLI10" for linked server "LINKED6" returned message "Deferred prepare could not be completed.".
Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Msg 7202, Level 11, State 2, Line 1
Could not find server 'XXXX\SQL2008' in sys.servers. Verify that the correct server name was specified.
If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.