Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Access Denied

Posted on 2011-03-25
6
Medium Priority
?
2,240 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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

704 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