I recently ran into a problem where I needed to connect to SQL 2005 from inside SQL 2008 Management Studio.
I have SQL 2008 installed on my machine and I run my sql scripts against the production environment which is hosted by my ISP.
Although, the configuration is pretty straight-forward, however, if not done often, it can turn into oblivion.
This blog post is mainly a reminder to me in case I re-image my hard-drive and have to repeat the process.
Here are the following steps:
- Inside SQL 2008 Management Studio, highlight Database(s) node. You will notice on the right hand pane, there are five columns, namely Name, Policy Health State, Recovery Model, Compatibility Level and Owner.
- Highlight the ‘Name’ column and right click on it, uncheck Collation
- Now, try to reconnect or simply refresh.
- You should see all available data bases on the shared server.