Archive
October, 2019
Browsing all articles from October, 2019
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.

Dynamics AX 2012 Event

Recent Posts

Tags

Archives

Random Testimonial

  • ~ Muheet Shariff, Dynamics AX Consultant

    muheet"I have found Amer a pleasant, generous person who is never afraid to take on a challenging task.Amer is an independent, self directed person who is able to communicate effectively and meet even the most demanding challenges. I am positive he will make outstanding contributions to Microsoft technologies. It was a great experience working with Amer during our implementation of Dynamics AX at  Al-Fahad and Al-Othaim companies. His support to Microsoft Dynamics AX is outstanding and very professional. Technically he sounds very strong. It was a great pleasure to be associated along with Amer performing some challenging tasks. I wish him to reach the desired success with his professionalism."

  • Read more testimonials »