none
SQL Server CE in Management studio express

    Question

  • Hello,

    I am trying to connect to sql server CE trough SQL Management studio express. But it seems like it only wants to connect to an SQL server express instance. Does SQL server CE needs to run as a server? because I can't seem to be able to just connect to a file. Does Anyone know how to connect to SQL CE?
    Thanks!

    Greetings,
    Mark
    Friday, September 07, 2007 9:00 AM

Answers

All replies

  • You mus have SQL Server Management Studio Express SP2 installed in or to manage SQL Compact files. There will be a new "server" type called "SQL Compact Edition". And SQL Server Compact is a in-process database engine, not a service. You can download SSMSE SP2 from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&displaylang=en

    Friday, September 07, 2007 1:18 PM
  • Thank you! I will download it immediately!
    Friday, September 07, 2007 2:18 PM
  • Hi Erik

    Thanks for your ExportSqlCe tool, BTW. I've been needing something like that.

    I'm having this same problem, only on SSMSE 2008 x64 and SQLCE 3.5 SP2 x64 (w/VS2010 x86). Win7 Ultimate x64.

    In SSMSE I only get the Database Engine option on the Connect dropdown.

    Any ideas? It used to work on my old WinXP x86 machine.

    Thanks,
    Jeff

     

    Friday, August 20, 2010 10:39 PM
  • You probably should try to re-install the SQL Compact tools MSI: SSCESqlWbTools.msi (from your SSMS installation media).

    I see it in E:\x86\Setup (and E:\x64\Setup).


    Visit my SQL Compact blog - http://erikej.blogspot.com - Please mark as answer, if this was it.
    • Proposed as answer by InteXX Saturday, August 21, 2010 6:28 PM
    • Marked as answer by ErikEJMVP, Moderator Sunday, August 22, 2010 2:28 PM
    Saturday, August 21, 2010 9:25 AM
  • Yep, that did the trick! Good man  :-)

    Thanks for all the great work that you do. You're a national treasure  :-)

    Saturday, August 21, 2010 6:29 PM