SQL Server 2005 installed on CIRGIS2

In preparation for the installation of ArcSDE 9.2 Enterprise, I've installed and SP'd SQL Server 2005 Workgroup Edition (supported for Enterprise). I patched the machine with Windows Update (53!) after adding SQL Server SP1.

I grabbed IP 207.233.107.43 to talk to windows update, but there is a second, local gigabit connection to CIRGIS1 that I installed last night with a gigabit card and a crossover cable. That's intended to be the way that CIRGIS1 and CIRGIS2 talk in the future when CIRGIS1 makes a data request.

We might consider a dbo account instead of an SDE account for 9.2--see
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=An_overview_of_ArcSDE_geodatabase_administration

Next steps: add more user accounts, antivirus software, and wait for the SDE 9.2 box while we pile up data.

CIRGIS WMS service addresses

http://www.cirgis.org/wmsconnector/com.esri.wms.Esrimap?ServiceName=test

It is administered at: http://www.cirgis.org/wmsconnector/com.esri.wms.Esrimap?

CIRGIS2 is up!

Last night I successfully loaded Windows 2003 Server R2. Turns out there was a CD in the Dell box that contained the drivers for the RAID array, and walked me through the installation of the OS.

I put the OS in a 20 GB C: partition, and I intend to use the rest of the 476GB mirrored array as an E: partition for programs and swap space. I'll make the ~2TB RAID5 container drive F: for data (which will be mostly SQL server, if we use SDE), and the solo disk as drive T:, for temp data and the tempdb.