Solved

SQL Access Denied

Posted on 2011-03-25
6
2,203 Views
Last Modified: 2012-05-11
On 2008 server R2 x64 bit installing SQL Express 2008 R2 x64

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: Access is denied
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110325_195340\Detail.txt

I looked at the log and not sure if that will help anybody
0
Comment
Question by:snyderkv
[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
  • 4
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35216842
Run setup as an administrator.

Here's instruction installing express r2 on win 2008 r2:
http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx
0
 

Author Comment

by:snyderkv
ID: 35217425
The link is exactly what I did, pretty much clicked next next next next. I don't see any value in it.

I gave the sql service account debug program rights, it also has logon as service right and local administrator. UAC is off, firewall service is started but turned off for allprofiles state. IIS is installed and I put it in 32bit mode and registered 32bit ASP

Maybe that has something to do with it. I'll install 32bit SQL 2008 R2 tomorrow and see.

I'm also installing the 64bit sql in the x86 folder (default) not sure if that's it.
0
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35217505
SeDebugPrivilege should be granted for admin account (to run setup), not for SQL Server service account.
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 

Author Comment

by:snyderkv
ID: 35217951
Ok will try it again. I'll get back.
0
 

Accepted Solution

by:
snyderkv earned 0 total points
ID: 35220860
FIXED!

I installed the 32bit version instead and it worked. Why wouldn't 2008Express 64bit work on 2008 R2 64bit? I don't know. I think it had something to do with the directory installation path not being in the x86 folder? Or maybe because I registered ASP.net for 32bit and IIS in 32bit mode. I do remember this being an issue even with a full install of SQL so it's definately the bits and not the version of SQL.

Thanks

0
 

Author Closing Comment

by:snyderkv
ID: 35252841
Fixed by installing 32bit
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

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…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

635 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