Log Name: Application
Source: Windows SharePoint Services 3
Date: 6/26/2009 10:23:11 AM
Event ID: 3351
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: sharepointed
Description:
SQL database login failed. Additional error information from SQL Server is included below.
Windows SharePoint Services VSS Writer
I updated the Log On from Local System account to one of the Farm admin accounts.
→ No CommentsTags: SharePoint
(The specified address was excluded from the index. The crawl rules may have to be modified to include this address. (The item was deleted because it was either not found or the crawler was denied access to it.)
We were using the Robots.txt file to block search engines from indexing our public site. When I first tried to index the site from the SSP it would only crawl a small part of the site. After messing with permissions and other items I was informed that we had added a Robots.txt file to the site. Once we removed the file from the C:\inetpub\wwwroot\wss\VirtualDirectories\YourSiteName folder and rebooted the server, I was able to index the entire site from the SSP. The following day is when the trouble began. I tried doing a Full Crawl and the crawl status would change from Crawling to Idle within a few seconds and would display the error above.
Here is how I fixed the problem. In the content database create this Stored Procedure (you can delete it later).
What does it do? The stored procedure will allow you to search all the tables in a database.
Create PROC [dbo].[SearchAllTables]
(
@SearchStr nvarchar(100)
)
AS
BEGIN
CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))
SET NOCOUNT ON
DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ”
SET @SearchStr2 = QUOTENAME(’%’ + @SearchStr + ‘%’,””)
WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ”
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’
AND QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + ‘.’ + QUOTENAME(TABLE_NAME)
), ‘IsMSShipped’
) = 0
)
WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN (’char’, ‘varchar’, ‘nchar’, ‘nvarchar’)
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)
IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
‘SELECT ”’ + @TableName + ‘.’ + @ColumnName + ”’, LEFT(’ + @ColumnName + ‘, 3630)
FROM ‘ + @TableName + ‘ (NOLOCK) ‘ +
‘ WHERE ‘ + @ColumnName + ‘ LIKE ‘ + @SearchStr2
)
END
END
END
SELECT ColumnName, ColumnValue FROM #Results
END
Once you have created the stored proc execute this command:
Exec SearchAllTables ‘Robots.txt’
You will see a single record returned.
Then run this command:
Delete from AllDocs
Where LeafName = ‘Robots.txt’
After this I rebooted the server and went to lunch. Why lunch? Well, for some reason SharePoint takes a little time to propagate the change (timer job I’m sure).
If you are having an issue where only part of your site is being indexed try adding crawl rules.
example:
include
then select the default account or use one that has read access to the site.
→ No CommentsTags: SharePoint
For one reason or another, Central Administration wouldn’t come up and the only thing i could see was HTTP Error 503. The service is unavailable..
easy fix.
Check the Application Pools for SharePoint Central Administration v3 and make sure it’s running.
done!
→ No CommentsTags: SharePoint
After upgrading to Windows 7, I’m unable to view List’s in Datasheet View.
Error:
The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.
Solution
I was running IE 8 (64 bit), when I tried editing the list in Datasheet view with the 32 bit version, everything was back to normal.
It appears a 64 bit version of Office will be out for the 2010 release.
http://arstechnica.com/microsoft/news/2009/04/confirmed-office-2010-will-come-in-32-bit-and-64-bit.ars
→ No CommentsTags: SharePoint
This is the connection string I use for all my BDC files. Once the file is imported into the BDC, I then assign permission accordingly.
<LobSystemInstances>
<LobSystemInstance Name=”BDC_Unique_Name_RI”>
<Properties>
<Property Name=”DatabaseAccessProvider” Type=”System.String”>SqlServer</Property>
<Property Name=”AuthenticationMode” Type=”System.String”>RevertToSelf</Property>
<Property Name=”RdbConnection Data Source” Type=”System.String”>Database_Server_Name</Property>
<Property Name=”RdbConnection Initial Catalog” Type=”System.String”>Database_Name</Property>
<Property Name=”RdbConnection Integrated Security” Type=”System.String”>SSPI</Property>
<Property Name=”RdbConnection Pooling” Type=”System.String”>false</Property>
<Property Name=”RdbConnection Trusted_Connection” Type=”System.String”>false</Property>
<Property Name=”RdbConnection User ID” Type=”System.String”>User_Name</Property>
<Property Name=”RdbConnection Password” Type=”System.String”>User_Password</Property>
</Properties>
</LobSystemInstance>
</LobSystemInstances>
In SQL Server I assing User_Name Select permissions on the items referenced in the BDC file.
NOTE
Make sure your default search account has access to the BDC file once it’s imported. I applied Execute and Selectable in clients permissions on both the Application and Entity.
“How do I find the default accout?”
Shared Services Administration: SSP1 > Search Administration > Default content access account
→ No CommentsTags: SharePoint
If your site is missing the Search Web Parts, make sure you have the Feature enabled on your site.
→ No CommentsTags: SharePoint
Changes to the content source cannot be made while it is not idle. Wait for the current action to complete and retry your changes.
If you receive this error make sure you are not crawling anything. Simple, yes, but I spent a few minutes trying to figure out what was going on.
→ No CommentsTags: SharePoint
I was seeing this error when trying to create new email address for a Document Library.
When setting up email in SharePoint, make sure your Application Pool account, Timer account, and the account you are using for mail access are all the same.
After updating this, the Server was unable to process request. —> Access is denied. error went away.
In Windows Server 20008 the Application Pools are located here:
Server Manager –> Roles –> Web Server (IIS) –> Internet Information Services
Under the Connections section click on Application Pools
On the right side of the screen you will see Actions. From there click on Advanced Settings…
The value in the Identity field is the same account we use for the Timer Service and the account that has access to Active Directory.
How to check or update the Windows SharePoint Services Timer:
Open Server Manager, in Windows Server 2008 this can be found in the Start Menu (start button) or type Server Manager in the search box in the Start Menu. Once you have this open click on Configuration –> Services then locate Windows SharePoint Services Timer.
From there right click on Windows SharePoint Services Timer and select Properties. Now, click on the Log On tab. The account listed should also be the same as the account you were using in the Application Pool.
Let me know if you have any questions.
→ 1 CommentTags: SharePoint
I used the following site to configure a dedicated front end server for crawling:
http://technet.microsoft.com/en-us/library/cc261810.aspx
In doing this, the only issue I ran into was this error:
The search service is currently offline. Visit the Services on Server page
in SharePoint Central Administration to verify whether the service is
enabled. This might also be because an indexer move is in progress.
My issue was related to the existing server having a file index location of C:\Index.
Central Administration > Application Management > Manage this Farm’s Shared Services > New Shared Services Provider
Once I created a folder in the same location, on the new server, the error went away.
Only thing I can imagine is SharePoint wanted to move the index from the old server to the new server. SharePoint being SharePoint, it wanted the index folder in the same exact location.
Update:
If you are moving to Windows Server 2008 make sure you read this KB article.
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 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.)”
http://support.microsoft.com/kb/896861
→ No CommentsTags: SharePoint
I will continue to update this list…
1. Check your new Farm for blocked file types.
Central Administration > Operations > Blocked File Types
2. InfoPath forms. Make sure you check that your forms are working in the new Farm. In my case, the forms had the old URL and wouldn’t work. I had to also update / relink the forms to their corresponding library.
3. PDF icon
http://support.microsoft.com/kb/837849
4. When we created the new Farm we also used all new AD accounts. When I tried to crawl our network I was only able to crawl public folders. Fix? Replace the old crawl account on the domain with the new account or update your new Farm with the old crawl account.
Shared Services Administration: SSP1 > Search Administration > Default content access account
5. BDC. This has turned out to be a big one. I wasn’t able to simply export the BDC definition files from the old Farm and import them into the new Farm. I had to recreate all the BDC files, security, and update all the pages that were using the BDC data. If you are not using BDC Metaman, you need to start!
6. If you are moving to Windows Server 2008 make sure you read this KB article.
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 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.)”
http://support.microsoft.com/kb/896861
7. Search Scopes, none, zero, nothing was moved over when we migrated. i’m now in the process of trying to recreate all the search scopes.
8. reapply the Adobe PDF filter to the Farm. This post goes into great detail on how to apply the update.
http://bloggingabout.net/blogs/harold/archive/2008/10/02/index-pdf-documents-on-sharepoint-using-adobe-pdf-ifilter-9.aspx
→ No CommentsTags: InfoPath · SharePoint