Solved

SQL Server 2012 - New Local Server Group

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL BCP Extra Lines Between Records 2 23
sql how to count case when 4 24
SQL - format decimal in a string 5 38
Negative isnull? 3 14
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

789 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