Hello All,
Out SBS 2003 server basically crapped out on me. It first started off with the Microsoft ISA Server 2004 firewall service (Microsoft Firewall) failing to start which was blocking ALL communication from the internal network and the internet. I managed to fix that problem but now another one has risen. We had SQL Server 2000 installed on the server but the SQL Server Agent service failed to start not matter what I did. Well it came to the point where I uninstalled SQL Server and attempted a reinstall. The install will not complete, I have tried SQL Server 2000 (the one that came with SBS 2k3, SQL Server 2005 Express (since the app we use does not really require a full version of SQL), and MSDE), everything fails and I am unsure of how to proceed, here is the event log from the installation:
#####################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=SERVER;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).
driver={sql server};server=SERVER;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).
driver={sql server};server=SERVER;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.
##################################################################
02:39:47 Process Exit Code: (-1)
02:39:57 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
02:39:57 Action CleanUpInstall:
02:39:57 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
02:39:57 Process Exit Code: (1060) The specified service does not exist as an installed service.
02:39:57 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
02:39:57 Process Exit Code: (0)
02:39:57 StatsGenerate returned: 2
02:39:57 StatsGenerate (0x0,0x1,0xf000,0x100,1033,303,0x0,0x1,0,0,0
02:39:57 StatsGenerate -1,Administrator)
02:39:57 Installation Failed.
Let me know if you need any more info.
Thanks!
|