Posts Tagged ‘SharePoint’

Inside SharePoint Search Database, Troubleshooting SharePoint Search


— get overview ——————–
  msscrawlurllog.lasttouchstart as Time
, msscrawlurllog.displayurl as URL
, DocName = REPLACE ( RIGHT(msscrawlurllog.displayurl, CHARINDEX(‚/‘, REVERSE(msscrawlurllog.displayurl))-1 ) , ‚%20‘, ‚ ‚)
, msscrawlurllog.errorid as Error
, msscrawlerrorlist.errormsg as Description
FROM  dbo.msscrawlurllog with (nolock)
inner join dbo.msscrawlerrorlist with (nolock) on msscrawlurllog.errorid = msscrawlerrorlist.errorid
order by msscrawlurllog.lasttouchstart

— show latest crawler stats———————
FROM [dbo].[MSSCrawlHostList] with (nolock)


In my case i found following error through above TSQL:

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled. (The item was deleted because it was either not found or the crawler was denied access to it.)


Solution was to set following registry-key in windows 2008 :

Disable the loopback check

Follow these steps:


Click Start, click Run, type regedit, and then click OK.


In Registry Editor, locate and then click the following registry key:



Right-click Lsa, point to New, and then click DWORD Value.


Type DisableLoopbackCheck, and then press ENTER.


Right-click DisableLoopbackCheck, and then click Modify.


In the Value data box, type 1, and then click OK.


Quit Registry Editor, and then restart your computer.

After setting the registry key start Crawler with stsadm.exe manually:


Kategorien:Allgemein Schlagwörter: , ,

HowTo export all AD service principal names (SPNs) to textfile

If you need to troubleshoot kerberos problems with SharePoint, Reporting Services… you need an overview of all defined HTTP SPNs in Active Directory.

You can use the the following command in a dos-box to quickly output all SPNs to a textfile with the windows tool “LDIFDE.EXE”:

ldifde.exe -f check_spn.txt -t 3268 –d “” -l serviceprincipalname -r “(servicePrincipalName=HTTP*)” -p subtree

Here’s a sample output:


If ldifde.exe  i not installed on your server:


Windows 2008 
–> Add Remote AD Management Tools (RSAT-ADDS) Feature with Servermanager or:

  1. Click Start, Run, and in the Open field run ‚ServerManagerCmd -i RSAT-ADDS

Windows 2003 –> Install Support Tools from windows server CD or download:

Kategorien:Allgemein Schlagwörter: , ,

Best-Practice: SQL Alias für SharePoint Zugriff konfigurieren

11. Januar 2011 3 Kommentare

Bei DB-Applikationen ist es eine gute Praxis den Namen des SQLServer grundsätzlich nicht direkt im Connectionstring/Config zu hinterlegen sondern über einen „SQL Alias“ zu arbeiten!Muss der SQLServer irgendwann umgezogen werden oder im Disaster/Ausfallszenario auf einen anderen SQL Server umgeleitet werden kann man, für die Anwendung transparent, dann einfach den SQL Alias anpassen. Ein SQL Alias ist übrigens NICHT zu Verwechseln mit einem  DNS-Alias(Host/CNAME Eintrag)!

Microsoft empfiehlt in folgendem Artikel auch explizit das Anlegen von SQL Aliasen vor dem eigentlichen SharePoint Setup:

Storage and SQL Server capacity planning and configuration (SharePoint Server 2010)

Ein SQL Alias kann entweder über das, auf jedem Windows Client/Server vorhandene, Tool CLICONFG.EXE eingerichtet werden oder über „SQL Server Configuration Manager“ (wenn SQL Client explizit installiert wurde).

In beiden Fällen sollte man folgendes zu beachten: Auf 64Bit Systemen muss der Alias für 64BIT UND 32BIT separat konfiguriert werden sonst funktionieren nicht alle Anwendungen (in Abhängigkeit davon ob die Anwendung 32bit oder 64bit SQL-Provider verwendet)!

Auf Systemen ohne SQL Installation findet man die Tools hier:

32Bit -> C:\WINDOWS\System32\cliconfg.exe
64Bit -> C:\WINDOWS\SysWOW64\cliconfg.exe

Auf Systemen mit SQL Installation geht es etwas komfortabler über den “SQL Server Configuration Manager“ (Start>Programme>SQL Server>Config Tools..):


Weitere Infos:

Kategorien:Allgemein Schlagwörter: ,

SharePoint Email Integration Tools

SharePoint Outlook Connector

SharePoint Outlook Connector makes it easier for outlook users to upload emails to SP and attach SP documents to an email message . You’ll no longer have to save your email to desktop and upload from SP UI or download SP documents to your drive and attach them to your email.

  • Saving email meta data to SharePoint document item (title, to, from etc) functionality has been added
  • SharePoint 2010 support has been added
  • Saving email message as list item and attachments as attachment of the list item functionality has been added


CodePlex:SharePoint Task List Email Reminders (WSS 3.0, MOSS2007, SharePoint 2010)

Similar to OOTB Alerts; but emails are triggered by task due date.
Allows task list owners to automatically send email reminders when tasks are due.
One email is sent per list, per assignee each day, if tasks meet this criteria:
1) task status is open
2) it is assigned and assignee has an email address
Emails are sent out daily and only when assignee has tasks in the list that are:
1) due today
2) due in two days
3) two days past due

SharePoint AD User Editor Webpart

31. Oktober 2010 1 Kommentar
AD User Editor

AD User Editor is a Webpart for MOSS 2007 that allows to easily modify any profile property of any person in Active Directory. Il can also be configured as "self-service" for a user to be able to modify his properties only.

  • 6 different types of properties fields: ReadOnly, Simple TextBox, DropDownList/ListBox (with predefined values), People Picker, Date Picker with calendar.
  • Multi-domain compatible.
  • Nearly Any Active Directory property can be easily added or removed of the edit form, directly trough the webpart configuration (nothing "hard-coded").
  • SharePoint "look & feel"
  • Available in English, Spanish and French

Inside Managed Metadata Service (MMS) DB and User Profile Service (UPS) SocialDB

Zur Einführung hier ein paar Links zum Thema:
SharePoint Logging Database Exposed
SharePoint Tagging Exposed

Über TSQL Abfrage auf die MMS DB anzeigen wer wann welche Tags erstellt hat:


FROM [ECMChangeLog] ecl, ECMTerm t, ECMTermLabel etl
ChangeType = 1
ecl.ObjectUniqueId = t.UniqueId
ecl.ObjectId = etl.TermId 


to be continued…

Kategorien:Allgemein Schlagwörter: , , , ,

Inside SharePoint Secure Store Service (SSS) Database, Auditing, SSS Activity

25. Oktober 2010 4 Kommentare

TSQL Experten lieben SharePoint 2010. Dort gibt es viel mehr Datenbanken als in 2007 mit jeder menge nützlichen auch in der SSS Datenbank

Was ist SSS:
The Secure Store Service replaces the Microsoft Office SharePoint Server 2007 Single Sign On feature. Secure Store Service is a shared service that provides storage and mapping of credentials such as account names and passwords. It enables you to securely store data that provides credentials required for connecting to external systems and associating those credentials to a specific identity or group of identities. The SSS Database provides storage and mapping of credentials such as account names and passwords.

DB Schema of Secure Store Service DB

Additional Information for the DB can be found here: [MS-SSDPS]: Secure Store Database Protocol Specification

The DB can log informations for troubleshooting and compliance purposes. THIS IS NOT SUPPORTED AND ONLY FOR DEV-ENVIRONMENTS.

HowTo enable DB-Auditing:
1. Connect with SQL Server Management Studio (SSMS) to Secure_Store_Service….DB
2. Run following command:  UPDATE dbo.SSSConfig SET EnableAudit = 1
3. Open DOS-Box and run: IISRESET /NOFORCE
4. Audit Data should now be logged to table dbo.SSSAudit
5. You can run following query or create as VIEW for easier analysis of this table:

   –   ,[ActionType]
      ,[ActionTypeText] = CASE [ActionType] 
                           WHEN 101 THEN ‚A target application has been created.‘
                           WHEN 103 THEN ‚A target application has been updated.‘
                           WHEN 105 THEN ‚A target application has been deleted.‘
                           WHEN 107 THEN ‚The user claim (2) for an individual target application has been retrieved.‘
                           WHEN 109 THEN ‚The group claims (2) for a group target application has been retrieved.‘
                           WHEN 111 THEN ‚The claims (2) for the group of SSS users that are administrators for a target application have been retrieved.‘
                           WHEN 113 THEN ‚The claims (2) for ticket redeemers for a target application have been retrieved‘
                           WHEN 115 THEN ‚The definition for a target application has been retrieved.‘
                           WHEN 117 THEN ‚The fields for a target application have been retrieved.‘
                           WHEN 119 THEN ‚The definitions for all target applications have been retrieved.‘
                           WHEN 121 THEN ‚The credentials for an SSS user have been set.‘
                           WHEN 123 THEN ‚The credentials for a group target application have been set.‘
                           WHEN 125 THEN ‚The credentials for an SSS user for a target application have been deleted.‘
                           WHEN 127 THEN ‚The credentials for an SSS user for all target applications have been deleted.‘
                           WHEN 128 THEN ‚An SSS ticket was issued.‘
                           WHEN 130 THEN ‚An SSS ticket was redeemed.‘
                           WHEN 132 THEN ‚The credentials for an SSS user have been retrieved.‘
                           WHEN 134 THEN ‚The restricted credentials for an SSS user have been retrieved.‘
                           WHEN 136 THEN ‚A SSS user has set his/her own credentials in the SSS store.‘
                           ELSE CAST([ActionType]   as nvarchar(100))
  FROM [dbo].[SSSAudit]
  order by AuditDateTime DESC

Kategorien:Allgemein Schlagwörter: , , ,