Act failed to open a connection to the database 1

[JASimonds]

Every time I start Act this is what comes up, "Act failed to open a connection to the database" any ideas?

 

[GLComputing]

Without knowing the version of ACT!, this would be my first guess -

http://tinyurl.com/yt83ue

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JASimonds]

Hi Mike,

That did not help.

The problem I have is: I have just installed Act 2007 Version 9. After the installation, I try to start the program and then I get this message: “Act failed to open a connection to the database”. I have tried uninstalling the program and reinstall and still get the same error.

Any other suggestions?

Thanks,
Jack

 

[GLComputing]

Did you follow ALL the steps in the knowledge base article?
Including the link at the bottom?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

 

[JASimonds]

I only have 480 MB of RAM is that a problem?

 

[JASimonds]

This is the latest problem:


Microsoft SQL Server 2005 9.00.2170.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Mon Dec 10 09:21:21 2007

DESKTOPOFFICE : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : DESKTOPOFFICE
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DESKTOPOFFICE_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : DESKTOPOFFICE
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DESKTOPOFFICE_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : DESKTOPOFFICE
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DESKTOPOFFICE_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : DESKTOPOFFICE
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DESKTOPOFFICE_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : DESKTOPOFFICE
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : DESKTOPOFFICE
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_DESKTOPOFFICE_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{ODBC Driver Manager} Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
--------------------------------------------------------------------------------

 

[GLComputing]

The minimum required RAM for Microsoft SQL Server is 512MB... and I'd recommend 1GB. So I don't know if that might be causing SQL to have a problem.

But it does look like SQL didn't properly install

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au