Richard's Infrastructure Blog

SQL Server 2005 Clean up maintenance plan not deleting files?

2007-07-12T14:10:00Z

If you set up a maintenance plan to cleanup and delete old files from a folder and it doens't delete the files (a common problem as it turns out), create a new maintenance plan and add an 'Execute T-SQL Statement' task.

The following will delete BAK and TRN files, enter it in the T-SQL statement window:

declare @dt datetime
select @dt=getdate()-[number of day's files to keep, i.e. 14 to delete files over 14 days old]
EXECUTE master.dbo.xp_delete_file 0,N'[file folder]',N'BAK',@dt
EXECUTE master.dbo.xp_delete_file 0,N'[file folder]',N'TRN',@dt

Set up a reccuring schedule to run once a day and save the new plan.

Old files will now be deleted and your hard drive won't fill up.

Office 2007 icons and correct functioning in SharePoint 2003

2007-05-23T16:08:00Z

Found this which worked like a charm:

http://uksbsguy.com/blogs/doverton/archive/2007/03/13/how-to-get-companyweb-windows-sharepoint-services-v2-to-work-with-office-2007.aspx

To get the icons working properly you need to unzip the file here: http://www.it99.org/axl/ct.ashx?id=edab2641-4283-492c-8156-e4ddadfc2ee3&url=http%3a%2f%2fwww.it99.org%2faxl%2fdownload%2fOffice%25202007%2520Icons%2520for%2520SharePoint.zip and copy just the contents of the gif-light folder to 'C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\IMAGES'

TFS stops working after SP1 install

2007-05-22T15:03:00Z

Found this which fixes the problems TFS Service Pack 1 creates

From: http://www.codefounders.com/community/blogs/davidg/default.aspx

Before you install TFS SP1 it informs you that you need to download and install another update first which puts the TFS server in a quiescent state so that there is no activity going on on the server whilst the update is performed, otherwise the TFS database may become corrupted. Once this in place then you can do the update, which works correctly. The problems seem to stem first update puts the server in a quiescent state by applying an IP address restriction to the entire web server used as the application tier front-end so that it can only accept requests from the localhost address (if you have other web sites hosted on this server, like our main company website for instance, this really isn't funny, though I appreciate that was probably the easiest way for the VS team to achieve the behaviour they require for update.) It also modifies some of the TFS databases and places them into single-user mode. My guess is that at the end of the SP1 update these changes are supposed to be undone leaving the TFS server in its original state.

On our server, the IP address restriction was not removed from IIS and four of the TFS databases (TfsActivityLogging, TfsBuild, TfsIntegration and TfsVersionControl) were left in single-user mode. Manually temoving the IP address restriction using inetmgr and resetting the four databases back to multi-user mode using SQL Server Management Studio fixed the problem and all is now working as it should. Having finally brought TFS back to life, I have to say that it was definitely worthwhile installing SP1 as there are some noticeable performance improvements, and I haven't even had a chance to really play with it yet.

Virtual Server - Tired of having to repeatedly type passwords?

2007-05-21T07:49:00Z

To stop having to keep re-authenticating while working in Virtual Server without using SSL, add the URL to your Intranet security zone in Internet Explorer.

In IIS Manager on the Virtual Server:
- Open the properties on the Default Web Site
- Click the Directroy Security tab
- Click Edit in the Authentication control box
- Check Basic authentication
- Uncheck Integrated Windown authentication

Now when you use Virtual Server you should only have to authenticate once.

Fixing broken virtual networking

2007-04-25T11:19:00Z

Found this page which is very uselful if you have virtual image networking problems on XP or Vista: http://blogs.msdn.com/virtual_pc_guy/archive/2007/01/15/fixing-broken-virtual-networking.aspx

IE crashes when opening Office 2003 files previously opened in Office 2007 from SharePoint 2003.

2007-02-26T15:42:00Z

If IE crashes when opening an Office 2003 file in Office 2003 that has been opened and saved (in Office 2003 format) in Office 2007, install the Office Compatability Pack (avalaible here: http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en)

IE crashes when opening Office documents from SharePoint 2003 using Office 2007

2007-02-12T14:54:00Z

Go to “C:\Program Files\Microsoft Office\Office12”

Delete “OWSSUPP.DLL”

“Start” -> “All Programs” -> “Microsoft Office” -> “Microsoft Office Tools” -> “Microsoft Office Diagnostics”

Run the diagnostics and it should fix 1 issue in its last step.

Vista: Installing Networked Printers - Print Monitor is Unknown Error

2007-02-07T12:18:00Z

Problem:
When installing a networked printer you receive a The Specified Print Monitor is Unknown error.

Solution:
1.) Enable UAC (Go into the control panel and type UAC in the search bar then follow through the 'wizard') -- restart your computer when prompted
2.) Install the printer
3.) Disable UAC

Source: http://vistafix.blogspot.com/2006/12/installing-networked-printers-specified.html

CRM 3.0: Accidentally deleting the CRM OU in Active directory

2006-11-13T16:21:00Z

If you accidentally delete the CRM organisation unit in AD and don't have a backup of your active directory (which is never a good idea), you may think looking at Microsoft's documentation that there's no way of ever seeing your data again. No so.

If you follow the Redeploying CRM 3.0 document (MicrosoftCRMv3Redeployment.pdf) in the RedeploymentTool folder on the CRM CD you can re-install CRM and create a new OU.

TFS from Excel: TF84037 there was a problem initializing the addin

2006-11-02T15:54:00Z

1. In Add/Remove programs, locate your Office application and select it.

2. Click on the 'Change' button

3. Select 'Add or Remove features' and click 'next'

4. Select 'Choose advanced customization of applications' and click 'next'

5. In the tree view, expand 'Microsoft Office Excel' and make sure the .NET Programmability Support option is set to 'run from my computer'.

6. Click 'update'

TFS: TF30177: Team Project Creation Failed error

2006-10-05T15:53:00Z

The "cannot find team project" error condition is sometimes a symptom of having a client-side metadata cache that is out of sync with the server.

We can try to determine if the cache is the problem by moving it out of the way.

Shut down all running instances of Visual Studio on the client
Open \Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Team Foundation\1.0
Rename the Cache subdirectory Cache.sav
Open Visual Studio and retry project creation

The TFS restore instructions include a section that describes how to invalidate the client side cache of all machines connected to a server. See the section entitled Refreshing the Data Cache on Client Computers in this topic: http://msdn2.microsoft.com/en-us/library/ms252458(VS.80).aspx. This handles the case when a server is restored to a point in time where the metadata on the server does not match that stored in the client caches. Another situation where this metadata cache mismatch might occur is when copying a Virtual Server image with TFS installed. The reason that it might happen in this case is that the client caches are keyed by a TFS server GUID. A client machine connecting to the "same" TFS instance in different Virtual Server images will ultimately end up with mismatched metadata as the servers drift apart.

From: Bill Essary MSFT

Microsoft Dynamics CRM 3.0 with Office 2007, Windows Vista and Exchange 2007

2006-10-04T20:13:00Z

Microsoft Dynamics CRM 3.0 with Office 2007, Windows Vista and Exchange 2007

Office 2007 and Windows Vista

With the pending releases of Office and Windows products, a new level of productivity tools and a new generation of operation system will be available to our customers. By releasing a compatibility update for Microsoft Dynamics CRM 3.0, we will enable our customers to take advantage of powerful new products.

Windows Vista availability will begin in November for businesses, January for consumers. We’ve pegged the Microsoft CRM 3.0 compatibility update to the worldwide release schedule of Office 2007 for a reason; we will want to do absolute final testing on the RTM versions of Office 2007, which is why we plan on delivering immediately after the Office 2007 RTM.

The compatibility release will be slipstreamed into our inventory of media kits, but it will also be made available for download.

Expect Office 2007 RTM + 1-2 weeks for downloads (same math applies to localized versions of the compatibility release) and approximately 45-60 days for media kits to be replaced with the compatibility release. Effectively that will mean that the compatibility release will be available several weeks before General Availability of Office 2007.

Microsoft Exchange 2007

Microsoft CRM 3.0 currently supports the ability to locate user mailboxes on Microsoft Exchange 2007 servers; the Microsoft CRM 3.0 Exchange E-mail Router and its dedicated mailbox continue to require Exchange 2000/2003 and can operate in a mixed environment.

However, the current Microsoft CRM Rule Deployment Wizard cannot be used against Exchange 2007 mailboxes, so alternative rule deployment methods should be used. An update to the Microsoft CRM Rule Deployment Wizard to enable use on Exchange 2007 servers is planned for release at approximately the same time as RTM of Exchange 2007 and we aim at making the update available for download immediately after.

From: http://blogs.msdn.com/crm/archive/2006/08/30/730678.aspx

Internet Explorer 7 - Release Candidate 1

2006-08-29T16:07:00Z

Internet Explorer 7 Release Candidate 1 (IE7 RC1) is now available, get it here: http://www.microsoft.com/windows/ie/downloads/default.mspx

Team Foundation Server - Event 3031 - TFS Services

2006-08-17T09:00:00Z

If you install TFS and don't specify an e-mail address, you'll receive the following error in your Applicatoin event log:

Event Type: Error
Event Source: TFS Services
Event Category: None
Event ID: 3031
Date:  17/08/2006
Time:  09:58:46
User:  N/A
Computer: TFS Server
Description:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 17/08/2006 08:58:46
Machine: TFS Server
Application Domain: /LM/W3SVC/3/Root/services-3-1280027870957xxxxxx
Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2172
Thread Id: 3204
Account name: domain\TFSService

Detailed Message: Unrecognized default notification 'From' address:

To fix this, add an e-mail address to <add key="emailNotificationFromAddress" value=TFSemailaddress@company.com /> in C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\Services\web.config

CRM 3.0 - Event 208 - Source: SQLSERVERAGENT in event log

2006-08-09T12:20:00Z

If you find the following in your SQL server event log:

SQL Server Scheduled Job 'Start_Incremental on Companyname_MSCRM.ftcat_documentindex.[7.5]' (0xB7324B3916DFFF449C956936187A787A) - Status: Failed - Invoked on: 2006-08-09 13:01:21 - Message: The job failed. The Job was invoked by User <user>. The last step to run was step 1 (Full-Text Indexing).

Make sure the Indexing service is running on the server.

Run execute sp_fulltext_database 'enable' in SQL Analyzer against the Companyname_MSCDM database.

Richard's Infrastructure Blog

SQL Server 2005 Clean up maintenance plan not deleting files?

Office 2007 icons and correct functioning in SharePoint 2003

TFS stops working after SP1 install

Virtual Server - Tired of having to repeatedly type passwords?

Fixing broken virtual networking

IE crashes when opening Office 2003 files previously opened in Office 2007 from SharePoint 2003.

IE crashes when opening Office documents from SharePoint 2003 using Office 2007

Vista: Installing Networked Printers - Print Monitor is Unknown Error

Problem:When installing a networked printer you receive a The Specified Print Monitor is Unknown error.

CRM 3.0: Accidentally deleting the CRM OU in Active directory

TFS from Excel: TF84037 there was a problem initializing the addin

TFS: TF30177: Team Project Creation Failed error

Microsoft Dynamics CRM 3.0 with Office 2007, Windows Vista and Exchange 2007

Microsoft Dynamics CRM 3.0 with Office 2007, Windows Vista and Exchange 2007

Internet Explorer 7 - Release Candidate 1

Team Foundation Server - Event 3031 - TFS Services

CRM 3.0 - Event 208 - Source: SQLSERVERAGENT in event log

Problem:
When installing a networked printer you receive a The Specified Print Monitor is Unknown error.