Solved

SQL Server 2012 - New Local Server Group

Posted on 2014-03-18
5
525 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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