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.
File.. New... "SQL Server Compact Edition query"
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)"
精彩评论