Unable to create databases in SQL Server Management Studio 2016

Unable to create databases in SQL Server Management Studio 2016 For Dynamic 365

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)’

Create databases not working SQL Server Management Studio

Fig 1 – Error While Creating A DataBase in SQL Azure

Solution:
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.

Create databases not working SQL Server Management Studio

Fig 2 – Creating Databases in SQL Server Management Studio 17.6

References:

Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.
Avatar

Navneeth Nagrajan is a Technology Specialist at Deloitte Australia focussing on design, development, integration, and implementation of the Microsoft Power Platform (primarily PowerBI, Common Data Service and Flow) and Dynamics 365 for Finance and Operations ERP. Other areas of focus include Azure DevOps, Github (related to Dynamics 365 for Finance and Operations deployments), and Dynamics Lifecycle Services.Profile:Twitter: http://www.twitter.com/nav21n LinkedIn: https://www.linkedin.com/in/navneeth-nagrajan-94a9aa5/