Dynamics 365 for Finance and Operations connect to UAT SQL from local
- Get SQL information from LCS
a. SQL SERVER: spa**********bda2ec
b. Database Name: db_*********2020025_10023910_3e32
- Enable remote access to UAT AOS server. Refer
https://doc.daxonet.com/kb/935116 - Remote to UAT AOS via RDP
- Run Microsoft SQL Server Management Studio 17
- Login using SQL Server authentication
Server name: [Get from LCS #1a].database.windows.net
Login:axdbadmin
Password:[Get from LCS]
- Click Options -> Connection Properties
- Connect to database get from LCS #1b
- Run below SQL command: a.b.c.d replace by your public IP
-- Create database-level firewall setting for IP a.b.c.d
EXECUTE sp_set_database_firewall_rule N'Debugging rule for DevTest environment', 'a.b.c.d', 'a.b.c.d';
Note: need redo this after refresh UAT database from PRD
Was this article helpful?
Votes:
0
Article details: