Resolved Question

Windows 7 - SQL server problems

I use SAGE ACT software which requires Microsoft SQL server. I previously had SAGE ACT premium installed (200Cool which had Microsoft SQL 2005 bundled into its installer. I have since uninstalled this edition of SAGE ACT along with Microsoft SQL 2005 - as I want to try out the latest SAGE ACT 2011. 2011 edition comes bundled with Microsoft SQL Server 2008 R2, however the program will not work because something goes wrong with the SQL Server install. I have tried downloading Microsoft SQL Server 2008 R2 directly from Microsoft and installing this however the install always fails due to the following message:

The following error has occurred:

Could not open key: UNKNOWN\Components\7ABFE44842C12B390AF18C3B9B1A1EE8\D9988C7307DFF18449AAF1B18067E522. Verify that you have sufficient access to that key, or contact your support personnel.

There is also the following codes:

LinkID 20476
Message ID 50000

I have looked at the logs of the install, but there is no further information other than this. I have also looked online but have been unable to resolve this problem. I have even tried downloading the latest SQL server preview release from the following link:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9

When installing I get exactly the same error as before. I then tried installing the standalone SQL server 2005 and this works, however nothing after 2005 seems to work.

This is driving me really mad and it means I am unable to run my SAGE CRM software. Does anyone know how I could solve this problem? I have read some help guides and am using the latest .net 4.0 etc, so I really don't know what to do?

My system is:

Windows 7 x64
Core 2 Duo 3.33ghz, 4GB Ram

Thanks for your help

Ad

Discussion is locked
marada2 has chosen the best answer to their question. View answer
Follow
Reply to: Windows 7 - SQL server problems
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: Windows 7 - SQL server problems
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Comments
- Collapse -
Clarification Request
Microsoft SQL Server

Please just forget about SAGE ACT, I only posted that to give a context behind my problems. My issue is with installing the Microsoft SQL servers (later than 2005) on my windows 7 machine. Please don't post anything from the ACT forums I have already spent 4 days looking at many forums with no joy.

Best Answer

- Collapse -
Re: install error

I googled the error message and had only a few hits. You'll like the "nightmare" of http://www.intellitechture.com/SQL-Server-2008-Install-Nightmare/ , I suppose.

It tells you the same as the error message: to verify the access to that registry key. Luckily, it also tells which one(s) and what to do if you don't have it. That might be the solution for you also.

Another option might be to "run as administrator". That might be in the right click menu for the install program.

Kees

- Collapse -
still not working
- Collapse -
I have sorted the problem

Hi Kees
I think your answer was probably the best. A couple of the things at the link you posted worked, although I had various corruptions and did a system restore. I then did a manual install of the SQL instancem but still had various problems with ACT. I then has to register various DLL and repair some of the registry. I now have it sorted but it has taken me nearly a week of stress!
Thanks for your help

- Collapse -
Answer
Have You Seen This Discussion?
- Collapse -
Please don't post anything from ACT forums

Please just forget about SAGE ACT, I only posted that to give a context behind my problems. My issue is with installing the Microsoft SQL servers (later than 2005) on my windows 7 machine. Please don't post anything from the ACT forums I have already spent 4 days looking at many forums with no joy. I am at the stage now where I am thinking about reinstalling windows as I just can't sort this.

- Collapse -
Answer
Manually Create the Microsoft

ACT! has an instruction for how to create the SQL Server instance manually, it usually help when the normal installation procedure fails:
http://goo.gl/Vf3Dy
Lennart Johansson
Sage ACT! Premium 2011 Product Specialist
Zoft 80 AB
http://actsupport.zoft80.com/
Tel. +4690-713550

- Collapse -
Answer
but what about the OS?

I realise that in happily using Sage ACT on SQL Server you're probably pretty strong on IT skills but I have to ask the question - you are aware that SQL Server 2005 doesn't work "easily" on Windows 7 and SQL Server 2008 won't work at all right?

I read something a few days ago about SQL Server 2008 developer being the only version of SQL Server that successfully installs and operates on Windows 7, all the others require Server 2008.

SQL Server 2005 Standard will install on Windows 7 but the installation and configuration procedure is a odd and very poorly documented online (no surprises there). A guide is available...

http://www.geakeit.co.uk/installations/installing-microsoft-sql-server-2005-on-windows-7-32-bit-and-64-bit.html

...but there is charge, couldn't find any Microsoft documented answer apart from the usual 'considerations' which don't cover the real problems you encounter.

From memory I think it needs to be installed in stages with a 'Surface Area Configuration' tool used. You'll probably have to google this for yourself though.

- Collapse -
Which brings up a good point/question.

Given the cost of support today, is it cheaper to move to 2008's SQL servers?

CNET Forums