>Sharepoint 2003 – Event log shows "error canot connect to config db"

>Portal shield uses the command line to set the Config_Db account its not done via its GUI, so if you change the password on this account you will need to go here and reset it for portal sheild access.

C:\Program Files\Network Associates\McAfee PortalShield\bin>SetSQLAct.exe

Changes the user credentials used by McAfee PortalShield to connectto a remote Microsoft SharePoint 2003 database.

USAGE:

SetSQLAct.exe /USER= /PASSWORD= /DOMAIN=
.. name of the account used to connect
.. password of the account used to connect
.. name of the domain this accounts belongs to

C:\Program Files\Network Associates\McAfee PortalShield\bin>SetSQLAct.exe /USER=FarmAdminAccount /PASSWORD=password /DOMAIN=somedomain

The user credentials used to connect to the remote SharePoint 2003 database have successfully been changed to: somedomain\FarmAdminAccount

>Disaster recovery for sharepoint 2007

>I have recently been reading with interest some information on DR in sharepoint 2007, you can read a good post here.

I have to say, Joel Oleson is always worth reading.

My answer to this was to slightly modify my sharepoint 2003 DR scripts to work on 2007, not a huge task, not necesarily best practice but it works for me.

Send me a mail here if you would like a copy.

>Disaster recovery for sharepoint 2003

>As the whole world has not yet upgraded to sharepoint 2007, this may still be relevant to you.

I used to have a .vbs script to iterate my site collections in sp 2003 and issue a stsadm backup on each one, this used to backup the site collection and all subsites.

I regularly tested a restore scenario using stsadm restore and was satisfied that the site collection and all its subsites were correctly restored. This process has been in place since sp 2003 rtm’d. I have a pre sp2 environment where this is still the case.

Recently (I think post SP 2003 sp2) I had occasion to restore a site collection to retreive some files from a sub site, well, stsadm backup is still backing up the site collection and all subsites the backup file size is consistent with that, however, stsadm no longer restores the subsites, it only restores the top level site.

MS released an article relating to this phenomenon here, notice the para

‘The original, published version of the Microsoft SharePoint Products and Technologies Resource Kit contains contradictory information about when you can use the Stsadm.exe tool to back up and to restore Windows SharePoint Services Web sites and personal sites.

I know other people have written workrounds for this however, they did not exactly suit my requirements, so I’ve written my own, feel free to take advantage.

You can get it by dropping me an email here.

>RSS feeds in wss 3

>So rss feeds in wss 3 are good, however I want to be able to target a particular view on the list in question, how is it done?

I will find out and get back here as soon as I have …

Well, well, low and behold dougv sorted it already, dont you just love google.

which says, more or less, use the following url format

http://server/sites/site/_layouts/listfeed.aspx?List=LIST_GUID&View=VIEW_GUID

but note the GUIDs are sprinkled with Html encoded bits.