14,502 questions
Download SSMS 19, preview 4, which understands about SQL 2022.
Microsoft SQL Server Management Studio 2022 cannot create Tables
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 30%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gorawit Sukontee
21
Reputation points
When I try to create tables .It show me this error.
I use this version
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 22621: )
===================================
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)
SQL Server | Other
{count} votes
-
Viorel 122.6K Reputation points2022-12-21T17:25:42.31+00:00 Are you using the latest version of Management Studio?
You can also try the preview version, which is probably adjusted for SQL Server 2022.
Sign in to comment
Accepted answer
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2022-12-21T22:27:38.11+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
James Longstreet 26 Reputation points2022-12-28T16:48:35.35+00:00 I ran into a glitch here on the update from Preview 3 (19) to Preview 4. Currently, I'm investigating why I am getting an "Unable to load DLL 'Microsoft.Data.qlClient.SNI.x86.dll'" The Preview may not understand the location of my drive as I do not install to the C: drive. I see no sign of the error in the Event logs. This is a company laptop and I have no access to the security logs. The actual file appears at "C:\Program Files\Azure Data Studio\resources\app\extensions\mssql\sqltoolsservice\Windows\4.3.1.2" and not in the Microsoft SQL Server folder.
-
James Longstreet 26 Reputation points
2022-12-28T17:12:16.167+00:00 In response to my previous comment, running a repair forced a reboot and now all is working.
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2022-12-28T21:47:59.393+00:00 The documentation clearly says that you need to uninstall Preview 3 before you install Preview 4.
What? You don't read documentation? Well, nor did I, and I got the same error. I reported it to a contact at Micorsoft who patiently pointed out the requirement. That's what they call learning things the hard way.
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2022-12-22T01:45:54.237+00:00 Hi @Gorawit Sukontee ,
Welcome to Microsoft Q&A! This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio).
Please refer to this document: https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16#tools
SSMS version 19.0 Preview 3 is now available and is the recommended version of SSMS for SQL Server 2022 (16.x). Download SQL Server Management Studio (SSMS).
When you click into the download link, you find that SSMS 19 preview 4 is already available.Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.