Can I Install?
May 7, 2008
hi all,
can i install the both SQLServer 2000 and 2005 in same server?
Thanks!
ADVERTISEMENT
SQL Server 2005 Install Keeps Failing To Install SQL Services (i.e. The Main Engine!).
Feb 6, 2007I am currently running Windows XP Professional Service Pack2. It already has MSDE & SQL Server 2000 installed (although I just uninstalled MSDE in the vain hope that it might present the installer with a more straightforward upgrade).
I have tried installing with the default instance & a new instance (I don't really care - I just need to install the darn thing). I just want the basic database & Books On-line, nothing fancy.
Here is the Summary log, for what it's worth:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Feb 06 16:45:14 2007
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_OWC11_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BOL_1.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_BackwardsCompat_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : MSXML 6.0 Parser (KB927977)
Product Version : 6.00.3890.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_ANTHONYY1_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : ANTHONYY1
Product : SQLXML4
Error : Setup is preparing to continue with the installation.
--------------------------------------------------------------------------------
Here is the SQLSetup0011_ANTHONYY1_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Tue Feb 06 16:45:14 2007
Process ID : 2560
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/6 16:45:14
Complete: LoadResourcesAction at: 2007/1/6 16:45:14, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/6 16:45:14, returned true
Running: ValidateWinNTAction at: 2007/1/6 16:45:14
Complete: ValidateWinNTAction at: 2007/1/6 16:45:14, returned true
Running: ValidateMinOSAction at: 2007/1/6 16:45:14
Complete: ValidateMinOSAction at: 2007/1/6 16:45:14, returned true
Running: PerformSCCAction at: 2007/1/6 16:45:14
Complete: PerformSCCAction at: 2007/1/6 16:45:14, returned true
Running: ActivateLoggingAction at: 2007/1/6 16:45:14
Complete: ActivateLoggingAction at: 2007/1/6 16:45:14, returned true
Running: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14
Complete: DetectPatchedBootstrapAction at: 2007/1/6 16:45:14, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2560" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/1/6 16:45:14
Complete: PerformDotNetCheck2 at: 2007/1/6 16:45:14, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/6 16:45:14
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [ANTHONYY1]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = ANTHONYY1, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = ANTHONYY1, Article = XMLDomDocument, Result = 0 (0x0)
Machine = ANTHONYY1, Article = Processor, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PhysicalMemory, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSServicePack, Result = 0 (0x0)
Machine = ANTHONYY1, Article = OSType, Result = 0 (0x0)
Machine = ANTHONYY1, Article = iisDep, Result = 0 (0x0)
Machine = ANTHONYY1, Article = AdminShare, Result = 0 (0x0)
Machine = ANTHONYY1, Article = PendingReboot, Result = 70011 (0x1117b)
Machine = ANTHONYY1, Article = PerfMon, Result = 0 (0x0)
Machine = ANTHONYY1, Article = IEVersion, Result = 0 (0x0)
Machine = ANTHONYY1, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = ANTHONYY1, Article = COMPlus, Result = 0 (0x0)
Machine = ANTHONYY1, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = ANTHONYY1, Article = MDAC25Version, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: ANTHONYY1
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Failed to find help file for LCID :2057
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/1/6 16:49:35, returned true
Running: SetPackageInstallStateAction at: 2007/1/6 16:49:35
Complete: SetPackageInstallStateAction at: 2007/1/6 16:49:36, returned true
Running: DeterminePackageTransformsAction at: 2007/1/6 16:49:36
Complete: DeterminePackageTransformsAction at: 2007/1/6 16:49:47, returned true
Running: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47
Complete: ValidateSetupPropertiesAction at: 2007/1/6 16:49:47, returned true
Running: OpenPipeAction at: 2007/1/6 16:49:47
Complete: OpenPipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/1/6 16:49:47
Complete: CreatePipeAction at: 2007/1/6 16:49:47, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2007/1/6 16:49:47
Complete: PopulateMutatorDbAction at: 2007/1/6 16:49:47, returned true
Running: GenerateRequestsAction at: 2007/1/6 16:49:47
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = 3
SQL_FullText = 3
SQL_SharedTools = 3
SQL_BC_DEP = 3
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = 3
Connectivity = 3
SQL_Tools90 = 3
SQL_WarehouseDevWorkbench = 3
SDK = 3
SQLXML = 3
Tools_Legacy = 3
TOOLS_BC_DEP = 3
SQL_Documentation = 3
SQL_BooksOnline = 3
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/1/6 16:49:48, returned true
Running: CreateProgressWindowAction at: 2007/1/6 16:49:48
Complete: CreateProgressWindowAction at: 2007/1/6 16:49:48, returned true
Running: ScheduleActionAction at: 2007/1/6 16:49:48
Complete: ScheduleActionAction at: 2007/1/6 16:49:48, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2007/1/6 16:49:48
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallSqlAction.11 at: 2007/1/6 16:49:51, returned true
Running: InstallSqlAction.12 at: 2007/1/6 16:49:51
Installing: sqlncli on target: ANTHONYY1
Complete: InstallSqlAction.12 at: 2007/1/6 16:49:55, returned true
Running: InstallSqlAction.18 at: 2007/1/6 16:49:55
Installing: owc11 on target: ANTHONYY1
Complete: InstallSqlAction.18 at: 2007/1/6 16:49:56, returned true
Running: InstallSqlAction.21 at: 2007/1/6 16:49:56
Installing: sqlwriter on target: ANTHONYY1
Complete: InstallSqlAction.21 at: 2007/1/6 16:49:58, returned true
Running: InstallSqlAction.22 at: 2007/1/6 16:49:58
Installing: bcRedist on target: ANTHONYY1
Complete: InstallSqlAction.22 at: 2007/1/6 16:50:0, returned true
Running: InstallSqlAction.9 at: 2007/1/6 16:50:0
Installing: msxml6 on target: ANTHONYY1
Complete: InstallSqlAction.9 at: 2007/1/6 16:50:2, returned true
Running: InstallToolsAction.11 at: 2007/1/6 16:50:2
Installing: sqlsupport on target: ANTHONYY1
Complete: InstallToolsAction.11 at: 2007/1/6 16:50:5, returned true
Running: InstallToolsAction.12 at: 2007/1/6 16:50:5
Installing: sqlncli on target: ANTHONYY1
Complete: InstallToolsAction.12 at: 2007/1/6 16:50:8, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.18 at: 2007/1/6 16:50:8
Installing: owc11 on target: ANTHONYY1
Complete: InstallToolsAction.18 at: 2007/1/6 16:50:10, returned true
Running: InstallToolsAction.20 at: 2007/1/6 16:50:10
Installing: BOL on target: ANTHONYY1
Complete: InstallToolsAction.20 at: 2007/1/6 16:52:2, returned true
Running: InstallToolsAction.22 at: 2007/1/6 16:52:2
Installing: bcRedist on target: ANTHONYY1
Complete: InstallToolsAction.22 at: 2007/1/6 16:52:4, returned true
Running: InstallToolsAction.9 at: 2007/1/6 16:52:4
Installing: msxml6 on target: ANTHONYY1
Complete: InstallToolsAction.9 at: 2007/1/6 16:52:6, returned true
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallSqlAction at: 2007/1/6 16:52:7
Installing: sql on target: ANTHONYY1
Error: MsiOpenDatabase failed with 110
Failed to install package
This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Error: MsiOpenDatabase failed with 110 for MSI D:ServersSetupSqlRun_SQL.msi
Setting package return code to: 1620
Complete: InstallSqlAction at: 2007/1/6 16:52:27, returned false
Error: Action "InstallSqlAction" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Running: InstallToolsAction.10 at: 2007/1/6 16:52:27
Installing: sqlxml4 on target: ANTHONYY1
Error Code: 0x8007006e (110)
Windows Error Text: The system cannot open the device or file specified.
Source File Name: sqlchainingminorbuildactionbehavior.cpp
Compiler Timestamp: Mon Jun 13 14:30:04 2005
Function Name: sqls::MinorBuildActionBehavior::modifyRequest
Source Line Number: 65
---- Context -----------------------------------------------
sqls::InstallPackageAction::perform
Complete: InstallToolsAction.10 at: 2007/1/6 16:55:59, returned false
Error: Action "InstallToolsAction.10" failed during execution. Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Action "InstallToolsAction" will return false due to the following preconditions:
Condition "Action: InstallToolsAction.10 has finished and failed." returned true.
Installation of package: "tools" failed due to a precondition.
Step "InstallToolsAction" was not able to run.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2007/1/6 16:55:59
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1620
Error Code: 0x80070654 (1620)
Windows Error Text: This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
led due to cancel code received from cancel source: 29539
...and here is the SQLSetup0011_ANTHONYY1_SQL.log:
=== Verbose logging started: 06/02/2007 16:52:14 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (00:54) [16:52:14:284]: Resetting cached policy values
MSI (c) (00:54) [16:52:14:284]: Machine policy value 'Debug' is 0
MSI (c) (00:54) [16:52:14:284]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (00:54) [16:52:14:284]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (00:54) [16:52:14:284]: Grabbed execution mutex.
MSI (c) (00:54) [16:52:14:299]: Cloaking enabled.
MSI (c) (00:54) [16:52:14:299]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (00:54) [16:52:14:299]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A4:98) [16:52:14:299]: Grabbed execution mutex.
MSI (s) (A4:00) [16:52:14:299]: Resetting cached policy values
MSI (s) (A4:00) [16:52:14:299]: Machine policy value 'Debug' is 0
MSI (s) (A4:00) [16:52:14:299]: ******* RunEngine:
******* Product: D:ServersSetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (A4:00) [16:52:21:080]: Note: 1: 2203 2: D:ServersSetupSqlRun_SQL.msi 3: -2147024873
MSI (s) (A4:00) [16:52:21:080]: MainEngineThread is returning 1620
MSI (c) (00:54) [16:52:21:080]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (00:54) [16:52:21:080]: MainEngineThread is returning 1620
=== Verbose logging stopped: 06/02/2007 16:52:21 ===
I suppose an error dialog (or log message) that actually told you what is wrong and then what to do is too much to ask for. (Or an installer than just copied all the files into place). :(
Database Services Install Fails When Install SQL Server 2005 SP2
Aug 15, 2007The error I got is:
Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.
EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@sysdbupg.sql@3 P4 : 0x7361
P5 : lib_odbc_statement.h@91 P6 : unknown P7 : sql9 P8 : hotfix@
P9 : x86 P10 : 3042
Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
I tried to search internet, however, I couldn't get solution.
My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.
Thanks a lot,
Rex
How To Suppress Dialog [Install Xxx Using The Default Application Install Directory?] ?
Dec 7, 2006I have compile my application into a Smart Device CAB and also including SQLCE CAB file for SQL.
I have users who choose to install SQLCE into Storage Cards instead and causes the application not to function, when asked which destination to install.
I've done some search and found out about "wceload.exe /noaskdest" but I'm using NSIS to compile into a single .exe file, and its calling "CEAppMgr.exe"
How can I force SQLCE to install into its default directory without asking user?
Thanks!
Standard Install Gives: Value Does Not Fall Within The Expected Range After SP1 Install
Jan 30, 2007Win XP Pro SP2IIS 5.1SQL 2005 SP1 (Developer edition)VS 2005 SP1.Net 2.0IE7 (didn't work on IE 6 either)Latest updates from Windows updateI have set up SSRS successfully on several machines. But on a new machine with standard install I have the out of the box SSRS report manager running with issues and would like to resolve them. Report Manager will serve image files from my project. But it won't render deployed reports, not even one which has no data sources. From within VS 2005 the same reports render, no problems. The same reports published to another SSRS machine render fine.The browser erorr message is "Value does no fall within the expected range".Any ideas? Thanks in advance.
View 3 Replies View RelatedInstall Enterprise Manager Without Install Sql Server
Jul 23, 2005Hi,Is it possible to install Enterprise Manager without to install theserver ?Thanks !--J-L M. (Alphomega)ICQ: 149635116Pour m'écrire, cliquer le lien ci-dessoushttp://cerbermail.com/?G5iYdBb2Ce
View 3 Replies View RelatedFailed To Install And Configure Error On Install
Nov 14, 2007Hi,
I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.
Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17
http://support.microsoft.com/kb/940971
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501
The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.
I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.
Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.
Thank you in advance.
Tim
De-install And Re-install Problems SQL Server 2005
Feb 15, 2007I never installed previous beta versions on my computer before. But now I have some serious problem after an incomplete de-install and a re-install of SQL server 2005 express advanced. I hope anybody can help me to solve this. Because the first installation eas not succesfull I had to do an de-install. I have tried to unstall through start/control panel/ add-remove programms and even there not all programs were removed. And that caused the problem. After that I wanted to re-install again but an msi file was missing. So I did a de-install agian. Tried to re-install again but with a lot of errors. After looking at the library I found a program: Windows Install CleanUp. I installed it and that even gives an error for all programs installed with SQL 2005.
After that I ran a program called MsiInv to clean but without any succes because this program reported a run-tim error. I have all reports on my computer but don't know how to attach them. If you think you can help me I could send you all the reports.
Regards,
Jan J
Is Sql Server 2005 A Standalone Install? Or Do You Have To Install Windows Server
May 26, 2006I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server
View 3 Replies View RelatedCan't Seem To Install SQL Server 2005? Install Completes, But Where Is SQL Server 2005
Apr 8, 2007I went to one of the Microsoft "Ready To Launch" events over a year ago. Microsoft was gracious and gave everyone who attended a free copy of Visual Studio 2005 and SQL Server 2005. I have installed the Visual Studio and use it all of the time. I also installed the SQL server 2005 but I can not find the application on my computer. After the install the only items that appear to have been installed are the following:
SQL Server Configuration tools(SQL Server Configuration manager,SQL Server Error and usage reporting, SQL Server surface area confiuration, Reporting Services configuration). There is also a menu icon labeled "Microsoft SQL server upgrade advisor" and SQL server upgraded wizard.
That is all. I can't find anything that is analogus to the Enterprise manager that was in SQL server 2000 or anything that is analogous to Query Analyzer of 2005.
Can someone help me out? We use SQL server 2005 so I know how it looks. I just can't see where it insalled. I don't think it did?
BCP Install
Aug 14, 2007Hi, I need to have on a client machine the bcp.exe installed. What components do I need to install from SQL Server 2005. I would like to have the absolute minimal installed on this machine. Thanks.
View 1 Replies View RelatedInstall
May 20, 2004i have downloaded MSDE sql ad I have extract it...
but now I can't install it with the command prompt
Is windows xp home edition a problem?
Need To Re-install SQL
Nov 5, 2001I need to re-install SQL 7 sp3 on NT4. I have read that I should detach the user databases of which I have 3, uninstall SQL then install SQL, then reattach. But what about all the jobs and packages and security I have setup? It is my understanding that this is stored in the master db. Won't that all be lost? If so I guess jobs could be scripted, packages could be saved, but what about the security?
-Thanks in advance.
Install 6.5 To 7.0
Jun 2, 2000I installed 6.5 into a server that aleardy has 7.0. Toward the end, it said 'Setup could not connect to the SQL Server'. Now as I try to start MSSQLSERVER I got an internal NT error.
I am stuck. Should I remove 7.0, install 6.5, then 7.0
PN.
SQL 6.5 Install After 7.0
Apr 1, 1999I have a new box that I have install SQL7 on and I also need SQL 6.5 on there to get back to SQL 6.5 databases on another server. The only way I know how to do this is uninstall SQL7 and then SP4 and then start with SQL 6.5, SP4, and SQL 7. Has anyone found another way?
Thanks
Ricky Kelley
SQL 7.0 Install
Sep 29, 1999Hi All,
I am on a client site, and they are trying to install SQL Server 7 (standard) on an NT 4 server (SP5), and hitting a problem that prevents the installation completing. The error log generated includes `Attempting to initialise Distributed Transaction Coordinator.....Failed to obtain Transaction Dispenser Interfaces`. If anyone has ideas on what the problem is, I would appreciate a response.
Thanks,
Herve
Install SQL 6.5
Jul 29, 1998I have 486 processor and Win 98 OS. SQL Svr 7 Beta doesn`t like 486.. I don`t have NT on my machine is it possible to run SQL 6.5 on Win9x?
Thank You.
SP3 Install
Aug 9, 2004Hi,
I want to deploy the sp3 on sql2000 msde on a lot of laptop, do you know a way to install the sp3 without any actionv of the user.
a silent install.
SQL Install
May 9, 2006I'm not sure if this is the best place but I cannot install SQL Server 2000 on a new machine running SBS '03 PE. When I double click MSDE.exe on disk four of the install it tells me a strong SA password is needed and something about SAPWD. I have an SA account (maybe it is not setup correctly?). Any ideas why this is happening?
View 1 Replies View RelatedHow To Install
Jul 8, 2007hi, how do i install sql express on vista properly?
After installation I only have access to the server configuration manager.
Install
Dec 28, 2007I want to install sql server 2005 compact edition on UNITECH HT660(pda mobile).
http://www.ute.com/product_info.php?id=65
When a transfer installation of sql sever 2005 compact edition from computer to UNITECH with usb cable(i get installation on my pda but , and try to install can't.Just can not to figure .exe file.
How To Install Onto D: ?
May 19, 2007My partition C: on my development server is too small, so it's critical to install SQL Server Express to the D: partition which has plenty of free room.
However SQL-Server starts to install onto C:ProgrammeMicrosoft SQL Server, and when it comes to changing the install path some error pops up and says, that the "Common" directory already has been chosen, such that I cannot alter the path.
How do I make install not to use drive C:?
-Tino
Can't Install SP2
Mar 7, 2007I'm trying to install SP2 (on XP SP2) and for some reason I'm getting an error on the authentication dialog.
The error is: "Your account information could not be verified. Press Ok to return to Authentication Mode screen to determine the reason for failure." For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator." In the dialog under status the value reads "Login Failed: ".
I've tried integrated security (I'm a local admin on this machine) and the sa account but no luck either way. I've tried starting every service that starts with "SQL" and still no luck.
Thoughts or ideas?
Thanks,
Mike
CD Install
May 9, 2006I would like to extract the self extracting exe files to go to a directory so I can burn a CD. I have tried burning the CD's from the temp directory but it wouldn't install properly from the CD. Is there a command line parameter to get around this? TIA
View 1 Replies View RelatedInstall Sp4
Nov 16, 2007Hi Could you please send me the steps to install sp4 on sql server 2000 --windows 2000 computer.
Please let me know also how much time it will take ?
How And What To Install
May 11, 2006Hi,
My hosting cie sugested I upgrade from Access to SQL wich I did.
I downloaded the fullest version (trial) of SQL I could find, not knowing what I realy needed.
The Trial has now expired and when I try to install the "Microsoft SQL Server 2005 Express Edition with Advanced Services " it sais that I need to uninstall some stuff (the error message is trunckated).
My use for this is to connect to and manage my live database. And to have a local copy of this database on my devellopement and testing machine that I can play around with.
Since i've install this "big version", I find that i'm only using the "sql management studio".
But when I go "add or remove prgms", it says I use everything "Frequently"!
So I do not want to uninstall something that I realy am using "frequently"...
Here is what I have in that list:
SQL server 2005
SQL server 2005 backward compatibitity
SQL server 2005 books online
SQL server Native client
SQL server setup support files
SQL server VSS writer
Visual Studio 2005 premier partner edition -ENU
This takes up 1121.62 MB !
I do not see in this list the sql management studio...?
What do I need to uninstall to be able to install "Microsoft SQL Server 2005 Express Edition with Advanced Services "?
What else should I uninstall because I just would not need ?
When I do uninstall whatever I need to uninstall, and install this express version, will it remember my conections? Find my local database? Basicly, will it screw up anything?!?
Thank you for your help!
Dominique
How Do I Install
Dec 3, 2007Okay, I am new to all of this. I am taking a cbt for exam 70-228. The course is sql server 2000 overview. I have sql 7.0. Can I install it on my XP Professional OS?
View 1 Replies View RelatedInstall
Mar 24, 2006I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu.
Any suggestions would be appreciated.
Thanks!
SQL Does Not Install
Nov 12, 2007What is this as I get this from both SQL Server 2005 Express as well as Office Accounting Express 2007. And I get no help from anybody on the phone at Microsoft.
TITLE: Microsoft SQL Server Setup
------------------------------
SQL Server Setup cannot install files to the compressed or encrypted folder: c:Program FilesMicrosoft SQL Server. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28062
------------------------------
BUTTONS:
OK
------------------------------
Re-Install
Jan 11, 2008If I install SQL Server Express 2005 with Advance Services will I lose my existing databases?
View 1 Replies View RelatedInstall SQL Everywhere
Oct 22, 2006I already had SQL Mobile installed on my development machine. I just downloaded and installed SQL Everywhere.
When I go to SQL Management Studio to create a new database using SQL Everywhere, it does not show up as an option. It does show SQL Mobile.
Did I upgrade my SQL Mobile to SQL Anywhere? Or should I have uninstalled SQL Mobile before installing Everywhere?
Thanks in advance.
Trying To Install The An SQL Database
Aug 17, 2006I have this CD that has a database called Contacts on it and everytime I try to insatll it I get the same errors. I'm trying to install it from the D: driveThis is what is to be ran in Query Analyzer
/****** Object:
Database Contacts Script Date:
3/7/2002 1:52:44 PM ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE
name = N'Contacts')
DROP
DATABASE [Contacts]
GO
CREATE DATABASE [Contacts]
ON (NAME = N'Contacts_Data', FILENAME = N'MCSDWebAppschapter05Contacts.MDF'
, SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Contacts_Log', FILENAME =
N'MCSDWebAppschapter05Contacts.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE
SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'Contacts', N'autoclose', N'false'
GO
exec sp_dboption N'Contacts', N'bulkcopy', N'false'
GO
exec sp_dboption N'Contacts', N'trunc. log', N'false'
GO
exec sp_dboption N'Contacts', N'torn page detection',
N'true'
GO
exec sp_dboption N'Contacts', N'read only', N'false'
GO
exec sp_dboption N'Contacts', N'dbo use', N'false'
GO
exec sp_dboption N'Contacts', N'single', N'false'
GO
exec sp_dboption N'Contacts', N'autoshrink', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI null default', N'false'
GO
exec sp_dboption N'Contacts', N'recursive triggers',
N'false'
GO
exec sp_dboption N'Contacts', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Contacts', N'concat null yields null',
N'false'
GO
exec sp_dboption N'Contacts', N'cursor close on commit',
N'false'
GO
exec sp_dboption N'Contacts', N'default to local cursor',
N'false'
GO
exec sp_dboption N'Contacts', N'quoted identifier', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Contacts', N'auto create statistics',
N'true'
GO
exec sp_dboption N'Contacts', N'auto update statistics',
N'true'
GO
use [Contacts]
GO
/****** Object: Table
[dbo].[Calls] Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Calls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Calls]
GO
/****** Object: Table
[dbo].[Contact Types] Script Date:
3/7/2002 1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contact Types]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contact Types]
GO
/****** Object: Table
[dbo].[Contacts] Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contacts]
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
if not exists (select * from dbo.sysusers where name =
N'ASPNET' and uid < 16382)
EXEC
sp_grantdbaccess N'ASPNET', N'ASPNET'
GO
/****** Object: User
dbo Script Date: 3/7/2002 1:52:45 PM
******/
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_accessadmin', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_backupoperator', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datareader', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datawriter', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_ddladmin', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45 PM
******/
exec sp_addrolemember N'db_denydatareader', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_denydatawriter', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_owner', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_securityadmin', N'ASPNET'
GO
/****** Object: Table
[dbo].[Calls] Script Date: 3/7/2002
1:52:51 PM ******/
CREATE TABLE [dbo].[Calls] (
[CallID]
[int] NOT NULL ,
[ContactID]
[int] NOT NULL ,
[CallDate]
[datetime] NULL ,
[CallTime]
[datetime] NULL ,
[Subject]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table
[dbo].[Contact Types] Script Date:
3/7/2002 1:52:55 PM ******/
CREATE TABLE [dbo].[Contact Types] (
[ContactTypeID]
[int] NOT NULL ,
[ContactType]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/****** Object: Table
[dbo].[Contacts] Script Date: 3/7/2002
1:52:55 PM ******/
CREATE TABLE [dbo].[Contacts] (
[ContactID]
[int] NOT NULL ,
[FirstName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LastName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Dear]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StateOrProvince]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PostalCode]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Region]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Country]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CompanyName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkPhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkExtension]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HomePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MobilePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FaxNumber]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EmailName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Birthdate]
[smalldatetime] NULL ,
[LastMeetingDate]
[smalldatetime] NULL ,
[ContactTypeID]
[int] NULL ,
[ReferredBy]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContactsInterests]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Calls] WITH NOCHECK ADD
CONSTRAINT
[PK__Calls__59063A47] PRIMARY KEY
CLUSTERED
(
[CallID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact Types] WITH NOCHECK ADD
CONSTRAINT
[PK__Contact Types__5AEE82B9] PRIMARY KEY
CLUSTERED
(
[ContactTypeID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
CONSTRAINT
[PK__Contacts__5CD6CB2B] PRIMARY KEY
CLUSTERED
(
[ContactID]
) ON [PRIMARY]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Calls] TO [ASPNET]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Contact Types] TO [ASPNET]
GO
GRANT SELECT ON [dbo].[Contacts] TO [public]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Contacts] TO [ASPNET]
GO
INSERT Contacts VALUES (1, 'Kim', 'Abercrombie', 'Ms.',
'1234 Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1111', '999', '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '8/3/1961', NULL, 1, NULL, NULL, 'Parasailing')
INSERT Contacts VALUES (2, 'Jay', 'Adams', 'Mr.', '631 Eagle
Rd.', 'Watertown', 'PA', '999999', NULL, 'USA', 'Fabrikam', NULL, '(111)
555-1112', '888', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'4/1/1942', NULL, 3, NULL, NULL, NULL)
INSERT Contacts VALUES (3, 'Adam', 'Bar', 'Mr.', '55
Passaway Ave.', 'Boston', 'MA', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1113', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '2/3/1965', NULL, 4, NULL, NULL, 'Fly fishing')
INSERT Contacts VALUES (4, 'Ido', 'Ben-Sachar', 'Mr.', '602A
Leeward Dr.', 'Sarasota', 'FL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1114', '777', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '1/22/1960', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (5, 'Bradley', 'Beck', 'Mr.', '44
Adams St.', 'Parkaway', 'NJ', '999999', NULL, 'USA', 'Adventure Works', NULL,
'(111) 555-1115', '333', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'9/30/1959', NULL, 2, NULL, NULL, NULL)
INSERT Contacts VALUES (6, 'Karen', 'Berge', 'Mrs.', '205
Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers', NULL,
'(111) 555-1116', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'6/7/1960', NULL, 3, NULL, NULL, 'Windsurfing')
INSERT Contacts VALUES (7, 'Scott', 'Bishop', 'Dr.', '8898
Lipshaw Blvd.', 'Paradise', 'OR', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1117', '555', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '11/23/1961', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (8, 'Pat', 'Coleman', 'Ms.', 'Rte 3
Highway 99', 'Circle City', 'AZ', '999999', NULL, 'USA', 'Fabrikam', NULL,
'(111) 555-1118', '87', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'10/13/1970', NULL, 2, NULL, NULL, 'Skiing')
INSERT Contacts VALUES (9, 'Jane', 'Clayton', 'Ms.', '2
Wyldflower Ln.', 'Boulder', 'CO', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1119', '22', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '5/4/1961', NULL, 3, NULL, NULL, 'Hunting')
INSERT Contacts VALUES (10, 'Kari', 'Hensien', 'Ms.', '43
Stormwater Cr.', 'Indialantic', 'FL', '999999', NULL, 'USA', 'Adventure Works',
NULL, '(111) 555-1110', '0988', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '7/7/1959', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (11, 'Don', 'Funk', 'Mr.', '55
Moccasin Wallow Dr.', 'Ernst', 'FL', '999999', NULL, 'USA', 'Fourth Coffee',
NULL, '(111) 555-1120', '111', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '3/15/1966', NULL, 1, NULL, NULL, NULL)
INSERT "Contact Types" VALUES(1, 'Business')
INSERT "Contact Types" VALUES(2, 'Social')
INSERT "Contact Types" VALUES(3, 'Friend')
INSERT "Contact Types" VALUES(4, 'Fishing buddy')
INSERT Calls VALUES(1,1,'3/3/2002', '12:00PM', 'Hosting
services', 'Return call with estimates')
INSERT Calls VALUES(2,3,'3/3/2002', '1:00PM', 'Trip to
Azores', 'Got lost on way. Needs directions.')
INSERT Calls VALUES(3,2,'2/1/2002', '10:00AM', 'Long call',
'A very, very long call.')
THIS IS THE ERRORS I KEEP GETTING
Server: Msg 5105, Level 16, State 2, Line 2
Device activation error. The physical file name
'MCSDWebAppschapter05Contacts.MDF' may be incorrect.
Server: Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be
created. Check previous errors.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database
'Contacts'. No entry found with that name. Make sure that the name is entered
correctly.
Server: Msg 15007, Level 16, State 1, Procedure
sp_grantdbaccess, Line 97
The login 'ASPNET' does not exist.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
I JUST WANT TO KNOW WHAT I NEED TO DO STEP FOR STEPTHIS IS MY FIRST TIME ON THIS FORUMCAN ANYONE HELP ME OUT
SQL Install Error!
Mar 6, 2007My system can not install the SQL SERVER 2003.There are some errors as follow when I install it.How can I solution this problem.Thanks very much!
09:25:23 Begin Setup09:25:23 8.00.19409:25:23 Mode = Normal09:25:23 ModeType = NORMAL09:25:23 GetDefinitionEx returned: 0, Extended: 0x009:25:23 ValueFTS returned: 109:25:23 ValuePID returned: 109:25:23 ValueLic returned: 009:25:23 System: Windows NT WorkStation09:25:23 SQL Server ProductType: Personal Edition [0x2]09:25:23 Begin Action: SetupInitialize 09:25:23 End Action SetupInitialize09:25:23 Begin Action: SetupInstall09:25:23 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir ...09:25:23 CommonFilesDir=C:Program FilesCommon Files09:25:23 Windows Directory=C:WINDOWS09:25:23 Program Files=C:Program Files09:25:23 TEMPDIR=C:WINDOWSTEMP09:25:23 Begin Action: SetupInstall09:25:23 digpid size : 25609:25:24 digpid size : 16409:25:24 Begin Action: CheckFixedRequirements09:25:24 Platform ID: 0xf00000009:25:24 Version: 5.1.260009:25:24 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.2900.291909:25:24 End Action: CheckFixedRequirements09:25:24 Begin Action: ShowDialogs09:25:24 Initial Dialog Mask: 0x83000f7, Disable Back=0x109:25:24 Begin Action ShowDialogsHlpr: 0x109:25:24 Begin Action: DialogShowSdWelcome09:25:25 End Action DialogShowSdWelcome09:25:25 Dialog 0x1 returned: 109:25:25 End Action ShowDialogsHlpr09:25:25 ShowDialogsGetDialog returned: nCurrent=0x2,index=109:25:25 Begin Action ShowDialogsHlpr: 0x209:25:25 Begin Action: DialogShowSdMachineName09:25:26 ShowDlgMachine returned: 109:25:26 Name = C853FFE5CF474B3, Type = 0x109:25:26 Begin Action: CheckRequirements09:25:26 Processor Architecture: x86 (Pentium)09:25:26 Service Pack: 51209:25:26 ComputerName: C853FFE5CF474B309:25:26 User Name: Administrator09:25:26 IsAllAccessAllowed returned: 109:25:26 OS Language: 0x80409:25:26 End Action CheckRequirements09:25:26 This combination of Package and Operating System allows a full product install.09:25:26 CreateSetupTopology(C853FFE5CF474B3), Handle : 0x1743fb0, returned : 009:25:26 CreateSetupTopology returned : 0, Handle : 0x1743fb009:25:26 Topology Type : 1, Return Value : 009:25:26 ST_GetPhysicalNode returned : 0, PNHandle : 0x174400809:25:26 PN_EnumerateEx returned : 009:25:26 PN_GetSQLStates returned : 0, SqlStates : 0x009:25:26 PN_StartScan [0x1744008] returned : 009:25:26 PN_GetNext [0x1744008] returned : 18, Handle: [0x0]09:25:26 No more items in enumeration.09:25:26 ReleaseSetupTopology09:25:26 Named instance limit: 100, quota: 009:25:26 End Action DialogShowSdMachineName09:25:26 begin ShowDialogsUpdateMask09:25:26 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 009:25:26 Updated Dialog Mask: 0xbf00037, Disable Back = 0x109:25:26 Dialog 0x2 returned: 009:25:26 End Action ShowDialogsHlpr09:25:26 ShowDialogsGetDialog returned: nCurrent=0x4,index=209:25:26 Begin Action ShowDialogsHlpr: 0x409:25:26 Begin Action: DialogShowSdInstallMode09:25:27 ShowDlgInstallMode returned: 109:25:27 InstallMode : 0x109:25:27 End Action DialogShowSdInstallMode09:25:27 begin ShowDialogsUpdateMask09:25:27 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 109:25:27 Updated Dialog Mask: 0xbf40037, Disable Back = 0x109:25:27 Dialog 0x4 returned: 109:25:27 End Action ShowDialogsHlpr09:25:27 ShowDialogsGetDialog returned: nCurrent=0x10,index=409:25:27 Begin Action ShowDialogsHlpr: 0x1009:25:27 Begin Action: DialogShowSdRegisterUserEx09:25:28 End Action DialogShowSdRegisterUserEx09:25:28 Dialog 0x10 returned: 109:25:28 End Action ShowDialogsHlpr09:25:28 ShowDialogsGetDialog returned: nCurrent=0x20,index=509:25:28 Begin Action ShowDialogsHlpr: 0x2009:25:28 Begin Action: DialogShowSdLicense09:25:29 End Action DialogShowSdLicense09:25:29 Dialog 0x20 returned: 109:25:29 End Action ShowDialogsHlpr09:25:29 ShowDialogsGetDialog returned: nCurrent=0x40000,index=1809:25:29 Begin Action ShowDialogsHlpr: 0x4000009:25:29 Begin Action: DialogShowSdCliSvr09:25:29 DisplaySystemPreReq09:25:30 ShowDlgClientServerSelect returned: 109:25:30 Type : 0x209:25:30 End Action DialogShowSdCliSvr09:25:30 begin ShowDialogsUpdateMask09:25:30 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 109:25:30 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:30 Dialog 0x40000 returned: 109:25:30 End Action ShowDialogsHlpr09:25:30 ShowDialogsGetDialog returned: nCurrent=0x80000,index=1909:25:30 Begin Action ShowDialogsHlpr: 0x8000009:25:30 Begin Action: DialogShowSdInstanceName09:25:30 Begin Action: ShowDlgInstanceName09:25:32 End Action: ShowDlgInstanceName09:25:32 ShowDlgInstanceName returned : 1209:25:32 InstanceName : 09:25:32 End Action DialogShowSdInstanceName09:25:32 begin ShowDialogsUpdateMask09:25:32 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1209:25:32 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:32 Dialog 0x80000 returned: 1209:25:32 End Action ShowDialogsHlpr09:25:32 ShowDialogsGetDialog returned: nCurrent=0x40000,index=1809:25:32 Begin Action ShowDialogsHlpr: 0x4000009:25:32 Begin Action: DialogShowSdCliSvr09:25:32 DisplaySystemPreReq09:25:34 ShowDlgClientServerSelect returned: 109:25:34 Type : 0x209:25:34 End Action DialogShowSdCliSvr09:25:34 begin ShowDialogsUpdateMask09:25:34 nFullMask = 0xbfc0037, nCurrent = 0x40000, nDirection = 109:25:34 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:34 Dialog 0x40000 returned: 109:25:34 End Action ShowDialogsHlpr09:25:34 ShowDialogsGetDialog returned: nCurrent=0x80000,index=1909:25:34 Begin Action ShowDialogsHlpr: 0x8000009:25:34 Begin Action: DialogShowSdInstanceName09:25:34 Begin Action: ShowDlgInstanceName09:25:34 End Action: ShowDlgInstanceName09:25:34 ShowDlgInstanceName returned : 109:25:34 InstanceName : MSSQLSERVER09:25:34 CreateSetupTopology(C853FFE5CF474B3), Handle : 0x1743fb0, returned : 009:25:34 CreateSetupTopology returned : 0, Handle : 0x1743fb009:25:34 Topology Type : 1, Return Value : 009:25:34 ST_GetPhysicalNode returned : 0, PNHandle : 0x174400809:25:34 PN_EnumerateEx returned : 009:25:34 PN_GetSQLStates returned : 0, SqlStates : 0x009:25:34 PN_StartScan [0x1744008] returned : 009:25:34 PN_GetNext [0x1744008] returned : 18, Handle: [0x0]09:25:34 No more items in enumeration.09:25:34 ReleaseSetupTopology09:25:34 End Action DialogShowSdInstanceName09:25:34 begin ShowDialogsUpdateMask09:25:34 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 109:25:34 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x109:25:34 Dialog 0x80000 returned: 109:25:34 End Action ShowDialogsHlpr09:25:34 ShowDialogsGetDialog returned: nCurrent=0x100000,index=2009:25:34 Begin Action ShowDialogsHlpr: 0x10000009:25:34 Begin Action: DialogShowSdSetupType09:25:34 Begin Action: Setup Type09:25:56 SQL program folder: d:program files ool softwaresql09:25:56 SQL data folder: d:program files ool softwaresql09:25:56 Windows system folder: C:WINDOWSsystem3209:25:56 Prog req: 38073, Data req: 36544, Sys req: 16916809:25:56 Prog avail: 6388716, Data avail: 6388716, Sys avail: 272730809:25:56 Prog req vs. avail, 74617, 638871609:25:56 Data req vs. avail, 36544, 638871609:25:56 Sys req vs. avail, 169168, 272730809:25:56 DisplaySystemPreReq09:25:56 [SetupTypeSQL]09:25:56 szDir = d:program files ool softwaresql09:25:56 szDir = d:program files ool softwaresql09:25:56 Result = 30109:25:56 szDataDir = d:program files ool softwaresql09:25:56 szDataDir = d:program files ool softwaresql09:25:56 End Action: Setup Type09:25:56 Setup Type: Typical (301)09:25:56 End Action DialogShowSdSetupType09:25:56 begin ShowDialogsUpdateMask09:25:56 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 30109:25:56 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:25:56 Dialog 0x100000 returned: 30109:25:56 End Action ShowDialogsHlpr09:25:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=2209:25:56 Begin Action ShowDialogsHlpr: 0x40000009:25:56 Begin Action: DlgServices09:26:02 ShowDlgServices returned: 109:26:02 [DlgServices]09:26:02 Local-Domain = 385509:26:02 AutoStart = 1509:26:02 Result = 109:26:02 End Action DlgServices09:26:02 begin ShowDialogsUpdateMask09:26:02 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 109:26:02 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:02 Dialog 0x400000 returned: 109:26:02 End Action ShowDialogsHlpr09:26:02 ShowDialogsGetDialog returned: nCurrent=0x800000,index=2309:26:02 Begin Action ShowDialogsHlpr: 0x80000009:26:02 Begin Action: DlgSQLSecurity09:26:08 ShowDlgSQLSecurity returned: 109:26:08 LoginMode = 2,szPwd09:26:08 End Action DlgSQLSecurity09:26:08 begin ShowDialogsUpdateMask09:26:08 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x800000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=2409:26:09 Begin Action ShowDialogsHlpr: 0x100000009:26:09 Begin Action: DlgCollation09:26:09 ShowDlgCollation returned: 109:26:09 collation_name = Chinese_PRC_CI_AS,locale_name = Chinese_PRC,lcid = 0x804,SortId = 0,dwCompFlags = 0x3000109:26:09 End Action DlgCollation09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x1000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=2509:26:09 Begin Action ShowDialogsHlpr: 0x200000009:26:09 Begin Action: DlgNetwork09:26:09 ShowDlgNetwork returned: 109:26:09 [DlgServerNetwork]09:26:09 NetworkLibs = 25509:26:09 TCPPort = 143309:26:09 TCPPrxy = Default09:26:09 NMPPipeName = \.pipesqlquery09:26:09 Result = 109:26:09 End Action DlgNetwork09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x2000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=2709:26:09 Begin Action ShowDialogsHlpr: 0x800000009:26:09 Begin Action: DialogShowSdStartCopy09:26:09 End Action DialogShowSdStartCopy09:26:09 begin ShowDialogsUpdateMask09:26:09 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 109:26:09 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x109:26:09 Dialog 0x8000000 returned: 109:26:09 End Action ShowDialogsHlpr09:26:09 ShowDialogsGetDialog returned: nCurrent=0x0,index=009:26:09 End Action ShowDialogs09:26:10 Begin Action ProcessBeforeDataMove:09:26:10 DeinstallStart returned (d:program files ool softwaresqlMSSQL): 009:26:10 End Action ProcessBeforeDataMove:09:26:10 Begin Action SetToolsComponentSelection:09:26:10 End Action SetToolsComponentSelection:09:26:10 Begin Action ProcessComponentSelection:09:26:10 End Action ProcessComponentSelection09:26:10 Begin Action LogSelectedComponents:09:26:10 SQLProg09:26:10 SQLProgSQLServr09:26:10 SQLProgSQLServrHelp09:26:10 SQLProgSQLServrSCMDev09:26:10 SQLProgSQLServrSCMDevSCMh09:26:10 SQLProgSQLServrSCMDevSCMX86Lb09:26:10 SQLProgSQLServrSCMDevSCMALb09:26:10 SQLProgSQLServrRs103309:26:10 SQLProgSQLServrRsIntl09:26:10 SQLProgSQLServrActiveX09:26:10 SQLProgSQLServrSystem09:26:10 SQLProgUpgTools09:26:10 SQLProgUpgToolsUpgSys09:26:10 SQLProgUpgToolsActiveX09:26:10 SQLProgUpgToolsRes103309:26:10 SQLProgUpgToolsResOther09:26:10 SQLProgUpgToolsResld09:26:10 SQLProgReplSupp09:26:10 SQLProgReplSuppReplDat09:26:10 SQLProgReplSuppRepComm09:26:10 SQLProgReplSuppRepNoDk09:26:10 SQLProgReplSuppActiveX09:26:10 SQLProgInstall09:26:10 SQLProgSystem09:26:10 SQLProgSvrExt09:26:10 SQLProgSvrExtHelp09:26:10 SQLProgSvrExtSvrExtRs09:26:10 SQLProgSvrExtResIntl09:26:10 SQLProgDat09:26:10 SQLProgDatSmpl09:26:10 SQLProgBaseSys09:26:10 SQLProgBaseBinn09:26:10 SQLProgBaseInst09:26:10 SQLProgSymbols09:26:10 SQLProgSymbolsEXE09:26:10 SQLProgSymbolsDLL09:26:10 SQLProgPerfmon09:26:10 SQLProgPerfmonSystem09:26:10 SQLProgRoot09:26:10 MgtTool09:26:10 MgtToolSEM09:26:10 MgtToolSEMHTML09:26:10 MgtToolSEMMSD9809:26:10 MgtToolSEMMSD98SYS09:26:10 MgtToolSEMMSD98Res09:26:10 MgtToolSEMMSD98Hlp09:26:10 MgtToolSEMHelp09:26:10 MgtToolSEMRes103309:26:10 MgtToolSEMResIntl09:26:10 MgtToolSEMMSD98RsI09:26:10 MgtToolSEMActiveX09:26:10 MgtToolSEMActiveXRes103309:26:10 MgtToolSEMActiveXResIntl09:26:10 MgtToolSEMScripts09:26:10 MgtToolSEMOLEDB09:26:10 MgtToolSEMOLEDBRes103309:26:10 MgtToolSEMOLEDBResIntl09:26:10 MgtToolProfiler09:26:10 MgtToolProfilerHelp09:26:10 MgtToolProfilerRes103309:26:10 MgtToolProfilerResIntl09:26:10 MgtToolQryanlz09:26:10 MgtToolQryanlzHelp09:26:10 MgtToolQryanlzRes103309:26:10 MgtToolQryanlzResIntl09:26:10 MgtToolDTCCLi09:26:10 MgtToolWzcnflct09:26:10 MgtToolWzcnflctWzcnHlp09:26:10 MgtToolWzcnflctWzcn103309:26:10 MgtToolWzcnflctWzcnOthr09:26:10 MgtToolWzcnflctWzcnCmn09:26:10 MgtToolUtilSys09:26:10 MgtToolUtilBinn09:26:10 Connect09:26:10 ConnectConnSys09:26:10 Books09:26:10 BooksBookso09:26:10 BooksBooksoUtils09:26:10 DevTools09:26:10 DevToolsDbg Int09:26:10 DevToolsDbg IntDbg Int Common09:26:10 DevToolsDbg IntEXE09:26:10 CoreRepl09:26:10 CoreReplRes103309:26:10 CoreReplResIntl09:26:10 Core09:26:10 CoreRes103309:26:10 CoreResOther09:26:10 Repostry09:26:10 RepostryRepstSys09:26:10 RepostryRes103309:26:10 RepostryResIntl09:26:10 CoreMisc09:26:10 CoreMiscActiveX09:26:10 CoreMiscActiveXRes103309:26:10 CoreMiscActiveXResIntl09:26:10 CoreMiscRes103309:26:10 Monarch09:26:10 MonarchMonr103309:26:10 MonarchMonrIntl09:26:10 Jet09:26:10 CoreInst09:26:10 CoreCOM09:26:10 CoreCOMRes103309:26:10 CoreCOMResIntl09:26:10 CoreTool09:26:10 CoreToolRes103309:26:10 CoreToolResOther09:26:10 DBLibCli09:26:10 SFExt09:26:10 SFExtActiveX09:26:10 SFExtActiveXRes103309:26:10 SFExtActiveXResIntl09:26:10 SFExtRes103309:26:10 SFExtResIntl09:26:10 Trace09:26:10 TraceRes103309:26:10 TraceResOther09:26:10 MiscCore09:26:10 MC09:26:10 MCMC103309:26:10 MCMCIntl09:26:10 MCHelp09:26:10 SQLMgr09:26:10 SQLMgrRes103309:26:10 SQLMgrResIntl09:26:10 SvrTool09:26:10 SvrToolRes103309:26:10 SvrToolResIntl09:26:10 DTSUI09:26:10 DTSUIRes103309:26:10 DTSUIResIntl09:26:10 MSOlap09:26:10 MSOlapRes103309:26:10 MSOlapResIntl09:26:10 ATL09:26:10 ATLwinnt09:26:10 ATLwin9x09:26:10 MFC42U09:26:10 VC09:26:10 VB09:26:10 OCX109:26:10 SQLAdHlp09:26:10 SQLAdHlpRes103309:26:10 SQLAdHlpResOther09:26:10 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}09:26:10 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}09:26:10 End Action LogSelectedComponents09:26:10 Begin Action InstallPkgs:09:26:10 Begin Action: Locked Connectivity Files Check09:26:11 ConnectivityLocked returned: 009:26:11 �作�功完�。
09:26:11 End Action: Locked Connectivity Files Check09:26:11 安装程åº?æ£åœ¨å®‰è£… Microsoft æ•°æ?®è®¿é—®ç»„件 (MDAC) ...09:26:11 H:PERSONALx86Othersqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"09:26:29 ExitCode: 009:26:30 安装程åº?æ£åœ¨å®‰è£… Microsoft 分布å¼?事务处ç?†å??调器 (MSDTC) ...09:26:30 C:WINDOWSTEMPSqlSetupBincldtcstp.exe -SupportDir "C:WINDOWSTEMPSqlSetupBin" -DTCPkg "H:PERSONALx86Otherdtcsetup.exe" -LogFile "C:WINDOWSsqlstp.log"09:26:30 Process Exit Code: (0) 09:26:30 /Q:A /T:C:WINDOWSTEMPixp001.tmp09:26:30 安装程åº?æ£åœ¨å®‰è£… HTML 帮助09:26:31 HTML Help installer exit code: 009:26:58 End Action InstallPkgs09:26:58 Begin Action MoveFileData:09:26:58 Enabled SELFREGISTERBATCH09:26:58 Enabled CORECOMPONENTHANDLING09:30:07 Begin Action: MoveFileDataSpecial09:30:07 End Action: MoveFileDataSpecial09:30:07 End Action MoveFileData09:30:07 Begin Action ProcessAfterDataMove:09:30:08 H:PERSONALx86Binnhhcol.exe C:Program FilesMicrosoft SQL Server80ToolsBooks09:30:09 End Action ProcessAfterDataMove09:30:09 Begin Action BuildServer:09:30:09 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 5 -ExePath "d:program files ool softwaresqlMSSQLinnsqlservr.exe" -Service "MSSQLSERVER"09:30:09 Process Exit Code: (0) 09:30:09 Begin Action: CreateRegistrySetSQL09:30:09 End Action: CreateRegistrySetSQL09:30:09 Begin Action: RegWriteSetupEntry09:30:09 End Action: RegWriteSetupEntry09:30:09 Begin Action: CreateSer09:30:09 End Action: CreateSer09:30:09 Begin Action: SkuIt09:30:10 End Action: SkuIt09:30:10 SetFileSecuritySQLAndAdmin for d:program files ool softwaresqlMSSQL returned: 0, 009:30:10 SetRegSecuritySQLAndAdmin for SoftwareMicrosoftMSSQLServerMSSQLServer returned: 0, 009:30:10 Begin Action: UpdateSystemPath09:30:10 Path successfully updated.09:30:10 %SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;C:Program FilesCommon FilesAdobeAGL;C:Program FilesMicrosoft SQL Server80ToolsBINN09:30:10 End Action: UpdateSystemPath09:30:11 C:Program FilesMicrosoft SQL Server80ToolsBinncnfgsvr.exe -F "C:WINDOWSsqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Chinese_PRC_CI_AS" -H 262782 -U sa -P ###############################################################################
æ£åœ¨å?¯åŠ¨?
Chinese_PRC_CI_AS
-m -Q -T4022 -T3659
æ£åœ¨ä¸Žæœ?务?
driver={sql server};server=C853FFE5CF474B3;UID=sa;PWD=;database=master
æ£åœ¨é…?ç½®æœ?
EXEC sp_grantlogin N'BUILTINAdministrators'
[Microsoft][ODBC SQL Server Driver][SQL Server]已� 'BUILTINAdministrators' 授予登
EXEC sp_addsrvrolemember N'BUILTINAdministrators', 'sysadmin'
[Microsoft][ODBC SQL Server Driver][SQL Server]'BUILTINAdministrators' å·²æ·»åŠ åˆ°è§’è‰² 'sysadm
update master.dbo.spt_server_info set attribute_value = @@version where attribute_id = 2
EXEC sp_addserver N'C853FFE5CF474B3', local
[Microsoft][ODBC SQL Server Driver][SQL Server]密ç ?å·²
EXEC sp_configure 'allow updates', 1
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC 执行完毕。如果 DBCC 输出了错误?
[Microsoft][ODBC SQL Server Driver][SQL Server]已将�置选项 'allow updates' 从 0 改为 1。请�行 RECON
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 执行完毕。如果 DBCC 输出了错误?
[Microsoft][ODBC SQL Server Driver][SQL Server]已将�置选项 'allow updates' 从 1 改为 0。请�行 RECON
reconfigure with override
æ£åœ¨æ–开与æœ?务
æ£åœ¨å?œæ¢?
已�功�置 SQL Se
###############################################################################
09:30:49 Process Exit Code: (0) 09:30:49 End Action BuildServer09:30:49 Begin Action SelfRegiser09:30:49 DLLRegisterServer atl.dll: 0, 0x009:31:07 Manual DLLRegisterServer C:WINDOWSsystem32Msrdo20.dll: 0, 0x009:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationConflict Viewerwzcnf.dll: 0, 0x009:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesSystemOLE DBmsolap80.dll: 126, 0x7e09:31:08 The file listed below could not be registered. Adding it to RunOnce to try again on the next reboot.09:31:08 DLL0: C:WINDOWSsystem32
egsvr32.exe /s "C:Program FilesCommon FilesSystemOLE DBmsolap80.dll"09:31:08 Manual DLLRegisterServer C:Program FilesCommon FilesSystemOLE DBmsolui80.dll: 126, 0x7e09:31:08 The file listed below could not be registered. Adding it to RunOnce to try again on the next reboot.09:31:08 DLL1: C:WINDOWSsystem32
egsvr32.exe /s "C:Program FilesCommon FilesSystemOLE DBmsolui80.dll"09:31:08 Begin Action SelfRegisterOnCluster09:31:08 End Action SelfRegisterOnCluster09:31:08 Begin Action RegisterSvrReplFiles09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMsnapshot.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMdistrib.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COM
eplmerg.exe-unregserver09:31:08 **** File registered: C:Program FilesMicrosoft SQL Server80COMlogread.exe-unregserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMqrdrsvc.exe-unregserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMsnapshot.exe-regserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COMdistrib.exe-regserver09:31:09 **** File registered: C:Program FilesMicrosoft SQL Server80COM
eplmerg.exe-regserver09:31:10 **** File registered: C:Program FilesMicrosoft SQL Server80COMlogread.exe-regserver09:31:10 **** File registered: C:Program FilesMicrosoft SQL Server80COMqrdrsvc.exe-regserver09:31:10 End Action RegisterSvrReplFiles09:31:10 Begin Action SelfRegisterCOMShared09:31:10 End Action SelfRegisterCOMShared09:31:10 End Action SelfRegister09:31:10 Begin Action SetupRegistry:09:31:10 Begin Action RegWriteInstalledInstances:09:31:10 End Action RegWriteInstalledInstances09:31:10 Register this installation of SQL Server with MDAC09:31:11 Completed registering this installation of SQL Server with MDAC09:33:05 创建一个或多个注册表项时出现错误。请å?‚è§? C:WINDOWS\sqlstp.log 以了解详细情况。问题å?¯èƒ½æ˜¯ç”±äºŽæ³¨å†Œè¡¨å¼•ç”¨æ?¡ä»¶ä¸?足而引起的。09:33:05 Action CleanUpInstall:09:33:05 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT09:33:05 Process Exit Code: (1060) 指定的æœ?务并未以已安装的æœ?务å˜åœ¨ã€‚
09:33:05 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER09:33:06 Process Exit Code: (0) 09:33:06 StatsGenerate returned: 209:33:06 StatsGenerate (0x0,0x1,0xf000000,0x200,2052,303,0x0,0x1,0,0,009:33:06 StatsGenerate -1,Administrator)09:33:06 Installation Failed.