1.. EXEC sp_addlinkedserver ServerName1, N'SQL Server'
EXEC sp_addlinkedserver ServerName2
EXEC sp_configure 'remote access', 1
RECONFIGURE
GO
2.. Stop and restart the first SQL Server.
3..
4.. Run the following code on the second SQL Server. Make sure you are
logging in using SQL Server Authentication.
5.. -- The example shows how to set up access for a login 'sa'
-- from ServerName1 on ServerName2.
EXEC sp_addlinkedserver ServerName2, N'SQL Server'6.. EXEC
sp_addlinkedserver ServerName1
EXEC sp_configure 'remote access', 1
RECONFIGURE
GO
-- Assumes that the login 'sa' in ServerName2 and ServerName1
-- have the same password.
EXEC sp_addremotelogin ServerName1, sa, sa
GO
I done it in ServerName1 and ServerName2, and ServerName1 is runningstored
procedures from ServerName2.After doing at ServerName1EXEC sp_addremotelogin
ServerName2, sa, sa
GO
, running stored procedures at ServerName1 from ServerName2it is not
possible. I got error connection on ServerName1.Please help.Regards