开发者

Unable to change server type in SQL Management Studio 2008

I am trying to create and manage SQL Server Compact databases. The problem is that I can't change the "server type" from database 开发者_如何学JAVAengine. I tried following the directions here: link text.

Unable to change server type in SQL Management Studio 2008


File.. New... "SQL Server Compact Edition query"

Unable to change server type in SQL Management Studio 2008

If I go to "Registered Servers", I can connect to SSRS, SSIS in Object Explorer. Right click there, Connect... I get the choice of db engine etc as expected.

If I try to connect on SSMS startup or when I have DB Engine query window open, I can't change it either like above.

Bug? Feature? By design? There probably is some logic to it if I applied some thought...

Edit:

  • this is SSMS 2005 I'm using, "full" version
  • do you have the SQL CE option in "Registered Servers" (I have SSRS, SSIS, SSAS, SQLCE + DB Engine)
  • are you using Express tools?

Edit 2:

http://support.microsoft.com/kb/955965

You need "SQL Server Compact 3.5 SP1 Query Tools (SSCESqlWbTools-language.msi)"

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜