Solved

SQL Server 2012 - New Local Server Group

Posted on 2014-03-18
5
515 Views
Last Modified: 2014-03-19
Problem:
Can't create a (Server Group ? Instance?) for SQL Server 2012

info - See Graphic Below
I'm using SQL Server Express 2008 and a customer has a database from SQL Server 2012 that I have to look at.  I installed SQL Server 2012 Express on my local computer and can't seem to add a database.

I created a (Server Group ? Instance? - I'm not sure what you call it)  of BCData\Exp_2012
which has a white dot.
BCData\Exp_2008 my older server on the local machine has a green arrow and allows me to restore a 2008 database.

How do I create a 2012 instance where I can restore a 2012 database.

Note:  I can't restore the 2012 database to BCData\Exp_2008

Note2: When I right click on BCData\Exp_2012 - go to properties an click the test button I get the below error.

Thanks in advance for any help.
LJG SQL Server 2012 Problem
0
Comment
Question by:LJG
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39939486
Hi,

This indicates that the SQL Server service is not running.  Start the service using service manager and see if OK.

Regards,

Bill
0
 
LVL 2

Author Comment

by:LJG
ID: 39939511
Thanks Bill

Facts
Under Services the only thing I have under SQL are to do with 2008
     SQL Active Directory Helper Service
     SQL Server (Exp_2008)
     SQL Server Agent (Exp_2008)    
     SQL Server Browser
     SQL Server VSS Writer

Thought after researching this morning
Did I install the wrong file?  I installed
   SqlLocalDB.MSI
   SQLManagementStudio_x64_ENU.exe

Should I have installed
    SQLEXPR_x64_ENU.exe instead of SqlLocalDB.MSI
if so what's the best way to recover?

thanks
LJG
0
 
LVL 14

Accepted Solution

by:
Bill Ross earned 500 total points
ID: 39939529
Hi,

Since you have not used any SQL 2012 yet you should go to control panel and remove any SQL2012 specific entries.

Reboot.
 
Run the file  SQLEXPR_x64_ENU.exe ans set up a different instance name like SQLExpress2012.

That will be the easiest way.  Then you have  a clean install and should recover everything.

Regards,

Bill
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39939533
Note:  ONLY remove SQL 2012 specific entries.  If in doubt - leave it as it may be used by 2008.
0
 
LVL 2

Author Comment

by:LJG
ID: 39939830
Bill
Thanks so much for the answer that got me up and running.

I did ask another question about the files.
https://secure.experts-exchange.com/askQuestion.jsp?taid=5639
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now