home links tools blog about
home

« July 2005 | Main | September 2005 »

August 10, 2005

IIS 6, VS 2005, and VPC - oh my!

So, I've got VS 2005 running on one of my VPCs which is running Win2k3 Server.

VS 2005 has been running fine for a while, but I'm working on a project that's basically what I'm lovingly calling TECH-SOUP (embedding WMP in a winform control using interop, and them making that WINFORM control consumable as an ActiveX object in a web page -- where I'll tell the player what to play through AJAX).

Only after installing IIS 6 I keep getting these bloody: Service Unavailable errors. They're driving me nuts.

Then I check the event logs. Sure enough: evil has come, once again, for another visit:

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID
{A9E69610-B80D-11D0-B9B9-00A0C922E750}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20).  This security permission can be modified using the Component Services administrative tool.

So (GASP), I decide (after reading the log event) that I'll need to visit DCOM, find the CLSID in question and muck with it. Too lazy to try and find the class by it's ApplicationID, I just copied and pasted that nasty SID into Regedit and let it look it up for me: IIS Admin Service (two-timing traitor!!).

Once I found the culprit I just found it in  Component Services: Start | Admin Tools | Component Serivices | Computers (you'll have to toggle between icon and the +) | My Computer (same shuffling maneuver) | DCOM Config. Once in there just find IIS Admin Service | Right Click | Properties and select the Security tab.

Then from the Launch and Activate Perms, set to Customize and click Edit. Then add Network Service and give them the appropriate rights (local launch and local activation).

Stop and Restart your App Pool (may not be necessary, but I did it for good measure). Voila... IIS is back up and running.

(Now back to my tech-soup endeavors...)

 

Posted on August 10, 2005 | | Comments (14) | TrackBack (0)

Confession: I've never seen Ferris Bueller's Day off

Sure, I've seen some parts of it. I know the concept... more or less. But I've never seen the whole movie, nor have I ever seen more than like 10 minutes of it in a row.

Just thought you should know... Even though people tend to freak out when they hear that about me.

(Yes, I was born in America. No, I'm not a sleeper/mole for some covert terrorist group - I imagine most of them would have seen the movie anyhow.)

(Oh, and the fact that I'm blogging means I'm not Amish - so that's not it either.)

Posted on August 10, 2005 | | Comments (0) | TrackBack (0)

WorkHappy.net

So, my buddy Carson has been hard at work with a new pet project of late. I've been pretending to be skeptical, but I've actually been quite impressed with it.

It's called WorkHappy.net, and like many good things in the universe it's SIMPLE. It's a resource for entrepreneurs (and wannabees) dedicated to cataloging killer services and products. The goal is to help you be better at what you do by providing you tools that help you focus on what it is that you do... (So it's basically about world domination, which makes it score points with Mikeey.)

The best part He allows people to submit entries to the site. That means that Carson isn't responsible alone for the content -- it's more of a community resource. Entrepreneurs from all over the globe review tools, services, and goodies that they've used and like (or dislike). Believe it or not, he's got a readership in the strong HUNDREDS already, which means that more and more people keep submitting cool tools, resources, and services. I've submitted a few myself, but found tons of cool things that I didn't even know existed before.

Go check it out. Then once you've lurked and scraped together your own list of cool tools, post about some of the stuff you use and can't live without.

Posted on August 10, 2005 | | Comments (0) | TrackBack (0)

August 05, 2005

*Scratches Head*

So yesterday there was a minor emergency in my life. My Laptop died - or rather the OS on my laptop died.

Prior to my mishap with rd, I was playing around in SQL Server Query Analyzer, and ran a funny little query like so:

EXEC xp_cmdshell 'del \\agamemnon\d$\FakeBackupDirectory *.* /F /Q '
GO

That just uses xp_cmdshell (an extended proc that lets sql server have access to the command prompt) to zip out to a share on my local box and delete the files in the share. Nothing big.

Only when I did that, I got a NASTY warning from the OS, telling me that trusted operating system files had been replaced by an unknown source. Would I please put in the WinXP CD so that Windows could fix0r the problem I scratched my head, checked for viruses, satan, etc. and slapped in the CD. Obviously SQL Server decided to overwrite some of my key .dlls when it did this delete operation 'remotely' (i.e. against a share).

That scared the crap out of me, so I started playing around on Virtual Machines for 'spooky' command line operations. (And then blew up one of my Virtual Machines.) At any rate, things were stinky enough with my Host OS that I decided to reboot. Only hal.dll had been corrupted, and the box wouldn't restore.

Luckily I use Acronis True Image, had a decent backup/image of my OS, and all of my data had been backed up just an hour or so before my box refused to boot. I restored from my Acronis image (note to self, don't use an image vectored from an image where both images have heavy compression - recovery took 2 hours (then I had to install everything that I've installed since the image was made 2+ months ago)).

So, today, everything is back up and running. Only I'm playing around with Performance Counters on my host, and the Processor Counter Group simply doesn't exist. *scratches head*

Posted on August 05, 2005 | | Comments (0) | TrackBack (0)

FireFox - Even more anti-pop-up-ier than ever!

http://www.petebevin.com/archives/2005/03/10/firefox_popups.html

Block popups from plugins (like Flash). I'm surprised that's not a default...

Posted on August 05, 2005 | | Comments (1) | TrackBack (0)

August 03, 2005

Using FeedBurner with .Text .95

I'm building a demo involving 2 SQL Servers and a shared backup directory.

In the process of building the following batch file (which removes a directory/share (if it already exists), then creates a directory/structure and shares it), I was running the commands by hand in the command prompt:

@Echo off
REM Delete share/directory if already in existance
net share Backup /DELETE
rd /S /Q C:\Backup
REM Create directory/share
md C:\Backup
md C:\Backup\Logs
net share Backup=C:\Backup
EcHO ---- Press any key to continue ----
pause >nul

Only, when I went to type rd /S /Q C:\Backup, I accidentally typed rd /S /Q C: and instead of hitting \ I hit ENTER. The good news: That's a bloody fast way delete every file on a drive (that isn't locked/in-use by a process). The bad news, that's a Bloody fast way to delete every file on your drive (that isn't currently in use).

Needless to say, I'm waaay glad that I was doing this on a VM (in VMWare 5).

Of course, you could think of this as the poor-man's dejunker: Just open the programs you want to keep (and any files you want to keep on your C: drive) and then delete everything ;)

Posted on August 03, 2005 | | Comments (9) | TrackBack (0)

Thank goodness for Virtualization

I'm building a demo involving 2 SQL Servers and a shared backup directory.

In the process of building the following batch file (which removes a directory/share (if it already exists), then creates a directory/structure and shares it), I was running the commands by hand in the command prompt:

@Echo off
REM Delete share/directory if already in existance
net share Backup /DELETE
rd /S /Q C:\Backup
REM Create directory/share
md C:\Backup
md C:\Backup\Logs
net share Backup=C:\Backup
EcHO ---- Press any key to continue ----
pause >nul

Only, when I went to type rd /S /Q C:\Backup, I accidentally typed rd /S /Q C: and instead of hitting \ I hit ENTER. The good news: That's a bloody fast way delete every file on a drive (that isn't locked/in-use by a process). The bad news, that's a Bloody fast way to delete every file on your drive (that isn't currently in use).

Needless to say, I'm waaay glad that I was doing this on a VM (in VMWare 5).

Of course, you could think of this as the poor-man's dejunker: Just open the programs you want to keep (and any files you want to keep on your C: drive) and then delete everything ;)

Posted on August 03, 2005 | | Comments (3) | TrackBack (0)

August 01, 2005

Building Clustered SQL Servers on VMWare 5.0

Clustering is just plain fun. Being able walk around with a clustered system on my laptop (and trusty, portable, external USB HD sidekick) is a total hoot.

To get an entire cluster working on VMWare 5.0 can be a bit of a bear though, because there's really a paucity of documentation out there that explains how to do it. The biggest challenge, of course, being how to simulate shared drive resources usable by the cluster (i.e. how do you simulate something like fiber attached to HBAs, or a SAN, etc?).

Happily VMWare does support simulating shared IO/drive resources though you'll need access to some powerful vodoo.

Build instructions, including the Vodoo, are listed below:

1) Build a Base Machine. Build a base Machine which you can use as an image for your domain controller, and two (or more) Custered SQL Servers. (Yeah, I went with the option of making the DC a non-clustered resource. If you want to, you could just dcpromo both of your nodes and try it that way....). To do this:

     
  • Just create a brand new VMWare server - specifying Windows Server   2003 Enterprise Edition (or better) as the guest OS.  
  • Give it about 4 GB of non-fixed disk space.  
  • Some Ram,  
  • SCSI drives  
  • and a bunch of clicks on the Next button.  
  • Then ensure that the Windows 2003 Enterprise Server Installation Media is   either captured as an .ISO for your VM, or slap the disk into your CD/DVD-ROM   drive.  
  • Start the VPC, and install Windows 2003 Enterprise..  
  • During installation, give the box a bland name, something like WIN2K3BASE,   or whatever. (This box won't really be a part of your cluster - you're just   paving it to use as the 'base' for your other boxes.)  
  • Once the Install is complete. Patch the box.  
  • Then drop the new SysPrep Tool on it from Microsoft: http://support.microsoft.com/?kbid=838080  
  • Extract the files, and then just run sysprep.exe.  
  • It will warn you that it can mess up boxes - click yes, you're TRYING to   mess up your box ;)  
  • Select Reseal, and click OK. In case you   don't know what you're doing, and somehow just managed to put SysPrep on your   workstation because you thought the NAME was cool, Windows warns you that you   are about to.... PREP your machine. Click Yes (you're mature   enough).  
  • The VM powers down.  
  • Once it powers down, from the VMWare menu, select the VM's   Settings. Click into the Options Tab,   and select Advanced. Then put a check mark in the   Enable Template Mode. OK your way out of   there.  
  • From the VM menu, take a new snapshot. Give it a happy, cuddly name, like   "momma," cuz this is what you'll run home to if everything ends up barfing on   you later on.  
  • Now, from the VM menu, select Clone. Make sure that you   create a full clone, and not just a linked or forked version of the server   (you want a FULL copy/clone).  
  • Repeat the cloning process until you have 3 'boxes': A Domain Controller,   SQLServerNode1 and SQLServerNode2. (I prefer Simpson's characters for server   names, and Marge's sisters work out perfectly; Patty and Selma are names   that are uniquely suited to clustering <g>).

2) Build a Domain Controller.

     
  • Fire up the box that will be your DC, run through the happy, abbreviated   setup wizard and give your box a network name you can live with -- Quimby is   pretty authoritative for a DC.  
  • Once it reboots, give it a static IP address. I prefer to just bind my   boxes to the VMnet2 network. And then do something imaginative like set the DC   to 192.168.235.1, with 255.255.255.0 as the subnet. Add a gateway if you've   got one... etc. (though, if you're like me, you don't care much about your   clustered SQL Server 'domain' being able to chat with external boxes).  
  • Then, either run DC Promo on it, or use the Add Server Role do-hicky from   manage your server.  
  • Just 'Next' your way through the wizard, stopping only to   tell it to take care of the DNS (unless you're a glutton for punishment).

3) Cluster and SQL Server Service Accounts. Create a user account to use for the cluster and for SQL Server

     
  • While you are still on the DC, go to Start | Administrative Tools   | Active Directory Computers and Users and create a new user in your   domain for the cluster account.  
  • You can also create another user for the SQL Server account (which is a   good idea in the real world).  
  • You'll want to make sure that both of these users don't allow the user to   set the password, that the password never expires, and OF COURSE, uncheck that   dumb: User must change password at next logon.

4) Build Out your SQL Server Nodes

     
  • For each of your SQL Server Nodes, you'll want to add a new NIC from the   VM Hardware manager (just select Settings on the VM, and the   use the Add button to launch the Add Hardware wizard).  
  • Bind the newly added NICs to a custom VMWare Network (I keep all of my   VNICs bound to the VMnet2 network).  
  • Boot server1. Once it's booted, navigate to the network connections   section of the control panel in Windows Explorer. Right click and rename your   Area Connections to External and Heartbeat.  
  • Change the IP addy for External to something fixed on your network (like   192.168.235.11 or .12 for server2) with the appropriate subnet mask   (255.255.255.0). Then specify the fixed IP of your   Domain Controller as the Preferred DNS IP   Address (i.e. 192.168.235.1).  
  • Now change the IP Address for your HeartBeat NIC.   Set it to something like 10.1.1.1 (or 10.1.1.2 for   Server2). Leave the Gateway empty. Leave DNS blank. Click the   Advanced button, and from the WINS tab,   click Disable netbios over tcpip.  
  • Do the same for Server2 (using different IP addresses, of course).  
  • Add both servers to your domain (Right Click My Computer |   Properties, and then from the   Network Identification tab click   Change. Specify the credentials you provided when you created   your Domain Controller in the previous steps as the credentials you need to   add the box to the domain.)  
  • Joining to the Domain switched your External NICS to DHCP. Jump back in   there, and slap them back to the way you had them before. If you get grumped   at by Windows (telling you that there may be a collision, just ignore it (I   think you have to click No to make the nag screen go away)).  
  • Check out your IP Addresses by running ipconfig /all from the command line   -- just to make sure. Also make sure that you can see that the heartbeat nic   has netbios turned off.  
  • Power off both boxes once they've had their nics configured and have been   added to the domain.  
  • Now would be a really good time to snapshot both boxes incase you do   something dumb down the road.

5) Configure Shared Disk Resources. Now comes the juicy part. The way to spoof your virtual machines into believing that they have access to shared disk resources. In my quest for clustering I found two resources on this, one was hideously outdated - but contained enough theory to help me out, The other was for version 4.5x and was missing one critical piece of data that is apparently now needed in VMWare Workstation 5.0. The key concepts here are that you just need to create SCSI controllers on both machines, and then provide directives that tell VMWare NOT to lock the disks when they are connected. This lets machines share disks, as long as all of the SCSI connection info is configured correctly. From there you just need to, obviously, make sure that the disks aren't busy trying to dynamically allocate size; i.e. the disks have to be fixed or each VM will see a different size, state, etc. 

The first thing you need to do is create some drives that you'll hook up to your machines. The best way to do this is to just create them with the wizard by 'adding' them to one of your machines, and then immediately removing them. Think of it as a virtual-hard-drive-egg-laying-chicken (or just think of it as a way to make virtual hard drives, if that's easier). To Proceed:

     
  • Open up one of your SQL Servers and Select VM | Settings   from the menu. To add the drives just click Add and use the   Wizard.  
  • The first drive will be your Quorum drive, and just needs   to be a few hundred MB (200 MB will work fine - or .2GB).  
  • The wizard steps are as follows: Create a new virtual disk. Next.   SCSI. Next. Disk Size = .x GB Then ensure that   Allocate all disk space now is checked. Click   Next. Browse out and drop the disks in a directory called   SharedDisks (or something). And click the Advanced button.   Make sure that Independent is checked. Then click   Finish.  
  • Make sure you create two disks (your Quorum drive, and then a Resource   drive (or more)).  
  • Then select each drive, and Remove it in the Hardware   management thingy. We just needed to MAKE Hard Drives, we don't want to add   them just now. (You'll add them by hand to the machines in a second.)

6) Attaching Shared Disks. Add your virtual shared drives to the boxes by hand. Now that the drives are sized and created, it's time to head to the virtual server rack and hook up some virtual SCSI controllers.

     
  • Navigate to the directories where your Virtual Machines are kept, and for   Server 1 open the .vmx file in NotePad.  
  • First add some instructions for disk control, and to make sure that the VM   won't attempt to lock the drives it connects to: 
    # Shared Disk Config Info:
    diskLib.dataCacheMaxSize = " 0"
    diskLib.dataCacheMaxReadAheadSize = " 0"
    diskLib.dataCacheMinReadAheadSize = "0" 
    diskLib.dataCachePageSize = "4096"
    diskLib.maxUnsyncedWrites = "0" 
    disk.locking = "FALSE"
     
  • Then add a new SCSI controller: 
    scsi1.present = "TRUE"
    scsi1.virtualDev = "lsilogic"
    scsi1.sharedBus = "virtual"
     
  • Once that's done, add your Quorum Drive (making sure to   specify that the drive itself uses the lsilogic bus (this was the big missing   component between Karl's   post for 4.5x and 5.0. I found this out by trial and error): 
    scsi1:1.present = "TRUE"
    scsi1:1.fileName = "\Quorum.vmdk"
    scsi1:1.redo = ""
    scsi1:1.mode = "independent-persistent"
    scsi1:1.deviceType = "disk"
    scsi1:1.virtualDev = "lsilogic"
     
  • Once the first controller and drive is added, just add the second SCSI   controller and disk (making sure to change your paths, etc.: 
    scsi1:2.present = "TRUE"
    scsi1:2.fileName = "\Resource.vmdk"
    scsi1:2.virtualDev = "lsilogic"
    scsi1:2.redo = ""
    scsi1:2.mode = "independent-persistent"
    scsi1:2.deviceType = "disk"
     
  • The entire 'snippet' to copy/paste is here: 
    # Shared Disk Config Info:
    diskLib.dataCacheMaxSize = "0"
    diskLib.dataCacheMaxReadAheadSize = "0"
    diskLib.dataCacheMinReadAheadSize = "0"
    diskLib.dataCachePageSize = "4096"
    diskLib.maxUnsyncedWrites = "0"
    disk.locking = "FALSE"

    scsi1.present = "TRUE"
    scsi1.virtualDev = "lsilogic"
    scsi1.sharedBus = "virtual"
    scsi1:1.present = "TRUE"
    scsi1:1.fileName = "\Quorum.vmdk"
    


    scsi1:1.redo = ""
    scsi1:1.mode = "independent-persistent"
    scsi1:1.deviceType = "disk"
    scsi1:1.virtualDev = "lsilogic"
    scsi1:2.present = "TRUE"
    scsi1:2.fileName = "\Resource.vmdk"
    scsi1:2.virtualDev = "lsilogic"
    scsi1:2.redo = ""
    scsi1:2.mode = "independent-persistent"
    scsi1:2.deviceType = "disk"
     
  • Make sure, of course, that you specify the full path to your shared Drives   directory (i.e. M:\VirtualMachines\Shared Drives\).

And now you've got shared drive resources! If you're a geek like me, you're pumped.

7) Ensure Drive connectivity from both Servers.

     
  • Power down BOTH of your server nodes.  
  • Boot up Server 1.  
  • Right click My Computer | Manage. Go to the Disk   Management node.  
  • You should see your two new drives available. (And the Welcome and convert   wizard will probably start up.)  
  • Make sure both disks are Basic Volumes (Dynamic disks ==   bad). Quick Format them and bind them to Drive Letters (I like   Q and R (quorum and resource) myself).  
  • Test that you can access the drives from within Windows. (Try creating a   .txt file and fill it with gibberish - then move it to the   other drive, etc.)  
  • Once everything is peachy, shut the box down.  
  • Then boot Server 2. From the Disk Managemt node in the   Management Console, you should see both disks. Just 'change'   their drive letters (you'll have to add them AFTER clicking change...).   Give them the same drive letters that you gave them for Server 1.  
  • Test read/write functionality.  
  • Shut down the Server.

8) Time to start Clustering. It's also probably a good time to take a snapshot about now (with both boxes shut down).

     
  • Fire up Server 1. Once it finishes booting, go to Start |   Administrative Tools | Cluster Administrator.  
  • Select create a new cluster from the dropdown.  
  • Walk through the wizard which scans your configuration, makes sure that   shareable resources exist, etc.  
  • Specify a name for the virtual/clustered server, as well as an IP.   192.168.235.3 works well, and Server3 works well as a name if   you are going the bland route. (Note that the cluster itself ends up being   represented as a virtual machine on the network, with an IP Address, a name,   and 'resources' at its disposal. If you put SQL Server (or Exchange for that   matter) then that 'server' will have its own name and IP address (and   resources) in addition to the name and IP of the cluster. (In this manner, a   clustered SQL Server with 2 nodes consumes 6 IP Addresses, and 4 Network   names: 2 HeartBeat addresses (on a private networks). 2 IP addresses for use   by the servers (upon which the cluster is built) along with 2 network names,   and 1 name and IP for the cluster, as well as 1 name and IP for the Clustered   SQL Server (or virtual server as it is called).  
  • When it comes time specify an account for the cluster service to run   under, use the account you created up in step 3.  
  • At the final, summary, page of the wizard, there's a   Quorum button. It should be its own screen, but it's just a   button squirreled away on the very last page. Pay attention for   it. Click it, and make  sure that it is trying to use your   Quorum drive for the Quorum drive (it's   NOT smart enough to figure it out on its own).  
  • Once the wizard is complete, the cluster service installs.  
  • Once that's complete, bring Server 2 online. You can then either open the   Cluster Administrator on Server 2 and Add   Server 2 to an existing node, or return to Server 1 (now also called Server 3   - or the Active node in the cluster) and Add a new server to the Node (Server   2). The wizard is pretty similar, only there aren't as many steps.

Once the second wizard is done, you've successfully created a cluster. Woot! If you're a true geek, you'll fail it over a few times just to see it in action (go to the Groups node in Cluster Admin and right click the Cluster Group, then select Move Group (i.e. move the resource group to another cluster)). Note too, that as you do this, the Group 0 resource (your remaining shared HD) stays with the original node (though you can move it too).

9) SQL Pre Configuration

     
  • You'll want to install MSDTC on both servers in the   cluster. Move the Cluster Resources to Server1. (Fail the   resources back to Server1 if you need to.)  
  • Start | Control Panel | Add/Remove Programs | Add/Remove Windows   Components.  
  • Select Application Server, and then click   Details. Then select Enable network DTC   access and click OK (boy is this tons easier than   configuring it for Windows 2000) a few times to load in   MSDTC.  
  • Once Server1 is configured, fail over to Server 2, and do the same.

10) Install SQL Server

     
  • You'll want NEED to copy the contents of   your SQL Server 2000 Enterprise Installation CD onto the local harddrive for   Server 1. (Otherwise you'll most likely encounter a read error during the   middle of installation. Recovery at this point is just UGLY.)  
  • Make sure cluster resources are on Server1. (Otherwise your   installation won't get far...)  
  • Change the name of the Group 0 resource to SQL   Server Resource.  
  • Run the autorun.exe from your VM's hard drive. (i.e.   start the 'CD' up from your Hard Drive).  
  • From the splash screen select SQL Server 2000 Components,   and the pick Install Database Server.  
  • Walk your way through the wizard. You'll be creating a Virtual SQL   Server. And you'll need to provide a network name for it. SQLServer   is a good name if you're going the bland route, otherwise it has to either be   Marge, or Barney <g>. You'll also need to specify an IP Address as well.   When you do so, make sure you are binding the IP address to the   External NIC, not to the heartbeat NIC.  
  • Finish up the installation as needed (putting your database files on the R   Drive).

When Installation completes, you'll have a watered down, not-terribly-secured BUT clustered SQL Server instance in a completely virtual environment. (You may then want to set dependencies and other things on cluster resources in the SQL Server Resource Group... check out the Patterns and Practices Library for details (though remember this info is old and for Windows 2000 - though it's not that different).

 

Posted on August 01, 2005 | | Comments (12) | TrackBack (0)

« Previous