Sage 100

 View Only

  • 1.  Premium version moved from live server to hosting server

    Posted 11-23-2022 13:35
    I'm getting an error when I right click on the databases and go under properties to assign the permissions to the MAS_USER in SQL. 


    When I look at the security, logins section for the MAS_USER. I show the user is mapped to the company database and system files.


    I think I'm missing a checkbox somewhere in SQL. When I log into Sage I get this message:



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------


  • 2.  RE: Premium version moved from live server to hosting server

    Posted 11-23-2022 14:22
    I think I've seen that SQL error before... where the "old" MAS_User owns something in the database (like a schema) blocking the ownership change, due to the name conflict.  Try looking in each database's Users to track down what's blocking the change.
    (Be sure you have good backups before making any changes!).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------



  • 3.  RE: Premium version moved from live server to hosting server

    Posted 11-23-2022 14:28
    Usually, you have to remove MAS_User from each database and then add it back, which get the actual MAS_User with the correct guid for the new server

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 4.  RE: Premium version moved from live server to hosting server

    Posted 11-23-2022 14:31
    Phil,
    That is normally only needed for MAS_Reports.  Usually MAS_User doesn't own any objects within the databases, so setting database ownership works directly.
    use MAS_###;
    exec sp_changedbowner 'MAS_User';
    exec sp_dropuser 'MAS_Reports';
    exec sp_grantdbaccess 'MAS_Reports';
    exec sp_addrolemember 'db_datareader', 'MAS_Reports';


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 5.  RE: Premium version moved from live server to hosting server

    Posted 11-23-2022 18:32
    Now I'm getting this error when I test out the business insight explorer views:



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------

    Original Message


  • 6.  RE: Premium version moved from live server to hosting server

    Posted 11-23-2022 18:58
    Make sure the MAS_Reports permissions are correct.  (The script I posted should do that properly...).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


Related Content