Subscribe: bugmandan's WebLog
Added By: Feedage Forager Feedage Grade B rated
Language: English
access  account  application  bdc  content access  content  error  file  full crawl  pdf  permissions  server  setup  shared services  sql 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: bugmandan's WebLog

bugmandan's WebLog


Determine DFS Status

Thu, 29 Dec 2011 15:59:00 GMT

Was looking for a way to see if DFS Replication was working.  Found this command:

dfsrdiag backlog /rgname:"Group Name" /rfname:"folder name"
/sendingmember:servername /receivingmember:servername

Shows the Backlog File Count.

Searching BDC Data

Fri, 18 Apr 2008 14:52:00 GMT

I went to setup searching a Business Data Catalog application this morning.  I setup the content source under the Shared Services Adminstration console and selected Start Full Crawl.  I noticed that the crawl logs were showing an error:

The parameter is incorrect. (Access denied by BDC.)

I did some searching and found some other people had the same error, I read through the forums and none of the solutions matched my exact scenario, but they did point me in the right direction.  My Default Content Access account was setup as a domain user (domain\user Id), and that account did not have any permissions to the BDC.  Back in the SSP console I selected Business Data Catalog permissions and added the Default Content Access account with Execute permissions.  I went back into Search Settings, kicked off a full crawl and still got the same error.  It turns out that the BDC has a very powerful granular permissions model, and permissions can be set on the BDC, the applications, and each entity separately.  They also have a nice feature for "pushing" the permissions down to the child objects up on the toolbar called "Copy all permissions to descendants", so I clicked that link this time around.  Be careful with this option though as it will repace all the permissions, it does warn you of this before making the change.  Alternatively I could have gone to the Application & Entities and given the account the necessary permissions.

I started a full crawl of the BDC content source, and got a new error this time:

The parameter is incorrect. (Cannot connect to the LOB System.)

Back to the search engines, but this time didn't have much luck.  So I checked the ULS logs...I only do this when I'm desparate as they are so "Un-User" friendly.  However, way down toward the bottom on like line 7000 something I see the following:

Cannot connect to the LOB System. (A connection was successfully established with the server, but then an error occurred during the login process

So realizing that I'm trying to connect to the SQL database using the Default Content Access account I thought to check the database permissions.  Turns out that I had a login for the account, but that account did not have any rights to the database that the BDC application is using.  So I added the account to the db_datareader role using SQL Server Management Studio.  I started another Full Crawl of the BDC application content source, this time I knew it was working as the crawl logs were showing a success, no more error messages...and the number of items in the index was increasing.

I hope this helps someone else when they try to setup searching a BDC application with the default content access account setup as a reguler domain user account and not an administrator account.

How to speed up Sharepoint Alert notifications

Tue, 25 Mar 2008 00:24:00 GMT

stsadm -o getproperty -propertyname job-immediate-alerts -url http://demo

stsadm -o setproperty -propertyname job-immediate-alerts -url http://demo -propertyvalue "every 1 minutes between 0 and 59"


SharePoint 2007: Acrobat PDF IFilter 6.0

Fri, 09 Mar 2007 15:30:00 GMT

Here are the instructions for installing the PDF IFilter 6.0 on a SharePoint 2007 server to allow PDF files to be indexed (full text) by the Search and for the icon to be shown next to PDF documents.

Download Adobe PDF IFilter 6.0

  1. Stop the IIS Admin service: Start -> Run -> services.msc -> IIS Admin Service -> Stop
  2. Run the Adobe PDF IFilter 6.0 Setup program to install the filter on the server.
  3. Copy the ICPDF.GIF file to "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images"
  4. Edit the file C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML\DOCICON.XML
    1. Add an entry for the .pdf extension.
  5. Perform an iisreset or recycle the SharePoint Application Pools
  6. Add the .pdf file type to the index list:
    1. Go to Central Administration, then to the Shared Services Administration Web of the current SSP, go to Search Settings and next to File Type
    2. Add a new file type pdf
  7. Perform a Full Update on the Search content indexes

Logon Failures in the Application Event Log

Wed, 07 Mar 2007 20:29:00 GMT

Remember this if you ever have to delete a MOSS Shared Services Provider database.

 Originally posted at:

Cleanup task if you delete a Shared Services DB

I just noticed on our SQL back end server an error occurring every minute for the SQL service account trying to access a no longer existing SSP DB. The error was a "Logon Error: 18456, Severity: 14, State: 16". Although the error is not actually affecting anything it does fill up the logs (both SQL and Application) so you may miss something important as a result.

These are caused by a SQL job scheduled every minute to delete expired sessions. It appears this gets created but never gets deleted (or even disabled) if you remove that database. Just delete or disable it from the Management Studio at \SQL Server Agent\Jobs.