SQL server will not install...

[Joeybear23]

Here are the specifics:

Logged on as a local administrator
SQL Server Enterprise
Windows 2000 Enterprise Server

The only non-default option is the collation: BIN 850 multilingual

When I try to install I get these non-specific errors in the Sqlstp.log:

Starting Service ...

SQL_Latin1_General_CP850_BIN

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SAPTS2;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=SAPTS2;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=SAPTS2;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.

SQL/SAP DBA

 

[Corran007]

did you set it to use a local account or a domain account for sql server?

 

[Joeybear23]

I tried it both ways, same result.

SQL/SAP DBA

 

[gmmastros]

Security Policies must allow unsigned driver installation.

In the Control Panel, open "Administrative Tools"
Open "Local Security Policies"
Expand "Local Policies"
Click on "Security Option"
On Windows 2000, make sure "Unsigned non-driver installation behavior" is set to "Silently Succeed"
On Windows 2003 and Windows XP, make sure "Devices: Unsigned driver installation behavior" is set to "Silently Succeed"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Joeybear23]

That didn't do the trick either...

SQL/SAP DBA

 

[Corran007]

are you using the default instance name(machine name) or specifing a seperate one.

has sqlserver ever been on this system before?

 

[Joeybear23]

Default instance name.

I have install SQL Server on 3 identical machines (different name of course) in the past two weeks. This is the only time I've had any trouble. Also, we have rebuilt the server completely.

SQL/SAP DBA

 

[Joeybear23]

Well, Microsoft is stumped as well...

SQL/SAP DBA