Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

share|improve this question

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.

share|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

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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