web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Connecting to RMS HQ i...
Microsoft Dynamics RMS (Archived)

Connecting to RMS HQ installed on a remote server

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have two machine (Server1 and Server2) wherein both RMS Headquarters is installed. I'm receiving this error when trying to connect from Server1 to Server2 using Headquarters Administrator installed on Server1 (File > Connect): SQL Server does not exist or access denied. ConnectionOpen (Connect()).

When Testing the Database Connection (File > Configuration) this error is the error: Error #-2147467259 [DBNETLIB] [ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 08001) (Native Error: 17) No help file available.

Server2 is up and all required fields (SQL Server name/IP address, Username, Password) are correct. Out of curiosity just want to check/know if it will connect. Is it possible?

Please forgive me I just new to Microsoft Dynamics RMS Store Operation/Headquarters.

Thank you,

Koymackoy

 

*This post is locked for comments

I have the same question (0)
  • Grier Fleischhauer Profile Picture
    Grier Fleischhauer 782 on at
    RE: Connecting to RMS HQ installed on a remote server

    You have either wrong database (misspelled), wrong password (misspelled) or wrong IP for server you are trying to connect to. Verify these settings in HQ Admin on the server you are trying to connect from. Should have settings set up to the server you want to connect to on the server you are connectiong from.

  • Community Member Profile Picture
    Community Member on at
    RE: Connecting to RMS HQ installed on a remote server

    Hi Grier! Thank you for your reply.

    I typed all the required field correctly, but still the error persisted. Please see the scenarios I tried below.

    At Server2: (Connection was successful when using the following)

    SQL Server name: (local)

    Username: sa

    Password: default123

    SQL Database: HQ

    Connection timeout: 20

    At Server2: (Connection was successful when using the following)

    SQL Server name: HQ (wherein HQ is the name of the server)

    Username: sa

    Password: default123

    SQL Database: HQ

    Connection timeout: 20

    At Server2: (Connection was unsuccessful when using the following)

    SQL Server name: 192.168.1.130 (this is the IP address of the server)

    Username: sa

    Password: default123

    SQL Database: HQ

    Connection timeout: 20

    At Server1: (Connection was unsuccessful when using the following)

    SQL Server name: 192.168.1.130 (this is the IP address of the Server2)

    Username: sa

    Password: default123

    SQL Database: HQ

    Connection timeout: 20

     

    Thank you,

     

    Koymackoy

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Connecting to RMS HQ installed on a remote server

    It's not something related to the credential or else you would've got a different error, I think it's something related to whether SQL server is listening for remote connections or not on TCP/IP and named paipes, u need to check the Surface area configuration in SQL 2005 (I don't recall it in SQL 2008)

  • Community Member Profile Picture
    Community Member on at
    RE: Connecting to RMS HQ installed on a remote server

    Thank you Hassan! Thank you very much..

    Koymackoy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans