Solved

sql server 2005 installation error code is 29506 on windows 7

Posted on 2011-09-21
8
358 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 52

Author Closing Comment

by:_agx_
ID: 36597812
I was finally able to figure it out!
0
 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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