Chris May

Accessing WHS Connector Software via secret HTTPS location

Chris May — Tue, 10 Jan 2012 14:14:11 GMT

If you are ever in a situation when you want to install the Windows Home Server connector software, but don't have the CD, you can always get it through the browser.

Just browse to:

https://SERVERNAME:56000

It's important that you do the https.

This page will give you the ability to download the right version of the connector software, as well as some tools for diagnosing issues with WHS.

Windows 7 x64 SP1 ERROR_NOT_FOUND 0x80070490 Solution

Chris May — Sun, 18 Dec 2011 20:46:18 GMT

For the last couple weeks I've been unable to install SP1 for Windows 7 x64. From time to time windows update tries to install it, and it always fails with:

ERROR_NOT_FOUND 0x80070490

There are a ton of people online trying to figure out this problem, with a wide range of suggestions and solutions, and quite often people resorting to reinstalling windows.

One users post sent me down a path that allowed me to resolve the problem, but it wasn't completely clear from his post that what I was doing was working, so I wanted to elaborate on what I did and how I fixed the issue.

First, I did the following without any change:

Run chkdsk
Run sfs /scannow
Run the System Update Readiness Tool

The post by Ben-IS was the one that got me going in the right direction:

http://social.technet.microsoft.com/Forums/en-US/w7itproinstall/thread/bfb3e5b5-a3bd-4124-b4d6-7fb437ac7b74

The log flies that I frequently checked (and cleared out) were:

C:\Windows\Logs\CBS\CBS.log (filled with stuff when you run the service pack install)

C:\Windows\Logs\CBS\CheckSUR.log (filled when you run the System Update Readiness Tool)

C:\Windows\inf\setupapi.app.log (this one was most important)

When I checked setupapi.app.log I and searched for "failed to" it would find a line like this:

!!! sto: Failed to find driver update 'C:\WINDOWS\WinSxS\amd64_usbport.inf_31bf3856ad364e35_6.1.7600.16788_none_19ba59901d3be89e\usbport.inf' in Driver Store. Error = 0x00000490
<<< Section end 2011/12/17 20:38:02.355
<<< [Exit status: FAILURE(0x00000490)]

So, given that line, I was then able to register the driver using the command:

pnputil -a C:\WINDOWS\WinSxS\amd64_usbport.inf_31bf3856ad364e35_6.1.7600.16788_none_19ba59901d3be89e\usbport.inf

So after doing that, I go back and run the SP install again, and guess what, it fails in exactly the same place with the same error. Crap.

I had copied the setupapi.app.log out of it's folder so that a brand new one was created, so I went back and looked for the same "failed to" phrase and quickly found:

!!! sto: Failed to find driver update 'C:\WINDOWS\WinSxS\amd64_usb.inf_31bf3856ad364e35_6.1.7600.20934_none_27ac0e3841194697\usb.inf' in Driver Store. Error = 0x00000490
<<< Section end 2011/12/17 21:42:08.609
<<< [Exit status: FAILURE(0x00000490)]

But, if you look very closely, you'll see that this is NOT the same error. It's a different error. The first path ended in "89e\usbport.inf" and the 2nd ended in "697\usb.inf".

After an even closer examination of the entire block that contained this error showed that it had gotten 1 line further than last time. And based on this header information:

>>> [Uninstall Driver Updates]
>>> Section start 2011/12/17 22:19:38.189
      cmd: C:\WINDOWS\servicing\TrustedInstaller.exe
     sto: Driver Update Context:
     sto:      Image State        = Specialized
     sto:      Image Architecture = amd64
     sto:      Transaction        = CbsDriversAndPrimitives
     sto:      Driver Updates     = 66

I knew that there were only supposed to be 66 drivers being worked on, and I had made it past 64 of them by this point. I went back to earlier log files and found that I had only gotten past 63 before. So I repeated the process a couple more times, each time getting 1 driver further until finally it installed completely.

I spent EASILY 20 hours on this over the past couple weeks. It was a giant pain in the butt, but I'm really glad to have resolved it because reinstalling everything on my dev laptop would have taken days.

10 months with no posts

Chris May — Sun, 18 Dec 2011 20:43:21 GMT

10 months ago I moved my blog from my old server to the new one that I've been using. This meant going from Windows 2003 and IIS6 to Windows 2008 R2 and IIS7.5. I soon found there were a lot of minor problems hosting a dasBlog on an x64/iis7.5 server.

I got to the point where the site would run, but I still couldn't get it to save any new posts. I put it on my todo list to figure it out and the proceed to have 10 months of work and family stuff get in the way of ever getting back to it.

I'll be posting once again from time to time now that I've resolved the issues.

IIS6 HTTP Compression

Chris May — Tue, 22 Feb 2011 15:45:46 GMT

Here are some great articles talking about properly enabling compression in IIS6.

I had made some of these changes in the past, but I noticed that they had since been overwritten or not persisted. I believe with the changes to the metabase file it will help keep the compression working.

http://blog.grushin.com/2008/04/21/iis6-compression-including-js-css-etc/

http://blog.grushin.com/2008/04/21/iis6-compression-file-extensions-and-testing/

Bear Necessities Pediatric Cancer Foundation

Chris May — Tue, 15 Feb 2011 20:21:05 GMT

Last year, I donated a weekend of my time to work with some other developers to create a new site for Bear Necessities Pediatric Cancer Foundation.

When we wrapped up work, the site was nearly completed, with a few ends to tie up, and of course, all the content needed to be entered and hosting setup and DNS ..... you get the idea.

So FF a many months and I was starting to think that the site would never go live. Well it finally did.

http://bearnecessities.org/

It isn't the most beautiful site (we didn't have any graphic artists on the team) but it's waaaaay better than what they had.

XXXX is ambiguous in the namespace 'ASP'

Chris May — Thu, 10 Feb 2011 19:15:02 GMT

I've been getting this error every now and then.

Usually this problem is caused by having 2 controls with the same name. It can be that they are in different folders as well.

I came across this post today:

http://personalinertia.blogspot.com/2007/06/there-bug-in-compiler.html

Well, a quick search online told me that this might be a result of a known bug in the compiler. The fix was easy, you have to compile your app in non-batch -mode. How do you do this, I hear you asking. Simple: enter the compilation section of your web.config, and set batch="false", as so:

<compilation debug="true" batch="false">
...
</compilation>

Tracking Schema Change Details in SQL Server

Chris May — Thu, 27 Jan 2011 17:15:21 GMT

In SQL Server 2005 and newer you can create database catalog wide triggers that you can use to track all schema changes to any objects in that database.

I wanted to track all schema changes to all catalogs on my server, so what I did was to create a database catalog called SchemaChangeLog that contained a table and a SP as follows:

USE [SchemaChanges]
GO

/****** Object:  Table [dbo].[SchemaChangeLog]    Script Date: 01/27/2011 11:17:26 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SchemaChangeLog](
    [SchemaChangeLogId] [int] IDENTITY(1,1) NOT NULL,
    [EventType] [varchar](100) NULL,
    [PostTime] [datetime] NULL,
    [LoginName] [varchar](100) NULL,
    [Username] [varchar](100) NULL,
    [DatabaseName] [varchar](100) NULL,
    [SchemaName] [varchar](100) NULL,
    [ObjectName] [nchar](100) NULL,
    [ObjectType] [varchar](100) NULL,
    [SqlText] [varchar](max) NULL,
    [ServerName] [varchar](100) NULL,
 CONSTRAINT [PK_SchemaChangeLog] PRIMARY KEY CLUSTERED 
(
    [SchemaChangeLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 
IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS  = ON, 
ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SchemaChanges]
GO

/****** Object:  StoredProcedure [dbo].[SchemaChangeLog_Save]    Script Date: 01/27/2011 11:17:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:        Chris May
-- Create date: 1/27/11
-- Description:    saves schema change info
-- =============================================
CREATE PROCEDURE [dbo].[SchemaChangeLog_Save]
      @data XML
AS
BEGIN
    BEGIN TRY
          
        insert  INTO schemachanges.[DBO].SchemaChangeLog
                (
                  [EventType],
                  PostTime,
                  ServerName,
                  LoginName,
                  Username,
                  DatabaseName,
                  SchemaName,
                  ObjectName,
                  ObjectType,
                  SqlText
                        
                )
        VALUES  (
                  @data.value('(/EVENT_INSTANCE/EventType)[1]', 'sysname'),
                  GETDATE(),
                  @data.value('(/EVENT_INSTANCE/ServerName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/LoginName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/UserName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/ObjectType)[1]', 'sysname'),
                  @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'VARCHAR(max)')
                ) ; 

    END TRY
    BEGIN CATCH
        -- we just don't want any errors here
                
    END CATCH ;
END

GO

Then on each database catalog you want to track schema changes on, just run this to create the trigger:

create TRIGGER Trigger_Track_Schema_Changes ON DATABASE
    FOR DDL_DATABASE_LEVEL_EVENTS
AS
    SET NOCOUNT ON
    DECLARE @data XML ;
    BEGIN TRY
   
        SET @data = EVENTDATA() ;
        EXEC SchemaChanges.dbo.SchemaChangeLog_Save @data

    END TRY
    BEGIN CATCH
            -- we just don't want any errors here
    END CATCH ;

go

If you want to undo this you can always drop the trigger by using:

drop TRIGGER Trigger_Track_Schema_Changes ON DATABASE

EDIT: I've found that some things (like some actions in SQL Compare) cause this trigger to throw an error. I'm not sure why. But, if you want to just disable the trigger for a moment you can run this:

disable trigger Trigger_Track_Schema_Changes on database

Mounting a VHD file in Windows Server 2008

Chris May — Sun, 09 Jan 2011 16:54:00 GMT

Say you have a VHD from some VM but you really don't want (or can't) spin up the VM to access the drive. Well you can just mount it up in windows 2008 using Disk Management inside Computer Management.

Very handy.

Converting video clips between types

Chris May — Mon, 03 Jan 2011 17:46:48 GMT

I had a small WMV file that I wanted to convert into a stand alone flash video (not a FLV, a SWF) to stick on a website.

There are lots of seemingly poor options out there for doing this, but this one was perfect: http://www.youconvertit.com.

I uploaded the WMV and they had a number of output options, one of which was SWF. They emailed me a few seconds later letting me know my conversion job was completed, and I downloaded the SWF, which worked just as expected.

Ignore White Space in Visual Studio built in compare tool

Chris May — Mon, 03 Jan 2011 01:24:23 GMT

If you don't really care about spaces vs tabs when comparing files in visual studio using the built in compare tool you can use the info found here to get VS to ignore white space.

Tools -> Options -> Source Control -> Visual Studio Team Foundation Server -> Configure Users Tools.. -> Add ->

Add "%5 /ignorespace" at the end of the "arguments" textbox.

That's it.