Azure SQL Database
An Azure relational database service.
![](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(307.2, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
On my side, the problem came from my company's network rules (the rules on firewall destinations and protocols are very strict).
Azure Data Studio - Error when loading Table Designer
![](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(297.6, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SCHULTE, MAREIKE
0
Reputation points
Hi all,
I can't open the Table Designer, not when clicking on "New Table" nor when I want to edit an existing table.
This is the error message:
"An error occurred while initializing the table designer: Failed to initialize the table model."
How do I fix this?
The error details read:
at Microsoft.Data.Tools.Sql.DesignServices.TableDesigner.TableDesigner..ctor(String connectionString, String accessToken, String schemaName, String tableName, Boolean isNewTable, TableDesignerOptions options)
at Microsoft.SqlTools.ServiceLayer.TableDesigner.TableDesignerService.CreateTableDesigner(TableInfo tableInfo) in /_/src/Microsoft.SqlTools.ServiceLayer/TableDesigner/TableDesignerService.cs:line 1808
at Microsoft.SqlTools.ServiceLayer.TableDesigner.TableDesignerService.<>c__DisplayClass18_0.<<HandleInitializeTableDesignerRequest>b__0>d.MoveNext() in /_/src/Microsoft.SqlTools.ServiceLayer/TableDesigner/TableDesignerService.cs:line 102
--- End of stack trace from previous location ---
at Microsoft.SqlTools.ServiceLayer.TableDesigner.TableDesignerService.<>c__DisplayClass17_0`1.<<HandleRequest>b__0>d.MoveNext() in /_/src/Microsoft.SqlTools.ServiceLayer/TableDesigner/TableDesignerService.cs:line 88
Azure SQL Database
-
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator2023-06-23T21:09:54.7533333+00:00 @SCHULTE, MAREIKE Thank you for reaching out and sorry to hear about this issue.
I just tried to reproduce this issue from end by following this doc https://learn.microsoft.com/en-us/sql/azure-data-studio/overview-of-the-table-designer-in-azure-data-studio?view=sql-server-ver16
and it worked.
what version of Azure Data Studio are you using, and to what database are you connecting (e.g. on-prem, Azure SQL, Managed Instance, Synapse, etc.)?
Please check the below issue similar to your on github https://github.com/microsoft/azuredatastudio/issues/20787
Regards,
Oury
-
Vinodh247 42,051 Reputation points MVP Volunteer Moderator2023-06-25T05:17:03.3833333+00:00 probably should be a older version, could you let us know what your version number is? also try upgrading your ADS and see if you still face the same issue.
https://stackoverflow.com/questions/73879766/missing-table-designer-in-azure-datastudio
-
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,461 Reputation points Moderator2023-06-28T07:09:51.75+00:00 Hi
SCHULTE, MAREIKE •,Just checking if the issue is already resolved or if it still exists. Did updating version of Azure Data Studio help?
Let us know if you need further assistance. Thank you.
-
![](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(73.60000000000001, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Roberts, Siromani 0 Reputation points2023-07-24T21:15:47.3133333+00:00 As on July 24,2023, 17:14pm, the issue still persists and the version I am running is 1.44.1
-
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator
2023-07-25T19:30:39.9133333+00:00 I would suggest opening a support ticket. Do you have a support plan.?
Regards
Oury
Sign in to comment
2 answers
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(153.6, 66%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
way0utwest 81 Reputation points MVP2023-08-09T16:56:25.7466667+00:00 I would upgrade to 1.45 and test that. Alternatively, uninstall and reinstall ADS. It's possible you had some issue with the way this was configured. As of today, this is working for me.
Let me know what ADS version and also what SQL Server instance version. I have tested this on SQL 2017/2019/2022 and it works for me.
Windows 10, 22H2