Breaking news from around the world
Get the Bing + MSN extension
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I am trying to connect an on-premise SQL Business Central Solution to a online BC. I have managed to install the Integration Runtime Service, and it states it is connected to cloud service, but if I in the assisted setup in BC Online, try and click next to verify the connection, it just says check your settings.
I checked the windows event log, and the following entry seems to indicate something is wrong with my connection string, but I can´t see the issue. "Execute task failed. Error message: 'Invalid database connection string provided. Check the connection string at 'Source' side.'"
My connection string is like this :
Server=localhost\SQL;Initial Catalog=Demo Database NAV (13-0);UserID=PPO;Password=Password123;
I even took this database to Azure SQL, but no luck connecting there either.
Does anyone have any idea what could be wrong?
Solved - for anyone else who can't get it to work, try this one -
Hi Povl O,
I am facing some other issue while configuring the "Intelligent Cloud", after putting the SQL connection string, on the next page I did the Company Selection for replication, till here it is working fine. But on the next page where we need to "Schedule Data Replication", i can't enable it, rather the field is grey'ed out for me.
I used below connection string
Server=<<MachineName>>\NAVDEMO;Database=Demo Database NAV (13-0);UID=<<Username>>;PWD=<<Password>>;
Can you please help?
It worked for me now. The blunder which I was doing is to run "Assisted Setup" from on-premise BC rather then Tenant BC.
The connection string is the key. One slash between server name and instance and a space between User and ID. Also use SQL authentication, not Windows.
Business Applications communities