May 5, 2010 at 1:27 pm
We just upgraded our development environment to MS SQL Server 2008. We still have 2 more servers that are running MS SQL Server 2005. I installed backward compatibility during my 2008 upgrade and can still connect to the servers running 2005 just fine. Can anyone think of any reason as to why I would still need SQL Sever 2005 installed on my system. Just thought I would ask before I completely remove it from my workstation.
May 5, 2010 at 5:46 pm
SSMS 2008 will work fine to manage the data engine of a SQL 2005 install. However, if you are using Reporting Services you have to connect using http://<servername>/reportserver and you can't manage 2005 integration services with SSMS 2008. I'm not certain about Analysis Services.
May 5, 2010 at 6:02 pm
Thanks. I had a feeling SSIS would be an issue, but also was wondering if there might be anything else as well. I appreciate your response.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply