Blog

Microsoft Dynamics AX Blog

Browsing all articles in 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.

26

كمبادرة من :مجتمع مايكروسوفت داينامكس إيه إكس برينز” و الذي نشأ في البلاد العربية لدعم و مساعدة العاملين على نظام مايكروسوفت داينامكس إيه إكس (المسمى سابقا بـ: أكزبتا)، ارتأينا القيام بسلسلة من الحلقات التعليمية الخاصة في نظام مايكروسوفت داينامكس إيه إكس باللغة العربية.

الهدف هو إظهار قدرات هذا النظام، و إبراز معالمه الرئيسية، و نشر وعي المجتمع العربي.

المستهدفين هم الأخوة و الأخوات الراغبين في التعرف أكثر و التقرب أكثر من صناعة أنطمة تخطيط موارد المنظمات، و بالأخص العاملين على نظام داينامكس إيه إكس.

نبدأ الحلقات بأول حلقة:

1

Intro

Your business deserves more than
just an accounting solution.

Find out more at the Microsoft Dynamics Launch Event.

Dear Customer,

Microsoft is redefining how business solutions empower people for greater success, predict potential issues and opportunities, and enable organizations to expand the possibilities for competitive advantage.

Join us at the Microsoft Dynamics Launch Event to find out how to work forward and continue to grow into a well-connected, forward-looking organization that empowers its people to reach their full potential.

Meet Microsoft and Microsoft partners, learn about the latest Microsoft Dynamics solutions from industry experts, and find out how to deliver immediate results for your business.

Date: Sunday, 24th February, 2013
City: Riyadh
Venue: Intercontinental Hotel
Tracks: Multiple tracks

 

Register now

Agenda

08:00 – 09:00 Registration & Morning Coffee
09:00 – 09:15 Welcoming & Introduction
09:15 – 09:30 Keynote
09:30 – 10:00 CRM Overview
10:00 – 11:30 CRM Partner Solution

AX R2 2012 Track
12:45 – 01:30 AX R2 2012 Overview
01:30 – 03:00 AX Partner Solution
03:00 – 03:30 Microsoft Dynamics Communities in Saudi: Why, how and where?
03:30 – 05:00 Prayer, Coffee Break & Meeting the Partners

GP 2013 Track 
01:00 – 03:00 GP Partner Solution
03:00 – 05:00 Prayer, Coffee Break & Meeting the Partners Prayer,

 

NAV 2013 Track
01:00 – 03:00 NAV Partner Solution
03:00 – 05:00 Prayer, Coffee Break & Meeting the Partners

 

0

Files of Our AX Brains Dec 2012 Event

Dynamics AX Brains Community

As part of our contribution to our Dynamics AX Brains community members, we are sharing our presentation files we have used during the four sessions we had in our Dynamics AX Dec 2012 Technical Seminar. (Click to Download.)

Read more »

0

It was a great day!