Note that the methodology is pretty straight foward for a new setup: The process finishes after one has run the ACCPAC Setup Wizard to configure the company.
Our primary focus in this post is a very long struggle to get an existing ACCPAC client migrated to a new SBS installation that upgraded a peer to peer setup.
- Create SQLUser in ADUC with a static password and no Exchange attributes
- Create SQLUser2 in ADUC with a static password and no Exchange attributes
- Make sure to follow the SBS password security guidlines for the client's setup when creating the user passwords for these accounts.
- Note that their passwords must be set to not expire.
- Depending on the client configuration, further restrictions on these users can be initiated via OU and Group Policy Objects.
- Click on MySBSDomain\SQLUser
- Verify "Connect" is checked
- We now have two blank databases to work with that are ready for the ACCPAC setup wizard.
- If a mistake is made, all we need to do to start over is delete any tables under MYCSYS and MYCDAT --> Tables (click on the first table - NOT THE SYSTEM TABLES FOLDER - then SHIFT + the last table entry, right click and Delete.
- Note that there will be other setup steps that will need to be accomplished such as setting up security on the ACCPAC Database Setup console that are beyond the scope of this post.
- Note that the ACCPAC Database Setup utility on any workstation will muck up the server settings if the MYCSYS and MYCDAT entries are modified/deleted!
If need be, for larger firms, we can initiate the SQL 2K5 install routine to install a dedicated SQL2K5 instance for ACCPAC's purposes prior to performing the above steps.
Microsoft Small Business Specialists
*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.