Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Issues installing SQL 2008 Express R2 on machine already running SQL 2012 Express

Posted on 2013-01-15
5
Medium Priority
?
2,370 Views
Last Modified: 2013-01-15
Hi Experts,

I asked this question yesterday and got some positive responses:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27994359.html

I was installing it this morning but it's not installing. As the other expert comments said, I gave it a completely new instance name during the install.

I don't know what's going wrong.
The only error I get is:
"SQL Server Browser service group does not exists. Check for earlier failures in the setup"
The earlier failure is "Installation completed with failures".

If I look in the services, the new instance is there, but it wont start.

Any help would be superb.
I know this is very brief, but I'm not sure what information to find, or where to find it.
0
Comment
Question by:INHOUSERES
[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
5 Comments
 
LVL 19

Expert Comment

by:lamaslany
ID: 38777938
Can you check the security groups on the machine and see if you have any that start 'SQLServer'?

PS: Is this a domain-joined machine or stand-alone?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 38778046
0
 
LVL 10

Expert Comment

by:CSIPComputing
ID: 38778082
I'm guessing that you're installing on a DC of some sort.

In this scenario, the SQL Installer can't create the security groups it requires, so you've got to create them yourself.

You need to know the name of your machine (e.g. "Server01")

Then create the group:
SQLServer2008SQLBrowserUser$Server01 and add the the Service Account (e.g. Network Service, or the named service account if you're using one) to the group.

You'll probably need to uninstall the failed installation (as you can see the instance), and then re-try the installation.
0
 
LVL 10

Expert Comment

by:CSIPComputing
ID: 38778084
That petenet article covers it nicely!
0
 
LVL 5

Author Comment

by:INHOUSERES
ID: 38778088
Thanks AngelIII - That link explained how to get it sorted really easily.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

610 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