Post reply

Setting up a linked server connection

  • January 18, 2005 at 7:12 am

    #86593

    I have a test and production db, and I want to transfer data from some tables from test to prod. Both are SQL servers, each on separate physical servers. Both use windows authentication security. I've tried several examples of linking servers and none work. I get login failed for user '/'. I tried adding logins with sp_addlinkedsrvlogin but still does not work. Now I am trying to delete the link and start over, and it keeps saying  'there are still remote logins for server 'serverX'. I've run sp_deletelinkedsvrlogin for each login that I added (sa and my own id) but it still gives the error.

    how do i get a list of the remaining logins and delete them? 

    how do i set up a simple server A to B linked server connection between two sql servers using windows authentication?

     

    THANKS

     

     

     

  • January 18, 2005 at 11:03 am

    #537900

    With this 2 procedures you can query remaining linked or remote logins on your servers: sp_helplinkedsrvlogin, sp_helpremotelogin (execute them on both servers).

    It is quite complicated task to configure linked servers with windows authentication. You can read more in this post:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=150105#bm150118

    Another way to transfer data from one server to another (without configuring linked servers) is using DTS. But it depends on your tasks.

  • January 19, 2005 at 1:39 am

    #537991

    Thanks, I'll take a look at this today. I had a feeling that WIndows Authentication was making it more difficult than it should be.

    BTW, I was trying to set this up to avoid a cumbersome transfer using DTS and import/export....

     

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply