?
Solved

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

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 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