Error 29506. SQL Server Setup Failed To Modify Security Permissions
Aug 15, 2007
Received the following error while installing SP2
MSI (s) (D8!A0) [21:07:09:062]: Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
Tried running install with a domain account and local account with same results.
Based on the error message, I checked permission on the drive and still received the same error.
Followed resolution based on KB 916766, this did not resolve the error.
Only possible resolution I found was to disable UAP, reboot and retry the install. This will be done as a last resort, but any other suggestion will be appreciated.
Last night at home on my 64 bit Vista machine, I encountered the same error 29506 that said that the management studio express could not be installed. I looked up the error message and below is what I received. I also installed the 64 bit .net framework which installed just fine before trying to install the SSSME.
I followed the instructions below but this did not seem to make a difference. However, I did not reboot after applying new permissions. I have installed this software a few times now on 32 bit machines for both XP and RC1 Vista, and have not had a problem. Last night, I did use the 64 bit version. Also, there is no data file yet because after the install it rolls back, so I gave myself Full permissions on the SQL server directory which should include all sub directories, right? Thanks, Teri Error 29506. SQL Server Setup failed to modify security permissions on file Drive:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLData for user SYSTEM. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
Note A SQL Server service pack refers to SQL Server 2005 Service Pack 1 (SP1) and later service packs. CAUSE This problem occurs because one or more data files exist that do not have the required permissions. By default, the Full Control permission of the Administrators group is granted to the data file when you create a database. If the permission of this group is removed from the data file, the SQL Server 2005 service pack setup will fail. RESOLUTION To resolve this problem, grant the Full Control permission to the Administrators group on all data files and on the Data folder. To grant the Full Control permission to the data files, follow these steps:
1. Locate the folder that contains the data files. By default, these files are located in the following folder: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
2. Right-click the data file that has no required permissions for the Administrators group, and then click Properties.
3. If the Administrators group is not in the Group or user names list, click Add, type Administrators, and then click OK.
4. Click Administrators in the Group or user names list, and then click to select the Allow check box for the Full Control item in the Permissions for Administrators list.Note If the files in the Data folder have an orphan owner, you have to take ownership of the files and then grant the Full Control permission to the files. We recommend that you do not change the default permissions for the data files.
I tried to install this evening SQL Server Management Express on my Windows Vista 32 bit Home Premium Edition + Sql server 2005 express.
The problem is that at the end of the installation this error comes out:
"Si è verificato un errore imprevisto durante l'installazione di questo pacchetto. Probabile problema con questo pacchetto. Il codice errore è: 29506"
Error message: Setup failed to configure the server
I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)
The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.
I downloaded it (via MSDN license) and accepted the defaults on the install.
Whenever I try to install SQL Server 2005 Express Edition on my Vista Ultimate x64 platform I get error 29506. All I could find on the web was that this is probably due to an access control problem. I have tried installing it as the local administrator, as a member of domain admins, and as the domain administrator. All get the same error. My domain is a Small Business Server domain. This may be part of the problem, but I can't imagine how.
When trying to force access to the domain administrator, I also seem to get an access problem.
Hi, I get the following error message error : "the setup failed to read IISmimemaptable the server code is 2147024893" and I cannot uninstall SQL Server 2005. Any idea this is happening. thanks!
We have a new Win 2008 Enterprise x64 server running SQL 2008When we try to connect to the server using Windows Authentication, from a user account which is a domain administrator, we get the following message:"Token-based server access validation failed with an infrastructure error"What needs to be configured here for this to work ?
I am trying to install the SQL7 server, at the end of the installation before rebooting the server I got the following error: "Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information". I have not seen that error before. I cannot install the SQL7 because I always get the same message. Your help would be very appreciate helping me to solve this problem.
I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message
native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.
I have had the same Error 29506 that a lot of people are having when installing SP2 for SQL 2005. I've tried the install with myself (a Domain Admin), local Administrator, cascaded full rights down the entire file system structure and still not luck. One thing I'm wondering if it is hanging me up is that all of my databases and logs are not on C:. They are on LUNS on a NetApp SAN (Data is on M: and Logs is on L:). Even the system databases (Master, Model, etc.) are on the LUNs. The error logs referenced permissions to the data directory under the default installation path on C:. Anyone else have this problem? Got a fix? I really don't want to migrate all of my data back to the local machine, apply the patch, them migrate back. Surely this SP should be able to read the data location from the SQL engine. And surely others have their databases on SANs.... I'm at a loss.
No logs created, this is all I have: Â Unhandled Exception: System.Security.SecruityException: Request failed. Â Â Â Â Â Â Â Â at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() Â Â Â Â Â Â Â Â at Microsoft.SqlServer.Chainer.Setup.Setup.Main()
Then the Managed SQL Server Installer box pops up with Managed SQL Server Installer has stopped working.
I am working with a SQLServer installation where all public permissionshave been revoked from the system.I currently hold the securityadmin and sysadmin roles to perform mylogicall access control work (creating logins and adding users todatabases and changing group memberships.)There has been a question as to whether or not I need the sysadmin roleto do my job, so we tried an experiment in dropping the sysadmin rolefrom my id.With no public permissions, I see no user information on the server,which really limits my ability to do the job.Has anyone ever worked with a super-locked-down server without thesysadmin role for doing security admin work?What I'm looking for is hopefully SQL to perform the access privilegesneeded for the security admin role by itself.Thanks in advance!
I'm trying to harden our SQL Server environment to improve overall security of our systems. I would like to check what specific permissions are granted to SQL Server, SQL Server Agent and SQL Server Integration Services account. I've tried with the "sc qprivs <service_name> " command, but it returns an empty privilege list. Is there a way to retrieve the permissions using a cmd or powershell command?
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
i have recently ported an old asp.net web application using crystal reports 9 from windows server 2003 to windows server 2008 . the crystal reports smoothly at first but one of the reports stopped working when the admin changed his password now the report is showing error. Failed to open a rowset
I have finally gotten a setup to work, but I suspect there are improvements I should make to the permissions. Here's the setup: I am accessing two databases, (aspnetdb and my own database called custom) on a local SQL 2005 server. In SQL Server Management Studio (SMS) I created logins at the level of the SQL instance for two users ( "NT AUTHORITYNETWORK SERVICE" and "viewer"). Then I select each user, and set the properties to access the Server Roles section. There I found each was given the public server role. Now here's where I set the permission to sysadmin. This setting allows my application to work, but I'm sure there are less permissive approaches I should take. However, I just can't seem to find a simple and direct explanation of the procedure to set more appropriate permissions. The "NT AUTHORITYNETWORK SERVICE" accesses aspnetdb in order to create users and membership settings. The "viewer" login accesses the database called custom, and it reads and alters this database. The application (which is name viewer) performs these operations using a connection string like this: Data Source=STORE;Initial Catalog=custom;Persist Security Info=True; User ID=viewer; password=xxxxx; What is the recommended way to set the minimal permissions for these logins on these databases?
We have a SQL 2012 SSRS instance. We need to modify the permissions on one of the reporting folders. I went to the Security setting of the folder, clicked "New role assignment", then entered a group name into the box and selected desired permission ("Browser" in this case).
However this always fails with the same error: "The user or group name 'BUILTINBUILTIN' is not recognized. (rsUnknownUserName)"
I always get the same error no matter if I enter user or group, domain or local. And it always says BUILTINBUILTIN. I've tried changing the SSRS service account to a domain account (it was a local one), but that didn't work.
When installing SQLEXPRESS I am getting this message:
Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled.
Please suggest what I can do . I had SQL Server 7.0 ( NT 4) installed on my desktop . I have not used it for a while and lately found that there is a problem to start service. So , I decided to reinstall it.
As a result of installation I got the message : "Setup Failed to configure the server" The log does not tell to much besides repreating the same message , that setup failed. What could be a problem ? How I can fix it.
I have Sql Server Express installed on Vista (service pack 2)
I have Visual Studio 2005 with an application that I'm trying to access it with within a WCF service.
The login ID of the service is added to the database.
The database has remote access turned on.
The ID is granted access to all databases within the server.
The thread is being set with WindowsProvider and the services set their thread to WindowsProvider.
The dataserver is set with using Windows Authentication for security.
When I open my connection to the database, though, it reports the typically useless message that the connection is not allowed and that the server may not allow remote connections.
How to I get past this? I've done everything right.
Here is my situation: I am creating a database driven ASP.Net web application that will be used over the internet. My ASP.Net application connects to my SQL server 2005 database/server by using a SQL server login. I am using the DPAPI API to encrypt my connection stings with a hidden entropy value for extra security. I am using the SQL login for obvious reasons, as my users will not have a windows login.
What I am trying to do: I want to limit this SQL login account to be able to just run/execute stored procedures and NOT access the tables or views directly. In my ASP.Net application I am using the MS applications data block, and I am using stored procedures for every single database access action. There is no inline SQL being executed from my web application.
What I have tried so far:
I created a new schema and made the above SQL login account owner of this schema. I then granted "Execute" permissions to the SQL login and DENY permissions to all other permissions.
I created an database role with "Execute" only permissions and DENY permissions to all other permissions.
What Happened: In BOTH of the above scenarios I tested a direct SQL statement against one of my tables, from my ASP.Net application and I was able retrieve data back, NOT GOOD, exactly what I am trying to STOP.
If someone could give me (Step-by-Step) guide on how to setup the situation I am looking for, I would be very grateful!
Hi I am trying to install SQL server 7 on XP. I did not install any prerequisite such as service pack 4. During the installation process, I received a error message that says:
'Setup fail to configure the server. Refer to server errorlog and cnfigsvr.out for more information. '
In Errorlog file, the last part of it says:
. . . SQL server's unicode collation is: 'English' (ID =1033) Comparison style =196609
SQL server's non-unicode sort order is: 'no case_iso'(ID=52)
SQL servers non-Unicode character setn is 'iso_1(ID=1)
AppData entry is present under the above registry entries with the value of "%USERPROFILE%Application Data
But the problem still exists.
Please Help, Thanks in advance, Sonia
The log file is as follows
========================
Microsoft SQL Server 2005 Setup beginning at Mon Jun 19 10:43:41 2006 Process ID : 3476 c:c8e46d550eeabd55d7setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/5/19 10:43:40 Complete: LoadResourcesAction at: 2006/5/19 10:43:40, returned true Running: ParseBootstrapOptionsAction at: 2006/5/19 10:43:40 Loaded DLL:c:c8e46d550eeabd55d7xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/5/19 10:43:41, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: -2146893813 Windows Error Text: Key not valid for use in specified state.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Oct 26 16:37:25 2005 Function Name: sqls::CryptSameUserSameMachine::ProtectData Source Line Number: 50
2148073483 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3476"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2006/5/19 10:43:41 Complete: ValidateWinNTAction at: 2006/5/19 10:43:41, returned true Running: ValidateMinOSAction at: 2006/5/19 10:43:41 Complete: ValidateMinOSAction at: 2006/5/19 10:43:41, returned true Running: PerformSCCAction at: 2006/5/19 10:43:41 Complete: PerformSCCAction at: 2006/5/19 10:43:41, returned true Running: ActivateLoggingAction at: 2006/5/19 10:43:41 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00F8CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3476"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
hi, Whenever i tried to install Sql Server 2005, the installation fails giving errors for event logs and error logs [microsoft][SQL Native Client][SQL Server]. The server could not load DCOM...
While trying to download SQL Server 2005 Express SP2 I receive the following error message: 'SQL server Setup Unexpectedly dailed. For more information review the Setup memory log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt'.
That log file simply contains the text:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
In the Files folder under log, a text file has been created with the following data:
Microsoft SQL Server 2005 Setup beginning at Mon Nov 19 20:30:29 2007 Process ID : 4648 c:fc359db69b5e5a0ff927be3c2esetup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/10/19 20:30:28 Complete: LoadResourcesAction at: 2007/10/19 20:30:28, returned true Running: ParseBootstrapOptionsAction at: 2007/10/19 20:30:28 Loaded DLL:c:fc359db69b5e5a0ff927be3c2exmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/10/19 20:30:29, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: -2146893813 Windows Error Text: Key not valid for use in specified state.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Jun 14 16:28:04 2006 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50
2148073483 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "4648"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/10/19 20:30:29 Complete: ValidateWinNTAction at: 2007/10/19 20:30:29, returned true Running: ValidateMinOSAction at: 2007/10/19 20:30:29 Complete: ValidateMinOSAction at: 2007/10/19 20:30:29, returned true Running: PerformSCCAction at: 2007/10/19 20:30:29 Complete: PerformSCCAction at: 2007/10/19 20:30:29, returned true Running: ActivateLoggingAction at: 2007/10/19 20:30:29 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00DFCFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered.
Can anyone give me some advice on what I need to correct in order to be able to install SQl server Express? Thanks very much in advance.
One of my customers is trying to setup SQL Server 2005 Express SP1 on his Windows XP Home SP2 machine.
Setup failed with the following in the Summary.txt file:
-------
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Mon Dec 04 23:59:22 2006
D86VH461 : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Mon Dec 04 23:59:23 2006
---------
What is this D86VH461 error code? I seached the Internet and could not find any information on it.
I´m running WinXP SP2 with 1GB RAM, dotNET 2.0. and a previous install of SQL Server 2000. I have tried to install SQL Server 2005 Express and it fails early in the installation: "SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file...". The log file is: (!)
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Wed Jun 14 10:27:51 2006
I have tried named instances, reinstall SQL Server 2000, search readme, kb, forums about the problem....nothing
I had a strange experience with MS SQL Server 2005 Express Edition installation, I am running a P4 3G Processor, 1 GB of RAM, Windows XP SP2, 300 GB HDD (SATA if it matters at all :) ) And using Visual Studio Pro 2005.
I have managed to install the SQL Express with no hassle at all, then had to format my HDD, and start from scratch, to make a new home for my VS 2005 Pro (The 300 GB HDD) And managed to install the SQL Express as part of the VS 2005 without any problems, after using it for 3 months now, I've started a new project in VS 2005, and tried to add a new SQL DB, but it had failed for several times.
I€™ve decided that the files got corrupted for some reason and tried to reinstall the MS SQL 2005 using the original SQL Express installation file I've used before, but without joy.
I thought that it is conflicting with some new MS Update patch and downloaded the latest SQL Express advanced installation, but that did not fix the problem either.
The message I'm getting every time I attempt the installation is" SQL Server service failed to start" with all the bla bla about the online books and whatever useless stuff to learn how to start the service manually.
I have uninstalled the whole thing, including VS 2005, .NET Framework, and any registry trace of the SQL Server installation, but again all in vain.
Finally, some smart wizard suggested in one of the threads that if your computer is not part of a domain, you should run the SQL service as a local service, using the advanced option during the first step of the setup.
And guess what! It worked!!!! My Question is why did it work during the first two installations, without me fiddling with the advanced installation feature? My computer was and still is, not part of any domain, my hardware did not change at all, and I had the installation failing with or without any software installed!
When i try to install, the filed are extracted and then i get this error message:
SQL Server Setup unexpectedly failed. For more information, review the Setup summery log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
I open the file and this is all i get:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional
Service Pack 2 (Build 2600) Time : Mon Apr 02 15:31:10 2007
I looked in this forum at others peoples threads and it seems as if they all have a lot larger Summary.txt file. I never had any other verson of SQL Server installed on this computer and i just uninstalled .net 2.0 framework and reinstalled it.
My computer runs Windows XP Pro with SP 2, AMD Athlon 64 Processor 3500+ 2.20 GHz, 1.00GB of RAM.
Anyone have any clue why the installation wont even start?
