web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Debugging sandbox envi...
Finance | Project Operations, Human Resources, ...
Suggested answer

Debugging sandbox environment

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Robert Sammut Profile Picture
    Robert Sammut 456 on at
    RE: Debugging sandbox environment

    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.

  • Alex VN Profile Picture
    Alex VN 1,994 on at
    RE: Debugging sandbox environment

    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,

  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 26,311 Super User 2025 Season 2 on at
    RE: Debugging sandbox environment

    Hi Yuji

    you must set your IP address in LCS.

    or you can restore your database in the VM

    Best regards

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Debugging sandbox environment

    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?  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,352

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 830 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 634 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans