I am attempting to query a SQL 2008 x64 database from a SQL 2008 x64 database. All attempts have failed, whether using Linked Server or OpenQuery. To create the Linked Server entry I have used the linked server dialog, the script it creates and the sp_AddLinkedServer procedure. The error occurs whether I use Windows Authentication or the SQL Authentication with sa user credentials.
In security tab i have selected the remote user name and password
in bottom of the page 4 options available
Not be made
Be made without using security context
Be made using the login's current security context
Be made using security context
i have seleced the "Be made without using security context" this options
It says The login failed
I have tried in another way
exec sp_addlinkedserver 'ipaddress'
select * from [ipaddress].dbname.dbo.t_tablename
i have execute the above query i got following error mrssage
Could not find server 'ipaddress' 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.
thanks