Link to home
Start Free TrialLog in
Avatar of blackadder999
blackadder999

asked on

SQL Express 8 Install

HI

I installed SQL Express 2008 and restored a 2005 database which completed with no errors.  However, when I try to run the application that is connecting to this database I get the following error:

'the database version you are logging in to isn't the one expected. Please notify your system administrator. You login attempt has been cancelled'

Does anybody know what the problem could be and how to resolve it?

Thanks in advance for your help.
Avatar of markterry
markterry

Likely go to the database properties and change the SQL version to 2005.
Avatar of Kevin Cross
That is definitely something to check. For clarity's sake, you want to right-click on the database, select properties, click on options, then set "compatibility level" to SQL Server 2005 (90).
Avatar of blackadder999

ASKER

I have checked the compatibility and it was set to SQL Server 2000 (80) and the only othe option is SQL Server 7 (70).  Neither of these work.

I was realised now that it wasn't a SQL Express 2005 database I restore but one from Microsoft SQL Server Desktop Engine.  

Any other suggestions?  Thanks
MSDE is SQL Server 2000. What you can do is create a new database in SQL 2008 and transfer data from the old MSDE database to the new one.
Is there any eay method for transferring the data to the new database?  I'm assuming I can't just restore a backup then?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial