While working on the “Bring Your Own Database to Azure” functionality in Microsoft Dynamics 365 for Finance and Operations, Enterprise Editions/Microsoft Dynamics 365 Unified Operations, there is a step where we need to first setup and configure a SQL Azure Database and an instance. Now, to test this instance, we need to login to SQL Server Management Studio and check if we can connect successfully to the SQL Azure database instance.
Testing the SQL Server Management Studio 2016 to test the SQL Azure connection:
On logging into the SQL Server Management Studio, it will connect to the SQL Azure instance, but while creating a database in SQL Azure, there is an error that we receive stating
“Method Not Found:’System. Collections.Specialized.StringCollection
Microsoft.SqlServer.Management.Smo.Server.GetPropertyNames (System.Type)’ ”
Fig 1 – Error While Creating A DataBase in SQL Azure
While troubleshooting this issue, received an update pop-up at the bottom of the SQL Server Management Studio. Selected the update link and that triggered the update from SQL Server 2016 tools to SQL Server 17.6 updates.
Post update to SQL Server 17.6, this error was resolved, and the database creation option worked fine.
Fig 2 – Creating Databases in SQL Server Management Studio 17.6