SQL 2000 New Install -> "Setup Failed to Configure the Server" error

[Neil Kiser]

Hi,

I have tried everything I can think of and no matter what I get this error
at the end of the installation (at least I think it's the end, I haven't
made it past this point). This error occurrs after the files are installed.

I checked sqlstp.log and it says that there is a "SSL Security Error". I am
installign this onto a machine runnign Windows 2000 Server. This is a brand
new install, not an upgrade. I am running W2K SP1.

I stopped all services that access ODBC, as specified in the setup
documentation.

I am using Windows 2000 Authentication instead of Mixed Mode.

I'm really at a loss here, the Knowledge Base has nothing on this that I can
find.

Thanks for any assistance.

-Neil Kiser

[Trym Asserson]

Hi Neil and everyone else,

I am suffering from the exact same error during setup. It's finished copying
files when it displays a box saying "Setup is installing the server...", after
which it displays a new box "Setup is starting the server, and installing your
configuration" (or something similar) at which point the setup hangs and after
a "time-out" of sorts, I am given the "Setup failed to configure the server"
error and everything uninstalls (CleanupInstall is ran I see from the log).

In my 'sqlstp.log' however, I encounter the lines :

>>
Connecting to Server ...
driver={sql server};server=MYSERVER;UID=sa;PWD=<pwd>;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL
Server
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(PreLoginHandshake()).
driver={sql server};server=MYSERVER;UID=sa;PWD=<pwd>;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL
Server
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(PreLoginHandshake()).
driver={sql server};server=MYSERVER;UID=sa;PWD=<pwd>;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]Encryption not supported on SQL
Server
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(PreLoginHandshake()).
SQL Server configuration failed.
###############################################################################
14:33:46 Process Exit Code: (-1)
>>

And the ERRORLOG says 'SQL Server is terminating due to 'stop' request from
Service Control Manager'.

Anyone have a clue what's wrong?

I've tried to install at least ten times now, each with different configuration
(of authentification accounts, etc. Mixed mode vs. Windows mode +++), and I've
tried to remove all keys manually from the Registry to no avail.

Someone hinted to me that it may be that it's SQL Server 7.0 that has keys
remaining in the registry that need to be removed. If so, could someone please
tell me how to get rid of them [easily]?

Many thanks to the person who can help me!

Trym

-----Original Message-----
Hi,

Thanks for any assistance.

-Neil Kiser

.

[John Weigand]

Hello All,

I am having the exact same problem as Neil. Wish I could offer some
assistance, but at this point I'm clueless. I've had a successful install
of SQL Server 2000 on another Win2000 machine so I expected this one to go
smoothly. Guess not. The only obvious difference between the two machines
is that the one that the install is failing on has the high encryption pack
on it. Do you have this installed also or not?

Let me know. If I find anything I'll be sure to post it.

Thanks,
John

"Neil Kiser" <ne...@interaccess.com> wrote in message
news:Oz8C83kfAHA.1684@tkmsftngp02...

[Raj Deshmukh]

PROBLEM: Seeing errors in the SQLSTP.LOG as follows:
....
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(SECDoClientHandshake()). driver={sql
server};server=ROSE9;UID=sa;PWD=;database=master [Microsoft][ODBC SQL
Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL

Server Driver][Shared Memory]ConnectionOpen

(SECDoClientHandshake()). SQL Server configuration failed.

RESOLUTION:
1) Click on Start, Run... MMC.
2) Console, Add/Remove Snap-In.
3) Add, Certificates, Add, Computer Account, Local Computer, Finish, Close,
OK.
4) Look at Personal Certificates for any certificates. If exist, export
them to a file using All Task, Export.
5) After that, select the certificates, and delete them using Action,
Delete.

If this doesn't work, you may need to reinstall MMC and try it again.

If Deleting the Certificate is not an Option:
Create a certificate in the name of the fully qualified DNS name of the
server that is valid for server authentication and store it on the machine.

HTH.

Raj.