Run Sage 100 Advanced in Standard mode to troubleshoot issues such as:

• Deferred is the only printer option available
• Errors on the screen that are otherwise disguised
• Network connection issues
• Tasks requiring a mapped drive instead of a UNC path
• Problems tied to the Advanced edition's service or application, such as program or data corruption

Before you begin 

• Sage doesn't recommend this method for normal operational use
• It doesn't use primary Advanced features
• users can't see each other
• and correct toolbar bitmaps and HTML pages don't display

To run Sage 100 Advanced from the ProvideX prompt

1. Go to the server's MAS90, Home folder in Windows Explorer.
2. Right-click or Double-click Pvxwin32.exe.
3. At the ProvideX prompt, type RUN "STARTUP.M4P".
4. For MAS 90/200 versions three point seven x or below, type RUN "MAS90".
5. Press ENTER.
6. Log into Sage 100.

To create a Sage 100 ERP Standard shortcut icon

1. Make a copy of the Sage 100 ERP Advanced shortcut icon.
2. 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: "X:\MAS90\Home" (quotes required only if the path contains a space)

For Sage 100 ERP Premium Server Edition

Identify the User's Domain Account

1. Assign SQL database permissions to the user.
2. Note the user's Windows domain account.
3. Open a command prompt (Start, Run, CMD) and type SET.
4. Note the values for USERNAME and USERDOMAIN.

Assign SQL Database Permissions

1. Have the SQL DBA assign these database roles to the domain account for MAS_XXX and MAS_SYSTEM. XXX = company code.
   
   • DB_DataReader
   • DB_DataWriter
2. Create the MASSQL DSN driver to access the data.

Create the MASSQL DSN Driver

1. At the Windows Start menu, click Control Panel.
2. Double-click Administrative Tools.
3. Select Data Sources (ODBC) to open ODBC Data Source Administrator.
   •  For a 64-bit operating system, run EXE from the C:\Windows\SysWOW64 folder
4. Click System DSN tab.
5. Click Add.
6. Select SQL Server and click Finish.
7. Enter the following and click Next:
   • Name = MASSQL
   • Description = MASSQL
   • Server = name or IP address of the SQL Server
8. Click With Windows NT Authentication Using Network Login ID option button.
9. Click Client Configuration.
10. Click TCP/IP option button, and OK.
11. Click Next.
12. If "Logon Failure" or similar occurs, the user account doesn’t have sufficient rights to the SQL Server. Close the window, give the user sufficient rights, and start over.
13. Select both ANSI check boxes, then clear all other check boxes.
14. Click Next.
15. Accept the default selections and click Finish.
16. Click Test Data Source to verify the connection.

Update the Sage 100 Shortcut

1. Make a copy of the Sage 100 ERP Premium shortcut icon.
2. 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: "X:\MAS90\Home" (quotes required only if the path contains a space)