The user "sa" lost access to the companies.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Good morning to all. I explain the situation. I have GP 2015 working on windows server 2008 r2 and SQL server 2012 standard edition. And I do not know what happened and the user "sa" did not have access to the companies (2). At this moment I am using DYNSA to login with a little more privileges. Can somebody help me

Juan Bonilla

Greetings.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Mariano Gomez 26,225 on at

Like (0)

Report
RE: The user "sa" lost access to the companies.

Your 'sa' user has no record entries in the User Access table. You can verify that by running the following query:

select * from SY60100 where USERID = 'sa'

If you find that there are records missing, the following script should rebuild access:

insert into SY60100 (USERID, CMPANYID) select 'sa', CMPANYID FROM SY01500 except select USERID, CMPANYID FROM SY60100 where USERID = 'sa';

Please let us know if this was the case.
Richard Wheeler 75,788 Moderator on at

Like (0)

Report

RE: The user "sa" lost access to the companies.

Sounds like someone removed the access for 'sa' in GP. If you have access you can go to Tools->Setup->System->User Access and grant access back to 'sa'. You may want to check with your IT department first.