The answer is “it depends.” It depends on how you define “works with.” There is no PowerApps connector for D365 on Premise. There is a SQL Server connector, and this connector can connect to on premises SQL databases. This includes the D365 on premise SQL database. So you can make an app that reads directly […]
Tip #923: Where is my license key?
A client recently moved from a SPLA license to a Volume License (VS) license for CRM On Premises. They needed to replace their license key, but the Volume Licensing Service Center (VSLC) said a key code was not required for Dynamics CRM 2016. The answer is there still is a product key, but the volume […]
Tip #681: Hunting down invisible timeouts
Application Request Routing (ARR) feature allows creating a reverse proxy front-end for your on-premises deployment. Web Application Proxy (WAP) is another (newer) kid on the block allowing DMZ deployments of CRM. We’ve been successfully using both for quite some time and they are way down on the list of suspects when things go wrong. And […]
Tip #659: Installing Dynamics CRM on a named SQL Server instance
It is possible to install Dynamics CRM On-premises using SQL Server named instance. For most parts, the process is straightforward and no different from a “standard” installation except that you have to use server_name\instance_name notation when referring to SQL Server. But sometimes things don’t go according to the plan and this is what I learned: […]
Tip #536: CRM Online, SharePoint On-premises and OneNote walk into a bar
There seems to be a theme here, at CRM Tip of the day, with trios of various components walking into refreshment establishments. On this occasion, it did cost me a few hours of mouse-bending investigation. Enjoy the summary. As we mentioned before, if you carefully followed the steps to configure server-based authentication for Dynamics CRM […]
Tip #519: Keep your precious SharePoint on-premises
Most of the people in our small but very proud Dynamics CRM universe are perfectly aware of the very cool integration between Dynamics CRM Online and SharePoint Online. Yes, the one which is required to enable other cool features like OneNote integration unleashed (had to add a cool word for the third link). As I […]
Tip #358: How to delete deleted report
No, it’s not a typo – I am going to talk about deleting the deleted. – “What?!” Let me explain. We all have that Rupert/Vernona/Joe/Jill on our team who think they know best and, for some inexplicable reason, management agreed and granted them privileges sufficient to deliver some real damage. Like going into SQL Server […]
Tip #347: How to use datetime fields in WHERE clause
Gotta love user Q&A sessions, like the one at Convergence 2015 that I had a privilege to take part in. Questions from users are always refreshing, very often challenging and sometimes they are just the reminder that any small bit of information that one possesses is not necessarily the common knowledge. On this occasion question […]
Tip #336: Choose your name wisely
A common mistake when setting up your on-premises CRM organization is choosing the wrong name. Name not display name. Frequently when seeing the field to enter the organization name, the novice CRM implementer will think they should enter the name of their company/organization. This is generally a bad idea. The organization name will form part […]