I am not finding a work around to this issue. Any network device connected to the same network as our ACT server (XP Pro OS) has full read/write access to all data in our shared db. Sage supports position on this security issue is that if they don't have ACT installed on their workstation, then they can't do anything w/ these files. Anybody that manages a network knows that this isn't an acceptable solution.
So, is there a way to use a group other than the Everyone group for the Full Control share permission to our shared DB?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
The below dialog box occurs:
"Cannot find database supplemental files folder (our database) files in this location (our ACT server). This could be a problem with the share, or the folder may not exist. Please contact the administrator of your database."
Note that the "shared" act database folder can be accessed via explorer and does have full read/write privileges to all data of the shared folder.
When the share permissions are changed to use the "Everyone" group, this error goes away.
You should have full-control, not just read/write - http://tinyurl.com/5fzsbx
Are you on a Domain or a Workgroup?
If on a Domain, is the database on the DC?
- Domain, not workgorup.
- ACT server is not on a DC. Its an XP Pro workstation.
- I have seen the link. It states the below which is making me think there's no way around this issue w/out getting into the SQL db:
"It is recommended the user named Everyone have Full Control permissions to the shared folder. In some cases, it is necessary to add the specific names of the remote users to this Share Permissions list, to ensure that each domain user has Full Control of the shared folder."
It is not in My Documents. It's on a separate partition in its own folder.
I'll have to get back to you on the .pad contents. I am currently moving the server (it's a VM) to some beefier hardware to increase performance.
Note: If you want to know if the sharing is enabled by seeing that there is a HOST entry, it is. This was one of the trouble shooting tips that was given by Sage. I was hoping that this is where the group information is stored. It's not.
I was thinking about changing the machine name in the PAD to the IP address.
With the share and folder security just one user, do it allow the user access logged in locally?
How about an Admin user (explicitly added) from a workstation?
How about Everyone in the folder security and only the needed users in the Share (and also in the folder with Everyone)?
- Good thinking on the IP. I tried that as well before posting. No joy.
- As for differnet share / security permission alternate configurations, I've tried all of what you suggested (and then some). Any configuration other than Everyone: Full Control on the share permission is no joy.
Am I the only one that has a problem w/ this? Does it make sense to not use the Everyone group?
RLAInc,
I think the "ACT! application" itself needs permission to the supplemental file folder - not individual users. In other words, when ACT! starts, it needs to open the layout files, etc. I don't think this is done at a user level but somewhere in the application level.
So if you could find a way to give the ACT7 SQL instance and .net access to that folder you might have better luck.
Good luck
Steve
Business Accounts
Answer for Membership
by: GLComputingPosted on 2008-10-17 at 21:14:26ID: 22747033
Not sure what you're trying to do?
The ACT! users need full-control of the ACT! database folder, not the Everyone group