get_TargetDatabaseEngineEdition SSMS 2016出错 [英] Error on get_TargetDatabaseEngineEdition SSMS 2016

问题描述

您好，在对Visual Studio（2017）应用各种更新并安装Visual Studio 2015之后，我现在在尝试使用SSMS（SQL Server Management Studio 2016）连接到数据库时收到错误

Hello, after applying various updates to Visual Studio (2017) and installing Visual Studio 2015, I now get an error when trying to connect to a database using SSMS (SQL Server Management Studio 2016)

程序集'Microsoft.SqlServer.Management.UserSettings.ScriptingOptions'中的方法'get_TargetDatabaseEngineEdition'来自程序集'Microsoft.SqlServer.Management.UserSettings，Version = 13.0.0.0，Culture = neutral，PublicKeyToken = 89845dcd8080cc91'不实施
。 （mscorlib）

Method 'get_TargetDatabaseEngineEdition' in type 'Microsoft.SqlServer.Management.UserSettings.ScriptingOptions' from assembly 'Microsoft.SqlServer.Management.UserSettings, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' does not have an implementation. (mscorlib)

卸载SQL Server 2016并重新安装没有帮助。我还重新安装了Visual Studio 2017.  

Uninstalling SQL Server 2016 and reinstalling did not help. I also re-installed Visual Studio 2017.  

有关解决问题的建议或有关进一步调查此问题的方法的建议吗？

Any suggestions on a resolution or suggestions on ways to further investigate the issue?

谢谢！

推荐答案

您好，

请验证以下所有清单选项：

Please verify all the below checklist options:

• 确保SQL Server已启动，您在SQL Server ErrorLog中看到以下消息：
  
  SQL Server现在已准备好进行客户端连接。这是一条情报信息;无需用户操作。
• 验证IP地址的基本连接并检查是否存在任何异常：
  
  ping -a< SQL Server计算机>，ping -a< SQL Server IP地址>。如果您发现任何问题，请与网络管理员一起修复此问题。
• 检查是否SQL通过查看ErrorLog来监听适当的协议。
• 检查您是否能够连接到SQL服务器使用  UDL  文件 - 如果有效，则连接字符串可能存在问题。有关关于UDL测试的
  过程的说明，请选择选项" C onnect to to使用UDL文件的SQL Server  "在底部。
• 检查您是否能够从其他客户端系统连接到SQL Server并且不同用户登录 - 如果您能够，则该问题可能特定于遇到
  问题的客户端或登录。检查有问题的客户端上的Windows事件日志以获取其他指针。还要检查网络驱动程序是否是最新的 。
• 如果遇到登录失败，请确保用户具有服务器级别的登录名以及连接到用户尝试连接的数据库的相应权限。

• Ensure SQL server is started and you see the following message in the SQL Server ErrorLog:
  SQL Server is now ready for client connections. This is an informational message; no user action is required.
• Verify basic connectivity over IP address and check for any abnormalities:
  ping –a <SQL Server machine>, ping –a <SQL Server IP address>. If you notice any issues, work with your network administrator to fix the same. 
• Check if SQL is listening on appropriate protocols by reviewing the ErrorLog.
• Check if you are able to connect to SQL server using a UDL file – if it works, then there may be an issue with the connection string. For instructions on the procedure about UDL test,select the option "Connect to SQL server using a UDL file " at the bottom.
• Check if you are able to connect to SQL Server from other client systems and different user logins– if you are able to, then the issue could be specific to the client or login that is experiencing the issue. Check the Windows event logs on problematic client for additional pointers. Also check if network drivers are up to date.
• If you are experiencing login failures, ensure the user has a login at the server level and appropriate permissions to connect to the database that the user is trying to connect to.

谢谢，

Alambir

这篇关于get_TargetDatabaseEngineEdition SSMS 2016出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！