Tuesday, April 18, 2006 - Posts

Installing SQL Server 2005 on Windows Server 2000 SP4

There's one interesting thing I found when attempting to upgrade SQL Server 2000 running on Windows Server 2000.

My company has a volume license agreement with Microsoft, so we get installation media with that nasty product key already embedded in the installation program, which is very cool. I've created a directory on a file server where I've copied all my installation files so I don't have to put the CD/DVD for software I'm installing into the drive on servers I'm upgrading. (This is a good thing, especially since a lot of my servers don't have DVD drives, and the new version is distributed on DVD media.)

The thing I found out, though, is that on Windows Server 2000 you CAN'T install from a mapped network drive. It works fine on Windows Server 2003 (and Windows XP, for the Developer's Edition) but I've had to copy the installation files to one of the fixed drives on the Win2000 servers I'm upgrading for the setup program to work.

Allen White - Marathon SQL Guy
Sr. Database Administrator

I'm in it for the long run

MarathonSQLGuy? Yes. I run marathons, and I've worked with SQL Server (both Sybase and Microsoft) since 1992.

There have been a lot of changes in SQL Server in that time, but at the same time the most important thing, the relational database engine, still gives us basically the same thing - relational data.

I'm really excited about SQL Server 2005. Microsoft asked me to help with the process of creating the certification exams for the new version, and I was able to help define the objectives for what are now the 71-441 and 71-442 exams, then I returned to Redmond and helped in the Alpha review of the 71-444 exam. The time there was interesting, a bit overwhelming, but I came to understand better the certification process. I also got a chance to know some really great people.

At this time I'm working on getting my company's servers upgraded to SQL Server 2005. It's usually pretty straightforward, but there have been some bumps. Third-party software vendors haven't been quick to certify their applications on the new version, so there are a number of servers I can't upgrade at this time. (I used to work at a couple of software development companies, so I understand that their priority is on their code, not testing already working code on Microsoft's newest set of bits. It does make life interesting, though, for we who have to maintain those environments and want to maximize the tools available.)

I'll try to keep this updated with the interesting things I find as we upgrade, and as I learn more about the product.

Quick Plug: I'll be presenting at the next meeting of the Ohio North SQL Server User's Group, on May 11, 2006, at the Microsoft Office. Details are at this URL: http://www.bennettadelson.com/technicalresources/sqlsig.aspx

Allen White - Marathon SQL Guy
Sr. Database Administrator