Unable to get the data from 2 tables which are in 2 differenet servers

[vnr]

Hi all, I am trying to get the data from 2 tables which are in 2 different servers , to get that i have used "sp_addlinkedserver" .Using this I am able to connect to the server also .I have used the following commands for example my server ip is 11.12.23.121 EXEC sp_addlinkedserver '11.12.23.121' EXEC sp_addlinkedsrvlogin @rmtsrvname = '11.12.23.121' after this I am not bale to get the results of the linked server using following query select * from '11.12.23.121'.testdb.dbo.userreg Please tell me how to get the data from the linked server. Thanks in advance

[Mycroft Holmes]

Try the following

select * from [11.12.23.121].testdb.dbo.userreg

Never underestimate the power of human stupidity RAH

[vnr]

HI, Thank for your reply , i have tried to get the data using the query but getting the following error "OLE DB provider "SQLNCLI" for linked server "[server]" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "[server]" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". Msg 53, Level 16, State 1, Line 0 Named Pipes Provider: Could not open a connection to SQL Server [53]. " can you please tell me the solution for this. Thank you

[Mycroft Holmes]

When setting up the linked server you have not applied the correct credentials. When, under duress, we need to do this we use a SQL standard account between servers and set it up in SSMS when creating the linked server.

Never underestimate the power of human stupidity RAH