Paul Devenney

Using Trusted Connections in Web Applications under SharePoint Server

Microsoft really try to hammer home the concept of using trusted connections in web.config files, such as <connectionStrings> <add name="MyDbConn1" connectionString="Server=MyServer;Database=MyDb;Trusted_Connection=Yes;"/> <add name= Read More

SSRS 2008 SharePoint Integrated Mode Issues -

I've finally found time to look at SSRS 2008 and how it improves the integration mode for SharePoint. As usual, I had a new pain setting it up. My setup: MOSS 2007 and SSRS 2008 installed on vmsp-01SQL Server 2008 installed on vmsql-01 There are several reas Read More

Deploying multiple SSIS Packages from Development to Live Environments

This is as much a reminder for myself as a reference for others ;) There are several ways of deploying SSIS dtsx packages under SQL 2005, but I like this one the best. It allows almost "one touch" style deployment of an entire project of packages. It makes use Read More

Full crawl only finding root page of new site collection

Had an interesting experience when testing a new server farm environment. We created a new web application/site collection for an intranet site. It uses 2 network load balanced WFEs, two query servers and a seperate index server, which uses itself as the WFE f Read More

BDC - I just wanna connect!

Using the Business Data Catalogue (BDC to the cool) is still quite painful, and all the articles I've seen cut straight to clever "best practice" methods such as Single Sign On and Passthrough authentication. Sometimes though you just want to connect to the BD Read More