Know Your Equipment

, 2008-06-05

Today I ran to the co-location facility for FourDeuce and End to End Training, to upgrade our database server to SQL Server 2005. We've been wanting to do it for awhile, but since most of our SQL code is fairly simple and generic, we haven't needed it.  The old SQL Server 2000 instance has run fine for years on there (it was the old database server) with no issues.

However we're starting to do more VS 2005 development and there are a few things in 2005 that it would be nice to tak eadvantage of. Plus we are teaching on 2005 all the time, or at least Andy and Brian are, so it makes some sense to just get 2005 on there.

I logged a ticket yesterday, got a note back today that I was set to go, and so I downloaded the 2005 Enterprise media today to my desktop and burned it on a DVD. I also started it downloading remotely on the database server, or so I thought. I didn't realize until later that it wasn't there.

I got to the colo at lunch, figuring this would be a quick hour. I got in, the guy from our hosting company opened the rack for me (we share with some of his other customers) and I got a crash cart and plugged it in. Now the crash cart had PS2 connections for the mouse and keyboard, which is OK since that's what the server has, but those connections are flaky. It would be better to have USB stuff on there, or at least adapters. I plugged things int he server, but it didn't respond.

So I did a hard shutdown, not able to reach Andy right then. So I started it up, plugged into the front (mistake) and only had one connection, so I went with keyboard. I've been using Windows for years, figure it would be easy to navigate. I got things up, logged on, put the DVD in, and

 "Please insert a CD into the drive"

 Huh? I opened it, put it back, cursed myself for not bringing a laptop, and then checked the drive. It was a "CD" drive and couldn't read DVDs. I haven't had a machine with no DVD drive in years, but this server is an old 2650, about 4-5 years old, and it doesn't have one. Even out "newer" machine, a 1750, is about 3 years old and doesn't have a DVD drive either. They didn't have one I could borrow, so I thought I'd download more media.

No chance. I got to the MSDN page, picked the server, but the "download" button wouldn't respond to keyboard input and I had no mouse.

I called Andy, thinking he might have some other idea, but it ended up being a busted trip.

When I got home, I saw the image was <4GB, so I could have actually put it on my flash drive, which I should have done. I'll try that tomorrow and see if I can get over there again and get a 2K5 instance.

So the moral: pay attention to your equipment. Remember that servers, espeically older ones, might be a generation behind your desktop in terms of interfaces and capabilities.    





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads