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
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
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.