SQL Server 2005 Express connection

0

On my computer I had installed Windows XP Service Pack 2. Then I installed Visual Studio 2008 SP1 and then SQL Server 2008 r2 and SQL Server 2005 Express. Up to that I had no problem using SQL Server 2008 r2 and SQL Server 2005 Express.

After that I updated Windows XP Service Pack 2 to Service Pack 3, because I wanted to install Visual Studio 2010. Then I installed Visual Studio 2010.

Now there is no problem using SQL Server 2008 r2, but while using SQL Server 2005 Express it's showing this error message

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers.(Microsoft.sqlServer.Express.connectionDlg)

I know that the SQL engine is the 2008 version so that the old version of SQL Server 2005 can't connect, but is there any solution for this problem? Can I install any newer service pack of 2005 SQL Server to solve this problem?

RaviG

Posted 2014-02-14T06:27:18.777

Reputation: 1

why do you want ss2005? – mcalex – 2014-02-14T07:32:38.490

because client using ss2005 – RaviG – 2014-02-14T09:01:17.003

tell 'em to use 2008 (or preferably later) express. they're all free – mcalex – 2014-02-19T05:04:41.590

No answers