Solved

SQL Server Management Studio doesn't see SQL Compact

Posted on 2014-02-05
20
1,803 Views
Last Modified: 2014-02-07
I run Management Studio and bring up the Connect to Server dialog. but the drop-down list of Server Names does not include the SQL Server Compact Edition server.

Any ideas ?

SQLMS 2012 v 11.0.2100.60 and SQL Server Compact 3.5 sp2 and 4.0 sp1
0
Comment
Question by:Dodsworth
  • 7
  • 6
  • 4
  • +2
20 Comments
 
LVL 19

Expert Comment

by:Kash
ID: 39835406
what server its installed on. if it is installed on the same machine then type 127.0.0.1 and then try. use local username/password
0
 
LVL 19

Expert Comment

by:strivoli
ID: 39835415
AFAIK, CE cannot be managed with the Management Console.
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 39835416
In the File > Connect Object Explorer dialog, change the Server Type dropdown to SQL Server Compact Edition.

Then in the Database File dropdown choose New Database.... and you're ready to go.
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39835657
@Eric: the Server Type box is greyed out :(

@Strivoli: I read another post that said that CE support has been removed from SSMS 2012.  What am I supposed to used instead ?
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39835677
You can use Visual Studio, you can try the Express edition.
You can look through codeplex to see if you like any of the tools there also.
e.g., http://sqlcetoolbox.codeplex.com/
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39835856
OK I have Visual Studio but can't see where to create a new db ?
0
 
LVL 19

Expert Comment

by:strivoli
ID: 39835882
Use the 2005 Management... details in the next post in about a couple of minutes.
0
 
LVL 19

Accepted Solution

by:
strivoli earned 500 total points
ID: 39835890
Microsoft SQL Server Management Studio Express is the 2005 version and should work with CE.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39835941
You can use the Server Explorer tab to access the menu to add connection to SQL compact edition, or create new database.  

In addition, here are some nice walk-through articles on MSDN:
http://msdn.microsoft.com/en-us/library/gg606540(v=vs.100).ASPX
http://msdn.microsoft.com/en-us/library/vstudio/bb546200(v=vs.100).aspx
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39838211
The create new sql server database option is dimmed out.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39838688
Did you look at the information on MSDN?  It steps you through the process nicely.
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39838819
In first link

2.In the Add New Item dialog box, select SQL Server Compact 4.0 Local Database

It's not there :(


In second link

2.Select Local Database in the list of available templates.

Not there either !
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39838843
What version of Visual Studio do you have?
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39839226
2012 express
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39839284
Ugh.  Like SSMS 2012, I do not believe VS 2012 Express supports CE.
You unfortunately may be stuck installing a different tool.  As others said above, older versions of SSMS will work (e.g., SSMS 2005 and SSMS 2008).  The tool I linked to in codeplex should work well also.
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39839344
Really ?  How then is anyone supposed to use up-to-date tools to create local databases for Windows Phone ? Data on WP8 is not so much a steep learning curve, more a downward spiral of despair !
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39839367
They are moving folks towards SQL Express LocalDB (and cloud-based Azure databases I suspect).
http://msdn.microsoft.com/en-us/library/ms233763(v=vs.110).aspx
0
 
LVL 1

Author Comment

by:Dodsworth
ID: 39839479
Azure Mobile Services is looking promising, but there's no support for LocalDB in WP8 or any sync framework for the times when there's no connection to the internet :(
0
 
LVL 19

Expert Comment

by:Kash
ID: 39839529
why not use mySQL and MAMP or phpmyadmin, a lot better free and less hassle.
0
 
LVL 19

Expert Comment

by:strivoli
ID: 39839611
Did you give Microsoft SQL Server Management Studio Express a try as I suggested you in my last post?
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

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

14 Experts available now in Live!

Get 1:1 Help Now