While trying to install SQL SERVER Standard I receive the following error message " SQL failed to install! (Completed != 1) " The only fix I found online was to remove one of the registry keys which I did. The error still appears. ANY help would be greatly appreciated
View 5 RepliesI am attempting to install SQL Server 2005 on a Server 2003 Enterprise edition SP2 and fully Patched with all critical updates, including .net 3.5 Additional Information, this is on a Virtuial Server.
When I try to install it fails near the beginning and the log file contains the following.
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Mon Mar 24 07:34:15 2008
Machine : X205
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_X205_Support.log
Last Action : InstallFinalize
Error String : The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
Error Number : 2908
====================================================================================
After doing some search engine digging I found some referances to simuilar problems being caused by .net. I tried uninstalling first 3.5, then 3.0 then 2.0sp1, at which point the install worked with only one error that SQL Management studio was unable to register (A bunch of black lines) although the sql installation seems to work. I then reinstalled .net 3.5 (Which also reinstalls 3.0 and updates 2.0 to SP1. Again S!QL seems to be healthy....
My Questions are:
1) is there a better way to do this???
2) If I do it this way do you see any l;ong term problems?
Kay
Hello All,
I am installing SQL Server 2005 Standard Edition for the first time on a Windows 2003 Standard server. I have already configured the system with the pre-req's. I am trying to install the workstation piece of it, and I am getting the following message:
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: -2146232062
Error message: Unknown error 0x80131902
Error description: Configuration section system.transactions/machineSettings could not be created. Machine.config is missing information
I have tried to uninstall and reinstall the software with no luck.
Please Help!!!!
I have an issue with trying to install SQL 2005 standard on my XP machine.
I get an .hta file that is not readable and when I btpass that I get a pop-up message:
please go to the control panel to install and configure system components.
WTH?
PLease assist....
Gene
I'm attempting to install SQL Server 2005 Standard, on my personal PC which isn't on a network, there are no user accounts besides myself, I'm signed-on as admin.
The logs from C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG, all appear successful, although there are many more logs.
When I look under Control Panel/Administrative Tools/Services, I see no service at all for SQL Server.
I attempted to use the SQL Server Surface Area Configuration Tool, which told me no instances of the data-base had been loaded.
I must admit, the install went a bit too fast for me to believe it was correct. I was never even asked for the product-key.
This particular copy, was bundled with Visual Studio 2005 Pro, which was given to me by someone who attended a Microsoft seminar/demo of some sort.
I've never used SQL Server before, and know nothing about it, so I hope I'm posting in the right forum.
Any help would be appreciated, and I can provide listings of any log-file if needed.
Thanxxxxxxxxxx in advance for any replies. I'm studying for MCTS, and am trying to work through ADO.Net Step by Step.
Hello,
I have SQL Server 2000 Developer Edition already installed. Before starting
the SQL Server 2005 Standard setup, I exited the SQL server agent running in
my system tray.
I am logged on as Administrator and no other desktop apps are running. SQL
Server 2005 Setup reports several "Setup failed." error messages after the
install. I am choosing (for now) ONLY the workstation tools and books online
check mark. The installation presents a screen that says that these products
were successfully installed ("Setup finished"):
- MSXML6
- OWC11
- SQL Server Backward-Compatibility Files
However, these items have a red x next to them:
- SQL Server Books Online
- SQL Server Support Files
- SQLXML4
- SQL Native Client
- Workstation Components, Books Online, ...
My Setup log file terminates with a few messages--one of which contains the
words "Configuration failed." (This is the ONLY mention of the word "fail" in
the Setup log--see the excerpt below.)
Any ideas??? I'm stuck without SQL Server 2005 running so this is a
productivity killer for me.
More info: Here is what I have done, to no avail:
1) Installed the OWC11 components using a direct download from Microsoft.
That install worked. But when it runs again from the SQL Server 2005 DVD, it
fails.
2) Logged on not as a user with Admin rights, but as ADMINISTRATOR. Same
results--the SQL Server 2005 Standard setup failed.
3) Installed SQL Server 2005 Express successfully. Afterwards, tried again
to install SQL Server 2005 Standard, and that setup failed.
4) Cleared registry values for SQL Server 2005 under HKLM.../Software as
described in KB article. Also deleted the installation folder ...90. Tried
again to install SQL Server 2005 Standard, and that setup failed.
5) Tried the 180-day trial of SQL Server 2005 Enterprise--to no avail. Same
results.
Found error logs but they did not help me pinpoint the root cause for the
failed installation.
Thank you,
-- Jonathan
SQLSetup0004_zzzzz_SQLNCLI_1.log Excerpt:
============================+
MSI (s) (60:90) [12:01:14:390]: Note: 1: 1729
MSI (s) (60:90) [12:01:14:406]: Product: Microsoft SQL Server Native Client
-- Configuration failed.
MSI (s) (60:90) [12:01:14:406]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (60:90) [12:01:14:406]: MainEngineThread is returning 1603
MSI (s) (60:68) [12:01:14:406]: Destroying RemoteAPI object.
MSI (s) (60:9C) [12:01:14:406]: Custom Action Manager thread ending.
=== Logging stopped: 2/8/2007 12:01:14 ===
MSI (c) (8C:4C) [12:01:14:406]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:4C) [12:01:14:406]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/8/2007 12:01:14 ===
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.
Win 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 Related
I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC.
I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!.
The folder in question is missing.
C:Program FilesMicrosoft SQL ServerMSSQL
The following folders do exist:
C:Program FilesMicrosoft SQL ServerMSSQL.1
C:Program FilesMicrosoft SQL ServerMSSQL.2
I initially suspected this problem was cause by a previous MSDE 2000 installation.
I uninstalled SQL Server 2005 & MSDE 2000.
I re-installed SQL Server 2005. Same problem.
I executed
http://support.microsoft.com/default.aspx/kb/320873
to make sure all registries are removed and manually deleted C:Program FilesMicrosoft SQL Server€™s content
Re-installed SQL Server 2005. Same problem.
I do not know what do in order to get SQL Server 2005 up & running.
All help is greatly appreciated.
Frank
Good Morning
I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.
I have selected the default instance and everything I try results in the error:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Log file says;
--------------------------------------------------------------------------------
Machine : ISAINTERNET
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ISAINTERNET_SQL.log
Last Action : DetectInstanceClash
Error String : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number : 28086
--------------------------------------------------------------------------------
Ian Smith
Hi
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
Thanks
Doug
I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems.
It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64.
I Check all request systems requirements many times and looks ok.
How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express.
Regards
Leandro
Hi all,
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Thank you very much
Tony
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
Any ideas?
Hi,
I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?
Thanks a lot
Haihong
I am getting the following error while attempting to install the Workstation components on my SQL2005 Standard Server.
To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
I know the problem is related to a previous installation of Enterprise Edition on the same server. I have tried deleting all SQL files, and registry keys yet I am still getting the same error.
Any suggestions would be greatly appreciated.
David
I ve been coping with the follwing Error for 2 months , and i desperately need sb helping me out with a practical solution. the error has become a real pain in the neck 4 me .I want to install SQL 2005 standard edition on a vista ultimate however the error appears at almost the end of installation proceess .and the sql server database services fails to be installed on vista????? and doesnt get a check mark. this is the Error:
sQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'computer-nameSQLServer2005MSSQLUser$computer-name$MSSQLSERVER' not found. Check the name again..
Hi,
While I installed on the active node I got the following error: A recently applied update, KB921896, failed to install
After that installation finished , but query the server version I get:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.1399.06 RTM Standard Edition
On the Visual Studion Manager Help About I get 9.00.3042
Error logs are below. Can you please tell me how can I overcome this?
TIA.
I paste here the summary and the hotfix logs of the primary node.
There is also the Redist9_Hotfix_KB921896_SqlSupport.msi.log but it is too long to paste here.
summary.txt:
Time: 07/29/2007 02:46:28.253
KB Number: KB921896
Machine: DB1
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(DB1) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
(DB2) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 STANDARD
Integration Services ENU SP1 9.00.2047.00 x86 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x86
Client Components ENU SP1 9.1.2047 x86 STANDARD
MSXML 6.0 Parser ENU 6.00.3883.8 x86
SQLXML4 ENU 9.00.2047.00 x86
Backward Compatibility ENU 8.05.1704 x86
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3883
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
hotfix log:
I paste here only part of the file were I think I see errors (because the post fails on complete logs)
07/29/2007 02:24:37.934 ================================================================================
07/29/2007 02:24:37.949 Hotfix package launched
07/29/2007 02:24:37.965 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:37.965 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
07/29/2007 02:24:37.965 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:37.965 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
07/29/2007 02:24:37.980 Local Computer:
07/29/2007 02:24:37.980 Target Details: DB1
07/29/2007 02:24:37.980 commonfilesdir = C:Program FilesCommon Files
07/29/2007 02:24:37.980 lcidsupportdir = f:33a341363e4f5937131539f11033
07/29/2007 02:24:37.980 programfilesdir = C:Program Files
07/29/2007 02:24:37.980 programfilesdir_wow = C:Program Files
07/29/2007 02:24:37.980 supportdir = f:33a341363e4f5937131539f1
07/29/2007 02:24:37.996 supportdirlocal = f:33a341363e4f5937131539f1
07/29/2007 02:24:37.996 windir = C:WINDOWS
07/29/2007 02:24:37.996 winsysdir = C:WINDOWSsystem32
07/29/2007 02:24:37.996 winsysdir_wow = C:WINDOWSSysWOW64
07/29/2007 02:24:37.996
07/29/2007 02:24:38.012 Enumerating applicable products for this patch
07/29/2007 02:24:38.027 Found Redist 2005 product definition
07/29/2007 02:24:38.121 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:38.121 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
07/29/2007 02:24:38.121 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:38.121 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
07/29/2007 02:24:40.105 Found Redist 2005 product definition
07/29/2007 02:24:40.137 Found Redist 2005 product definition
07/29/2007 02:24:40.152 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:40.152 Registry: Read registry key value "CommonFilesDir", string value = C:Program FilesCommon Files
07/29/2007 02:24:40.152 Registry: Opened registry key "SOFTWAREMicrosoftWindowsCurrentVersion"
07/29/2007 02:24:40.152 Registry: Read registry key value "ProgramFilesDir", string value = C:Program Files
07/29/2007 02:24:56.168 Found SQL 2005 product definition
07/29/2007 02:25:00.293 Enumeration: Determining QFE level for product instance MSSQLSERVER
07/29/2007 02:25:00.309 Enumeration: Associated hotfix build information not found for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLServr.exe
07/29/2007 02:25:00.309 Enumeration: Found following QFE level for product instance MSSQLSERVER: 1399
...
07/29/2007 02:30:06.090 Locked file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLinnsqlagent90.exe (SQLSERVERAGENT [SQLAGENT90.EXE] - 3284)
07/29/2007 02:30:06.387 Locked file: C:Program Filesmicrosoft sql server90sharedsqlbrowser.exe (SQLBrowser [sqlbrowser.exe] - 1480)
07/29/2007 02:30:58.137 Attempting to pause the 32 bit ngen queue
07/29/2007 02:30:58.902 Installing product: Redist9
07/29/2007 02:30:58.918 Installing instance: Setup Support Files
07/29/2007 02:30:58.934 Installing target: DB1
07/29/2007 02:30:58.934 Installing file: SqlSupport.msi
07/29/2007 02:30:59.027 Copy Engine: Creating MSI install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
07/29/2007 02:30:59.027 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
07/29/2007 02:30:59.027 Registry: Cannot read registry key value "Debug"
07/29/2007 02:31:29.730 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
07/29/2007 02:31:29.746 Registry: Cannot read registry key value "Debug"
07/29/2007 02:31:29.762 Copy Engine: Installed file: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
07/29/2007 02:31:29.762 Installed target: DB1
07/29/2007 02:31:30.027 Installed instance: Setup Support Files
07/29/2007 02:31:30.043 Installed product: Redist9
07/29/2007 02:31:30.043 Installing product: SQL9
07/29/2007 02:31:30.043 Installing instance: MSSQLSERVER
07/29/2007 02:31:30.059 Enumerating passive cluster nodes
07/29/2007 02:31:30.574 Patching available passive node: DB2
07/29/2007 02:31:30.574 Patching passive node: DB2
07/29/2007 02:31:30.590 Waiting for first completed passive node
07/29/2007 02:31:30.934 Task Scheduler: Created remote folder for product instance target \DB2
07/29/2007 02:31:49.387 Task Scheduler: Transferred payload to remote product instance target \DB2
07/29/2007 02:31:49.402 Task Scheduler: Transferred payload to remote product instance target \DB2
07/29/2007 02:31:49.574 Task Scheduler: Error, cannot create scheduled task for product instance target \DB2
07/29/2007 02:31:50.449 Task Scheduler: Removed remote folder for product instance target \DB2
07/29/2007 02:31:50.449 Error, remote process failed for product instance target
07/29/2007 02:31:50.449 Exit code for passive node: DB2 = 1603
07/29/2007 02:31:50.590 The following exception occurred: No passive nodes were successfully patched Date: 07/29/2007 02:31:50.590 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 3422
07/29/2007 02:31:51.449 Watson: Param1 = Unknown
07/29/2007 02:31:51.465 Watson: Param2 = 0x2b01
07/29/2007 02:31:51.465 Watson: Param3 = Unknown
07/29/2007 02:31:51.465 Watson: Param4 = 0x0
07/29/2007 02:31:51.465 Watson: Param5 = instance.cpp@3422
07/29/2007 02:31:51.465 Watson: Param6 = Unknown
07/29/2007 02:31:51.480 Watson: Param7 = SQL9
07/29/2007 02:31:51.480 Watson: Param8 = Hotfix@
07/29/2007 02:31:51.480 Watson: Param9 = x86
07/29/2007 02:31:51.480 Watson: Param10 = 3042
07/29/2007 02:31:51.480 Installed product: SQL9
07/29/2007 02:31:51.480 Installing product: DTS9
07/29/2007 02:31:51.496 Installing instance: Integration Services
07/29/2007 02:31:51.496 Installing target: DB1
07/29/2007 02:31:51.512 Installing file: sqlrun_dts.msp
07/29/2007 02:31:51.512 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
...
Trying to install SQL Server 2005 Standard on a pc with Windows xp pro spII with Visual Studio 2005 pro installed.I receive an error after 2/3 of the setup time.This is the error: Linkid: 20476Product name Microsoft SQL ServerProduct version 9.00.1399.06Message source Setup.rllMessage id 50000EvtType packageengineinstallpackageaction
View 10 Replies View RelatedWhen I was using
winXP Pro I installed a copy of SQL Server Standard and had it working correctly with Windows authenication logon. I subsequently upgraded to Windows Vista business edition. I also upgraded to SQL Server sp2. Now I get the dreaded "SQL Server, Error: 18456" when trying to connect to the instance of SQL server on my machine. On solution seems to be to login to the original instance and use a stored procedure to update subsequent instances of SQL server.
My subsequent instance is my original instance with the new OS. I do not have a clue how to edit registry entries or any othe methods of overcoming this problem. Anyone have a solution that I could use? Help would be very much appreciated.
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
string myConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
stringmyConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
No Firewall
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.
View 4 Replies View RelatedI have SQL Express 2005 with Advanced Services on a development box that I also want to have installed side-by-side with SQL Server 2005 Standard Edition so I can develop apps using either edition based on the features I need (or don't need). From what I understand from sifting through other posts is that side-by-side installs of these two editions is supported and I should setup a named instance for each edition (SQLEXPRESS for the express edition and MSSQLSERVER for the standard edition). Is this setup accurate or is there another/better way?
Also, does anybody know if side-by-side installations of Reporting Services is also supported? If I install SQL Server 2005 Standard Edition with Reporting Services, will there be two different report servers running in IIS? Since there are different features in Reporting Services between the two editions, I'm not sure how side-by-side installations will effect one another.
Thanks in advance for any help,
Tony
I am attempting to install SQL Server 2005 on a Laptop with Windows 2003 Standard Edition.
The installation fails and the File Summary.txt has the following entries:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Time : Fri Nov 30 09:36:53 2007
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Fri Nov 30 09:38:41 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SCC.log
The Log File, SQLSetup0004_<hostname>_Core.log, has the following entries:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 03 08:54:09 2007
Process ID : 2980
C:SAP_CDCD2x86EnterpriseEditionServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/11/3 8:54:9
Complete: LoadResourcesAction at: 2007/11/3 8:54:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9
Loaded DLL:C:SAP_CDCD2x86EnterpriseEditionServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9, returned true
Running: ValidateWinNTAction at: 2007/11/3 8:54:9
Complete: ValidateWinNTAction at: 2007/11/3 8:54:9, returned true
Running: ValidateMinOSAction at: 2007/11/3 8:54:9
Complete: ValidateMinOSAction at: 2007/11/3 8:54:9, returned true
Running: PerformSCCAction at: 2007/11/3 8:54:9
Complete: PerformSCCAction at: 2007/11/3 8:54:9, returned true
Running: ActivateLoggingAction at: 2007/11/3 8:54:9
Complete: ActivateLoggingAction at: 2007/11/3 8:54:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2980" returned false.
Running: PerformSCCAction2 at: 2007/11/3 8:54:9
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Complete: PerformSCCAction2 at: 2007/11/3 8:54:9, returned true
Running: PerformDotNetCheck at: 2007/11/3 8:54:9
Complete: PerformDotNetCheck at: 2007/11/3 8:54:9, returned true
Running: ComponentUpdateAction at: 2007/11/3 8:54:9
Complete: ComponentUpdateAction at: 2007/11/3 8:55:6, returned true
Running: DetectLocalBootstrapAction at: 2007/11/3 8:55:6
Complete: DetectLocalBootstrapAction at: 2007/11/3 8:55:6, returned true
Running: LaunchLocalBootstrapAction at: 2007/11/3 8:55:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1605
Aborting queue processing as nested installer has completed
Message pump returning: 1605
Regards
Hi all,Not sure where to post this but hopefully here...I am trying to install SQL Server 2005 on my laptop - It installed fine on a desktop PC but on the laptop I get"The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine JBXEL Error:2147749896 (0x80041008). For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342(No answers on this link!)"I Have spent the last week Googling this and have tried everything to fix it bar re-install Windows (XPPro SP2)I have run bat scripts, re-reged dlls and .exe files and much more but to no avail.One poster mentioned that in his case it was something to do with the windows firewall.I notice that under the advanced tab in my wirewall dialogue it says that the local connection is corrupt (or something similar)Could this be part of the problem?All help gratefully received.Cheers,j
View 4 Replies View RelatedI'm getting the below error after installing SQL server with new instant name in exsiting SQL server 2000.
Could you provide me workaround if you have faced same kind of issue?.
Erorr:
Application popup: DTSRun.exe - Unable To Locate Component : This application has failed to start because SqlResourceLoader.dll was not found. Re-installing the application may fix this problem.
Hi,
I'm having problem installing the Database Server on Windows XP (home).
It shows "Internal Error. Contact Microsoft Technical Support" when I clicked on the "Install Database Server". I'm using SQLServer 2000 Developer Edition. I have already enabled Named Pipes and TCP/IP.
But I can get through the setup screen of "Analysis Services" and "English Query" without any problem. I haven't install Analysis Services or English Query. Do I have to install other software (like the "Analysis Services" or "English Query") before installing the "Database Server"?
Please help..
Thank you.
Here's the summary:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Professional (Build 6000)
Time : Tue May 15 12:24:12 2007
Machine : RJMHOME2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : RJMHOME2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : RJMHOME2
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : RJMHOME2
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : RJMHOME2
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : RJMHOME2
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 : RJMHOME2
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_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
--------------------------------------------------------------------------------
And here is part of the SQL.log file around the error:
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Tue May 15 12:26:33 2007
<Func Name='InstallMOF'>
MOF data compiled from c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlwep-xp.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:756]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:757]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\.
ootMicrosoftSqlServerServerEventsSQLEXPRESSc:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlwep-xp.mof)
MSI (s) (24:00) [12:26:33:758]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
MSI (s) (24:00) [12:26:33:791]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA))
MSI (s) (24:30) [12:26:33:794]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3B2A.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Tue May 15 12:26:33 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEvents
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:843]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:843]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD))
MSI (s) (24:14) [12:26:33:846]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3B69.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Tue May 15 12:26:33 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:890]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:890]: Executing op: ProgressTotal(Total=4,Type=1,ByteEquivalent=1300000)
MSI (s) (24:00) [12:26:33:891]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (24:00) [12:26:33:961]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:33:962]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLDatamssqlsystemresource.mdf0)
MSI (s) (24:00) [12:26:33:963]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:163]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLDatamssqlsystemresource.mdf0)
MSI (s) (24:F0) [12:26:34:166]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3CA2.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:200]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:296]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLDatamssqlsystemresource.ldf0)
MSI (s) (24:00) [12:26:34:297]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:320]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLDatamssqlsystemresource.ldf0)
MSI (s) (24:74) [12:26:34:323]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3D3F.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:355]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:356]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.ldf0)
MSI (s) (24:00) [12:26:34:357]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:384]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.ldf0)
MSI (s) (24:54) [12:26:34:387]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3D7F.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:421]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:422]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.mdf0)
MSI (s) (24:00) [12:26:34:423]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:480]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.mdf0)
MSI (s) (24:B0) [12:26:34:483]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3DDD.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:498]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:499]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server81054800lpc:RJMHOME2SQLEXPRESS)
MSI (s) (24:00) [12:26:34:500]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (24:00) [12:26:34:542]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (24:CC) [12:26:34:546]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3E1D.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue May 15 12:26:34 2007
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue May 15 12:26:34 2007
Service failed unexpectedly (2)
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 2
MSI (s) (24!1C) [12:26:45:369]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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.
.
MSI (c) (04:4C) [12:26:37:880]: Entering MsiProvideComponentFromDescriptor. Descriptor: ']gAVn-}f(ZXfeAR6.jiHandWritingFiles>RMn1s[Rh9@Iqc3L`JQB,, PathBuf: 2CE77F0, pcchPathBuf: 2CE77EC, pcchArgsOffset: 2CE774C
MSI (c) (04:4C) [12:26:37:880]: Machine policy value 'DisableUserInstalls' is 0
MSI (c) (04:4C) [12:26:37:889]: MsiProvideComponentFromDescriptor is returning: 0
Error 29503. 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.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue May 15 12:26:45 2007
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue May 15 12:26:45 2007
Service failed unexpectedly (2)
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 2
MSI (s) (24!1C) [12:26:47:322]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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.
.
MSI (c) (04:4C) [12:26:46:556]: Entering MsiProvideComponentFromDescriptor. Descriptor: ']gAVn-}f(ZXfeAR6.jiHandWritingFiles>RMn1s[Rh9@Iqc3L`JQB,, PathBuf: 2CE77F0, pcchPathBuf: 2CE77EC, pcchArgsOffset: 2CE774C
MSI (c) (04:4C) [12:26:46:558]: MsiProvideComponentFromDescriptor is returning: 0
Error 29503. 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.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue May 15 12:26:47 2007
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue May 15 12:26:47 2007
Service failed unexpectedly (2)
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 301
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 2
MSI (s) (24:68) [12:27:00:359]: I/O on thread 4804 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 1820 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 4840 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5020 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5272 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 4780 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5128 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 6080 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 468 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5596 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5632 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 1356 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5800 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 1072 could not be cancelled. Error: 1168
MSI (s) (24:68) [12:27:00:359]: I/O on thread 5836 could not be cancelled. Error: 1168
MSI (s) (24!1C) [12:27:00:360]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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 29503. 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.
.
<Failure Type='Fatal' Error='2'>
<EndFunc Name='LaunchFunction' Return='2' GetLastError='203'>
Hi,
I am trying to install the sql 2005, the install goes through like it supposed to, when i click "Finish" it goes off with a message box :
" there was an unexpected failiure during the setup wizard. You may review the setup logs and/or click the help button for more info".
the info is:
LinkID: 20476
Product Name: MS SQL Server
Product ver: 9.00.1399.06
message source: setup.rll
message ID: 50000
EvtType: setupsqlsetupactions.cpp@InvokeSqlSetupDllAction@sqls::InvokeSqlSetupDllAction:erform@0x2
the yes button opens a link:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40InvokeSqlSetupDllAction%40sqls%3a%3aInvokeSqlSetupDllAction%3a%3aperform%400x2
and it says " were sorry there is no additional info about this error"
I am running on Win XP pro sp2.
COULD ANYONE PLEASE HELP ME???
must install sql server!!
THANX!!
Uri.
I uninstalled SQL Server Express 2005 and SQL Server 2005 from my laptop PC. I then tried to install SQL Server 2005 Developer on my PC and got the following message in my summary file:
Machine : MVANZANT-XP
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_MVANZANT-XP_SQL.log
Last Action : SetUnattendedSvcAccountProp
Error String : SQL Server Setup has determined that the following account properties are not specified: 'SQLACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
Error Number : 28006
Does anyone have any ideas on what I need to do to get a good install? I have tried repeatedly and it halts in the same place with the same error each time.
Thanks!
Newbie in need of help
Hay,
I have a problem to in stall my SQL database services.
I use the Microsoft SQL server 2005 on a Microsoft small business server 2003 system.
My system configuration check is oke and i have no problems to install the other services(Analysis,Reporting,Notification and Intergration).
When i install the SQL database services i have this error:
(Error attempting to read from the source install database,
d:windowsinstall7b027f.msi).
thanks
I have a laptop with 512Mb RAM, about 4Gb available disk space, processor Intel Pentium 1.4GHz. The O/S is Microsoft XP Professional. As I understand the info given on the SQL Server Express page, it should install under XP Professional.
Now, when I start installation everything seems OK. I get a particularly promising red message informing me that I already have .NET Framework 2.0 installed. However right at the very end I get this message:
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <machine name> Error: 2147746132 (0x80040154). Installation then stops.
I tried one of the solutions suggested (this one:
http://support.microsoft.com/default.aspx/kb/201234 )
which involved searching for these 2 files: Crsdll.dll and Crsapi.dll - but couldn't find them. Nor could I find the Microsoft Site ServerBin directory referred to. Yet allegedly SQL Server 2005 Express does install under XP Professional, so this all seems rather odd. Can anyone out there enlighten me?
I should point out that I have a student edition of MS Visual Studio 2003 connecting to the Northwind database installed, and wonder if this is affecting things. Alternatively, is my machine simply not powerful enough (e.g. insuffcient RAM or something)?
Any suggestions gratefully received! I intend to devote Monday (2nd April & a day off for me) to trying to sort it out myself anyway.