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.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.
megliAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
megliAuthor Commented:
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
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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
megliAuthor Commented:
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
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Productivity Apps

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.