Link to home
Start Free TrialLog in
Avatar of INHOUSERES
INHOUSERES

asked on

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

Hi Experts,

I asked this question yesterday and got some positive responses:
https://www.experts-exchange.com/questions/27994359/Running-SQL-Express-2012-2008-side-by-side-OR-Downgrading-SQL-Express-2012-to-2008.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.
Avatar of lamaslany
lamaslany
Flag of United Kingdom of Great Britain and Northern Ireland image

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?
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
That petenet article covers it nicely!
Avatar of INHOUSERES
INHOUSERES

ASKER

Thanks AngelIII - That link explained how to get it sorted really easily.