I'm using SQL Server 2012 Enterprise and while I'm trying to make a new database diagram, I get this error :
TITLE: Microsoft SQL Server Management Studio
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
I've tried reinstalling SQL Server but it didn't work.
Note: I installed Visual Studio Ultimate 2013 and then I uninstalled it.
Thanks.
Read this post and go to workarounds.
On my machine, I have VS2012
, SQL2008
, and SQL2012
. At one point I had installed VS2013
, which updated the dlls
in the following folders (mentioned by other users) to the VS2013
versions. After uninstalling VS2013
, they remained and caused the conflict. In order to fix it I simply backed up and deleted all of the files in these locations:
C:\Program Files (x86)\Common Files\microsoft shared\Visual Database Tools\dsref80.dll
C:\Program Files (x86)\Common Files\microsoft shared\MSDesigners8\
Then ran a repair of VS2012
, which restored the dlls
to the proper version. Everything is working smoothly now and I am able to create and open DB diagrams.
Also you have details here.