Note: This method is not recommended for normal operational use for the following reasons:
It does not use the primary Sage 100 ERP Advanced features (for example: processing data at the server rather than the workstation, performance, network security)
Users cannot ""see"" each other. Users in ""Sage MAS 90"" mode do not display in the Sage 100 ERP Advanced Master Console. Sage 100 Advanced users do not display in the ""Sage 100 Standard"" Master Console.
The correct toolbar bitmaps and HTML pages do not display on the Business Desktop (Launcher).
Map a drive to the parent drive or folder above the ""..\MAS90"" folder where Sage 100 ERP Advanced i is installed (for example: ""F:\Apps\MAS90""). A UNC path cannot be used. The ""Sage 100 Standard"" user must have Full Control permissions to the ""..\MAS90"" folder and all subfolders.
Then, either run Sage 100 from the Providex prompt, or create a Sage 100 Standard shortcut icon.
**To run Sage 100 ERP Advanced from the ProvideX prompt:**
In Windows Explorer, go to the server's ..\MAS90\Home folder
Double-click Pvxwin32.exe
At the ProvideX prompt, type RUN ""STARTUP.M4P""
Press ENTER
Log into Sage 100 ERP
Note: In case of an upgrade, for Sage 100 versions 3.7x (MAS200), on Step #3 above, you would type RUN ""MAS90"" instead of RUN ""STARTUP.M4P"".
**To create a ""Sage 100 ERP Standard"" shortcut icon:**
Make a copy of the Sage 100 ERP Advanced shortcut icon
Modify the following fields in the new icon (where X is the mapped drive letter, or C at the server):
Target:
""X:\MAS90\Home\ Pvxwin32.exe"" ..\Launcher\Sota.ini ..\SOA\Startup.m4p
Start In (quotes are required only if the path contains a space):
""X:\MAS90\Home""
Note: In case of an upgrade, for Sage 100 versions 3.7x (MAS200), on Step #2 above, target will be ""x:\MAS90\Home\Pvxwin32.exe"" ..\Launcher\Sota.ini ..\SOA\MAS90
Sage 100 ERP Premium Server Edition:
Assign SQL database permissions to the user:
Note: This step is not necessary if you log on as Administrator. The trusted Windows Administrator will be mapped into the SQL Builtin\Administrators group, unless specific SQL Server security has been set up.
Note the user's Windows domain account.
Open a command prompt (Start / Run / CMD) and type SET
Note the values for USERNAME and USERDOMAIN.
Have the SQL Database Administrator (DBA) assign the following database roles to domain account for the MAS_XXX and MAS_SYSTEM databases (XXX = company code):
DB_DataReader
DB_DataWriter
Create the MASSQL DSN driver to access the data.
Note: If you are at the server, this step is not necessary. The MASSQL DSN already exists.
At the Windows Start menu, click Control Panel.
Double-click Administrative Tools and Data Sources (ODBC) to open ODBC Data Source Administrator (or run Start / Run / ODBCAD32).
Click System DSN tab.
Click Add
Select SQL Server and click Finish to start the wizard.
Enter the following and click Next:
Name = MASSQL
Description = MASSQL
Server = The name or IP address of the SQL Server
Click With Windows NT Authentication Using Network Login ID option button.
Click Client Configuration
Click TCP/IP option button, and OK to return to the authentication window.
Click Next.
Note: If ""Logon Failure"" or similar occurs, the user account does not have sufficient rights to the SQL Server. Close the window, give the user sufficient rights, and start over.
Select both of the ANSI check boxes, and clear all other check boxes. Click Next.
Accept the default selections and click Finish.
Click Test Data Source to verify the connection.
Make a copy of the Sage 100 ERP Premium shortcut icon
Modify the following fields in the new icon (where X is the mapped drive letter, or C at the server):
Target:
""X:\MAS90\Home\Pvxwin32.exe"" ..\Launcher\Sota.ini ..\SOA\Startup.m4p
Start In (quotes are required only if the path contains a space):
""X:\MAS90\Home""
Note: In case of an upgrade, for Sage 100 versions 3.7x (MAS200), on Step #24 above, target will be ""X:\MAS90\Home\Pvxwin32.exe"" ..\Launcher\Sota.ini ..\SOA\MAS90
For more Help: Chat with Support