March 30, 2009 at 11:56 am
I get an error saying I am unable to connect using my version of SSMS to sql server 2008. Do I have to upgrad my management tools to connect?
March 30, 2009 at 1:45 pm
Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008
SQL 2005 SSMS cannot connect to SQL 2008
March 30, 2009 at 2:35 pm
Jerry Hung (3/30/2009)
Yes, you need to upgrade to SSMS 2008 to connect to SQL 2008SQL 2005 SSMS cannot connect to SQL 2008
Not quite true - you can connect to SQL Server 2008 using the 2005 tools if you have upgrade to SP3. I think the was a CU before SP3 that would allow this - but not sure exactly which one.
However, I would recommend installing the 2008 tools anyways as side-by-side (don't upgrade existing tools). That way, you can use the 2008 tools to do everything you need to against your 2008 instances and 2005 instances - and open the 2005 tools if you find you need something specific that the 2008 tools don't do (e.g. SSIS or SSRS).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply