• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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.
0
blackadder999
Asked:
blackadder999
  • 3
  • 2
1 Solution
 
markterryCommented:
Likely go to the database properties and change the SQL version to 2005.
0
 
Kevin CrossChief Technology OfficerCommented:
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).
0
 
blackadder999Author Commented:
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
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Kevin CrossChief Technology OfficerCommented:
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.
0
 
blackadder999Author Commented:
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
0
 
Kevin CrossChief Technology OfficerCommented:
You can try this: http://msdn.microsoft.com/en-us/library/ms144259.aspx
Options you want are probably something like: /ACTION=Upgrade /INSTANCENAME=MyMSDE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now