Unified Diff

I recently setup a SQL server, running Microsoft SQL Server 2005 Developer Edition. Installation was smooth, with a prettier interface than SQL 2000. The disk space requirement was a bit high, but not unreasonable.

The suite now includes a special management studio that uses the VS IDE. In the past, developers needed to use an MMC snap-in to manage databases. It was usable, but generic. Features weren’t obvious and the interface was clumsy. The new feature-rich interface is much more friendly and intuitive.

But the IDE does, however, carry the same massive footprint as Visual Studio. I would have preferred it if they had kept the MMC snap-in for server use. Needing to install the IDE on the server seems silly, considering the amount of use it would get. Overall, though, I’m impressed with the software.

Like many other developers, I wanted a chance to play with Windows Vista Beta 2. So I downloaded the whopping 3.2 GB DVD image (in twelve minutes). Since I don’t have a spare machine powerful enough to handle it, I decided to install Vista in a VMware virtual machine. This was, to say the least, not a clean and pleasant experience.

I opened my existing “Beta 1″ virtual machine with 256 MB of RAM and 8 GB of hard disk space, set the ISO as the boot media, and started it. Setup started, but then presented me with this:

The file WinSetup.dll could not be loaded or is corrupt. Setup cannot continue.

Microsoft recently renamed WinFX to .NET Framework 3.0 in an attempt to clarify the platform’s purpose. A new website was created to provide helpful information as well as the beta download.

I maintain several client and server machines that, up until recently, all authenticated users locally. I wanted a more centralized mechanism that could handle the various users and systems on the network. The big catch is that a few key system run Linux while others run Windows. So after doing some research, I turned to Active Directory.

My first chore was to install Windows Server 2003 and configure it to be a domain controller. This part was fairly easy, although a little time-consuming. Once that was working I was able to quickly join the Windows machines to the domain. Now to deal with Linux… for that I chose Windows Services for Unix. This software alters the AD schema to allow for Unix account attributes. On the Linux machines, I installed OpenLDAP, a Kerberos client, configured PAM… and voila! Now AD users can authenticate on the Linux machines.

My home-made DHCP/DNS configuration tool, however, was a little trickier. The data for this tool is stored in a MySQL database and accessed via a PHP script. If I wanted to grant someone access to the tool, I needed to first give them a MySQL account. Since Active Directory is basically an LDAP server, I rewrote the authentication mechanism to query AD.

With very little work, I was able to simplify authentication and account management. While this is not new technology, I still feel all warm and fuzzy with a sense of accomplishment.