Hey everyone! I’m having trouble with SQL Server Management Studio (SSMS). When I try to add a new table to my database, I get this weird error message saying the backend version isn’t supported for designing diagrams or tables. It’s super frustrating!
I checked my SSMS version, and it shows:
- Microsoft SQL Server Management Studio: 15.0.18206.0
- Microsoft Analysis Services Client Tools: 15.0.19342.0
- Microsoft Data Access Components (MDAC): 10.0.19041.1
- Microsoft MSXML: 3.0 6.0
- Microsoft .NET Framework: 4.0.30319.42000
- Operating System: 10.0.19042
Has anyone run into this before? What could be causing it? I’m pretty sure everything’s up to date, but maybe I’m missing something obvious. Any ideas on how to fix this would be awesome. Thanks in advance for your help!
This issue often arises when there’s a mismatch between SSMS and SQL Server versions. I encountered a similar problem and found that using the SSMS version corresponding to your SQL Server version usually resolves it. Have you confirmed your SQL Server version? If it’s older than your SSMS, consider installing an appropriate SSMS version from Microsoft’s archive. Alternatively, you could update your SQL Server instance if feasible. Another workaround is to use T-SQL scripts for table creation instead of the GUI. This approach bypasses the version compatibility check and allows you to manage your database effectively despite the error.
hey maya, i’ve seen this happen before. mayb ur ssms version is too new for the sql server version? have you tried downgrading or checking with a different instance? maybe exploring azure data studio is worth a shot? what experiences have you had?
yo maya, that sucks! have u tried checking ur sql server version? sometimes older servers dont play nice with newer ssms. maybe try an older ssms version or use t-sql scripts to make tables instead of the gui. good luck!