News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Nav 2013 Problem in Login

Small and medium business | Business Central, N...

Answered

Nav 2013 Problem in Login

(0) Share

Report

Report

Posted on by esnalca

25

Hello

Sorry for my English We have the next problem when we login into Navision, the traduction to english is:

The prepared statement with the identifier was not found.




I go to Windows Events and i can see this:

Can anyone help me to understanding this error.

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

esnalca 25 on at

Like (1)

Report

RE: Nav 2013 Problem in Login

The SQL Service is OK, when we have this problem i restart the service and nav instances and work fine.
Suggested answer

Amit_Sharma 2,545 on at

Like (0)

Report

RE: Nav 2013 Problem in Login

Hi,

1. Check SQL Service.

2. Check any change in the Table architecture directly via SQL.

Regards

Amit Sharma

www.erpconsultors.com
esnalca 25 on at

Like (0)

Report

RE: Nav 2013 Problem in Login

I can´t reinstall because the old technician doesn´t let nav2013 anywhere
Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (1)

Report

RE: Nav 2013 Problem in Login

Hi, Maybe reinstalling will fix the problem.

https://forum.mibuso.com/discussion/73891/nav-2013r2-the-following-sql-error-was-unexpected-the-prepared-statement-with-handle-xyz-was

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans