Unable to create databases in SQL Server Management Studio 2016

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

Facebooktwittergoogle_plusredditpinterestlinkedinmail

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.

Navneeth Nagrajan is a Technical Consultant at Avanade Australia focusing on implementation, pre-sales and support of Microsoft Dynamics 365 for Operations/ Microsoft Dynamics Ax ERP. Before Avanade, Navneeth worked as a Solutions Consultant at LM WindPower focusing on implementation and support of Microsoft Dynamics Ax Enterprise Resource Planning solution. Prior to LM WindPower, he worked as a Lead Consultant for ITC Infotech India Limited focusing on Enterprise Solutions like Microsoft Dynamics AX & Microsoft Dynamics CRM. He has worked for Microsoft as a Partner Technical Consultant. His primary focus area is Microsoft Dynamics AX and he specializes on Trade & Logistics, CRM, Service Management and Project Management functionalities. His secondary focus area is Microsoft Dynamics CRM and he specializes on Sales Management, Marketing Management and Service Management sections. He has successfully assisted more than 100 Microsoft partners and customers. At Microsoft, He has successfully written and published papers on '​'​ Needs for Microsoft Dynamics CRM in the Education Sector''. Prior to Microsoft, he has worked as a Functional Consultant and has implemented Microsoft Dynamics AX in the Manufacturing and Services Segment. He has also worked as a Business Development Executive implementing Document Management Systems for Security Broking and Manufacturing Organizations.