ERROR : [-10052] The authenticate_user script returned 4000.

Asked By rashadul2011 0 points N/A Posted on - 01/12/2012

My company has 50 employees working away from the office. They synchronize with our database daily and we have had no problems until two days ago. Now, whenever they synchronize, this error message appears in the record log:

ERROR : [-10052] The authenticate_user script returned 4000. I reviewed previous records and learned that it should “return 1000.” I am not sure what to do as I started work here only two days ago when the problem started. The employee I replaced left two days ago. Please advise me what to do and what is causing this error to appear. Thank you.

• Status: Open
• Question Views: 2489
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Richard Gabriel 0 points N/A #119108

ERROR : [-10052] The authenticate_user script returned 4000.

The error is being caused possibly by some changes that you probably made inside the login script, and therefore you will need to trace them and change them. I will suggest that you use sp_displaylogin to find to be able to find the procedure name that has that problem and change it accordingly.

The sp_displaylogin is probably inside the login script and therefore you should find it there, and then change the procedure name as I have already told you above.  Check also for changes in the logic of the expressions and syntax errors too, they might be responsible for the problem.

-Richard Gabriel

About Richard Gabriel

Questions
0

Answers
99

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 01/12/2012
• Question Category: Database