Cleaning up the Event Log
On a system running the CRM 2011 IFD as described here: http://www.interactivewebs.com/blog/index.php/server-tips/microsoft-crm-2011-how-to-configure-ifd-hosted-setup/
You may notice in the Event Log some errors that look like:
The description for Event ID 17137 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
AdfsArtifactStore
The specified resource type cannot be found in the image file
The Solution
1) Open SQL server management studio.
2) Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
3) Right-click on the database AdfsArtifactStore and select “Properties”
4) Click on the Options page
5) Set “Auto close” to False
Pingback: Microsoft CRM 2011 How to Configure IFD Hosted Setup | InteractiveWebs Blog
Pingback: Troubleshooting ADFS 2.0 » Rob Sanders: Sanders Technology
We have ADFS installed but SQL server management studio is not. How do we resolve these errors without installing SQL server management studio??
Frankly, you are best installing the management studio (big name for a small program) on the server. It allows you to jump in and be sure that SQL is running as it should.
Big thumbs up on that solution, worked a treat.
Unfortunately in my case it didn’t work when i right click – > Properties
==================================
Cannot show requested dialog.
===================================
Cannot show requested dialog. (SqlMgmt)
——————————
Program Location:
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()
===================================
Property Owner is not available for Database ‘[SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)