Skip to main content
N
NVL-Tom
Inspiring
March 18, 2015
Question

Creating a Coldfusion Data Source that connects to a DB on a different server

  • March 18, 2015
  • 1 reply
  • 256 views

Your assistance is appreciated.  I am attempting to create a data source on server #1 that is to connect to a database residing on Server #2.  Thus far, each attempt made results in an error that the database "is already opened exclusively by another user, or you need permission to view its data."  Be advised that I am experienced in working with data sources when the database resides on the same server.

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    March 18, 2015

    There is no problem creating a datasource on server 1 that references a database on server 2.  But you will have to check the permissions on server 2 to make sure server 1 can connect. I suppose the error message is telling you as much.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices