SSMS Becomes "Not Responding" and Shuts Automatically When Clicking "Design" on SQL Database's View

-
I faced a problem from SSMS which doesn't show any error when I wanted to see the "Design" of a SQL Database's View.

There is a similar post here.
I would say similar because my problem was a bit different than that post as my SSMS didn't even display any error, it just became "Not Responding" and closed itself automatically.

There was an AccessViolationException when I looked into the event of that SQL application, such as the following (also similar stacktrace):


The solution is... the same with the solution in the post above :)
My version of SSMS (2016) is older than the SQL Server itself (2017).

Another good reference which I referred for getting the version information is this: https://buildnumbers.wordpress.com/sqlserver/

Comments

Post a Comment

Popular posts from this blog

Added Contact Is Not Shown in List Manager in a Scaled Sitecore XP 9

-
There was a time when I needed to help someone from finding what’s wrong with List Manager in a scaled SXP 9 (the exact version was Sitecore Experience Platform 9.0 rev. 180604 (9.0 Update-2) ). New contacts added into List Manager does not appear even though the blue color message box around the top area says: “ The contact has been added to the list, and will be available after indexing. ” Looking at the Sitecore logs, there are errors such as: 4244 17:14:27 ERROR [ListManagement]: Failed to get count of contacts for 86c048c4-761d-47c8-814f-30344a5dcac8 contact list. The error has been occurred: The HTTP response was not successful: InternalServerError Exception: Sitecore.XConnect.XdbSearchUnavailableException Message: The HTTP response was not successful: InternalServerError Source: Sitecore.Xdb.Common.Web    at Sitecore.Xdb.Common.Web.Synchronous.SynchronousExtensions.SuspendContextLock[TResult](Func`1 taskFactory)    at Sitecore.XConnect.Client.XConnectSync
Read more

Windows could not start the Sitecore Xconnect Search Indexer - {xConnectInstance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.

-
Image
I was doing upgrade from Sitecore 9 Initial Release to Sitecore 9 Update 1. I felt somehow confident that I have followed all the steps of upgrade guide correctly, but when I reached to the step in resuming service (page 47 in the document: “Start the Sitecore XConnect Search Indexer Windows service” ), I faced the following error: “Windows could not start the Sitecore Xconnect Search Indexer - {xConnect Instance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.” Based on MSDN , this error means: “ While handling a control request, the service attempted to access an illegal address. ” I then tried to run this application manually from the folder containing it ( C:\inetpub\wwwroot\<xConnectInstance>\App_data\jobs\continuous\IndexWorker ). It is clear that this error refers to the connection string which I obtained by copying and pasting directly (my mistake during installation
Read more

EXM Throws NonCriticalException "Failed to download string content" with Nested Exception of "403 Forbidden" in Azure Web App

-
Image
 Upon previewing email content in Azure Web App, one could get the following error: 9668 03:27:56 ERROR Exception: Sitecore.EmailCampaign.Model.Web.Exceptions.NonCriticalException Message: Failed to download string content, URL: https://testazure-cm.azurewebsites.net/?sc_itemid=%7B229384AB-6279-42BC-925F-1D28C0227C03%7D&sc_lang=en&sc_device=%7BFE5D7FDF-89C0-4D99-9AA3-B5FBD009C9F3%7D&ec_database=master&ec_id=96F0189C036942DDA62BCE8D68C6D1C7&ec_message_id=583137BAD51D4491AD8D07451BCC9000, Use IIS Credentials: True, UserAgent: ECM Dispatch Source: Sitecore.EmailCampaign    at Sitecore.Modules.EmailCampaign.Core.WebContent.DownloadString(String url, Boolean useIisCredentials, String userAgent)    at Sitecore.Modules.EmailCampaign.Messages.WebPageMail.GetMessageBody(Boolean preview)    at Sitecore.EmailCampaign.Cm.MessageInfo.FillContentEditorInfo() Nested Exception Exception: System.Net.WebException Message: The remote server returned an error: (403) Forbidden. Source:
Read more