So if you’re like me, you are starting to use Microsoft’s Power BI even more. It’s a great tool, and really helps with Data Visualizations especially if you have the right data model to report from. The difference between having the right data model or not are simply mind boggling! Make sure you have the […]
A customer of ours had come to us facing a rather interesting issue. Every night around 1am their CRM database log file would grow to 31GB and cause the log drive to fill up. When users would log into CRM in the morning, they would receive SQL errors stating that their transactions could not be […]
Join me at the CRMUG Summit In Reno NV. This is the premier Dynamics CRM Event of the year. Don’t miss out, not too late to register below. More details.. http://www.crmugsummit.com/home Here’s my preliminary schedule. Please refer to the website! Monday, October 12 8:00pm-10:00pm @ Peppermill – Terrace Lounge Chapter Leader Bash Tuesday, October […]
We recently stumbled upon an issue when upgrading a customer from CRM 4.0 to CRM 2013. As is required, you must first upgrade the 4.0 database to 2011 and then from 2011 to 2013. The 4.0 to 2011 upgrade succeeded without error but threw an error when going from 2011 to 2013. 2013 was on […]
Microsoft has begun switching over many of our Microsoft Dynamics CRM customers to CRM 2013. Here’s some things you should know about the overall process: 1. Ensure you have another environment (test/dev) that matches your CRM production setup. This is a best practice by far. Not having a test environment, makes troubleshooting and changes in […]
While working on a routine CRM 2011 installation, all system checks passed except for Microsoft SQL Server’s. It failed with “The SQL Server ‘Server Name’ is unavailable. Gut instinct was firewall issues here. Disabled Windows Firewall on SQL an CRM servers but still […]
Installation of the Microsoft Dynamics CRM Reporting Extensions formally known as the SSRS Data Connector (Still in on the installation media in same folder) is necessary so that CRM and SQL servers can communicate over the kerboros double hop issue when using to seperate servers. The error below was received because a SQL Server was replaced the SSRS Data Connector […]
Microsoft has just released Update Rollup 10 for Microsoft Dynamics CRM 2011. One of the main areas we have been testing with is within quick finds (searching) using the Outlook Client. To further explain, please understand that the Microsoft Dynamics CRM 2011 Outlook Client uses a completely different SQL query than its Web client counterpart prior to Update Rollup 7. This […]
The use of SQL TDE – Transparent Data Encryption is a great way to secure your Microsoft Dynamics CRM 2011 or 4.0 systems, especially when they contain sensitive data like credit cards or social security numbers. This ensures that even if someone gets a copy of your database, it cannot be used or restored on […]
A common error when upgrading or installing CRM 2011: This error can be resolved by modifying the existing SQL server installation. From Control panel, click add/remove programs, click on SQL Server installation, change/ add features. You will be prompted for the original install media so make sure you […]