ACT!
Register  ·  Sign In  ·  Help
ACT! by Sage Forum : ACT! Product Forums : ACT! : Re: Need Microsoft SQL
  Search Board       User Search  ·  Advanced  
   Reply    Reply   
 
   Message Listing    Message Listing   
   Previous Thread    Previous Thread   
   Next Thread    Next Thread   
Jump to Page:   1
  Reply   Reply  

Need Microsoft SQL
Options    Options  
macroprez
Tuned Listener
Posts: 29



Country: USA

Message 1 of 6

Viewed 2,787 times


Dumb question. We have two copies of ACT 9.0 on two different workstations each using XP. The shared database is on one of these two machines, both of which are in the same office. Do we still have to use MS SQL in this setup? I ask because ACT!2007 is operating much slower than we were used to with ACT!2000. Thanks.
Kudos!
02-13-2008 03:11 PM
 
  Reply   Reply  

Re: Need Microsoft SQL
Options    Options  
Tdavis
Nickel Super Contributor
Posts: 441

Tdavis

Country: UK

Message 2 of 6

Viewed 2,775 times


You will need to install it but you can disbale the act 7 instance on the machine not hosting the db.  This will prevent you from opening local dbs on that machine though.
 
Tom
Kudos!
02-14-2008 02:53 AM
 
  Reply   Reply  

Re: Need Microsoft SQL
Options    Options  
macroprez
Tuned Listener
Posts: 29



Country: USA

Message 3 of 6

Viewed 2,766 times


How do you disable the MS SQL on the machines not hosting the database? Also, if I install ACT!9 on a third workstation, is there something I should do during installation to avoid setting up MS SQL? Thanks for the help.
Kudos!
02-14-2008 09:36 AM
 
  Reply   Reply  

Re: Need Microsoft SQL
Options    Options  
Moderator AJones Moderator
Moderator
Posts: 476

AJones

Country: USA

Message 4 of 6

Viewed 2,757 times


You can disable to ACT7 instance through the Services window.

Go to Start / Run and type in services.msc
Scroll down until you find SQL Server (ACT7) / right click on it and go to Properties.
Stop the service and change the dropdown from Automatic to Disabled.

It is highly recommended that you do not prevent the ACT install from installing SQL and instead disable it after install. In the even that there is an issue that would require some troubleshooting on a local database, you would not be able to to that until SQL has been installed and ACT is able to connect to it.
1
Kudos!
02-14-2008 12:24 PM

All Users' Tags:

  
  Reply   Reply  

Re: Need Microsoft SQL
Options    Options  
Employee Mark
Employee
Posts: 24

Mark

Country: USA

Message 5 of 6

Viewed 2,754 times


One other note, if you use the ACT! email client with POP3 that uses the local sql server instance, so the server will have to be turned on for that.
Kudos!
02-14-2008 12:36 PM
 
  Reply   Reply  

Re: Need Microsoft SQL
Options    Options  
GLComputi…
Platinum Contributor
Posts: 8138

GLComputing

Country: Australia

Message 6 of 6

Viewed 2,704 times


There are also a number of other things that can cause slowness.
Including the processor speed, RAM and HDD speed on both machines and how they have been set up

 

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing - Australia
Join the LinkedIN ACT! Fanatics Group
What you should add to any support post
Kudos!
02-19-2008 07:48 AM
 
Jump to Page:   1
 
   Message Listing    Message Listing   
   Previous Thread    Previous Thread   
   Next Thread    Next Thread