Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Sweden
    Posts
    15

    Question Unanswered: ACCESS between serveral SQL-servers

    I'v set up a new SQL6.5 server. The idea is to relieve our main server.
    The problem is that I can't run a SP on the main server from the new server.

    Ex: *fake data*

    Insert into newserver exec mainserver.database..sp

    this will generate:
    Msg 18484, Level 14, State 1
    Unable to connect to site 'newserver' because login failed

    I've managed to add the newserver in mainserver.master..sysservers and the mainserver in newserver.master..sysservers

    The way I see it I've got a problem with the users...??
    This is all new to me so please help me!

    Thanks:
    Bix

  2. #2
    Join Date
    Mar 2003
    Location
    Sweden
    Posts
    15

    Wink Access between several SQL-servers

    Hi, It's me again.
    I solved my problem, and it was easy...
    I guess that it was so easy that you guys didn't bother *s*

    If anybody else get my problem, the answere lays in "Remote Servers" under the "Server" menu.
    Register a remote server and map the logins...
    and everything works like a dream!

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •