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.
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.
Likely go to the database properties and change the SQL version to 2005.
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).
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
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.
ASKER
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
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.