Solved

SQL Server 2012 - New Local Server Group

Posted on 2014-03-18
5
552 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
[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
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

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 …
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 …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

615 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