469,600 Members | 2,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

remote stored procedure on MSDE

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
0 1275

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Brad H McCollum | last post: by
5 posts views Thread by great_googley_moogley | last post: by
7 posts views Thread by Douglas Buchanan | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.