Hi,
We have a suite of applications which go through the full product life cycle and I was wondering which SQL Server edition should be installed in every each environment from Proof of Concept -> Dev -> -> UAT -> Systest...
Production is straight forward but I am just not sure about all the other environments.
thanks
Lyn
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies View RelatedHi All,
I am facing a familiar issue, with a slight variance in the situation. I have already spent hours googling for a solution, so along with the problem I'll highlight what I have already tried to remedy it.
Problem
--------
I am trying to install SQL Server 2000 Dev. Edition on my Win XP SP1 platform. I did a default instance installation. I am able to start up the server and keep it up.
Issue
-----
On opening the Enterprise Manager I get the error, "SQLDMO.DLL not registered, re-run SQL Server setup etc."
Next I navigated to <install dir>Microsoft SQL Server80ToolsBinn and executed regsvr32 sqldmo.dll and I get the following error, "LoadLibrary("sqldmo.dll") failed - Invalid Access to Memory Location"
Comments
----------
I have verified that all the relevant dlls are present in the above and <...>system32 folders. I have also created an alias for the server using the client network utility.
There was a time when I had installed SQL Server 2000 previously and I did manage to get it to work, even the sqldmo.dll registeration bit. But uninstalled it subsequently as I was having space issues.
Since then I have installed various XP hotfixes and security fixes, except for Win XP SP2
Any thoughts, anyone?????
I'm trying to upgrade my SQL Server 2000 Developer's Edition to sp3a, I'm following the instructions.
I receive the following message:
Invalid product code was found. Check if product is installed.
I have installed this from CD I have with me. I followed instruction on http://support.microsoft.com/?kbid=311762
but I don't see product ID/code !!!!!
I have installed default instance (MSSQLSERVER) on my machine. How do I do Update to Service Pack 3a.
I can Install "Database Components "
Downloadable file name: SQL2KSP3.exe SP3a
but I can't install "SQL Server 2000 Desktop Engine(MSDE) "
Downloadable file name: SQL2kdesksp3.exe SP3a.
Any help?
Thank you.
It's arriving from ebuyer tomorrow for 32 quid. I already have aninstance of MSDE running on the laptop and ideally i would like SQLserver to be installed and use the current instance and not installany other additional services. [hope i got my terminology correcthere.] Basically all i would like is to use the Enterprise Managerwith my existing MSDE database. I was wondering if there is anything ishould be doing before I install. Should i shut down the service orleave it running for instance.Thanks for any tips,AndyB
View 2 Replies View RelatedHi everyone...
I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4.
After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation.
I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else???
Thank you all,
HERE IS THE LOG FILE:
"Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007
Process ID : 2684
c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/14 7:45:33
Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33
Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text:
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2"
** Error in msgbox : “Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information. �
** Cut From: C:WINDOWSsqlstp.log – ( previous exit codes look OK) ---
(previous text removed) …
21:54:29 C:Program FilesMicrosoft SQL Server80ToolsBinncnfgsvr.exe -F "C:WINDOWSsqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 66364 -U sa -P
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cn91909-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
SQL Server configuration failed.
###############################################################################
21:54:55 Process Exit Code: (-1)
21:57:07 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information.
21:57:07 Action CleanUpInstall:
21:57:07 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
21:57:07 Process Exit Code: (1060) The specified service does not exist as an installed service.
21:57:07 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
21:57:07 Process Exit Code: (0)
21:57:07 StatsGenerate returned: 2
21:57:07 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
21:57:07 StatsGenerate -1,debbie)
21:57:07 Installation Failed.
I have to creat virtual server. Then I Can't install sql server 2000 enterprise edition on winXP. What should i do? What do you think
View 1 Replies View Related
When come to Create Instances screen and click next it prompt error message
although i had restart my computer.
A previous program Installation created pending file operations on the installation machine. You must restart the computer before running setup.
Hi there
Our ISP hosts our data on SQL Server Enterprise, but I also going to host the databases on my local machine.
As it's just local would Standard edition do? If I migrate the databases over, will it work?
Thanks in advance.
Hi,
Can we degrade from SQL Server 2000 Enterprise Edition to SQL Server 2000 Standand Edition without doing Uninstall and reinstall?
Thanks in advance,
I am setting up sharepoint and sql server integration environment. I am considering the following topology: PowerPivot for SharePoint 2013 and Reporting Services in SharePoint mode Two Server Deployment
[URL]
I am looking to follow the topology example by the letter, which involves installing PowerPivot for SharePoint (aka SSAS in SharePoint mode) in the same server as my SQL, and installing SSRS in SharePoint (SP) integrated mode in the same server as SharePoint.
I understand, however, that if I wanted to install SSRS in SP mode in the same server as SQL, I could but only if the server contains the SP Object Model.
My first question is, what would involve having the SP Object Model in the SQL Server?
Would only installing SP binaries be enough; or Do I need to do a minimal install of SP in the SQL server enough for it to joing the SP farm? And most importantly, what would be the licensing implications for SP in case I want proceed down this route and have SSRS in SharePoint mode installed in the same server as the SQL?
Hi,
I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)
The Instance has many logins and jobs etc and I dont want to loose those
A document or some advice on how to go about it would help
Thanks
Hello all,
Here I need some help or suggestions for the following topic...
I am using SQL server 2000 enterprise edition installed on the machine. Now I wanted to change the edition from enterprise to standard.
There are around 4 user databases exists on the server.
What are the areas I have to take care while doing this? Could I do as normal installation?
No log shipping implemented on the server.
Your suggestions would be very helpful to me.
Thanks in advance.
I have web application and sql server 2k database in hosted environment. How can migrate my database to another server where I have SQL Server Express 2005.
View 1 Replies View RelatedI have a mobile device application using mobile sql 2005 replicating with sql 2000 in a x86 environment. This works fine!
I'm having issues getting this to work under Windows Server 2003 X64.
I've got all the components installed under the X64 environment including CLR 2.0 X64 and the mobile sql tools. the but when I run the Configure Web Synchronization Wizard I get the following error. SQL Server 2005 Mobile Edition Server Tools were not found on the IIS server. Run the SQL Server 2005 Mobile Edition Server Tools installer....
My question is: Were do I get the X64 version of these tools?
sqlce30setupen.msi
sql2Ken@P4.msi
The SQL environment is X86 as follows: SQL2000 SP4
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Any help would be much appreciated!
I have a two node failover cluster(Active/Passive). I am planning on installing the Report Server database on the failover instance.
Do i need to install RS on both the nodes?
thanks?
Fails on SQL Server Database services with "The SQL server service failed to start". Can't start manually either.
View 3 Replies View Related
Can I install SQL Server 2005 Developer Edition on XP Media Center Edition?
Thanks.
Hi. I've recently installed (not sure about the exact order):
.NET 2.0 Redist Package
.NET 2.0 Framework SDK
Visual C# 2005 EE
Visual C++ 2005 EE
Platform SDK (Windows Server 2003 R2)
Directx 9 SDK
I just want to start my way up with C# initially. I've been watching some lessons and I'm trying to use some SQL features of Visual Studio EE. Whenever I try to create a SQL item in my project list, I get the following error message box:
Connections to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component, or download from the URL:...
I got the SQL 2005 Express from MS' website, only to get this during (everything set to default) installation:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
I've read through every thread I can find, but can't find an answer for this.
The installation gets all the way to the end, and then stops. I receive the following error message:
"Microsoft SQL Server 2005 Setup has encountered a problem and will end..."
I've tried all the troubleshooting tips. I never had any of the beta or prior versions installed, so I'm not sure what the hangup is.
Can anyone please help me with this?
Charlie
Greetz All.
XP Pro SP2. For days I've been trying to install SQL SERVER 2005 EXPRESS EDITION.
Installation gets to around 95% and stops, citing error 2950. I've applied MS Workaround and
provided Full Rights to folder NetworkService (I have no folder named
Protect), to no avail. Any and all help most welcome. Relevant logs follow.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build
2600)
Time : Wed Apr 09 19:59:03 2008
Machine : GEMINI
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log
Machine : GEMINI
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log
Machine : GEMINI
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log
Machine : GEMINI
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log
Machine : GEMINI
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL Server
2005 Setup Log Files" and "Starting SQL Server Manually."
Machine : GEMINI
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL Server
2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
SQL Server Setup failed. %ProgramFiles%Microsoft SQL Server90Setup
bootstrapLOGSummary.txt.
Time : Wed Apr 09 23:15:10 2008
List of log files:
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQL.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Support.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SCC.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_WI.log
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 Setup beginning at Wed Apr 09 19:59:03 2008
Process ID : 2148
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version:
2005.90.3042.0
Running: LoadResourcesAction at: 2008/3/9 19:59:3
Complete: LoadResourcesAction at: 2008/3/9 19:59:3, returned true
Running: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup
Bootstrapxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3, returned true
Running: ValidateWinNTAction at: 2008/3/9 19:59:3
Complete: ValidateWinNTAction at: 2008/3/9 19:59:3, returned true
Running: ValidateMinOSAction at: 2008/3/9 19:59:3
Complete: ValidateMinOSAction at: 2008/3/9 19:59:3, returned true
Running: PerformSCCAction at: 2008/3/9 19:59:3
Complete: PerformSCCAction at: 2008/3/9 19:59:3, returned true
Running: ActivateLoggingAction at: 2008/3/9 19:59:3
Complete: ActivateLoggingAction at: 2008/3/9 19:59:3, returned true
Running: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3
Complete: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2148" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following
restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2008/3/9 19:59:3
Complete: PerformDotNetCheck2 at: 2008/3/9 19:59:3, returned true
Running: InvokeSqlSetupDllAction at: 2008/3/9 19:59:3
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup
Bootstrapsqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [GEMINI]
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 = GEMINI, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = GEMINI, Article = XMLDomDocument, Result = 0 (0x0)
Machine = GEMINI, Article = Processor, Result = 0 (0x0)
Machine = GEMINI, Article = PhysicalMemory, Result = 0 (0x0)
Machine = GEMINI, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = GEMINI, Article = OSVersion, Result = 0 (0x0)
Machine = GEMINI, Article = OSServicePack, Result = 0 (0x0)
Machine = GEMINI, Article = OSType, Result = 0 (0x0)
Machine = GEMINI, Article = AdminShare, Result = 0 (0x0)
Machine = GEMINI, Article = PendingReboot, Result = 0 (0x0)
Machine = GEMINI, Article = IEVersion, Result = 0 (0x0)
Machine = GEMINI, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = GEMINI, Article = COMPlus, Result = 0 (0x0)
Machine = GEMINI, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = GEMINI, Article = MDAC25Version, Result = 0 (0x0)
Machine = GEMINI, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: GEMINI
*******************************************
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: Pending Reboot 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
Article: Edition Upgrade Check, 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'>
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup
Bootstrapsqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2008/3/9 20:0:44, returned true
Running: SetPackageInstallStateAction at: 2008/3/9 20:0:44
Complete: SetPackageInstallStateAction at: 2008/3/9 20:0:45, returned true
Running: DeterminePackageTransformsAction at: 2008/3/9 20:0:45
Complete: DeterminePackageTransformsAction at: 2008/3/9 20:0:45, returned true
Running: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45
Complete: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45, returned true
Running: OpenPipeAction at: 2008/3/9 20:0:45
Complete: OpenPipeAction at: 2008/3/9 20:0:45, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2008/3/9 20:0:45
Complete: CreatePipeAction at: 2008/3/9 20:0:45, 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: 2008/3/9 20:0:45
Complete: PopulateMutatorDbAction at: 2008/3/9 20:0:45, returned true
Running: GenerateRequestsAction at: 2008/3/9 20:0:45
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = -1
SQL_FullText = -1
SQL_SharedTools = 3
SQL_BC_DEP = -1
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 = -1
Connectivity = -1
SQL_Tools90 = -1
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = -1
TOOLS_BC_DEP = -1
SQL_SSMSEE = -1
SQL_Documentation = -1
SQL_BooksOnline = -1
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2008/3/9 20:0:47, returned true
Running: CreateProgressWindowAction at: 2008/3/9 20:0:47
Complete: CreateProgressWindowAction at: 2008/3/9 20:0:47, returned true
Running: ScheduleActionAction at: 2008/3/9 20:0:47
Complete: ScheduleActionAction at: 2008/3/9 20:0: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: 2008/3/9 20:0:48
Installing: sqlsupport on target: GEMINI
Complete: InstallSqlAction.11 at: 2008/3/9 20:2:8, returned true
Running: InstallSqlAction.12 at: 2008/3/9 20:2:9
Installing: sqlncli on target: GEMINI
Complete: InstallSqlAction.12 at: 2008/3/9 20:3:30, returned true
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "sql",
install will be skipped as a result.
Running: InstallSqlAction.21 at: 2008/3/9 20:3:30
Installing: sqlwriter on target: GEMINI
Complete: InstallSqlAction.21 at: 2008/3/9 20:3:36, returned true
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package:
"sql", install will be skipped as a result.
Running: InstallSqlAction.9 at: 2008/3/9 20:3:36
Installing: msxml6 on target: GEMINI
Complete: InstallSqlAction.9 at: 2008/3/9 20:3:39, returned true
Skipped: InstallToolsAction.11
Skipped: Action "InstallToolsAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.12
Skipped: Action "InstallToolsAction.12" was not run. Information reported
during analysis:
No install request found for package: "sqlncli", referred by package:
"tools", install will be skipped as a result.
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.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "tools",
install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run. Information reported
during analysis:
No install request found for package: "BOL", referred by package: "tools",
install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.23
Skipped: Action "InstallToolsAction.23" was not run. Information reported
during analysis:
No install request found for package: "ssmsee", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.9
Skipped: Action "InstallToolsAction.9" was not run. Information reported
during analysis:
No install request found for package: "msxml6", referred by package:
"tools", install will be skipped as a result.
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: 2008/3/9 20:3:39
Installing: sql on target: GEMINI
Failed to install package
Fatal error during installation.
Setting package return code to: 29503
Complete: InstallSqlAction at: 2008/3/9 20:51:2, returned false
Error: Action "InstallSqlAction" failed during execution. Error information
reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported
during analysis:
No install request found for package: "sqlxml4", referred by package:
"tools", install will be skipped as a result.
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: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported
during analysis:
No install request found for package: "tools", 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.
Error: Action "ExposeVistaClusteredResources" failed during execution.
Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the
following condition:
Condition "The Clustered SQL Server instance that hosts is installed."
returned false.
Running: ReportChainingResults at: 2008/3/9 20:51:3
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. :
1067
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
------------------------------------------------------------------------------------------------
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log" to cab file :
"C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGSqlSetup0005.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/3/9 23:15:31
Message pump returning: 1067
2008-04-09 20:49:34.32 Server Microsoft SQL Server 2005 - 9.00.3042.00
(Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2008-04-09 20:49:34.32 Server (c) 2005 Microsoft Corporation.
2008-04-09 20:49:34.32 Server All rights reserved.
2008-04-09 20:49:34.32 Server Server process ID is 2788.
2008-04-09 20:49:34.32 Server Authentication mode is MIXED.
2008-04-09 20:49:34.32 Server Logging SQL Server messages in file
'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2008-04-09 20:49:34.32 Server This instance of SQL Server last reported
using a process ID of 2524 at 4/9/2008 8:42:12 PM (local) 4/9/2008 10:42:12
AM (UTC). This is an informational message only; no user action is required.
2008-04-09 20:49:34.32 Server Registry startup parameters:
2008-04-09 20:49:34.32 Server -d C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLDATAmaster.mdf
2008-04-09 20:49:34.32 Server -e C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLLOGERRORLOG
2008-04-09 20:49:34.32 Server -l C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLDATAmastlog.ldf
2008-04-09 20:49:34.32 Server Command Line Startup Parameters:
2008-04-09 20:49:34.32 Server -m SqlSetup
2008-04-09 20:49:34.32 Server SqlSetup
2008-04-09 20:49:34.32 Server -Q
2008-04-09 20:49:34.32 Server -q SQL_Latin1_General_CP1_CI_AS
2008-04-09 20:49:34.32 Server -T 4022
2008-04-09 20:49:34.32 Server -T 3659
2008-04-09 20:49:34.32 Server -T 3610
2008-04-09 20:49:34.32 Server -T 4010
2008-04-09 20:49:34.34 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2008-04-09 20:49:34.34 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2008-04-09 20:49:34.51 Server Using dynamic lock allocation. Initial
allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is
an informational message only. No user action is required.
2008-04-09 20:49:34.56 Server The time stamp counter of CPU on
scheduler id 1 is not synchronized with other CPUs.
2008-04-09 20:49:34.57 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2008-04-09 20:49:34.57 spid4s Warning ******************
2008-04-09 20:49:34.57 spid4s SQL Server started in single-user mode.
This an informational message only. No user action is required.
2008-04-09 20:49:34.57 spid4s Starting up database 'master'.
2008-04-09 20:49:34.78 spid4s SQL Trace ID 1 was started by login "sa".
2008-04-09 20:49:34.84 spid4s Starting up database 'mssqlsystemresource'.
2008-04-09 20:49:34.89 spid4s The resource database build version is
9.00.3042. This is an informational message only. No user action is required.
2008-04-09 20:49:35.06 spid4s Error: 15209, Severity: 16, State: 1.
2008-04-09 20:49:35.06 spid4s An error occurred during encryption.
2008-04-09 20:49:35.06 spid4s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
I have been through many Forums and newsgroups but I just end up in a loop.
Im trying to install the basic Microsoft SQL Server 2005 Express Edition. Without advanced services, toolkit and management studio.
First of all it incorrectly says I do not have the recommended specifications but I cant work out what I am missing. I have 20GB free HDD space. 1.2Ghz CPU, 512MB RAM, Windows XP Pro SP2. This meets the Minimum and Recommended.
All the other system checks have green ticks so I just igore the warning about recommended specs and continue to install.
The options I change from the default settings are: 'Default Instance', Built in system account: Local Service, 'Mixed mode' with a password.
It installs the following parts successfully:
MSXML6
SQL Setup support files
SQL native Client
SQL VSS Writer
As soon as it tries to install 'SQL server Database Services' it attempts to start MSSQLSERVER but fails. I try to start it manually and again it fails.
I notice that the Service is looking for the file: "C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER"
However the only 2 folders that exist in "C:Program FilesMicrosoft SQL Server" are "90" and "80", the "MSSQL" folder doesnt even exist.
The SQLSetup0001_PCNAME_SQL.log reports:
MSI (s) (50:C0) [11:48:46:170]: Note: 1: 1708
MSI (s) (50:C0) [11:48:46:180]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (50:C0) [11:48:46:220]: Cleaning up uninstalled install packages, if any exist
MSI (s) (50:C0) [11:48:46:220]: MainEngineThread is returning 1603
MSI (s) (50:E0) [11:48:46:220]: Destroying RemoteAPI object.
MSI (s) (50:08) [11:48:46:220]: Custom Action Manager thread ending.
=== Logging stopped: 02/11/2007 11:48:46 ===
MSI (c) (84:6C) [11:48:46:230]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:6C) [11:48:46:230]: MainEngineThread is returning 1603
=== Verbose logging stopped: 02/11/2007 11:48:46 ===
The Windows error signature contains:
EventType : sql90setup P1 : do_sqlshutdownranuinstance P2 : 0x733f
P3 : sqls__service__start P4 : 0x2 P5 : sqlsetuplib_service.cpp@316
P6 : sqlca.dll@2005.90.3042.0 P7 : sqlrun_sql.msi@9.2.3042.00
Bootstrap Contains:
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_PCNAME_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (2) The system cannot find the file specified.
Error Number : 29503
None of these logs seem to point to any solutions. Id be grateful if anyone can suggest something.
Many Thanks
I copied the error I received.
View 4 Replies View RelatedHi,
When I try to install either SQL Server 2005 SP2 or SQL Server 2008 CTP 2 on a trial copy of Windows Server 2008 Web Edition I get no error messages but the SQL engines are not installed. I have been informed that the SQL Server restriction in place for Windows Server 2003 Web Edition is no longer in place for the 2008 version.
http://www.directionsonmicrosoft.com/sample/DOMIS/update/2008/02feb/0208ws2plp.htm
Is this information incorrect?
Hi,
Is it possible to deploy both SQL2000 and SQL2005 on the same server in the production environment?
Is it recommended? Next year we will be deploying a SQL2005 solution and was wondering if we could get away with installing it on the same server as the SQL2000 server, or whether we should put it on another server.
We have up to a maximum of 50 concurrent users.
Thanks.
I have used the tool at this URL
http://msdn.microsoft.com/vstudio/express/support/uninstall/#Tool
and *cannot* get SQL Server 2005 Tools Express Edition CTP to uninstall. I get the following dialog box:
"The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is:Unable to write property into cache flagCommit Unable to write property into cache: "flagCommit" XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned 2."
Any ideas as to how I can work around this ?
I recently (yesterday) installed a fresh copy of Windows XP with Service Pack 2 applied.
I proceeded with Visual Studio 2005 Express Editions installation straight away.
But I cannot install Microsoft SQL Server 2005 Express Edition x86.
I choose to install Microsoft SQL Server 2005 Express Edition x86 component along with every component of visual studio but it simply would not install.
In the end, after the installation of each complete is complete, I simply get an error message saying that Microsoft SQL Server 2005 Express Edition x86 failed to install.
What is the problem?
I am planning to work with replication topic and i have a problem with it.
I have installed a SQL server 2005 standard edition.When i try creating a new publication it comes out with this error
"Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of sql server.
for information about installing replication,see installing replication in sql server books online
Additional information:
Execute permission denied on object 'sp_MS_replication_installed",database'master',owner'dbo'.
(Microsoft SQL server ,Error:229)
I have tried inserting the CD and reinstalling it.but didnt work.
When i tried to Remove sql server from control panel add/remove programs it shows me the following components to be deleted.but then even after restarting my machine i find everything in start->all programs.
what do i need to do??
Please help me.
I'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine.
I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch
I'm doing a named instance using the built-in system account with windows authentication mode.
Is there any COMPLETE guide as to how to work through all these installation problems?
I've gotten same results after about six attempts.
These always install:
SQL Setup Support Files
SQL Native Client
SQL VSS Writer
SQL Server Backward Compatibility Files
SQLXML4
SQL Server Books Online
These always fail:
OCW11
SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components; Books Online
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released?
When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though?
All of the features are green ticked except the OS which has a compatabilty warning (which i expected).
I feel im missing something really simple here....
Cheers
Rob Macnair
Hi,
I am trying to install Outlook 2007 and business contact manager which requiers SQL Server 2005 Express Edition. I did install the Outlook but When it want to install the SQL server for business contact manager it fails to install. It installs the SQL native after that when it wants to install the SQL 2005 it fails here is the error:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information.
Thanks
I am trying to install SQL Server 2005 Express Edition onto my PC on the D: drive. I do not have write privelleges to the C Drive. All I want to do is point the executable to install to another drive like D: or E: etc. Is this possible with SQL Server 2005 Express Edition setup executable file.
Just to let you know I have changed the template.ini file in the source folder to reflect the following (I tried both with and without quotes)
INSTALLSQLDIR="D:Program FilesMicrosoft SQL Server"
And then using command prompt I did the following:
"start /wait setup.exe /qn myini.ini"
and it still doesn't work.