Community
Showing results for 
Search instead for 
Do you mean 
Reply

Wrong SQLserver version

Highlighted
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

Highlighted
Nickel Elite Contributor
Posts: 988
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 / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php
Highlighted
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

Highlighted
Nickel Elite Contributor
Posts: 988
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 / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php
Highlighted
New Member
Posts: 5
Country: USA

Re: Wrong SQLserver version

This is the same exact error we are dealing with and wanted to see if anyone had anyone had any luck?

 

We have not a true backup but a copy of the ADF and ALF files from before when this error happened.

Highlighted
Nickel Elite Contributor
Posts: 988
Country: USA

Re: Wrong SQLserver version

[ Edited ]

Hello Rt,

Sorry, you have not provided enough information for me or anyone to provide a correct response.

1st

What version of act! are you using? reference help about and include the full version info.

2nd

Do you have a specific error message? What exactly does it say?

 

 

Also

Are you trying to upgrade from some previous version of ACT! yet unbeknownst to us?

 and are you trying to upgrade that older vers to the newest version 21?  pro? premium? prem for web?  etc..

 

Tip#1= most important for any and all act! users.

Backup your ACT! database Everyday.  - from ACT! / File / Backup / Database etc...

 Also backup your personal files daily.

 

 

Bill Williams - Owner / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php
Highlighted
New Member
Posts: 5
Country: USA

Re: Wrong SQLserver version

I posted this message in another thread but I followed up on this thread because it is the same issue.  This is the information that you should need to hopefully provided some assistance.  Thank you in advance.

 

We have a client that has ACT 2011 on Windows Server 2012 R2.  They have somehow managed to damaged all of their ADF files by messing with ACT 2011 and SQL server.  We have no idea what was done except that it is not working.

 

We are getting this error message with all the current database/files:

 

This database cannot be opened because the SQLServer version of this database cannot be identified.

 

When we restore backup files from before this issue occurred, we get a dialog box that say it will verify the database.  However, the next moment. we get an error message:

 

The log scan number (1201:656:1) passed the log scan in database 'Sales' is not valid,  The error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).  ......

 

We are doing what seems to be endless research and multiple solutions for SQL and/or ACT and nothing seems to be working.  Any thoughts or advice?

Highlighted
Nickel Elite Contributor
Posts: 988
Country: USA

Re: Wrong SQLserver version

[ Edited ]

OK thanks that is more info but not enough for me yet? but making progress.

So we know it is some version of act! 2011 ( still not sure of full version info?) AGAIN - reference ACT! help about if possible? to get full version info.

 example I am currently using  Act! Pro Version 17.2.217.0, Hot Fix 3  - Until next week - then I will be using act! vers 21 pro desktop.

 

Is your client a single user? Multi user with Remote databases?

How many users?

or do multiple users access the same shared db on a single primary pc?

 

Your last response you indicated that you tried to restore the db from a ACT! Backup of the db and not a copy of some adf file type etc..

I thought you did not have any ACT! db backups? but only alf or adf file type copies?

 Are you trying to restore a remote db?

 

What version of MS Windows is your client running? Windows 7 ? 10?   Are all users using same windows pc version

Did one of the pc's get a windows update and the other pc's did not get the same windows updates yet?

 

Do all pc's  involved have the same sql server version?  and .net framework version?

 

Can you open the ACT! 2011 demo db?

 

This is about over my head but hopefully some other ACC's will chime in on this with their greater expertise?

 

Regards - Bill 

 

 

 

Bill Williams - Owner / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php
Highlighted
New Member
Posts: 5
Country: USA

Re: Wrong SQLserver version

The version is Sage ACT! Pro 2011 Version 13.0.401.0.

 

We can open a test database without any issues.

 

It is a multi user environment but we are simply just trying to open a file on the server.  Nothing is open on any other computers.  I am not even sure of the network environment, like I said I just need to be able to open these files.

 

The back up was just the FILES/data directory.  Think of a Carbonite like backup of just the files not a true SQL backup or backup files out of ACT.

 

 

Everything is local.

 

I am not sure what version of Windows the clients are running as I am only working with the server since I just got dropped into the middle of this war zone/project.

 

 

 

Highlighted
Nickel Elite Contributor
Posts: 988
Country: USA

Re: Wrong SQLserver version

[ Edited ]

Hopefully this is enough info for a ACC to assist you with now?  You may want to put in a Support Call to Swiftpage Support 1st thing Monday am. ?

It may also help to know How many users and have they been using Remote ACT! database environment?

 or just everyone remotely accessing the one and only ACT! db located the main pc?

 

I want to suggest seeing if their is a Windows PC "Restore Point" you can revert back to?  To restore the pc itself back to a previous date/time.

 

That's is all can can do myself - Good luck . -Bill 

 

Bill Williams - Owner / ACT! Consultant / Trainer at FILL STAFF HR "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://www.fillstaffhr.com/backupfolderspro.html - FREE
Backup your ACT! Databases DAILY using ACT! / File/ Backup/ Backup Database.(Include Attachments).
Also - FREE - BIG ACT! LAYOUTS for Larger Monitors http://www.fillstaffhr.com/bigaldl01.html
Also - FREE - BullZip PDF Printer - Print directly to PDF http://www.bullzip.com/products/pdf/info.php