I've been trying to install SQL Server 2000 Pro on Windows 2000 Server without much luck.

I'm doing a very normal install, local server, typical setting, and windows auth. The installation gets most of the way through and then hangs as it tries to start the sql server service. I'm attaching the error log it generates.

I've tried turning off as many services as possible before attempting the install, but it always hangs in the same place. I've searched the ms knowledge base with the error in the log "EXCEPTION_ACCESS_VIOLATION" only to find too many references and none that seem to relate.

If anyone could help it would be very appreciated!!!

Thanks,
Tom

Have you installed the latest service packs? IIRC, SQL server requires them. What else is installed on the machine that might cause trouble?

It's SP2 with all of the latest hotfixes. Windows update shows nothing critical to download.

Other things installed... IMail 7.0, OfficeXP, Advanced Communications NT Hosting Controller, Flicks Authentix, thats about it.

Thanks,
Tom

Don't know exactly what your problem is but I see similar posts to the MS News groups about SQL 2K install problems.
and this is typically the comments the MS engineers make, heres a set of steps from one of them

---

Please try these steps:
1). Delete all SQL Server related registry key:
HKLM\Software\Microsoft\MSSQLServer
HKLM\System\CurrentControlSet\Services\MSSQLServer
HKLM\System\CurrentControlSet\Services\SQLServerAgent
Sometimes you need to delete this key:
HKLM\Software\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents
2). Reinstall the SQL Server.

Or,
3). Try x86\setup\setupsql.exe k=dbg to setup SQL Server in debug mode.

---

At the very least, step 3 will produce a detailed log you can post to MS and maybe they can help.
Also, I suggest if you get really stuck your try the MS SQL Server Setup nesgroup on msnews.microsoft.com
[need a news client to read/post there - outlook is the usual one most folks use].

Greetings!

Just a quick check - you installed this from physical console, not terminal services, right? SQL has a very bad habit of not installing properly unless you are on physical console.

I tried removing those registry keys and the setup continued to hang.

I checked out the newsgroup, thanks!. I'll post over there if pgrzelak's idea doesn't work.

Tom

Yep, I am installing over terminal services. I'm in CA and the server is in FL, so I don't really have much of an option.

Do you think if I installed pcAnywhere it would make a difference?

Tom

Greetings!

Unfortunately, it will not help. I have done this with multiple releases of SQL, and they all have glitches if you try to install over a remote access package. Did not try pcanywhere, though... Let me see if I can find that Q article...

Note: most of the hardware I deal with here is Compaq, and we use their Remote Insight Manager Boards. Remote console via the web. Excellent devices!

Using remote control software (such as pcAnywhere) will make a difference, I would give it a go. A terminal session is very different to a remote session of the "local" machine.

Using remote control software (such as pcAnywhere) will make a difference

Assuming, of course, that it doesn't also have problems installing via Terminal Services.

Tough part is, if a PC anywhere install fails, sometimes your GINA is hosed and it's a real pain to get the system to work again at all (and requires physical access to the box). Been there, done that.

You can install pcAnywhere 10.5 remotely (no need to use TS) and no reboot is required. pcAnywhere 10.5 also does not use a custom GINA. Many other remote control packages are available.

It is also possible to perform a remote installation of SQL 2000 as part of the normal Microsoft installation, or failing that you can configure an unattended installation and kick that off remotely.

Wow, cool, I didn't know that. I assume they're taking advantage of Win2k-specific features to acheive that. They probably helped MS develop those features in the first place...

Unfortunately I’m getting the same results with pcAnywhere 10.5

I also can’t figure out the remote installation of SQL. When I run setup on my local machine (WinXP) it complains it isn’t supported on this OS and only the client tools are available for installation. Then "Local Computer" is the only option available. "Remote Computer" and "Virtual Server" are grayed out.

Thanks for the help guys. I’m going to go post my error logs on the ms news server.

Tom

Woohoo!!! I got it.

I installed MSDE from www.asp.net/msde

With that running when SQL setup gave me the option of doing an upgrade. Upgrade worked great!

Thanks everyone.

Tom

Very cool!!!