Solved

SQL Server Management Studio doesn't see SQL Compact

Posted on 2014-02-05
20
1,854 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Alter table 4 23
TSQL Where clause for Date with CASE - what is wrong? 11 71
SQL Server stored proc 2 10
t-sql split string into multiple rows 7 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

914 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

17 Experts available now in Live!

Get 1:1 Help Now