October 15, 2019 in Blog by Amer

D365FO | Cannot Connect to SQL Server Database on Your Cloud Test Machines

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:

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)

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:

Number 1 + “database.windows.net”:

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

Hope that helps.

October 14, 2010 in Blog by Amer

Failed to Connect to the Local Windows Database Engine while Running SharePoint Configuration Wizard

I had a problem while running the SharePoint Configuration Wizard after installing WSS 3.0 SP2 that says:

Failed to connect to the configuration database.
An exception of type System.Data.SqlClient.SqlException was thrown.  Additional exception information: Access to module dbo.proc_getObjectsByClass is blocked because the signature is not valid.
System.Data.SqlClient.SqlException: Access to module dbo.proc_getObjectsByClass is blocked because the signature is not valid.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
.......

As it looks clear from the error, the wizard simply fails to connect to the database. (The database was installed as Express edition on the local machine and the OS was Windows Server 2008 R2.) After lots of tries to uninstall WSS 3.0 and reinstall it again and again… I have done the following:

1. Un-installed Microsoft SQL Server Express Edition (from Programs and Features)
2. Downloaded Microsoft SQL Server 2008 R2 Edition (http://www.microsoft.com/express/database/) and then installed it
3. Installed WSS 3.0 SP2 as farm installation
4. After the installation has finished, I got the SharePoint Configuration Wizard where I was able to choose the local database that I have just installed..

The wizard then ran just fine. Hope it will with you as well

May 31, 2010 in Blog by Amer

How to Create a Primary Key for a Dynamics AX Table

This topic might not be new to most of you guys, but I always wondered how can I create a primary key to a Dynamics AX table?

You could easily create index in any table in Dynamics AX and you could specify that this index is “not duplicated”, which means that values of the field(s) should be unique among the table values. But this does not mean that you this index is a Primary Key index!

To create a Primary key you have to set the PrimaryIndex property in the list of that table properties.

When you choose the PrimaryIndex property you have to set that index as “not duplicated”. Once you do that, you will have the icon of that index changed to be like this: