Welcome to Sign in | Join | Help
in
Home Blogs Files

Richard's Infrastructure Blog

  • SQL Server 2005 Clean up maintenance plan not deleting files?

    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

    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

    Found this which fixes the problems TFS Service Pack 1 creates Hmm

    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?

    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

    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.

    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

    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

    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

    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

    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

     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.

    1. Shut down all running instances of Visual Studio on the client
    2. Open \Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Team Foundation\1.0
    3. Rename the Cache subdirectory Cache.sav
    4. 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

    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

    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

    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

    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.

More Posts Next page »

This Blog

Post Calendar

<March 2010>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234

Syndication

Powered by Community Server, by Telligent Systems