Re: Cluster setup failing

rest of it...


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=xxx-xxx-2T;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'BUILTIN\Administrators'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'BUILTIN\Administrators'.

EXEC sp_addsrvrolemember N'BUILTIN\Administrators', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL Server]'BUILTIN\Administrators'
added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @@version where
attribute_id = 2

EXEC sp_grantlogin N'xxdomain\xxcluster'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'xxdomain\xxcluster'.

EXEC sp_addsrvrolemember N'xxdomain\xxcluster', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL Server]'xxdomain\xxcluster' added to
role 'sysadmin'.

EXEC sp_addserver N'xxx-xxx-2T', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If
DBCC printed error messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option 'allow
updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If
DBCC printed error messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option 'allow
updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###############################################################################

12:48:45 Process Exit Code: (0)
12:48:45 End Action BuildServer
12:48:45 Begin Action SelfRegiser
12:48:45 DLLRegisterServer atl.dll: 0, 0x0
12:48:53 Manual DLLRegisterServer C:\Program Files\Common Files\Microsoft
Shared\Database Replication\Conflict Viewer\wzcnf.dll: 0, 0x0
12:48:53 Begin Action SelfRegisterOnCluster
12:48:53 End Action SelfRegisterOnCluster
12:48:53 Begin Action RegisterSvrReplFiles
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\snapshot.exe-unregserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\distrib.exe-unregserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\replmerg.exe-unregserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\logread.exe-unregserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\qrdrsvc.exe-unregserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\snapshot.exe-regserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\distrib.exe-regserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\replmerg.exe-regserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\logread.exe-regserver
12:48:53 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\qrdrsvc.exe-regserver
12:48:53 End Action RegisterSvrReplFiles
12:48:53 Begin Action SelfRegisterCOMShared
12:48:53 End Action SelfRegisterCOMShared
12:48:53 End Action SelfRegister
12:48:53 Begin Action SetupRegistry:
12:48:53 SNMP service has been detected.
12:48:53 Begin Action RegWriteInstalledInstances:
12:48:53 End Action RegWriteInstalledInstances
12:48:53 Register this installation of SQL Server with MDAC
12:48:53 Completed registering this installation of SQL Server with MDAC
12:48:53 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\SQLServerAgent returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Replication returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Providers returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\Setup
returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Tracking returned: 0, 0
12:48:53 Updating SQL Licensing Control Panel information
12:48:53 Done updating SQL Licensing Control Panel information
12:48:53 SetRegSecuritySQLAndAdmin for
System\CurrentControlset\Services\MSSQLSERVER returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for Software\Microsoft\Windows
NT\CurrentVersion\Perflib returned: 0, 0
12:48:53 SetRegSecuritySQLAndAdmin for SOFTWARE\Clients\Mail returned: 0, 0
12:48:53 End Action SetupRegistry
12:48:53 Begin Action PostSetupRegistry:
12:48:53 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 7 -Service
MSSQLSERVER -SvcStartType 1 -SvcAccount "xxdomain\xxcluster" -SvcEPwd
12:48:53 Process Exit Code: (0)
12:48:53 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -Service
"SQLSERVERAGENT" -Dependencies MSSQLSERVER -ExePath "D:\Program
Files\Microsoft SQL Server\MSSQL\binn\sqlagent.exe" -SvcAccount
"xxdomain\xxcluster" -SvcEPwd
12:48:58 Process Exit Code: (0)
12:48:59 SetupSQLExecSecurity returned: 0
12:48:59 PerfmonLoad returned: 0
12:48:59 C:\PROGRA~1\MICROS~1\80\Tools\Binn\dcomscm.exe /RegServer
12:48:59 Process Exit Code: (0)
12:48:59 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.exe -RegServer
12:48:59 Process Exit Code: (-2147312566) Error loading type library/DLL.

12:48:59 regsvr32.exe /s "C:\PROGRA~1\MICROS~1\80\COM\repldsui.dll"
12:48:59 Process Exit Code: (0)
12:48:59 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\repldsui.dll
12:48:59 MSSearch ApplicationName: SQLServer
12:48:59 D:\SS2KEN~1\x86\FullText\ftsetup.exe SQLServer xxdomain\xxcluster 1
0 1 0
12:48:59 D:\SS2KEN~1\x86\FullText\ftsetup.exe SQLServer xxdomain\xxcluster
1 0 1 0
12:48:59 Process Exit Code: (0)
12:48:59 FulltextSetup returned: 0
12:48:59 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe
-i -lcid 1033
12:48:59 Process Exit Code: (0)
12:48:59 End Action PostSetupRegistry
12:48:59 Begin Action SetupFolders:
12:48:59 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Enterprise Manager
12:48:59 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Enterprise Manager
12:48:59 Tracking\Shortcuts\Enterprise Manager
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Query Analyzer
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Query Analyzer
12:49:00 Tracking\Shortcuts\Query Analyzer
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Profiler
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Profiler
12:49:00 Tracking\Shortcuts\Profiler
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Client Network Utility
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Client Network
Utility
12:49:00 Tracking\Shortcuts\Client Network Utility
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Configure SQL XML Support in IIS
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Configure SQL XML
Support in IIS
12:49:00 Tracking\Shortcuts\Configure SQL XML Support in IIS
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Import and Export Data
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Import and Export
Data
12:49:00 Tracking\Shortcuts\Import and Export Data
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Service Manager
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Service Manager
12:49:00 Tracking\Shortcuts\Service Manager
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Server Network Utility
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Server Network
Utility
12:49:00 Tracking\Shortcuts\Server Network Utility
12:49:00 C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
SQL Server\Books Online
12:49:00 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Books Online
12:49:00 Tracking\Shortcuts\Books Online
12:49:00 Microsoft SQL Server Folder refreshed.
12:49:00 End Action SetupFolders
12:49:00 Action CleanUpInstall:
12:49:00 Uninstall command: C:\WINDOWS\IsUninst.exe -f"D:\Program
Files\Microsoft SQL Server\MSSQL\Uninst.isu" -c"D:\Program Files\Microsoft
SQL Server\MSSQL\sqlsun.dll" -msql.mif i=MSSQLSERVER
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA4-5A21-11d2-9DAD-00C04F79D434}
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA5-5A21-11d2-9DAD-00C04F79D434}
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA6-5A21-11d2-9DAD-00C04F79D434}
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{6DC86044-0C71-11d3-9E18-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAD-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAD-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAF-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAF-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDB2-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDB2-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
12:49:00 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDBF-5A21-11d2-9DAD-00C04F79D434} (1)
12:49:00
Software\Microsoft\MSSQLServer\Tracking\{E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
12:49:00 StatsGenerate returned: 2
12:49:00 StatsGenerate (0x0,0x1,0xf00000,0x0,1033,303,0x0,0x1000000a,0,0,0
12:49:00 StatsGenerate -1,xxcluster)
12:49:00 Installation Succeeded

.

Relevant Pages

  • SIMPLE and wierd SQL Server 2000 login problem
    ... I have setup the following server: ... The SQL Server service ... Added a new local windows group called "ServerA\SQLAdminGroup" ... Run EXEC sp_grantlogin 'ServerA\SQLAdminGroup' [in SQL under SA ...
    (microsoft.public.sqlserver.setup)
  • Re: Problems launching DTS package from Stored Procedure
    ... exec sp_bcp_dbcmptlevel "UsersDatabase" SET FMTONLY ON Select * from Users1 ... Audit Logout ... Here is an example of an UNSUCCESSFUL sql profiler log: ... > I cannot run enterprise manager on our server because it is not installed. ...
    (microsoft.public.sqlserver.dts)
  • Re: Error in Distribution Clean Up Agent
    ... exec master.dbo.sp_configure 'xp_cmdshell' ... Server 1 SQL 2000 Distributor, ... Miscellenaous agent...except the Distribution Clean Up Agent ...
    (microsoft.public.sqlserver.replication)
  • MailMerge API Trouble
    ... word doc set up using the mailmerge wizard that creates an SQL ... Server .odc file to use as a datasource. ... there is an exec sp_cursoropen ...
    (microsoft.public.word.vba.general)
  • Re: Full text catalog just not populating
    ... exec sp_defaultdb N'NT Authority\System', N'master' ... means either the network guys in my company who don't know SQL but are admins ... > needs this login to log into SQL Server and you can either add back this ... >> fetching U ...
    (microsoft.public.sqlserver.fulltext)