| | Error: “Create Table failed for MAS_SYSTEM..SY_UserRegistry\28000: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'MAS_User' " |
| Cause | The MAS_XXX database in SQL is not owned by the MAS_user login and must be assigned in order to log in. This usually happens when trying to restore a database from backup or from another server or when ownership is not correctly applied during a new installation. The following resolution should only be attempted by a SQL System Administrator as improper modifications can cause database corruption or other issues. |
| Resolution | [BCB:2:Database warning:ECB]
- Open SQL Management Studio and log in.
- Select the MAS_XXX database from Object Explorer and then right click on Properties
- Select Database, Files, Owner and then click ... and select the MAS_User object
- Click Ok, close SQL Management Studio and verify you can access company from within Sage 100 ERP Premium.
DocLink: How to move Sage 100 Premium ERP SQL Database to a new Server
|
|