http://sharepoint2010.microsoft.com/try-it/Pages/Trial.aspx

not exactly sure what day they will release the bata version.

The jump from 2003 to 2007 wasn’t that bad. But I have a feeling that people are going to have fun with the new interface in SharePoint 2010, not to mention the changes to SharePoint 4.0 Central Administration. This should be fun!

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.

(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:

http://www.sharepointed.com/*

include

then select the default account or use one that has read access to the site.

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.

*Note*
If you have recently updated the password for the service account that the app pool runs under, you might see this. simply update the login and password the app pool is using.

done!

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

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

If your site is missing the Search Web Parts, make sure you have the Feature enabled on your site.

Site Collection Administration–>Site Features

Office SharePoint Server Search Web Parts

Office SharePoint Server Standard Site Collection features

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.

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.