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

  • ~ Mohamed Wajd Haikal, Software Team Leader at IDIS

    no_thumb"Amer is one of my best friends, he always tries to be the best by focusing on gaining new certifications and to have wide relationships"

  • Read more testimonials »