SQL Server - Windows Connection Error

Question

Dear Team,

Please guide me on this - I am trying to make dummy database in windows authentication.

But, I am getting the below error -

This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.DataTools.Interop.IDTTableDesignerFactory.NewTable(Object dsRef, Object pServiceProvider)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.TableDesignerNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con, String fileName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

----------

Mageshwaran R · Answer

Hi, Can you check with the below link: https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/

Riddhi Valecha · Answer

Hello sir... I have downloaded the SSMS Latest version and have installed it on my machine. Still, I am getting the same error while creating new table or making new Stored Procedure.

Udit Chauhan · Answer

Hi Ridhi, Use the SSMS version designed for your database version. You can use the command select @@version to check which version of SQL Server you are actually using. Update your SSMS to the latest version and try. You may have the latest version of SQL Server and older version of SSMS. https://msdn.microsoft.com/en-us/library/mt238290.aspx