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
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.