Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
ncorbett
Posts: 1
Country: USA
Message 1 of 12 (4,539 Views)

Unable to create database; SQL is not locally installed

I just downloaded the 30 day trial of ACT 2011 and can't even start the program because I am stuck on the opening page!  I am given two options - to Create an ACT! database (when I select this, I get the error message "Unable to create database; SQL is not locally installed") and the other choice is to open an existing ACT! database.  I have no existing database, and can not even find the sample one that is nowhere to be found with the rest of the ACT folders that came in the dowloads.  Is installing this program really this complicated??  Help!

Nickel Contributor
rosevear
Posts: 173
Country: Australia
Message 2 of 12 (4,484 Views)

Re: Unable to create database; SQL is not locally installed

Sounds like you have not installed SQL you can do this manually by following the Sage KB article 25198:
http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2519...
Travis Rosevear ACC for
Act Today Australia and New Zealand
Platinum Elite Contributor
GLComputing
Posts: 13,904
Country: Australia
Message 3 of 12 (4,466 Views)

Re: Unable to create database; SQL is not locally installed

Did you install as Custom or Typical?

You might check that SQL is installed - look in Add/Remove programs and services.msc

If installed, make sure the service is started

If not installed, you might look in the windows event log for the time you did the install to see if there was an error
Copper Super Contributor
agaliano
Posts: 279
Country: United States
Message 4 of 12 (4,467 Views)

Re: Unable to create database; SQL is not locally installed

What operating system is installed on this machine?

You must have SQL installed in order to create a new database on that local machine .  Perhaps it failed to install SQL and it skipped that item?

 

The demonstration database typically installs in the My Documents ( Windows XP) and User>Documents (Win 7)

You can also call into ACT! support for help with this issue.

 

R,

Alanna

Alanna Galiano

Emerging Technologies Inc.

Atlanta, GA 30327
New Member
jsaenz
Posts: 1
Country: USA
Message 5 of 12 (4,084 Views)

Re: Unable to create database; SQL is not locally installed

I am having the same problem. Have tried installing ACT on it's own but it fails to install SQL Server. Then I installed SQL server 2008 R2 on it's own, then ACT (which will install after the independent install of SQL Server) but when I try to create a database I get the Unable to create database; SQL is not locally installed error even though SQL is installed. UGH, why doesn't Sage make this product for MAC. 

 

Help! 

Platinum Elite Contributor
GLComputing
Posts: 13,904
Country: Australia
Message 6 of 12 (4,079 Views)

Re: Unable to create database; SQL is not locally installed

New Member
edbully12
Posts: 1
Country: United_Kingdom
Message 7 of 12 (3,648 Views)

Re: Unable to create database; SQL is not locally installed

did this work - I have the same problems.

Platinum Super Contributor
gmartin
Posts: 5,276
Country: USA
Message 8 of 12 (3,633 Views)

Re: Unable to create database; SQL is not locally installed

Hello Edbully12,

Welcome to the Sage ACT! Online Community!

 

The first step is to determin if SQL actually installed - this message generally indicates that it did not or did not completely.

 

- Go to Windows Start > Run (use Search if Vista/7) > enter 'services.msc' > scroll down to locate 'SQL Server (ACT7)'.  If not present, the SQL installation failed.

- At this point, if no other applications use SQL - the next step is to uninstall all SQL components through Add/Remove programs.

- Reboot

- Install SQL manually using the instructions in this article: KB Article 26994

 

 

If this service is present and started, can you open the ACT! Demo database?

 

Greg Martin
Sage
New Member
hxp8316
Posts: 2
Country: USA
Message 9 of 12 (3,535 Views)

Re: Unable to create database; SQL is not locally installed

I have the same problem. If I actually install the SQL server, how to start SQL Server (ACT7) service?

Platinum Elite Contributor
GLComputing
Posts: 13,904
Country: Australia
Message 10 of 12 (3,532 Views)

Re: Unable to create database; SQL is not locally installed