Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Access Denied

Posted on 2011-03-25
6
Medium Priority
?
2,263 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
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

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…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

971 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