I got the below error while access the Dynamics 365 PROD DB from my DEV box.
your client ip does not have access to the server. sign in to an azure error
Reason: Dev box IP was not whitelisted in the PROD instance.
Solution:
Below is the query to add the IP addresses to the firewall table(sys.database_firewall_rules) to access the database from outside.
Run the below query to see existing IP's
select * from sys.database_firewall_rules;
I executed the below queries to add the IP addresses to the table.
-- Create database-level firewall setting for only for one IP 0.0.0.4 EXECUTE sp_set_database_firewall_rule N'Example DB Setting 1', '0.0.0.4', '0.0.0.4'; -- Update database-level firewall setting to create a range of allowed IP addresses EXECUTE sp_set_database_firewall_rule N'Example DB Setting 1', '0.0.0.4', '0.0.0.6';
Use what is my ip in google for knowing your public IP.
Note: My AX is on cloud and we created a custom screen in AX to run the queries.
Below are the links helped me.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-set-database-firewall-rule-azure-sql-database?view=azuresqldb-current
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure
your client ip does not have access to the server. sign in to an azure error
Reason: Dev box IP was not whitelisted in the PROD instance.
Solution:
Below is the query to add the IP addresses to the firewall table(sys.database_firewall_rules) to access the database from outside.
Run the below query to see existing IP's
select * from sys.database_firewall_rules;
I executed the below queries to add the IP addresses to the table.
-- Create database-level firewall setting for only for one IP 0.0.0.4 EXECUTE sp_set_database_firewall_rule N'Example DB Setting 1', '0.0.0.4', '0.0.0.4'; -- Update database-level firewall setting to create a range of allowed IP addresses EXECUTE sp_set_database_firewall_rule N'Example DB Setting 1', '0.0.0.4', '0.0.0.6';
Use what is my ip in google for knowing your public IP.
Note: My AX is on cloud and we created a custom screen in AX to run the queries.
Below are the links helped me.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-set-database-firewall-rule-azure-sql-database?view=azuresqldb-current
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure
여러 서비스를 비교하다가 선택하게 되었는데 기대 이상이었습니다. 진행 방식이 직관적이고 빠르게 결과를 확인할 수 있어 컬쳐랜드할인. 특히 소액결제현금화 기능 덕분에 갑작스러운 상황에서도 유연하게 대처할 수 있었습니다. 신뢰할 수 있는 서비스라는 느낌이 강하게 들었습니다.
ReplyDelete원하는 시간대 선택이 가능해 생활 패턴 유지에 많은 도움이 되었습니다. 단기알바 서비스는 정보 확인이 편리하고 진행 속도도 빨라 만족스러운 경험이었습니다.
ReplyDelete늦은 시간에도 예약 진행이 빨라서 바쁜 직장인에게 정말 유용했어요. 성남출장마사지 서비스는 관리사의 응대가 친절하고 압 조절도 꼼꼼해서 피로 회복에 도움이 되었고 편안한 분위기까지 마음에 들었습니다.
ReplyDelete