Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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.