megli
asked on
Microsoft Sales for Outlook 2007 fails on SQL 2005 EE Check
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.Fr amework.ED WTool.RunS nifferVali date 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.
17:59:23|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Fr
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.
ASKER
The Machine is not part of a Domain. And on my laptop, I'm actually using Administrator as my account.
Do you think that the CRM tools require the laptop to be part of a domain? That would be annoying ..
Do you think that the CRM tools require the laptop to be part of a domain? That would be annoying ..
Well, YEAH, it needs to be part of the domain... I don't know why you think that's annoying... we're talking about providing security for your most sensitive customer data!
Jeff
TechSoEasy
Jeff
TechSoEasy
ASKER
I'm a contractor for the company that uses MSCRM, plus I contract for a few other companies as well .. this means I have to join my own laptop to their domain so that I can enter data to their CRM. That is annoying. Plus, then I have to get their IT Adminstrator to make sure that their blanket GPO don't apply to me, etc.
And .. you are absolutely positive that this requires the laptop to be in the same domain?
And .. you are absolutely positive that this requires the laptop to be in the same domain?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jeff
TechSoEasy