Error while creating Linked Server

Question

Hi All,

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

---

Banky

Answer 1

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/