Microsoft Sales for Outlook 2007 fails on SQL 2005 EE Check
Posted on 2007-03-22
When using Outlook 2007 and the updated Microsoft CRM Sales for Outlook designed for Office 2007 and Vista users, the installation fails the requirements check in regards to there being a local SQL 2005 installation. However, it was installed and setup by the setup application. I have redone the installation, rebooted, etc to no success. The installation log shows the following:
17:59:23|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server™ 2005 Express Edition database
17:59:23|Verbose| Calling BaseGroup.Validate
17:59:23| Error| Cannot open database "MSCRM_MSDE" requested by the login. The login failed.
17:59:23| Error| Check ExistingDatabaseValidator : Failure: Failed to access the Microsoft SQL Server MEGLI_MONSTER\CRM.
Which obviously seems to indicate either that the database doesn't exist or the login fails. However, I am unsure of how to check what DMs are installed with SQL 2005 Express Edition since it does not come with a true management console.
Any assistance in this matter would be greatly appreciated! Also, the more detailed the better.