Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Sales for Outlook 2007 fails on SQL 2005 EE Check

Posted on 2007-03-22
5
Medium Priority
?
506 Views
Last Modified: 2007-10-18
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.
0
Comment
Question by:megli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 18787924
It does seem to indicate that the login fails... which would say to me that you may not have proper credentials on this machine.  Is the user account that you're logged in with a member of the LOCAL Administrators Group on the machine as well as a member of the Domain Admins Group?

Jeff
TechSoEasy
0
 

Author Comment

by:megli
ID: 18789006
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 ..
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 18789074
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
0
 

Author Comment

by:megli
ID: 18789412
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?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 18789585
Well if I were that IT administrator I wouldn't allow you to join a domain and then not have GPO's apply... kinda makes all of the security for the domain fly out the window -- so to speak.

But you may be in luck... I just happened upon a possible work-around for you:  
http://groups.google.com/group/microsoft.public.crm.deployment/browse_thread/thread/d0293f5173716171/6b6327bd51bba694?&hl=en#6b6327bd51bba694

I haven't tried this, nor do I know if it would work... but it's worth a shot.

Otherwise, you might consider an alternate method such as running Virtual PC on your laptop running a Domain Member version of XP.

Jeff
TechSoEasy
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question