SQL Server 2000 Install failure

[pdtt]

Hi,

I am unable to install SQL Server on a Windows 2000 Server box. The error returned is "SQL Server does not exist or access denied". Here is the failure section from sqlstp.log:

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SQLDEV1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=SQLDEV1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=SQLDEV1;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

SQL Server configuration failed.


********************************************
I directed the setup program to use the local system account
and set the sa password as blank (it is a development server).

Does anyone know why the SQL server configuration failed?

Thank you

 

[ClaireHCM]

Try the following steps
Start --- Programs -- Microsoft SQL Server --- Client Network Utility -- Go to alias tab --- Add a Server alias in the list

Then try to connect to the server from isqlw ,you will be prompted a dialog which ask for SQL Server name,Which authentication u want to use to connect it.
Scroll down the list server name ,pick the one which you just added ,then select SQL authentication give sa and blank pwd

 

[pdtt]

Hi Claire,

Thanks for the posting. The install program did not put any items on the start menu. I have tried all the executible programs in the 80\binn directory and did not find the "Client Network Utility".

Also, even though there is a sqlsunin.ini file in the MSSQL folder, the add/remove program failed when I tried to uninstall the program.

Do you have any other ideas?

Thanks,

Paul

 

[pdtt]

Hi Claire,

I have found out how to clear the registry of SQL Server settings. I also set up a seperate NT account for SQL Server, stopped the IIS service and then deleted all SQL server files on the system. My next attempt at installing has been successful.

Thank you for your input. It gave me a starting point.