Community
Showing results for 
Search instead for 
Do you mean 
Reply

Wrong SQLserver version

New Member
Posts: 6
Country: United_Kingdom

Wrong SQLserver version

 

When I try to browse to the Act database (which has been working without a problem for many months) I get a message that 'This Database cannot be opened because the SQLserver version of this database cannot be identified'.

Same thing if I try to browse to the PAD file or direct to the ADF.

 

If I try to attach the database (I don't know why it has been detached, the setup is that of a client of mine and nobody is aware of having done anything to remove the database......) via Actdiag I get a message that 'The database was created with a version of SQL server which is neither SQL server 2005 or SQL server 2008. Attaching a non SQL 2005 or 2008 database is not supported'

 

This database was created on this machine with this version of Act.

 

I can get into Demodata, and create a new database & close & reopen it with no problems or errors, so I'm thinking the problem is with the database itself but without being able to reattach it or open it I can't see how I can get any further?

 

Act is version 12.0.409.0 Hf1 (2010)

Machine is XP pro.

 

Any help greatly appreciated.

Sue

Nickel Elite Contributor
Posts: 934
Country: USA

Re: Wrong SQLserver version

Using ACTDIAG, have you tried the rebuild options? such as rebuild schema and the others?

 

Since you take daily backups using ACT!, have you tried the restore database option or "restore as" option?

Cheers - FSB

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
New Member
Posts: 6
Country: United_Kingdom

Re: Wrong SQLserver version

Hi Bill,

 

Thanks for the suggestions but  I don't think I can access any of the rebuild options as the database isn't attached so doesn't appear in the list? If there is a way to do this I'll certainly try it.

 

I think we will need to resort to a backup but unfortunately this is not a regular client and their backup routine is not as frequent as it should be so was trying to find a way to access without having to do this!

 

Su

Nickel Elite Contributor
Posts: 934
Country: USA

Re: Wrong SQLserver version

[ Edited ]

Su,

What about performing a system restore point to a date when things where last working?

 

As you are attempting recovery, below are some backup processes you may find useful - Cheers - FSB

 
1: Backup Registry For XP reference > http://support.microsoft.com/kb/322756
Run
Regedit
File / Export
name your file something like REGBAK01_03162011 and save it to your desktop.
(If you need to Restore your Registry, use the Import option).
 
==== 
 
2: Create System Restore Point
How do I create a restore point manually?
  1. Open System by clicking the Start button , clicking Control Panel, clicking System and Maintenance, and then clicking System.

  2. In the left pane, click System Protection If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

  3. Click the System Protection tab, and then click Create.

  4. In the System Protection dialog box, type a description, and then click Create.

  =======
3: Backup All of Your Current existing relevant  ACT! database's from ACT!.
ACT!2011 / File / Backup / Database
  =======
4: Backup Your Current ACT! Personal Files from ACT!
ACT!2011 / File / Backup / Personal Files
===
 
PS; also check the knowledge base and search on: SQLserver version of this database cannot be identified..
Is this a stand alone single user database?
Or is there some remote database / sync stuff going on? Perhaps a change in your network or antivirus firewall issue going on?
 
Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html