Dynamics 365 for Finance and OperationsSQLSQL Server Unable to create databases in SQL Server Management Studio 2016 For Dynamic 365 April 19, 20181169 views0 Share By Navneeth Nagrajan Share 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 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. Fig 2 – Creating Databases in SQL Server Management Studio 17.6 References: SQL Server Management Studio 17.6: https://blogs.technet.microsoft.com/dataplatforminsider/2018/03/20/ssms-17-6-is-now-available-managed-instance-and-many-bug-fixes/ https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 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. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 Navneeth NagrajanNavneeth 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/ Twitter
SQL Server What is the SQL Server SA (Sys Admin) Password Policy & Default Password By IGApril 10, 2022
PowerBI Premium Storage Settings – Dynamics 365 Finance and Supply Chain (F&O) Environment Setup By Navneeth NagrajanJanuary 13, 2020
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
Dynamics 365 for Finance and Operations F&SCM Customer Integration Through CDS (Common Data Service) for Apps In one of the implementation projects recently, we used the F&SCM (F&O) customer integration through ...
Dynamics 365 for Finance and Operations Using Document Template Refresh Capabilities to fix Open Lines in Excel in Journals In one of our recent implementation projects (Dynamics F&O), we used the capabilities of “Open ...
Dynamics 365 for Finance and Operations “Click to Copy Password” button in Microsoft Dynamics Lifecycle Services In this post, we will highlight a new feature that is launched in Microsoft Dynamics ...
Dynamics 365 for Finance and Operations Report with Security Roles, Users Assigned Duties, Privileges and the Required Tables Often in many Dynamics 365 for Finance and Operations implementation projects, there is a question ...