Solved

sql server 2005 installation error code is 29506 on windows 7

Posted on 2011-09-21
8
353 Views
Last Modified: 2012-05-12
I keep trying to install sql 2005 and management studio under windows 7 but am getting the infamous error 29506.  The kb article says to  change the permissions on C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\. But that directory does not even exist on my system.  

I'm a win7 newbie.  So don't rule out the possibility of silly user errors :)

0
Comment
Question by:_agx_
  • 5
  • 3
8 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36576645
Are you using CD for the installation?
0
 
LVL 52

Author Comment

by:_agx_
ID: 36576731
No
0
 
LVL 52

Accepted Solution

by:
_agx_ earned 0 total points
ID: 36576834
Not sure if this is what did it, but I navigated to c:\program files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL . Then took ownership of the folder:  Properties > Security > Advanced > Owner  and suddenly it's working.  Go figure ..


0
 
LVL 52

Author Closing Comment

by:_agx_
ID: 36597812
I was finally able to figure it out!
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 8

Expert Comment

by:venk_r
ID: 36576853
So if you figured it out.Cool.
And yes starting from windows vista onwards there has been more security restrictions.
0
 
LVL 52

Author Comment

by:_agx_
ID: 36576861
Yeah, it's a lot to get used to.  Just wish I'd guessed they meant c:\program files (x86)\ and not c:\program files\  sooner ;-)
0
 
LVL 52

Author Comment

by:_agx_
ID: 36582316
I got so caught up in trying to fix the darn problem I forgot to say thanks for responding.

So thanks :)
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36582536
Your'e welcome.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need help with a query 4 45
SQL Server DatePart HOUR 6 32
Trigger for audit 26 56
Grid querry results 41 56
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now