Windows 7 forum

Resolved Question

Windows 7 - SQL server problems

by marada2 / May 2, 2011 6:53 AM PDT

I use SAGE ACT software which requires Microsoft SQL server. I previously had SAGE ACT premium installed (2008) 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

marada2 has chosen the best answer to their question. View answer
Discussion is locked
You are posting a reply to: Windows 7 - SQL server problems
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: 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.
Collapse -
Clarification Request
Microsoft SQL Server
by marada2 / May 2, 2011 6:25 PM PDT

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.

All Answers

Best Answer chosen by marada2

Collapse -
Re: install error
by Kees_B Forum moderator / May 2, 2011 7:19 PM PDT

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
by marada2 / May 2, 2011 10:11 PM PDT
In reply to: Re: install error
Collapse -
I have sorted the problem
by marada2 / May 4, 2011 8:09 AM PDT
In reply to: Re: install error

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?
by Grif Thomas Forum moderator / May 2, 2011 9:54 AM PDT
Collapse -
Please don't post anything from ACT forums
by marada2 / May 2, 2011 6:27 PM PDT

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
by RLennartJ / May 3, 2011 7:03 PM PDT

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?
by jeffgronkjar / July 16, 2011 7:04 PM PDT

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.
by R. Proffitt Forum moderator / July 17, 2011 1:03 AM PDT
In reply to: but what about the OS?

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

Popular Forums
icon
Computer Newbies 10,686 discussions
icon
Computer Help 54,365 discussions
icon
Laptops 21,181 discussions
icon
Networking & Wireless 16,313 discussions
icon
Phones 17,137 discussions
icon
Security 31,287 discussions
icon
TVs & Home Theaters 22,101 discussions
icon
Windows 7 8,164 discussions
icon
Windows 10 2,657 discussions

CNET FORUMS TOP DISCUSSION

Help, my PC with Windows 10 won't shut down properly

Since upgrading to Windows 10 my computer won't shut down properly. I use the menu button shutdown and the screen goes blank, but the system does not fully shut down. The only way to get it to shut down is to hold the physical power button down till it shuts down. Any suggestions?