• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2979
  • Last Modified:

SQL Server Management Studio doesn't see SQL Compact

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
Dodsworth
Asked:
Dodsworth
  • 7
  • 6
  • 4
  • +2
1 Solution
 
Kash2nd Line EngineerCommented:
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
 
strivoliCommented:
AFAIK, CE cannot be managed with the Management Console.
0
 
Éric MoreauSenior .Net ConsultantCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
DodsworthAuthor Commented:
@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
 
Kevin CrossChief Technology OfficerCommented:
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
 
DodsworthAuthor Commented:
OK I have Visual Studio but can't see where to create a new db ?
0
 
strivoliCommented:
Use the 2005 Management... details in the next post in about a couple of minutes.
0
 
strivoliCommented:
Microsoft SQL Server Management Studio Express is the 2005 version and should work with CE.
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
DodsworthAuthor Commented:
The create new sql server database option is dimmed out.
0
 
Kevin CrossChief Technology OfficerCommented:
Did you look at the information on MSDN?  It steps you through the process nicely.
0
 
DodsworthAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
What version of Visual Studio do you have?
0
 
DodsworthAuthor Commented:
2012 express
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
DodsworthAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
DodsworthAuthor Commented:
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
 
Kash2nd Line EngineerCommented:
why not use mySQL and MAMP or phpmyadmin, a lot better free and less hassle.
0
 
strivoliCommented:
Did you give Microsoft SQL Server Management Studio Express a try as I suggested you in my last post?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 6
  • 4
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now