Microsoft Dynamics GP (Archived)

Cloud solution connection string

(0) Share

Report

Posted on by Ola Darwish

915

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nanook Software 2 on at

Like (0)

Report

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;

Was this reply helpful? Yes No
Jennifer Ranz on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ola Darwish 915 on at

Like (0)

Report

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

Was this reply helpful? Yes No