[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2013-01-15
5
Medium Priority
?
2,400 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
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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Integration Management Part 2

873 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