Got SQL error while Logging into NAV 2009 classic?

Jacob1227

Hi All,

Login is existed for this user but still facing this error while logging into NAV.

" the following sql error or errors occurred. 15161,"42000" [microsoft ODBC SQL Server driver][SQl server] cannot set application role."



Please suggest me some solution to overcome this issue.

Thanks in advance,
Jacob A.

imclever1205

Did you check the permission assigned to the user in SQL ? It must be related to the role assigned to the user.

Arhontis

Hi,

Maybe this can help you:
https://forum.mibuso.com/discussion/51009/ndo-shadow-trouble

Or this:
https://blog.ctglobalservices.com/configuration-manager-sccm/kea/configuration-manager-2007-reporting-point-cannot-set-application-role-webreport_approle/