You’re offline. This is a read only version of the page.
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
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
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.
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;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,522
Super User 2024 Season 2
#2
Martin Dráb
228,441
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (