SP2010: An error has occurred while accessing the SQL Server database or the SharePoint Server Search service

By peter.stilgoe









In Sharepoint 2010 when clicking ‘Configure Synchronization Connections ‘ you get the error:

“An error has occurred while accessing the SQL Server database or the SharePoint Server Search service”

and in your Sharepoint logs you see the following:

ManageDSServer.IssueQuery: System.IO.FileLoadException: The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0×80131040)

at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.InitializeIlmClient(String ILMMachineName, Int32 FIMWebClientTimeOut)

at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager..ctor(UserProfileApplicationProxy userProfileApplicationProxy, Guid partitionID)

at Microsoft.SharePoint.Portal.WebControls.ManageDSServer.IssueQuery(String strQuery, Int32 startRowIndex, Int32 endRowIndex).

I had this problem just after provisioning a new ‘User Profile Service Application’ on my app server, the cure was to simply perform an IISRESET on that server.

Share

Leggi tutto

List all SPNs in your Domain using Powershell

By peter.stilgoe









The below script lists all SPNs in your domain using Powershell (The service type is specified on the 1st line, in this case it is returning all HTTP SPNs):

$serviceType="HTTP"
$spns = @{}
$filter = "(servicePrincipalName=$serviceType/*)"
$domain = New-Object System.DirectoryServices.DirectoryEntry
$searcher = New-Object System.DirectoryServices.DirectorySearcher
$searcher.SearchRoot = $domain
$searcher.PageSize = 1000
$searcher.Filter = $filter
$results = $searcher.FindAll()
foreach ($result in $results){
 $account = $result.GetDirectoryEntry()
 foreach ($spn in $account.servicePrincipalName.Value){
  if($spn.contains("$serviceType/")){
   $spns[$("$spn`t$($account.samAccountName)")]=1;
  }
 }
}
$spns.keys

This & other useful powershell scripts can be found here Useful Powershell Scripts




Share

categoriaKerberos, Powershell commentoNo Comments dataFebruary 13th, 2012
Leggi tutto

SQL Server: How to get instance level configuration details

By peter.stilgoe









A useful script to return you instance level SQL configuration settings:

SELECT  *
FROM    sys.configurations
ORDER BY name ;
GO

More information about the script and other useful scripts How to document & configure sql server instance settings

Share

categoriaSQL Server, SQL Server 2008 commentoNo Comments dataFebruary 13th, 2012
Leggi tutto