By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,187 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,187 IT Pros & Developers. It's quick & easy.

remote stored procedure on MSDE

P: n/a
1.. EXEC sp_addlinkedserver ServerName1, N'SQL Server'
EXEC sp_addlinkedserver ServerName2
EXEC sp_configure 'remote access', 1
2.. Stop and restart the first SQL Server.
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
-- Assumes that the login 'sa' in ServerName2 and ServerName1
-- have the same password.
EXEC sp_addremotelogin ServerName1, sa, sa
I done it in ServerName1 and ServerName2, and ServerName1 is runningstored
procedures from ServerName2.After doing at ServerName1EXEC sp_addremotelogin
ServerName2, sa, sa
, running stored procedures at ServerName1 from ServerName2it is not
possible. I got error connection on ServerName1.Please help.Regards
Jul 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.