January 19, 2011 at 7:25 am
Hi,
I have a local server 'LocalA', which need run one store procedure on another server 'RomoteB' via the Linked server 'BLS' created on the 'localA'. But I got following error when I called store proc via linked server. the rpc out has been set to be true. and the local server 'LocalA' is a Hyper-V server. I also use anotner physical machine instead of 'LocalA' to run same query, it worked fine. I think there should be some problem on my local server 'LocalA', which is Hyper-V server. Is there any body can help me take a look? Thanks a lot.
Could not execute procedure on remote server 'BLS' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
Thanks
Lindsay
January 19, 2011 at 12:53 pm
In order for LocalA to talk to LocalB or vis-a-vis you need to add the linked servers first. Read
http://msdn.microsoft.com/en-us/library/ms190479.aspx to find out more about how you can do it. Alternatively, talk to your DBA about this, probably he might be the best person to guide you 🙂
January 19, 2011 at 6:26 pm
Thanks for your reply rajiv^_^
actually,I have already added linked server, which name is ALS. that's why I got the error in my original post when I call store proc via the linked server. My question is that why I got that error......
January 19, 2011 at 6:37 pm
I have found the solution. use the following command and successully. and then run the execution should work. Share is with you guys, in case someone hit same issue:-)
exec sp_configure 'remote access', 1
reconfigure
Thanks
Linday
January 20, 2011 at 7:22 am
Thanks for sharing your solution Lindsay..Cheers!! 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply