2012년 8월 10일 금요일 오전 9:25
In my project I want to execute one insert statement on remote server.For that purpose I created Linked server.While doing that I got following error.Does anybody have idea?
Thanks in advance.....
2012년 8월 10일 금요일 오전 10:41
Normally for this kind of Situtations what I do is:
1. Create a Login for account used on remote server with appropriate permissions.
2. "BE made using this security context" and give a Remote Login name and password.
3. If any Stored procedures are used using this linked server then set the RPC, RPC out values to True in Server Options.
And I would suggest creating linked server from scratch....
Hope this helps...........
Vamshi SQL DBA(MCITP) My Blogs: http://sqlserver-dba.co.uk http://sql-developers.co.uk/