Solved

sql server 2005 installation error code is 29506 on windows 7

Posted on 2011-09-21
8
359 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_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query help 2 68
SSMS Imprt data from Excel 7 38
How come this XML node is not read? 3 54
Error converting data type varchar to numeric. 4 14
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 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