mylifeinaminute.com

Tag: wss 3.0

When you drop the default database of the farm Service Account…

by liquidpooled on Nov.14, 2008, under Microsoft, Office, SQL Server 2005, Sharepoint Server, Windows SharePoint Services

When cleaning up a number of older databases in a QA/Staging environment (databases dating back to 2003), we managed to delete the default database for the SharePoint database system account. After deleting the database, the user will longer be able to perform actions on the SQL instance (login, view databases, etc.) when logging on through Management Studio.  To fix this error, log on to your SQL server as another administrative user (like the “sa” account), and execute the following:


sp_defaultdb 'SQLSERVER\dbuser', <DEFAULT DB>

Replacing with the new default database name.

Leave a Comment :, , , , more...

Cleaning up the SharePoint Configuration Cache

by liquidpooled on Aug.22, 2008, under Microsoft, Office, Sharepoint Server, Windows SharePoint Services

There are times when strange errors can occur in your SharePoint environment, especially after making configuration changes such as adding a new Web Application role to an existing farm server or even updating an Alternate Access Mapping (AAM).  Clearing the configuration cache can also help with problems relating to the ULS logs growing at an exponential rate, especially when the “Config Refresh” timer job cannot complete successfully.

Clearing the SharePoint configuration cache can sometimes help alleviate these issues.  To clear the configuration cache, you can follow the procedures outlined in KB939308.

Leave a Comment :, more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit our friends!

A few highly recommended friends...