I am using ssms 2012 and trying to connect to the sdf created by orchard. According to this answer, i should be able to select sql server compact edition as the server type when connecting my object I have some er diagrams created in the development server. I want to export this as pdf and share with my analyst for further usage. The diagram needs to be in pdf format alone since the analyst doesn't have ssms in his system. Same issue with latest version. Uninstalling microsoft odbc driver 17 for sql server (via apps & features) resolves the issue. I'm still fairly new to ssis. I've figured out how to download packages from a server by connecting to integration services. How do i download packages from ssisdb?

We have a ton of packages that the previous people created. This is an issue if you are using 2008 management studio tools to connect to a sql 2012 instance. I experience this a lot if i am working on one server with sql 2008, and trying to quickly query another server that is running sql 2012. I am using microsoft sql server management studio to connect to a database. In it i've got a table, one column of which is an image column containing file data. Another column is a string containing the file name. Is there some way i can write some sql script Just install multiple version of sql server management studio. Sometimes you'll run into a situation where some of your db's are installed with sql server 14, 12, 11 etc. So instead of upgrading your only install of management studio, have multiple installed.

-

My advice is to download the latest stable sql server managemnt studio (not 2005, at least 2008 r2) as it can attach to any sql server instance regardless of version / edition. Express edition is related to sql engine, not smss itself. The issue is because sql integration services is not installed properly with the existing sql server you are using.