none
SSMS unable to connect with Sql CE RRS feed

  • Question

  • Hi

    My installation of Sql Server Management Studio 2008 R2 does not appear  can only connect with SqlExpress.  Although the option for connecting to Sql Server Compact is shown in the Connect drop down, it is grayed out.  I have a windows 7 64 bit system, running VS 2010.  My control panel indicates that Sql Server CE 3.5 sp2 is installed (x86 and x64). 

    Does SSMS for Sql Express support Sql CE? and how do I get it to connect to a SSCE .sdf file?

    Thanks


    Robotuner
    Wednesday, November 16, 2011 11:43 PM

Answers

  • Hi Robotuner,

    SQL Server Compact 3.5 Service Pack 2 (SP2) is included with SQL Server 2008 R2 and Visual Studio 2010.
    You need to download and install SQL Server 2008 R2 from http://www.microsoft.com/download/en/details.aspx?id=3743.

     

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Robotuner Wednesday, November 23, 2011 7:54 PM
    Tuesday, November 22, 2011 8:02 AM
    Moderator

All replies

  • Hello,

    You can use SQL Server Management Studio to get connected to SQL Server Compact 3.5.

    This issue may be solved by repairing SQL Server Management Studio. This way shared components may be updated.

    The following thread may help you:

    http://social.msdn.microsoft.com/Forums/en-AU/sqlce/thread/ba3aa484-cc22-463e-a63c-f63cbfbce3b7

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Thursday, November 17, 2011 1:42 AM
    Moderator
  • Hi Robotuner,

    SQL Server Management Studio supports SQL Server Compact 3.5 SP2.
    In the File > Connect Object Explorer dialog change server Type dropdown to SQL Server Compact Edition and then choose in Database File dropdown.
    Connect to Server (SQL Server Compact): http://msdn.microsoft.com/en-us/library/ms180101.aspx.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Friday, November 18, 2011 8:43 AM
    Moderator
  • I've seen numerous links, to this, but unfortunately, when I start Sql Server2008R2, the Connect to SErver dialog appears and the server name is: .\SQLEXPRESS, Authentication is Windows.

    When I select the drop down to change the server:  I only have local as the other option.

    When I connect using windows authentication, my .\SQLEXPRESS server is shown.

    When I select File, Connect Object Explorer I get the exact same dialog with the exact same choices.  How do I get SqlCE included?

     


    Robotuner
    Monday, November 21, 2011 3:18 AM
  • Hello,

    Please use the following resources to get connected to SQL Compact using SQL Server Management Studio:

    http://www.julian-kuiters.id.au/article.php/sqlce-connect-managementstudio

    http://msdn.microsoft.com/en-us/library/ms171916.aspx

    Please change the server type.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, November 21, 2011 3:42 AM
    Moderator
  • Maybe I'm not describing my problem correctly.
    The first link tells me to select File menu -> Connect Object Explorer and then change the Server type to Sql Server Compact Edition.

    I"m telling you that there isn't an option for Sql Server Compact edition!!

    The second link describes how to repair a Sql Server Compact 3.5 database.  I'm telling you I can't even open a Sql Server Compact 3.5 database, . . . much less repair it.

     


    Robotuner
    Monday, November 21, 2011 5:43 PM
  • Hello,

    Please try to install SQL Server Compact 3.5 SP2 Query Tools (SSCESqlWbTools-ENU.msi) from SQL Server media. This should solve the issue.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, November 21, 2011 6:12 PM
    Moderator
  • Hi Robotuner,

    SQL Server Compact 3.5 Service Pack 2 (SP2) is included with SQL Server 2008 R2 and Visual Studio 2010.
    You need to download and install SQL Server 2008 R2 from http://www.microsoft.com/download/en/details.aspx?id=3743.

     

    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Robotuner Wednesday, November 23, 2011 7:54 PM
    Tuesday, November 22, 2011 8:02 AM
    Moderator