cancel
Showing results for 
Search instead for 
Did you mean: 

changed sa password - cannot login SAP Business One

Former Member
0 Kudos

Please, could someone help me, I had changed the sa password and since then I cannot open Business One.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Natalia,

You can change server on Server tools / License Manager/ Configure Security.

GLU

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer thread

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Make sure you change the sa password in the License Manager security settings.

Former Member
0 Kudos

Can't login, I check the services SQL Server Agent is not stated, tried to restart but it fails.

I checked the log file, it says:

2013-12-19 16:53:08 - ? [100] Microsoft SQLServerAgent version 11.0.3000.0 (x86 unicode retail build) : Process ID 4812

2013-12-19 16:53:08 - ? [495] The SQL Server Agent startup service account is BSS\SOMAC$.

2013-12-19 16:53:08 - ? [393] Waiting for SQL Server to recover database 'msdb'...

2013-12-19 16:53:08 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs)

2013-12-19 16:53:08 - ! [000] The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229)

2013-12-19 16:53:08 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs)

2013-12-19 16:53:08 - ! [000] The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229)

2013-12-19 16:53:08 - ? [098] SQLServerAgent terminated (normally)

Former Member
0 Kudos

I don't know about all that. Have you tried researching the error messages? What version of SQL are you using?