Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT!2012 install problem SQL on Win7 Pro: database cannot be created

New Member
Posts: 3
Country: France

ACT!2012 install problem SQL on Win7 Pro: database cannot be created

Hello, I have tried to install ACT!2012 (downloaded as trial) on my laptop Win7 Pro; at early install I have a message window saying <<Prereq.Exceptions.InvalidInputException: an exception of type Prereq.Exception.InvalidInputException has been raised at Prereq.AccessINI.Parse(TextReader sr) at Prereq.Program.Main(String[] args)>> then the install goes on without problem, I choose to launch ACT! and create a new database, and then I fill in the fields 'name of database', etc., sharing ticked, no password; and then after 15 seconds or so new window: <<Impossible to create the database. An error did occur when connecting to the Microsoft SQL Server>>.

My installed programs include Microsoft .NET Framework 4 Client Profile / Extended / Multi-Targeting Pack; Microsoft Visual Basic 2010 Express (French), Visual C++ 2008 redistributable x64 (3 files) and x86 (4 files); Microsoft SQL Server 2008 R2 (64bit), 2008 R2 Native Client, 2008 R2 Setup (English), 2008 Setup Support Files, SQL Server Browser, SQL Server VSS Writer.

 

I have uninstalled all my SQL-related programmes, and then installed again from the Prerequisite ACT! folder, then launch ACT! installation again, for the same result with the same message windows. And I had disabled the Windows Firewall (not the antivirus, I am not sure how to do, I think it is McAffee).

 

Any help would be very welcome!

Thanks a lot

Pierre

New Member
Posts: 3
Country: France

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

I wrote ACT!2012, it is ACT!2011, of course - sorry for the typo

New Member
Posts: 7
Country: Ireland

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

I'm getting the same error and can't install ACT!. See below

How did you get around it?

 

 

 

 

prereq_error.jpg

 

New Member
Posts: 3
Country: France

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

I did not get around it.

I still cannot install it.

Pierre

 

Platinum Super Contributor
Posts: 5,275
Country: USA

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

For this issue, try the following:

- Browse the Sage ACT! installation files (assuming downloaded)

- Open folder 'Dependencies'

- Rename the folder 'PreReq' to 'PreReq - old'

- Attempt installation

 

 

 

Greg Martin
Sage
New Member
Posts: 7
Country: Ireland

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

thanks Greg.

I'll give it a go.

by renaming dependencies folder, does that skip the part where it checks for pre-requisites?

Just wondering why you're suggesting it

Eileen

Copper Elite Contributor
Posts: 233
Country: USA

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

Hello Pierre,

 

It's great when you get a post with as much detail as yours,

 

I believe its the install of Microsoft .NET Framework 4 Client Profile, on your machine that is causing the SQL install issue, we have been getting numerous calls with the issue, I would suggest UN-installing it first, you can reinstall after SQL is installed and working on your machine. I would also Un-install ACT! from the machine, and if there is a partial install of the ACT7 instance I would also Un-install that, check add remove programs to see if SQL 2008 R2 is installed and remove.

 

So steps to take

 

1.Un-install Microsoft .NET Framework 4 Client Profile

 

2.Un-install SQL 2008 R2 (the act7 instance if its there)

 

3.Un-install ACT! 2012

 

Reboot

 

5. Reinstall ACT!

 

Let me know how this works out for you

 

Kurt Rosemann

Platinum Act! Consultants
Kurt@ActiveSales.net | www.ActiveSales.net | 877-569-8005
Bronze Super Contributor
Posts: 1,542
Country: United_Kingdom

Re: ACT!2012 install problem SQL on Win7 Pro: database cannot be created

Pierre - I have found that the best way is to ALWAYS check if .NET 4 is installed and if it is to uninstall it before installing ACT! then re-install from the MS download site afterwards - http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17851

David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org