Skip to main content
NVL-Tom
Inspiring
Mar 18, 2015 7:41 PM UTC
Question

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

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 is closed to new replies. Start a new post to keep the conversation going.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Mar 18, 2015 9:53 PM UTC

    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.

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