Problem: Every night, around 4 AM, the SharePoint temp DB and logs would grow very very large. Size increased by about 60 GB every night, then shrank again. I couldn't figure out why the excessive growth was happening to one of the content datases and the temp database. All research pointed to the search crawler writing to the temp files. These are the steps I took: I disabled all crawls I disabled all usage analysis jobs I disabled any job running at night. This had no effect. The databases were...
Symptom: When trying to publish a page in SharePoint 2010 publishing template, you get this error: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator. Problem: The State Service is not configured. When you decide to configure everything yourself when installing 2010, the state service can only be installed/configured using PowerShell or the configuration wizard. Solution: Configure...
Problem: FAST Search is asking for the port number of SQL for the install. If it isn't the default, what is it and how do I know? Solution: Execute the following query in SQL: DECLARE @test VARCHAR(15) , @value_name VARCHAR(15) , @RegistryPath VARCHAR(200) IF ( CHARINDEX('\', @@SERVERNAME) <> 0 ) -- Named Instance BEGIN SET @RegistryPath = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + RIGHT(@@SERVERNAME, LEN(@@SERVERNAME) - CHARINDEX('\', @@SERVERNAME)) + '\MSSQLServer\SuperSocketNe...