Connect to database on another server?

Results 1 to 2 of 2

Thread: Connect to database on another server?

  1. #1
    Join Date
    Dec 1969

    Default Connect to database on another server?

    How would one go about connecting to a database on another server? If I have two shared server accounts and one happens to be on server A and the other ended up on server B, becuase there are only 50 accounts per server, and I have code on server A that needs to use information from a database on server B, what issues will I need to address?<BR><BR>Thanks<BR>Liz Foust

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Speak to your DBA

    add them as LINKED servers and make sure the login is valid on both<BR><BR>then you can access the data in one db from the other db.<BR><BR>

Posting Permissions

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