SQL Server - Windows Connection Error

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)

----------

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Can you check with the below link:
https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/
0
Riddhi Valecha8y ago
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.
0
Udit Chauhan8y ago
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
0