Mike, I am having the same issue, but a slightly different situation. I installed sql express...then thought I should uninstall and install sql express with advanced services...got the sa login error described in this thread but with error number 29521.
the summary log says this...should I also send you the error log referenced in this log?
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Jan 05 09:59:01 2007
Machine : myname
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQLSupport_1.log
--
Machine : myname
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQLNCLI_1.log
--
Machine : myname
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SqlWriter_1.log
--
Machine : myname
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_MSXML6_1.log
--
Machine : myname
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.
--
Machine : myname
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.
Error Number : 29521
--
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\Setup Bootstrap\LOG\Summary.txt.
Time : Fri Jan 05 10:06:07 2007
List of log files:
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_Core(Local).log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQL.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_Datastore.xml
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_Support.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_Core.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SCC.log
C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_WI.log
c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
I am having a similar problem, I first used the uninstall program which failed, then went to add remove programs finding nothing, then went to windows explorer and deleted what looked to be obvious choices. I still can't get sql express to install - any idea's?
Here are the logs:
Microsoft SQL Server 2005 Setup beginning at Fri Jan 05 10:50:37 2007
Process ID : 4024
c:\eceab003fc301e4e09e53aaa67\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/0/5 10:50:36
Complete: LoadResourcesAction at: 2007/0/5 10:50:36, returned true
Running: ParseBootstrapOptionsAction at: 2007/0/5 10:50:36
Loaded DLL:c:\eceab003fc301e4e09e53aaa67\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/0/5 10:50:37, returned true
Running: ValidateWinNTAction at: 2007/0/5 10:50:37
Complete: ValidateWinNTAction at: 2007/0/5 10:50:37, returned true
Running: ValidateMinOSAction at: 2007/0/5 10:50:37
Complete: ValidateMinOSAction at: 2007/0/5 10:50:37, returned true
Running: PerformSCCAction at: 2007/0/5 10:50:37
Complete: PerformSCCAction at: 2007/0/5 10:50:37, returned true
Running: ActivateLoggingAction at: 2007/0/5 10:50:37
Complete: ActivateLoggingAction at: 2007/0/5 10:50:37, 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__4024" returned false.
Running: PerformSCCAction2 at: 2007/0/5 10:50:37
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
rravech wrote:
Mike, I am having the same issue, but a slightly different situation. I installed sql express...then thought I should uninstall and install sql express with advanced services...got the sa login error described in this thread but with error number 29521.
<snip>
Machine : myname
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0024_myname_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information.
Error Number : 29521
--
Acutally, you don't need to uninstall SQL Express in order to install SQL Express Advanced, it can be directly upgraded, but it's probably too later for that now.
Take a look at the specific log being reference and see what it has to say. Is this a default installation or are you changing any settings when you step through the setup UI? If you're changing anything, please let me know what you're changing.
Mike
|||I am having a similar problem, I first used the uninstall program which failed, then went to add remove programs finding nothing, then went to windows explorer and deleted what looked to be obvious choices. I still can't get sql express to install - any idea's?
Here are the logs:
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
This error indicates that you have a pre-RTM CTP version of Express on your computer that you did not remove correctly. You will need to remove all pre-release software before you can install the released software. Try to remove components from Add/Remove programs first. If that fails, or if nothing is listed, manually remove the product using the product id listed in the log like this:
msiexec.exe /x {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Mike
|||Mike W
Thank you for your answer, I tried doing the msiexec.exe /x {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} but came up with this pop up error message when I did and I am lost.
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is" Failed to read property "Installlds" {"MachineConfiguration","","BEAST"} from cache Unable to write property into cache. IsClustered
Unable to write property in cache:"IsClustered":
XmlRW Error: Failure loading xmlre.dll
CheckAllProcedures() returned:2
Any more ideas?
Thanks
|||Hi mnn,
That one has me stumpt. I would suggest that you post this question into the Setup and Upgrade forum so the folks that specialize in the technology can offer suggestions.
Mike
|||Mike, thanks for getting back to me, you are right, it is too late - I didn't realize you didn't need to uninstall SQL Express...but that being said.
I got around the installation sa login issue by saying switching from windows mode authentication to mixed and putting in a sa login when installing the program and it worked. Not sure where it will affect things down the line...but right now I am testing the software on a local machine - not sure where it will end up.
It was very frustrating and I still don't have an answer, other than my work around. The log said it established an sa but then...lost it somehow...I don't really know and don't want to waste your time trying to figure it out since I got it to work.
Thanks!
Robin
No comments:
Post a Comment