SQL Server 2008 Unspecified error (MS Visual Database Tools)

sql-server-2008 database-diagram
SilentVoice picture SilentVoice · Jun 21, 2012 · Viewed 9.5k times · Source

I am a newbie using SQL Server 2008, and I am facing an error message when I try to make database diagram by right clicking on the database in SQL Server Management Studio:

Unspecified error (MS Visual Database Tools)

Program Location:

at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
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.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc, String fileName)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

I have searched for this error and most of the responses were about "common error when upgrading from 2005 to 2008", which is not my case, because I have only just newly installed SQL Server 2008 4 days ago.

Can someone help me to solve this problem?

Answer

Erin Gibbs picture Erin Gibbs · Oct 17, 2012

I had this error today. It had nothing to do with migration from SQL Server 2005 to 2008 in my case. To solve the problem, I restarted my SQL Server 2008 and, in the authentication window, I changed the "Authentication" field from "Windows Authentication" to "SQL Server Authentication". I have no idea how I had ended up on "Windows Authentication" in the first place but changing it fixed the issue for me.

Related questions

What does a dashed / dotted relationship line represent in SQL Management Studio - Database Diagram

I'm looking at an existing database in Microsoft SQL Server Management Studio, and in the Database Diagram there is one relatioship that appears with a dashed or dotted line. The other relationships are all solid lines. What does the dashed …

Read More
How can I script SQL Server database diagrams?

How can I export SQL Server database diagrams as developer-friendly SQL scripts? By developer-friendly, I mean written in a way similar to the way a human would write them as opposed to the messy many-UPDATEs style used by existing solutions. (…

Read More
create image for database diagram in sql server

I have created database diagram in sql server. But I have to take 15 more tables in db diagram. Then i take screenshot. But i can't take screenshot more than 5 table. So I take screenshot 2 or more times. If sql server …

Read More