We are in process of migrating Dynamics SL 2015 to dynamics SL 2018.We have two different servers where SL client and SL webapps are hosted in Private zone server and database is in DB zone server.
While deploying webapps and services didn't face any issues with all checks verified completed configuring them.
But user unable to login into webapps even the employee exists in user assignment,
Servers:Windows server 2019
SQL:SQL 2019
SSRS-2019
Dynamics SL 2018 cu5
We have enabled TLS 1.2 and disabled TLS 1.0,TLS 1.1
Error details:
LoginWindows SQLDBException SM~~16302~~Dynamics SL Message 16302: Fatal SQL Error~~~~ (Consumer: fe80::b807:3af0:736f:d249%4)
fe80::b807:3af0:736f:d249%4 POST /microsoft.dynamics.sl.webservices.session.loginwindows.svc - 444 Domain\user fe80::b807:3af0:736f:d249%4 - - 500 0 0 119
Hello.
Review this article and try the suggestion. If you have setup msdtc as our document describes then it should work.
Best Regards,
Jana MacDonald
Hi Marc,
Thank for the reply.
Yes i have done all the mentioned changes related to MSDTC before deploying of webservices and webapps and re-ran the scripts still facing same issue.I am suspecting some issue with webservice but unable to figure out the cause.
INETPUB error:
#Software: Microsoft Internet Information Services 10.0
#Version: 1.0
#Date: 2021-05-24 06:39:56
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status time-taken
2021-05-24 06:39:56 fe80::b807:3af0:736f:d249%4 POST /microsoft.dynamics.sl.webservices.session.loginforms.svc - 444 - fe80::b807:3af0:736f:d249%4 - - 401 0 0 1491
2021-05-24 06:39:56 fe80::b807:3af0:736f:d249%4 POST /microsoft.dynamics.sl.webservices.session.loginforms.svc - 444 serviceaccountXXX fe80::b807:3af0:736f:d249%4 - - 200 0 0 173
2021-05-24 06:40:08 fe80::b807:3af0:736f:d249%4 POST /microsoft.dynamics.sl.webservices.session.loginwindows.svc - 444 serviceaccountXXX fe80::b807:3af0:736f:d249%4 - - 500 0 0 95
Thank you,
Sandhya N.
Since you have SL DB and WA on different servers (recommended), did you allow MSDTC? See page 59 on the attached appendix
I would also rerun the SQL scripts on both APP and SYS db.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156