Finance | Project Operations, Human Resources, ...

Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

(0) Share

Report

Posted on by Peter van Dijk

PROBLEM: Cannot connect to our customer SQL Server UAT database

Perhaps this is the underlying question : Should a ‘Microsoft Subscription’ be visible within Azure Portal?

Steps we carried out from Microsoft SQL Server Management Studio:

Connect to SQL Server (using database name and credentials provided by LCS)
Sign in
Create Firewall rule

Result: An error occurred while creating a new firewall rule. (ConnectionDlg)

Additional information:

The server you specified (spartan-srv-emea-d365opsprod-35657742b3c5.database.windows.net) does not exist in any subscription in our-admin-user@ourtenant.onmicrosoft.com

Either you have signed in with an incorrect account or your server was removed from all subscriptions in this account.

Please check your account and try again. (ConnectionDlg)

Our additional notes:

In Azure there was initially no ‘Azure Subscription’ available for our tenant. We created a ‘pay-as-you-go’ subscription.
- This did not solve the problem, now it is not complaining anymore that there are no subscriptions but that it cannot find our client UAT database within any Azure subscription.
We do not see a ‘Microsoft Subscription’ in Azure from where, we expect, our 3 client environments (Build/Test, UAT or Production) could originate and be billed.
- We think there should be a subscription since we were able to bring up a client UAT environment from LCS
We have no view on the SQL Server D365FO database (AxDB) that is installed for our client UAT environment
- Therefore we cannot add firewall rules manually to a SQL Server database (we do not see it).
From the Microsoft SQL Server Management Studio connection interface it seems that adding firewall rules could be done automatically.
- However this did not work and resulted in the error mentioned under 2 (see before).
Furthermore, within the D365FO LCS we see an option to add firewall rules
- We added a rule containing the ip-adress of the machine from where we connecting however did not solve the problem

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Shafeeque P. 6,527 Moderator on at

Like (1)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

[quote user="Christoph Thaler"]
Hi Shafeeque Mohammed,

Please double check the server and database you entered in SSMS with the information shown in LCS. If this is not the same you will get this login azure form.
[/quote]

Thank you, that worked. I was missing to enter the DB name.

Note: I am unable to mark your answer as verified as I am not the original person who posted the question :)

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (1)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

Hi Shafeeque Mohammed,

Please double check the server and database you entered in SSMS with the information shown in LCS. If this is not the same you will get this login azure form.

Was this reply helpful? Yes No
Shafeeque P. 6,527 Moderator on at

Like (0)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

I am facing the same issue. Infact, my IP address is added to the inclusion list using the enable access. Still when we login through SSMS, it is asking to login to the azure account.

Was this reply helpful? Yes No
ThomasVogtPoulsen 30 on at

Like (0)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

Did anyone got this working from a PC?

Even adding my IP address to the environment and being able to access the database from the AOS does not permit me to do the same from my local PC. Seems that the IP address firewall rule is added to the AOS-servers only and not the database server.

Was this reply helpful? Yes No
Suggested answer

Kevin Carr 80 on at

Like (0)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

Hi Peter

For the new D365 UAT environments with JIT access enabled you will need to add the Azure firewall rule via the Maintain -> Enable access function in the LCS environment page. Similar to how you enable access for remote desktop you will now see an option for Service: AzureSQL.

Once your IP is added, you can then connect with SQL SSMS from your PC using the information you outlined (Server, credentials, and database on the advanced tab). Since you IP was added in previous step it will not prompt to add that again which resulted in the error "Result: An error occurred while creating a new firewall rule. (ConnectionDlg)"

Regards,

Kevin

Was this reply helpful? Yes No
Suggested answer

Yev 35 on at

Like (0)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

When connecting to AX database you need the following:

1. Database server name - as per your post it is www.google.com/search

2. User name from the LCS - for example axdbadmin

3. Password from LCS for this user

4. Exact database name from LCS: for example db_d365opsprod_12345_12345_78eb

You need to enter the database name in the connection dialog on the second tab "Connecton properties" in the field "Connect to database"

If you do not do that - you won't be able to connect

5. You can only connect to the AX database from AOS server. If you cannot RDP to AOS server - it's a different type of question.

All above details can be found in LCS, you don't need to go to Azure Portal or anywhere else. You won't find Azure SQL server there because it's hosted by Microsoft.

There are no firewall rules that needs to be added for enable SQL connection from AOS to AX database but you can only connect to the database directly, you cannot connect to the server itself because of firewall in Azure SQL won't allow it (hence step 4 above).

Any further queries - don't hesitate to ask.

Regards,

Yev

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: Problem with connection to customer D365FO UAT database from sql client (Microsoft Subscription)

You can't reach Microsoft's Azure subscription.

Check this article for more information: docs.microsoft.com/.../dbmovement-scenario-debugdiag

Was this reply helpful? Yes No