Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cloud solution connect...
Microsoft Dynamics GP (Archived)

Cloud solution connection string

(0) ShareShare
ReportReport
Posted on by Ola Darwish 905

Hi 

trying to get the intelligent cloud to work but its failing and not seeing that integration run time is connected 

although it is connected 

my server is RRLTT03, my sql is RRLTT03, my system DB is DYN and I use sa 

I tried this

 :server=RRLTT03.rimrock.ca\RRLTT03;Database=DYN;UserId=sa;Password=Password;

and this

 :server=RRLTT03\RRLTT03;Database=DYN;UserId=sa;Password=Password;

but none of them connecting and I see that runtime is working 

I m using Fabrikam and BC Sandbox.

any ideas what could be wrong with my connection string?

Thanks 

Ola

*This post is locked for comments

  • Ola Darwish Profile Picture
    Ola Darwish 905 on at
    RE: Cloud solution connection string

    Hi Jennifer,

    Thanks for your reply.

    I opened a case for this issue and the answer was as follows

    --------------------------------------

    Hello Ola, thanks for the update. I hope your Thursday morning is going well.

    Yes, you can use a different D365 account or trial account.

    For your string, remove the : at the beginning of it, so you’re only entering the following:

           Server=RRLTT03;Database=DYNAMICS;User Id=sa;Password=GPacc3ss;

    Then when you add the SQL Connection string, don’t tab off that field, but click the Next button and you’ll arrows next to the string field, showing that it’s attempting to make the connection.

    -----------------------------------------------------------------

    The part that is related to tabbing off is one of the key things that fixed the problem.  

    Thanks

    Ola

  • Jennifer Ranz Profile Picture
    Jennifer Ranz on at
    RE: Cloud solution connection string

    Server=tcp:SQLserver;Initial Catalog=should be your Dynamics Database;User ID=xx;Password=xxxxx;

    One thing I would also try is make sure User ID has a space between User and ID...another place to check to see what is wrong with the connection string would be to launch your integration runtime config manager and go to diagnostics and enter your info to see if you can connect that way.  Enter the info here and choose test.  If you can't connect here you will not be able to connect within the Intelligent CLoud setup.

    diag.png

  • Suggested answer
    Nanook Software Profile Picture
    Nanook Software 587 on at
    RE: Cloud solution connection string

    The connection string sits inside your environment.

    I am assuming you DON'T have a NAME SQL Instance of RRLTT03...

    Try this...

    :server=RRLTT03;Database=DYN;UserId=sa;Password=Password;

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans