Showing posts with label sdk. Show all posts
Showing posts with label sdk. Show all posts

Friday, February 17, 2012

Connecting via Management Studio

hi,

I've installed Microsoft SQL Server Compact Edition 3.1 .I want to connect to via management studio , but I dont khonw how!

SDK says :

1. In SQL Server Management Studio, open Object Explorer.

2. In Object Explorer, click Connect, and then choose SQL Server Compact Edition.

but there is no "Server Compact Edition" !

please help, Thanks

In my installation, it is still called SQL Server Mobile Edition, not Compact Edition, in the Object Explorer > Connect menu.

HTH,
Jon
|||

It is working but I doubt that it is the CE 3.1 !

Thanks.

|||

Your doubt is justified

There's "Compact Edition" all over the management studio

In VS2005 prof i first installed the SP1 then: (in this order)

SSCE31VSTools-enu-exe

SQLServerCE31-EN.msi

SSCE31BOL (Books online)

SSCE31SDK-ENU.msi

After that the newest version of management studio express (SQLServer2005_SSMSEE.msi)

This is how I did connect.

(Though not everything works: see my message somewhere below!

Anne-Jan Tuinstra

|||I Download and install "SQLServer2005_SSMSEE.msi" but the server type in this version is "Database Engine" and I can't change it!(It is disabled)|||Any idea ? Please help!

Connecting via Management Studio

hi,

I've installed Microsoft SQL Server Compact Edition 3.1 .I want to connect to via management studio , but I dont khonw how!

SDK says :

1. In SQL Server Management Studio, open Object Explorer.

2. In Object Explorer, click Connect, and then choose SQL Server Compact Edition.

but there is no "Server Compact Edition" !

please help, Thanks

In my installation, it is still called SQL Server Mobile Edition, not Compact Edition, in the Object Explorer > Connect menu.

HTH,
Jon
|||

It is working but I doubt that it is the CE 3.1 !

Thanks.

|||

Your doubt is justified

There's "Compact Edition" all over the management studio

In VS2005 prof i first installed the SP1 then: (in this order)

SSCE31VSTools-enu-exe

SQLServerCE31-EN.msi

SSCE31BOL (Books online)

SSCE31SDK-ENU.msi

After that the newest version of management studio express (SQLServer2005_SSMSEE.msi)

This is how I did connect.

(Though not everything works: see my message somewhere below!

Anne-Jan Tuinstra

|||I Download and install "SQLServer2005_SSMSEE.msi" but the server type in this version is "Database Engine" and I can't change it!(It is disabled)|||Any idea ? Please help!