Upgrade From SQL Server 2005 Express To 2005 Enterprise Fails

Dec 29, 2006

Hi

I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition.
(As a Preparation to install SQLServer2005 Service Pack 2 (CTP))

I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).

During the upgrade I get a message saying that ...

.....Your upgrade is blocked because of edition upgrade rules.....

All other components I selected for Installation are propertly installed (Analysis, Reporting)

The setup log contains the following detail information:

---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources

Error Code: 29543
MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142

---- Context -----------------------------------------------

I also tried to explicitly upgrade the OFFICESERVERS instance by executing Setup from the command shell:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=OFFICESERVERS UPGRADE=SQL_Engine SKUU
PGRADE=1 /qb

The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...

Does anybody know about this problem?
Some more information about the system:
W2K3 R2 Enterprise Edition
WSS3.0
MOSS2007
previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)

Kinde regards
Andreas

View 5 Replies


ADVERTISEMENT

Can I Upgrade From Sql 2005 Express To Sql Server 2005 Enterprise Edition ?

Jul 29, 2006

if i upgrade from sql server 2005 expressto sql server 2005 enterprise can i do it ?
am i need to uninstall 2005 express before ?

View 1 Replies View Related

Upgrade From SQL Express 2005 Report Server With Advanced Services To SQL 2005 Standard Fails

Feb 25, 2008

I am trying to upgrade SQL Server Express 2005 Report Server to SQL 2005 Standard and it fails with the following error:

SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting ServicesReportServer
ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.

After I click OK on the message, this whole path where the upgrade is bieng installed dissapears C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting Services. The error is a bit missleading because the file that it is trying to copy rssrvpolicy.config does appear in that upgrade folder so I am not sure why it would try to copy a file that has already been copied.

I was able to upgrade the Database Engine instance fine but can't upgrade Reporting Services due to that error. I have verified that the account that ran the setup had the administrator permissions. Your prompt reply to my question would be greatly appreciatted.

View 4 Replies View Related

Cannot Upgrade SQL Server 2005 Express To SP2 After Upgrading SQL Server 2005 Enterprise To SP2

Feb 18, 2008

How do I upgrade Sql Server 2005 Express to SP2 if I also have SQL Server 2005 Enterprise SP2 already on the same box? I installed Sql Server 2005 Enterprise first, then applied SP2, then installed Visual Studio 2008 (which installed SQL Server 2005 Express).

When I try to upgrade Sql Server 2005 Express to SP2 using the special Express edition of SP2, I get an error message that says "None of the selected features can be installed". I end up having to cancel the install of SP2.

I'm left with SQL Server 2005 at level 9.0.3054 and SQL Server 2005 Express at 9.0.3042. How can I bring SQL Server Express 2005 to the same level as SQL Server 2005 Entperprise?

View 2 Replies View Related

SQL Server 2005 Express Edition SP2 Upgrade Via Microsoft Update Fails

Mar 9, 2007

 

If I search for updates with Microsoft or Windows Update it notifies me to upgrade SQL Server Express to SP2. After the download the installation fails. The reason seems to be that Microsoft Update downloads SP2 with the wrong language:

Summary.txt

**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
Datenbankdienste für Express (SQLEXPRESS)  DEU       SP1    2005.090.2047.00  x86       EXPRESS
Datenbankdienste für Express (SQLExpress)  ENU       SP2                     x86       EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason
Datenbankdienste für Express (SQLExpress)  Für dieses Update ist die Sprache DEU erforderlich (required/me). Bei der Produktinstanz SQLExpress wird die Sprache ENU verwendet. Downloaden (download/me) Sie das Update für ENU.

**********************************************************************************
Summary
     One or more products failed to install, see above for details
     Exit Code Returned: 1627

Thank you.

 

View 7 Replies View Related

SQL Server 2005 Express Edition 2005 - Update Fails

Mar 26, 2008

HI, My computer keeps trying to download SQL Server 2005 Express Edition SP2 and fails with the error code 0x2B22. It is a new computer running with Windows XP Pro.

I have spent hours searching the forums and the internet, but I can't find anything to help, or I don't understand the solutions or whether they relate to my computer. I don't know how to find out why the update is failing either.

Please can someone help!!

Thank you!

View 40 Replies View Related

Connecting To SQL Server Express 2005 Using VB.NET 2005 Fails

Nov 29, 2006

Dear Sir,

We are using VB.NET 2005 (Winform) and the backend SQL Server Express 2005. We would like to connect the Express (.mdf) database from Remote Machine. What type of connection string we have to use?

We tried the following ConnectionString but we got the error:
Provider=SQLNCLI.1;Server=.SQLEXPRESS;AttachDbFileName=S:MLJData.mdf;Database=MLJData;Trusted_Connection=Yes;

Also suggest what are all the prerequisites to run sql server express 2005 database in client machine.

We did installed the following tools in client machine:

1. .NET framework 2.0
2. sqlncli.msi (SQL Server Native Client Setup)

Please provide us the solution for this.

Thanks
M. Gopalan
Sofist India

okugops@hotmail.com

View 3 Replies View Related

SQL Server 2005 Enterprise Eval Upgrade To Licensed Version

Sep 7, 2007



We have been using the 180 day evaluation version and I have my license key now for the purchased version. I read on the Microsoft site I am able to upgrade to the non-trial version without uninstalling the eval version. But it doesn't tell me HOW to do it. I was expecting a menu option, maybe on the About Screen of Management Studio to enter it. (How naive is that?) Is there a simple way to tell the Eval version I am now licensed?

TIA
Chris

View 19 Replies View Related

Upgrading SQL Server 2005 Express To SQL Server 2005 Enterprise Edition

Mar 29, 2007

Hello!! How can I upgrade from SQL Server 2005 Express Edition to SQL Server 2005 Enterprise Edition? I see allot of example of upgrading from SQL Server 2000 to SQL Server 2005, but no example on upgrading from SQL Server 2005 Express to SQL Server 2005 Enterprise or Standard. Is this possible?

View 6 Replies View Related

Upgrade SQL 2005 Standard To SQL 2005 Enterprise

Jun 8, 2006

Hi

we have installed SQL 2005 Standard and we are planning to upgrade to SQL 2005 Enterprise version. Do i need to uninstall SQL 2005 Standard and reinstall Enterprise or i can install SQL 2005 Enterprise on top of standard version to upgrade.

Thanks a lot in advance

View 1 Replies View Related

Upgrade SQL 2005 Standard To SQL 2005 Enterprise

Nov 1, 2007

Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place?

View 4 Replies View Related

Upgrade SQL 2005 Standard To SQL 2005 Enterprise

Nov 1, 2007

Can SQL 2005 32bit Standard edition be upgraded to SQL 2005 32bit Enterprise Edition in-place.

View 12 Replies View Related

Server Slowed After Upgrade To SQL Server Enterprise Edition 2005 32 Bit

Nov 22, 2007


I have upgraded a server with 4 CPU's 1.7 Dual Core AMD opteron.
Running with 16 GB RAM, on windows server 2003 enterprize edition.

and my server has really slowed down ?
An i missing something need urgent help

View 6 Replies View Related

SQL 2005 Express On Server 2k3 Enterprise

Feb 21, 2006

After a few failed installs I have gotten SQL2k5Exp installed. I have update my .net and my XML. I had the server running fine for about a week. The server still 'runs' fine, but when I connect to it with Server managment studio express I can't do anything with it. It will not allow me to expand the 'System Databases' It gives the error:

"Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

Additional information:

An exception occured while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.Express.ConnectionInfo)

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) (Microsoft SQL Server, Error: 109) "

I get just about the same error if I try to attach a database, the only change is the error code at the end.

After this error the SQL server service stops. I can restart it from the Services snap-in, but not inside SMSE. It will start and stop if i try to start it in SMSE.

I also find these types of errors in my event log:

"SQL Server is not ready to accept new client connections; the connection has been closed. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: <local machine>]"

"The SQL Server (SQLEXPRESS) service terminated unexpectedly. It has done this 8 time(s)."

"The SQL Server Active Directory Helper service terminated with service-specific error 3221225572 (0xC0000064)."

Any ideas on this?

View 6 Replies View Related

How To Restore Sql Express 2005 DB In Sql Express Enterprise Edition 2005

Apr 14, 2008

View 2 Replies View Related

How To Upgrade Sql 2005 Dev To Enterprise

Jan 12, 2007

Hey,



I tried the skuupgrade=1 and it appeared to want to install a whole new instance. This operation was supposed to recognise what to upgrade and what instance to do (there is only one). Can some send me some detailed instructions on how to upgrade my sql 2005 developer edition to the enterprise edition?

thanks

Terry

View 3 Replies View Related

The Bane Of Sql 2005 Express... Spending Life Attempting To Upgrade To SQL 2005.

Jan 16, 2008

I am out of brain cells.  I can not figure out how to upgrade instances of sql express to sql 2005 or even add an instance of sql 2005.  I have installed/upgraded everything else (SSMS, etc.) to SQL 2005.
I am dazed and confused.  I don't even know where to start in explaining what I have tried and done.  I have 303 log files going back to 3/27/2007 from various attempts.
Where do I start in figuring this debacle out???

View 7 Replies View Related

How To Upgrade From SQLServer Management Studio Express 2005 To SQL Developer 2005

May 25, 2007

I currently have SQL Server Management Studio Express 2005 and would like to upgrade my machine to SQL Developer 2005 as easily as possible. Keeping my databases and such.



Any recommendations on the best way to do this would be greatly appreciated.



thanks!

View 3 Replies View Related

Upgrade Sql Express SP1 To SQL Server 2005 Standard

Jan 26, 2007

How can I upgrade Sql Express SP1 to SQL Server 2005 Standard ?

View 1 Replies View Related

SQL Server 2005 Express Edition SP2 Upgrade

Mar 12, 2007

Getting error upgrading from SP1 to SP2:

SQL Server Database ServicesConfiguring Components:

The installed has encountered an unexpected error. The error code is 2259. Database: Table(s) update failed

Attached is the section of the SQL setup log where the error occurs:

MSI (s) (70!C4) [10:50:00:107]: PROPERTY CHANGE: Deleting SQLACCOUNT property. Its current value is 'NT AUTHORITYNETWORK SERVICE'.
<Func Name='updateFeatureSellection'>
Attempt to start service when it is already running
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect
sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.
sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.

<Func Name='SqlComponentUpgrade'>
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='111'>
<Func Name='ProcessHeaderTable'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
MSI (s) (70!C4) [10:50:00:417]: Note: 1: 2259 2: 3: 4:
<Func Name='GetFileTargetPath'>
Error Code: 0x8007065b (1627)
Windows Error Text: Function failed during execution.
Source File Name: darlibviewinstaller.cpp
Compiler Timestamp: Wed Jun 14 16:19:22 2006
Function Name: sqls::ViewInstaller::modify
Source Line Number: 137



---- Context -----------------------------------------------


Setting status of unmanaged components and removing unmanaged resources
Failed to modify installer view
1: 2259 2: 3: 4:



Error Code: 1627
MSI (s) (70!C4) [10:52:33:376]: Product: Microsoft SQL Server 2005 Express Edition -- Error 2259. The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed

Error 2259. The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Mon Mar 12 10:52:33 2007
<Func Name='ValidateUpgrade'>
<Func Name='updateFeatureSellection'>
<Func Name='SqlComponentUpgrade'>
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='111'>
<Func Name='ProcessHeaderTable'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='GetFileTargetPath'>
<Func Name='ProcessScriptTable'>
<Func Name='GetFileTargetPath'>
MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2205 2: 3: _sqlSqlUpgradeInstallSequence
MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2228 2: 3: _sqlSqlUpgradeInstallSequence 4: CREATE TABLE `_sqlSqlUpgradeInstallSequence` (`Action` CHAR(255) NOT NULL, `Sequence` INT NOT NULL, `Param` CHAR(0), `Retryable` INT NOT NULL, `Fatal` INT NOT NULL PRIMARY KEY `Action`, `Sequence`)
MSI (s) (70!C4) [10:52:33:506]: Note: 1: 2262 2: _sqlSqlUpgradeInstallSequence 3: -2147287038
<Func Name='GetFileTargetPath'>
MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '310719000'. Its new value: '325719000'.
MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '325719000'. Its new value: '325759000'.
MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '325759000'. Its new value: '325769000'.
MSI (s) (70!C4) [10:52:33:516]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '325769000'. Its new value: '395769000'.
MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '395769000'. Its new value: '576338000'.
MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '576338000'. Its new value: '591338000'.
MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '591338000'. Its new value: '621338000'.
MSI (s) (70!C4) [10:52:33:526]: PROPERTY CHANGE: Modifying Sql_sqlSqlUpgradeInstallSequence property. Its current value is '621338000'. Its new value: '621438000'.
Couldn't find SQL Agent service SQLAgent$SQLEXPRESS. Skipping service stop


Thanks for your help in advance,

Marty

View 1 Replies View Related

SQL 2005 Express Upgrade To SQL 2000 Server

Aug 20, 2007

Hi all,

My question might be a little bit unusual, but is it possible to upgrade SQL 2005 Express (the free version of SQL) to SQL 2000 Server without any loss of functionality?

Where do I have to pay attention to when doing this?

Thanks in advance!

MMQ

View 1 Replies View Related

Upgrade From SQL 2005 Standard To Enterprise

Aug 31, 2006

I'm installing SQL 2005 on a cluster. Currently we do not need the features of enterprise edition, but we may need them in the future. Can you upgrade Standard edition to Enterprise edition (on a cluster)?

View 3 Replies View Related

SQL 2005 Standard To Enterprise Upgrade

Dec 2, 2006

As I found on http://msdn2.microsoft.com/en-us/library/ms143393.aspx its only possible on 32 Bit subsystems and not on native 64 bit - is this true?

In addition is it a complete installations which remains the current configuration? (i guess this because we have to apply all service packs again)?

and at least - is a license upgarde possible or do we have to buy a complete new licence?

Thanks HANNES

View 5 Replies View Related

Sql Server 2005 Express/management &&amp; Enterprise Manager

Apr 16, 2007

I have presently installed on my local computer Enterprise Manager for access to our remote sql server. May I install sql server 2005 express and sql server management studio express on my local computer without causing conflicts with Enterprise Manager?



thanks,

damiata

View 1 Replies View Related

Can We Upgrade From Express 2005 To Standard/Workgroup 2005

Aug 8, 2006

Can we upgrade from Express 2005 to Standard/Workgroup 2005??If possible with what complexities can it be done??

View 1 Replies View Related

SQL Server Express 2005 Fails To Install

Jul 21, 2006

I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require.

Hardware:P4 1.7G CPU,30G HDD space,1G memory


Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Jul 21 15:08:24 2006

Machine : YANGNAN
Product : Microsoft SQL Server 安装程�支�文件(英语)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server VSS 编写器
Product Version : 9.00.2047.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : MSXML 6.0 分�程�
Product Version : 6.00.3883.15
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : SQL Server Database Services
Error : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANGNAN
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQL.log
Last Action : DetectSKUOS
Error String : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online.
Error Number : 28018
--------------------------------------------------------------------------------

View 4 Replies View Related

Install SQL Server Express 2005 Fails: .NET 2.0?

Mar 19, 2008

In C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles SQLSetup0001_MYSERVER_Core(Local).log I have the following error:
=============
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 3
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
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 BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" to cab file : "C:SQLEXPRsetup.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/2/18 18:14:45
Message pump returning: 3
============
The file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" does not exist.

What I've tried so far:
1. Using Add/Remove Programs, uninstall the following:
A. Microsoft SQL Server Native Client
B. Microsoft SQL Server Setup Support Files (English)
C. Microsoft SQL Server VSS Writer
D. Microsoft .NET Framework 2.0 (based on a post elsewhere that this resolved someone else problem)
2. Verified that the following Registry Keys were removed:
A. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer
B. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server
C. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client
(If they were not, I deleted them manually.)

When I was asked to help, the SSE installation had already been attempted 4 times. Part of their resolution attempts had been to install .NET 3.0, but I have not yet re-installed that.
It appears that .NET is still the culprit. Here is some information on the system:
Host Name: MYSERVER
OS Name: Microsoft(R) Windows(R) Server 2003, Standard Edition
OS Version: 5.2.3790 Service Pack 2 Build 3790
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Server
OS Build Type: Multiprocessor Free
Registered Owner: User
Registered Organization: MY LLC
Product ID: 69712-OEM-4411902-02111
Original Install Date: 8/30/2007, 3:29:16 PM
System Up Time: 0 Days, 2 Hours, 1 Minutes, 56 Seconds
System Manufacturer: Dell Computer Corporation
System Model: PowerEdge 840
System Type: X86-based PC
Processor(s): 2 Processor(s) Installed.
[01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
[02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz
BIOS Version: DELL - 1
Windows Directory: C:WINDOWS
System Directory: C:WINDOWSsystem32
Boot Device: DeviceHarddiskVolume2
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (GMT-07:00) Mountain Time (US & Canada)
Total Physical Memory: 4,095 MB
Available Physical Memory: 3,626 MB
Page File: Max Size: 5,976 MB
Page File: Available: 5,665 MB
Page File: In Use: 311 MB
Page File Location(s): C:pagefile.sys
Domain: WORKGROUP
Logon Server: \MYSERVER
Hotfix(s): 79 Hotfix(s) Installed.
[01]: File 1
[02]: File 1
[03]: File 1
[04]: File 1
[05]: File 1
[06]: File 1
[07]: File 1
[08]: File 1
[09]: File 1
[10]: File 1
[11]: File 1
[12]: File 1
[13]: File 1
[14]: File 1
[15]: File 1
[16]: File 1
[17]: File 1
[18]: File 1
[19]: File 1
[20]: File 1
[21]: File 1
[22]: File 1
[23]: File 1
[24]: File 1
[25]: File 1
[26]: File 1
[27]: File 1
[28]: File 1
[29]: File 1
[30]: File 1
[31]: File 1
[32]: File 1
[33]: File 1
[34]: File 1
[35]: File 1
[36]: File 1
[37]: Q147222
[38]: KB933854 - QFE
[39]: Q936181
[40]: IDNMitigationAPIs - Update
[41]: NLSDownlevelMapping - Update
[42]: KB925398_WMP64
[43]: KB937143-IE7 - Update
[44]: KB938127-IE7 - Update
[45]: KB939653-IE7 - Update
[46]: KB942615-IE7 - Update
[47]: KB944533-IE7 - Update
[48]: KB921503 - Update
[49]: KB924667-v2 - Update
[50]: KB925876 - Update
[51]: KB925902 - Update
[52]: KB926122 - Update
[53]: KB927891 - Update
[54]: KB929123 - Update
[55]: KB930178 - Update
[56]: KB931784 - Update
[57]: KB932168 - Update
[58]: KB933360 - Update
[59]: KB933729 - Update
[60]: KB933854 - Update
[61]: KB935839 - Update
[62]: KB935840 - Update
[63]: KB936021 - Update
[64]: KB936357 - Update
[65]: KB936782 - Update
[66]: KB937143 - Update
[67]: KB938127 - Update
[68]: KB941202 - Update
[69]: KB941568 - Update
[70]: KB941569 - Update
[71]: KB941644 - Update
[72]: KB942763 - Update
[73]: KB943055 - Update
[74]: KB943460 - Update
[75]: KB943485 - Update
[76]: KB944653 - Update
[77]: KB946026 - Update
[78]: KB948496 - Update
[79]: XpsEPSC

My next thought is to try this:
http://groups.google.com/group/microsoft.public.windowsupdate/msg/4d76de7769d04493
Does anyone have any better suggestions?
Is the .NET Framework the likely problem here?

TIA,
Brian

View 1 Replies View Related

SQL Server Express 2005 Fails To Install

Jun 22, 2006

I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK.

I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is provided below:


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Jun 22 10:42:08 2006

GLKD2396800 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : GLKD2396800
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : GLKD2396800
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 : GLKD2396800
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 : GLKD2396800
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_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
--------------------------------------------------------------------------------
Machine : GLKD2396800
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time : Thu Jun 22 10:46:19 2006


List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SCC.log
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG

View 17 Replies View Related

MSDE Upgrade To SQL Server 2005 Express Edition SP2

Sep 26, 2007

Hi,

I am trying to upgrade MSDE 2000 to MS SQL Server 2005 Express Edition SP2 (Build 9.00.3042.0) using a silent install.
MSDE on our systems is installed as a standalone product. There is only a single default instance (MSSQLSERVER) running on the system. SQL Authentication mode is being used.
When I try and upgrade MSDE 2000 directly to MS SQL Server 2005 Express Edition SP2, the install fails with an error:

"SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade"

When I try to upgrade the default instance of MSDE to SQL Server 2005 Express Edition SP2 selecting Windows authentication (logging in as a domain/local administrator to the server), the install fails with an error:

"Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user <mydomain><AdminID>"

However, MSDE 2000 upgrade to an earlier version of MS SQL Server 2005 Express Edition (Build 9.00.1399.6) using SA Authentication works successfully without any errors.

So I tried to upgrade our MSDE installation to SQL Server 2005 Express Edition SP2 (Build 9.00.3042.0) as a 2 step process. First by upgrading MSDE to SQL Server 2005 (Build 9.00.1399.6) using SA Authentication which works successfully as mentioned earlier.

However, when I try and upgrade SQL Server 2005 (Build 9.00.1399.6) to SQL Server 2005 SP2 (Build 9.00.3042.0) using SA Authentication, I receive the same error as before:

"SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade"

When I upgrade using Windows Authentication, the setup displays the following error:

"[Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet the requirements of the password filter DLL.. To continue, correct the problem, and then run SQL Server Setup again"

The log file content for the error is:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=01000, level=0, state=1, native_error=0, msg=[Microsoft][SQL Native Client][SQL Server]Signing sps ...
sqlstate=42000, level=16, state=1, native_error=15119, msg=[Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet the requirements of the password filter DLL.
sqlstate=HY000, level=0, state=0, native_error=0, msg=[Microsoft][SQL Native Client]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.
sqlstate=42000, level=16, state=2, native_error=2745, msg=[Microsoft][SQL Native Client][SQL Server]Process ID 51 has raised user error 50000, severity 20. SQL Server is terminating this process.
sqlstate=HY000, level=20, state=127, native_error=50000, msg=[Microsoft][SQL Native Client][SQL Server]Cannot create ##MS_AgentSigningCertificate## in msdb. INSTMSDB.SQL terminating.
Error Code: 15119
MSI (s) (08!80) [10:56:13:133]: PROPERTY CHANGE: Adding SqlUpgradeMessage property. Its value is 'SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet the requirements of the password filter DLL.. To continue, correct the problem, and then run SQL Server Setup again.'.
SQL Server Setup has encountered the following problem:
Failed to execute the Transact-SQL statement:
/**************************************************************/
/* Sign agent sps and ...
Script file: sqlagent90_msdb_upgrade.sql
The error was: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet the requirements of the password filter DLL.. To continue, correct the problem, and then run SQL Server Setup again.
SQL_ERROR (-1) in OdbcHandle::release
sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
SQL_ERROR (-1) in OdbcHandle::release
sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
SQL_ERROR (-1) in OdbcHandle::release
sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
Error Code: 0x80073b0f (15119)
Windows Error Text: Source File Name: libodbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@sqlagent90_msdb_upgrade.sql@967
Source Line Number: 91
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

The registry entries suggest that the version now is 9.00.3042.0. However, I am not sure if the upgrade was successful. I can connect to the database using the old SA user ID and password.

If anyone else has faced similar issues, please let me know the workaround for the same.

Thanks and Regards,
Sahil Girotra



View 3 Replies View Related

MSDE Upgrade To SQL Server 2005 Express Edition SP2

Sep 28, 2007

Hi,

I am planning an upgrade from MSDE to SQL Server 2005 Express Edition SP2 (Build 9.00.3042.0) for our 2000/2K3 Servers. The MSDE installation on our servers is a standalone installation (default instance) and uses Mixed Mode Authentication. When I execute the setup program for upgrade and choose SQL Server Authentication (and enter the corresponding SA user Id password), the setup program displays an error "SQL Server Setup cannot upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade". However, when I select Windows Authentication for the upgrade, the setup program displays an error €œ[Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet the requirements of the password filter DLL.. To continue, correct the problem, and then run SQL Server Setup again€? (Error Code 15119).

I even tried changing the Authentication mode from Mixed Mode to Windows Authentication (by changing the LoginMode registry key value to 1) and running the upgrade using Windows Authentication, but I receive the same error.

1) Is the password policy for SQL Server 2005 Express Edition SP2 different from MSDE or SQL Server 2005 Express Edition (Initial Version), since upgrade from MSDE to SQL Server 2005 Express Edition (Initial Version) worked successfully without any issues.
2) When I am using Windows Authentication for the upgrade, the installer does not prompt me for any password. What password is the installer validating against the password filter DLL? Is there a way to find it out? Also, is it possible to find out what was the reason for the password validation to fail?

I would really appreciate if I could get some answers to all the problems I am facing.

Thanks in Advance.

Regards,
Sahil Girotra

View 1 Replies View Related

MSDE Upgrade To SQL Server 2005 Express Edition SP2

Sep 6, 2007

I have a Windows Server 2000/Windows Server 2003 Environments with MSDE installed (default instance) and SecurityMode is SQL. I want to upgrade from MSDE to SQL Server 2005 Express Edition using a silent install since the number of servers is huge.

I downloaded the latest SQL Server 2005 Express Edition SP2 Version 9.0.3042.0 from http://msdn2.microsoft.com/en-us/express/bb410792.aspx

I am having the following problems:
- When I try to upgrade the default instance of MSDE (MSSQLSERVER) to SQL Server 2005 Express Edition SP2 using the above installer and selecting SQL authentication, the install fails with an error "SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade".
- When I try to upgrade the default instance of MSDE (MSSQLSERVER) to SQL Server 2005 Express Edition SP2 using the above installer and selecting Windows authentication, the install fails with an error "Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user <mydomain><AdminID>

I had earlier tested upgrading the MSDE installation to SQL Server 2005 Express Edition Version 9.00.1399.6 downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en and the upgrade worked successfully using SQL Authentication (SA User and corresponding password), but for some reason it doesn't work when I use the latest version 9.0.3042.0.

Has anyone else faced similar issues. Any tips on how I can upgrade from MSDE to SQL Server 2005 Express Edition SP2 are welcome.

Thanks in Advance.
Sahil Girotra

View 4 Replies View Related

How Upgrade MSDE Database To SQL Express 2005 On Different Server

Jun 21, 2007

I have a database on one server that is running MSDE and I would like to copy it to another server running SQL Server Express.



The process I followed was to create a backup on the first server.

Copy the backup file to the other sever

Then restore using the backed database file on the new server



Is this the right procedure? Everything I see about migrating in on the same server. I do not want to do it on the same server as we are migrating the application to the new server.

View 4 Replies View Related

Upgrade SQL Server Express 2005 To Standard Edition

Aug 23, 2007


I tried to upgrade an Express edition 2005 to Standard Edition 2005. I did remember to use the command prompt setup parameter to allow the upgrade but still the option to upgrade is disabled. Can upgrade from express to standard?

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved