SSMS error - "Attempting to read or write protected memory" - access to the local host - editing 200 lines

So, I ran localhost SQL Server, and I tried to edit the first 200 rows of the table. Then I got this (original in German, I found this through the web):

enter image description here

After that, the SSMS closes. I researched and I found out that this is a known problem if the PATH variable has more than 2 thousand characters. Mine is 1336, so the problem should be somewhere else.

This is the path variable:

C:\Program Files\Common Files\Microsoft Shared\Windows Live;
C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;
C:\ProgramData\Oracle\Java\javapath;
C:\Program Files (x86)\Intel\iCLS Client\;
C:\Program Files\Intel\iCLS Client\;
%SystemRoot%\system32;
%SystemRoot%;
%SystemRoot%\System32\Wbem;
%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;
C:\Program Files\Intel\WiFi\bin\;
C:\Program Files\Common Files\Intel\WirelessCommon\;
C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;
C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;%systemroot%\System32\WindowsPowerShell\v1.0\;
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;
C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;
C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;
C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;
C:\Program Files (x86)\Windows Live\Shared;
C:\Program Files\Git\cmd;%USERPROFILE%\.dnx\bin;
C:\Program Files\Microsoft DNX\Dnvm\;
C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;
C:\Program Files\TortoiseSVN\bin

Sometimes, depending on my luck, I don’t even get an error message, but this: enter image description here

This means that SSMS will restart.

Additional points:

  • SQL Server 2014
  • The problem exists only on localhost. If I connect to the server, this is normal.
  • I have enough RAM.
  • Localhost , - .

:

:

  • " ": enter image description here

  • SSMS 2014. .

  • 200 : enter image description here

  • ( , ):

https://gist.github.com/Vitosh/0eb2371ebf9552af0349ad8ceff442e7 https://gist.github.com/Vitosh/0f36f35998149de413e9b412ce8e21fc

EDIT - , , ! :

Microsoft SQL Server Management Studio 12.0.2000.8

Microsoft Analysis Services-Clienttools 12.0.2000.8

Microsoft (MDAC) 10.0.10586.0

Microsoft MSXML 3.0 6.0

Microsoft.NET Framework 4.0.30319.42000

Betriebssystem 6.3.10586

:

  • - 12.0.4213

  • localhost, , 13.0.1100

, -.

+4
1

, SQL Server.... , . , SQL Server 2014 SQL Server Management 2012. , SQL Server SQL Server 2014

: SQL Server Management Studio . ( " " ).

+1

Source: https://habr.com/ru/post/1654106/


All Articles