Last post Mar 15, 2017 11:25 AM by bobh0526
Mar 14, 2017 02:56 PM|bobh0526|LINK
I downloaded and installed SQL Server Express 2014 this morning. I then used SSMS to create a new database named Ecommerce. I open Ecommerce and right-click on Tables. But I get this error:
This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)
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.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
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)
So what am I doing wrong?
Mar 14, 2017 04:02 PM|kaushalparik27|LINK
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.
Download link for Sql Server 2014 Management Studio :
https://www.microsoft.com/en-in/download/details.aspx?id=42299 and download:
Mar 14, 2017 05:43 PM|bobh0526|LINK
Thanks for the reply. But I'm totally confused. At work, we have SQL DBAs who set-up SQL for us. I only write T-SQL stored procedures and create SQL databases and tables. But I'm trying to set-up SQL 2014 Express at home. I downloaded the SSMS for 2014
using the link you provided. But I get the same error. How can I check the SQL version of the DB that I'm using? I only know how to interact with SQL using SSMS. I go to help in SSMS and I got this:
Microsoft SQL Server Management Studio 12.0.2000.8
Microsoft Analysis Services Client Tools 12.0.2000.8
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.14393.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.14393
I'm assuming this is a 2014 Express db right?
Mar 15, 2017 12:52 AM|oned_gk|LINK
I use current release SMSS to manage any versions sql databases
Mar 15, 2017 03:22 AM|Chris Zhao|LINK
To fix the issue you need to download latest updated version of sql server management studio. This
article describes how to determine your current Microsoft SQL Server version number and the
corresponding servicing or service pack level. It also describes how to determine the specific edition of SQL Server that you are using.
Mar 15, 2017 07:51 AM|wmec|LINK
Mar 15, 2017 09:50 AM|bobh0526|LINK
I opened Control Panel and discovered I had SQL Server 2008, 2012, and 2014 installed. I removed them all but 2014 is giving me trouble. I right-click on 2014 and I get a panel that has a Remove option. I click this and it says I need to do a restart.
I do that and then try to Remove again but it keeps saying I must restart. My goal is to just install SQL Server Express 2016 and SSMS for 2016. But I keep getting this Restart failed when I try to remove 2014.
Anyone know how I can remove SQL Server Express 2014?
Mar 15, 2017 10:04 AM|wmec|LINK
There should be now problem and you need to re-setup SQL server express 2014 once again.
Mar 15, 2017 10:09 AM|kaushalparik27|LINK
I click this and it says I need to do a restart. I do that and then try to Remove again but it keeps saying I must restart.
Uninstaller might be caught in a dead-lock. Try to search for remove pending reboots in Windows OS, and you will get more details on this. For a try, navigate to Start » Run » regedit and navigate to
and delete the key resides there.
Mar 15, 2017 11:25 AM|bobh0526|LINK
I removed the registry key like you suggested. I rebooted. I now was able to remove all instances of SQL Server 2014. So now I use SSMS for 2016 and I am able to create a new database and add new SQL tables.
Thanks for all your help. Sorry about all the dumb questions but like I said, I'm a developer. I have never setup SQL before even on my own PC. I always brought my laptop into work and let the SQL DBA guys set it up for me.