Wednesday

Moving Sharepoint config database location

http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

The SharePoint Sherpa blog has the outline of how to run this task;

**** BACKUP FIRST AND PRACTICE THIS IN A TEST ENVIRONMENT ****

stsadm -o deleteconfigdb
stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_account -farmpassword your_farm_password

But….. this didn’t work for me. I then fixed the firewall on SQL Server 2008 R2 and it worked. Yay

Tuesday

Litespeed has an error: Could not find xpsls.dll. This is the dll for extended stored procedures. Just uninstall and reinstall to fix it. The device seems to have been removed when I upgraded to R2.

Dashboards

New dashboard is required for a project and an existing one has broken. Both are critical, both are important, both need to be working. There is one of me.

Friday

Monty has three bells now.

Internet access has returned after I checked the proxy settings in internet explorer to discover my computer was set to be it’s own proxy on port 81. Strange.

Dynamic Hyperlinks in Reporting Services

=”javascript:void(‘window.open(https://intranet/sites/Apps/IR/Lists/Injury/DispForm.aspx?ID=” + CSTR(Fields!ID.Value) & “‘));”

This will open the list based on the value in the ID field. ID has to be converted to a string otherwise it’ll give a compile warning but will still load.