Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1724
  • Last Modified:

Unable to Share ACT DB using ACT 2011 Premium on SBS2008

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
rjchallenged
Asked:
rjchallenged
2 Solutions
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
What happens when you try to access from the workstations? Do you get an error? If so, what is it?
0
 
rjchallengedAuthor Commented:
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
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rjchallengedAuthor Commented:
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
 
rjchallengedAuthor Commented:
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
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Please post the contents of the PAD file
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
The host should not be "."

That means local PC .... it should have the server name or it's IP address
0
 
rjchallengedAuthor Commented:
I can insert the IP address and see if that works.
0
 
rjchallengedAuthor Commented:
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
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
0
 
rjchallengedAuthor Commented:
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
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
0
 
rjchallengedAuthor Commented:
I'll give it a try and let you know.  Although this looks like a morning exercise.  Thank you.
0
 
50calCommented:
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
 
rjchallengedAuthor Commented:
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
 
rjchallengedAuthor Commented:
Really appreciated the quick response time and willingness to dig deeper.
0
 
DJNafeyCommented:
** 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now