Blog

Microsoft Dynamics AX Blog

0

It’s been so long and short years since I posted anything on my blog. So here you go, I’m blogging again.

If you faced an issue lately in connecting to Microsoft SQL Server database on the test machines of your Microsoft Dynamics 365 Finance & Operations cloud deployments, even after you added “.databse.windows.net” then your deployment might got effected by the latest release in August or September 2019.

We used to login with the LCS SQL Server credentials:

LCS Old Way

But we started to get the following error:

Cannot connect to spartan-*** .database.windows.net

Cannot open server ‘spartan-***’ requested by the login. Client with IP address ‘*.*.*.*’ is not allowed to access the server. To enable access, use the Windows Azure Management Portal to run sp_set_firewall_rule on the master database to create a firewall rule fore this IP addressor address range. It may ta up to five minutes to for this change to take effect. (Microsoft SQL Server, Error:40615)

Cannot connect to database

Now, Microsoft might have moved your database to different Azure SQL Servers.

To make it simple, you now still have to put the server name (from LCS) in the Connection fields in SQL Server Management Studio, and add “.databse.windows.net” but you need to go to Options button, and entering the Database name (from LCS). You should be able to connect.

Here you go in pictures:


NEW DB Connection LCS

Number 1 + “database.windows.net”:

SQL SerfverDatabase name

You should be able to connect now if you copied the right credentials like this:

Connected DB

Hope that helps.

"D365FO | Cannot Connect to SQL Server Database on Your Cloud Test Machines", 5 out of 5 based on 1 ratings.

Dynamics AX 2012 Event

Recent Posts

Tags

Archives

Random Testimonial

  • ~ Mohamad Adel, Sr. Dynamics AX Developer at Al-Fanar IT

    Adel"I recommend Amer Atiyah as i worked with him in many simple and complicated tasks and i realized that he is very intelligent in the way of thinking to solve tasks problems. He has a very good experience and knowledge of his job. He is very hard worker, committed, organized and creative and very open mind in his work and that is the reason if his brilliant in his specialized field. He is always showing a high degree of professionalism and ability to deliver and accomplish very complicated tasks at any condition with high quality. I am recommending him to work in any team and i know he will fit with all challenges. Purely, he is a professional guy. I wish to him more and more success in his career and his life."

  • Read more testimonials »