up vote 2 down vote favorite
share [g+] share [fb]

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express?

Is that a must for me to install MSSQL 2008 Express?

link|improve this question
feedback

2 Answers

AFAIK, SQL Server 2005 Management Studio can NOT connect to SQl Server 2008. I've just tried it and I get an error message that SQL Server 2005 Management Studio can only connect to SQL Server 2000 and SQL Server 2005.

link|improve this answer
That's what I was about to write in my answer because that is the message I recalled. Then I checked it, and it worked (might be a fix in one of the SQL 2005 service packs). – Richard Jan 19 '10 at 11:36
OK. I'll update my install and see what happens. Thanks. – joeqwerty Jan 19 '10 at 12:01
feedback

2005 Management Studio will connect to SQL Server 2008 (standard in this case) so I expect the answer is yes.

But, unless you can find something definitive, you need to validate.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.