Solved

Unable to Share ACT DB using ACT 2011 Premium on SBS2008

Posted on 2011-03-19
17
1,677 Views
Last Modified: 2013-01-03
Recently installed new Server running SBS2008.  
Installed ACT2011 Premium, backed-up database from old server running SBS2003 and restored to new server running SBS2008.  
The database restore was fine.  I can access the ACT databsae from the Server but cannot access from client workstations.  
I have allowed user access to new ACT database.  The "Share" option under Tools, Database Management is unavailable for some reason.
Any suggestions?
0
Comment
Question by:rjchallenged
17 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
What happens when you try to access from the workstations? Do you get an error? If so, what is it?
0
 

Author Comment

by:rjchallenged
Comment Utility
The error reads:  "Could not find a database called (DBName) on host (Workstations) as opposed to the domain where the database is located.  The workstation is mapped to the server location and access rights are co-owner for all users.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
If you are using a PAD file, you might be using the wrong one ... you can open the PAD file in Notepad - it just has the machine names, database name and location
0
 

Author Comment

by:rjchallenged
Comment Utility
Don't know why ACT is looking for the database on th elocal PC when the path indicates the database is on the server?
0
 

Author Comment

by:rjchallenged
Comment Utility
No the PAD file is looking to the correct location:

<?xml version="1.0" standalone="no"?>
<!DOCTYPE ACTDatabasePADFile>
<!--This file represents a Pointer to an Act Database or [PAD]-->
<ACTDatabase name="SR11" host="." location="E:\DATA\RJMCSTEP\RJMC\ACT\Databases" type="Sql" />
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
Please post the contents of the PAD file
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
The host should not be "."

That means local PC .... it should have the server name or it's IP address
0
 

Author Comment

by:rjchallenged
Comment Utility
I can insert the IP address and see if that works.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:rjchallenged
Comment Utility
New error after I inserted the IP Address:
"The database SR11 cound not be accessed.  In order to access the database, check your network connection and verify that your database server is available.  If may be necessary to disable any firewall software on your computer or the server."

I can easily access all the shared files on our server from any workstation.  There is no firewall software running to my knowledge unless it is a setting that is part of SBS2008.  

I still think it has something to do with the fact that I cannot enable the "share" status under the database maintenance option in ACT 2011.  This was not a prblem in our previous version of ACT 2009.  
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 250 total points
Comment Utility
0
 

Author Comment

by:rjchallenged
Comment Utility
The only possibility that I see is the Microsoft Firewall issue but I'll have to work with someone more technical than me to try it out.  

Thank you for your quick responses . . .. maybe tomorrow will be a better day.
0
 
LVL 30

Expert Comment

by:Mike Lazarus
Comment Utility
0
 

Author Comment

by:rjchallenged
Comment Utility
I'll give it a try and let you know.  Although this looks like a morning exercise.  Thank you.
0
 
LVL 7

Assisted Solution

by:50cal
50cal earned 250 total points
Comment Utility
If share database is Grey on the server then possibly UAC's are preventing access.
Close act on the server, then right click in the act icon and choose run as administrator, log into the database using an act admin user name and Password and then try sharing the database from tools -> database maintenance -> share database.

50cal.
0
 

Author Comment

by:rjchallenged
Comment Utility
Thanks for the suggestion.  I'll give it a try when I get to my office in a few hours and will let you know if that solves the problem.
0
 

Author Closing Comment

by:rjchallenged
Comment Utility
Really appreciated the quick response time and willingness to dig deeper.
0
 
LVL 3

Expert Comment

by:DJNafey
Comment Utility
** FIXED **

Hi,

In my case, the Windows Firewall was causing the problem so, if you're going to work through the very long list of possible causes in the Sage KnowledgeBase article, try the Windows Firewall suggestion first!  To get straight to the answer, visit the Microsoft support article at http://support.microsoft.com/kb/968872.  There's a 'Fix It' tool there but it only runs on plain Windows Server 2008, not SBS 2011.  However, Microsoft also give you all the code that you need to copy into a batch file.  

That worked perfectly for me on Small Business Server 2011 and took less than 2 minutes.  

I had experienced the same issue after moving a client with Sage ACT! Pro 2011 from an SBS 2003 server to an SBS 2011 server (based on Windows Server 2008 R2).  It wasted 2-3 hours of my time-critical server installation visit so I hope that my update can help someone else :-)
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

With users like the Professional Sales Road Warriors that made up much of ACT!'s early user base to field service technicians, trades-people, telecommuters who work from home, remote offices and others who need access to their data while out of the …
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now