web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Debugging sandbox envi...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Debugging sandbox environment

(0) Share

Report

Report

Posted on by Yuji

4,131

Hi experts,

I followed the article Debug a copy of the production database - Finance & Operations | Dynamics 365 | Microsoft Docs to debug code against a sandbox environment.

I changed the web.config file

>>>>>>>>>>>>>>>>>>>>>>>>>>>

<add key="DataAccess.Database" value="<example_axdb_fromAzure>" />

<add key="DataAccess.DbServer" value="<example_axdb_server.database.windows.net>" />

<add key="DataAccess.SqlPwd" value="<sqlpwd_password_from_LCS>" />

<add key="DataAccess.SqlUser" value="sqluser_from_lcs" />

>>>>>>>>>>>>>>>>>>>>>>>>>>>

And system is not started, and I checked the event log -

Login failed for user sqluser_from_lcs. But I use the same values and can access sandbox DB via SQL Server Management Studio.

Any idea?

Thanks,

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Gunjan Bhattachayya 35,429 on at

Like (0)

Report
Copy link

Link copied!

Hi Yuji,

While providing the IP address for accessing sandbox environment (using Maintain > Enable access), did you provide the IP address of the Dev environment? Were you able to access the sandbox DB using SQL server Management Studio from the Dev environment only?

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Yuji

you must set your IP address in LCS.

or you can restore your database in the VM

Best regards

Was this reply helpful? Yes No
Alex VN 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It seems that you used SSMS to access in the same dev environment and can access. In case you still have the issue if the IP address of the dev VM is added to UAT whitelist for DB access, please double check the provided information for the above 4 fields and ensure no space or wrong value.

Regards,

Was this reply helpful? Yes No
Suggested answer

Robert Sammut 456 on at

Like (0)

Report
Copy link

Link copied!

If you can connect from SSMS but not from the debugging environment (using the web.config changes), then the issue might be that you requested read-only access to the sandbox. "Reason for access" on the sandbox LCS page must be with write access.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Abhilash Warrier 635 Super User 2026 Season 1

#1

André Arnaud de Cal... 635 Super User 2026 Season 1

#3

Giorgio Bonacorsi 547

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans