• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • 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
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

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