SQL Server | PeteNetLive

Problem

Seen when reinstalling SQL 2008 R2 on a domain controller. Note: as a background the SQL Server was installed previously and then the server was promoted to a domain controller. Then when the attempt to reinstall SQL was carried out this happened:

Microsoft SQL Server 2008 R2 Setup
The following error has occurred.
SQL Server Browser service group does not exists. Check for earlier failures in the setup

Note: Yes thats a typo, but there is a typo in the error message.

Solution

1. You need to create the group(s) manually, logon to a domain controller > Windows Key+R (to run) > type ‘dsa.msc’ > Enter.

2. Create two Windows security groups called;

[box]

SQLServer2008SQLBrowserUser${ServerName} SQLServer2005SQLBrowserUser${ServerName}

[/box]

3. Retry the install.

KB ID 0000976

Problem

When trying to install SQL Server 2012 (Standard c/w SP2). This popped up;

Rule Check Result
Rule "Setup account privileges" failed.
The account that is running SQL Server Setup does not have one or all of the following rights: the right to back up files and directories, the right to manage auditing and the security log and the right to debug programs. To continue, use an account with both of these rights. For more information, see
http://msdn.microsoft.com/en-us/library/ms813696.aspx,
http://msdn.microsoft.com/en-us/library/ms813959.aspx and
http://msdn.microsoft.com/en-us/library/ms813847.aspx.

As I was logged in as the domain administrator, (yeah I know, but it’s my test network). I was confused.

Solution

1. Well, it turns out I don’t have those rights after all so lets grant them, Windows Key+R > Control admintools {Enter}.

2. Launch ‘Local Security Policy’.

3. Navigate to Security Settings >Local Policies > User Rights Assignment > Back up files and directories > Add in the user that’s being denied > Apply > OK.

4. In the same location locate ‘Manage auditing and security log’ > Add in the user that’s being denied > Apply > OK.

5. In the same location locate ‘Debug programs’ > Add in the user that’s being denied > Apply > OK.

6. Now try again, (remember if you added a group, you will need to log off and back on again.)

PeteNetLive

Technology that 'Just Works'

Tag Archives: SQL Server

SQL Sever 2012 Setup Error – Rule ‘Setup Account Privileges’ Failed

Problem

Solution

Related Articles, References, Credits, or External Links