WMI Config Error Installing SQL2k5 Standard Edition

Jan 19, 2007

This is (some of) the output from the Core(Local)log:

If possible, determine action
Machine = DJONES-XP, Article = WMIServiceWin32OSWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32CompSystemWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceWin32ProcessorWorking, Result = 2147500034 (0x80004002)
Machine = DJONES-XP, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = DJONES-XP, Article = WMIServiceWin32DirectoryWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = WMIServiceCIMDataWorking, Result = 70347 (0x112cb)
Machine = DJONES-XP, Article = XMLDomDocument, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: DJONES-XP
*******************************************
Article: WMI Service Requirement, Result: Error
Description: Windows Management Instrumentation (WMI) is not functioning properly. Further checks cannot be performed. Action: Please make sure Windows Management Instrumentation (WMI) is functioning properly.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine DJONES-XP Error:2147500034 (0x80004002).
The checkResult returned is 2147500034
The checkResult for local machine returned by CheckSCCResult is 70036
Setup is unable to proceed because one of scc articles failed. Please address those errors before continuing the setup.

Thanks DeWayne

View 14 Replies


ADVERTISEMENT

WMI Config Error Installing SQL2K5 Standard Edition

Jun 1, 2007

I am dealing with the same issue posted in this other thread that seems to have died with no solution found:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1131407&SiteID=17

Almost as soon as I start to install SQL 2005 on my Windows XP Pro Version 2002 Service Pack 2 machine at work it pops up a dialog with one of the following 2 error messages (they alternate randomly):

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147500034 (0x80004002).

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine PCF092191 Error:2147749907 (0x80041013).

After clicking OK the installation just closes.

I also discovered when I load wmimgmt.msc and click Properties on the WMI Control, I get the following errors on the General tab, AND it does not allow me to click on any other tabs:

Failed to initialize all required WMI classes.
Win32_Processor: <Null>: No such interface supported
Win32_WMISetting: Successful
Security information: Successful
Win32_OperatingSystem: <Null>: No such interface supported

I have been searching online for days and tried doing virtually everything I found that I could understand and nothing works. Reinstalling WMI off the XP CD doesn't work, rebuilding the WMI repository doesn't work, registering all the WMI DLLs and MOF files doesn't work, running all the various scripts to fix WMI that are posted all over online doesn't work.

I downloaded the Microsoft WMI Diagnostics tool and ran it. It printed a ton of errors in a 466-line report that I can't make head or tail of. 6 here, 33 there, 27 over there...almost too many to count. The suggestions it gives to fix them range from vague and incomplete to incomprehensible. I'll paste those error results into a followup post.

I installed the WMI Tools package and can't figure out what to do with any of the tools at all. The only thing I noticed is that when examining a section under Win32_Processor, most entries for various properties are marked <empty>, while I have seen people discussing what I think are those same properties online and talking about seeing stuff typed into theirs (such as the HostingModel having LocalServiceHost typed in and ImpersonationLevel having 1 typed in). But there are so many properties and I'm not sure what should be typed into all of them or if I'm even looking in the right place.

I've seen some suggestions in WMI documentation that not all WMI errors may be related to WMI itself at all, which I think might be the case here, but I don't know. Some material said DCOM may be the problem, but I didn't have much luck figuring out how to fix that either. From the WMI Diagnostics it looks like there may be multiple errors of different kinds, but if it's that bad, I don't know how my computer's been working at all.

I've been using this computer for 9 months and had no major problems with it, although I did have a problem installing Microsoft Windows Genuine Advantage Notification, for which Microsoft sent me a script that fixed it. One other person here at work is suffering from this same WMI error, but most people have been able to install SQL 2005 here with no problem.

My boss does not want me to just do a full XP reinstall. He wants me to identify the specific problem and fix it. If this was my home computer I wouldn't spend so much time banging my head over this incomprehensible problem. But a full reinstall is not really an option for me in this case, unless maybe Microsoft says that's the only way to fix it.

I am available to deal with this issue during 9 to 5 eastern time Monday to Friday.

Thanks in advance for any help...
Eric

View 3 Replies View Related

Error Installing Express Edition With VS2005 Standard

Nov 15, 2005

I've installed VS2005 Standard Edition onto a machine running XP Home

View 11 Replies View Related

Error Installing Standard Edition On A Windows 2003 Server

Jun 17, 2005

I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.

View 4 Replies View Related

Error Installing SQL Server 2005 (32Bit) On A Laptop With Windows 2003 Standard Edition

Dec 3, 2007

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

View 1 Replies View Related

Installing SQL Server 2005 Enterprise Trial Edition And Standard Edition On Same Machine

Jan 22, 2008



Hi
-I have istalled sql server 2005 standard edition , I want to install sql server 2005 enterprise edition on the same machine.
Is it possible? I have Microsoft windows server 2003 SP2 and 1GB RAM.
I want to use partition function with the enterprise edition, will the trial version of sql server work for me?
-If I have already created a database and tables using the standard edition, will I be able to access and use the database using the installed trial version or will I have to start a fresh creating a new database?
- Is it possible to access the same database with any of the installed versions?

BTW, I am prety new to sql server and databases , I am trying to learn by myself

Thanks



View 9 Replies View Related

Installing MSSQL 2000 Standard Edition 32 Bit On A 64 Bit Node

Apr 18, 2008

Would there be any issues with installing an MSSQL 2000 32 bit instance onto a windows 2003 64 bit server?

View 5 Replies View Related

Problems In Installing Sql Server 2000 Standard Edition

May 23, 2007

When i install sql server 2000 i have a message
" Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"

Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist.

What to do now?

I found out that if one has sql server 2000 standard editon the prerequisties are
Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server.


I have windows xp professional version on which i am installing sql server standard edition.
Which of the above exists in my OS. Or which should I download.

Thanks

View 1 Replies View Related

Standard Edition 2005 Not Installing On Dual Processor Quad Core (8 Way)

Feb 27, 2008

hi all,
I was under the impression that SQL Server 2005 can install on dual processor, quad core Intel machines.

Here's what we have: Intel Quad Core Xeon (E7340) @ 2.4Ghz. (8 way)

Has anyone encountered any issues w/ this setup -- particularly on this Intel CPU version?

thank you,
Cosmin

View 3 Replies View Related

Error Upgrading SQL Server 2005 From Standard Edition To Enterprise Edition (x64)

Apr 10, 2008

I am attempting to upgrade a 2005 Standard Edtion to Enterprise Edition. This is a default instance. All components are upgraded successfully except the Database Engine. I receive the following error:


SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it.. To continue, correct the problem, and then run SQL Server Setup again.


This installation does not have encryption enabled, so I do not undersand the error or how to correct it.

After rebooting the SQL instance appears to be upgraded to Enterprise, but it cannot be upgraded to SP2.

Thanks,

View 3 Replies View Related

Installing SQL Server Standard Edition 2005 After Installing SQL Server Express 2005

Feb 14, 2007

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

View 5 Replies View Related

How To Upgrade One Of A Multi-instance SQL2K5 DEVELOPER Versions To Standard Version With SP1 Applied?

Oct 11, 2006

hello we want to evaluate TS foundation server but it says it won't support developer edition sql, only sql2k5 stanard. But now we have DEVELOPER version on our development sql server, DEVDATA1, i.e. instances DEVDATA1DEV, and DEVDATA1QA are both installed on the same sql server box with both SP1 applied.

How can we update DEVDATA1QA to Standard version while still have SP1 applied? we just install Standard CD and then apply SP1 again?

Because this instance is our QA version, before we do something silly, if any of you did that before, any advice would be really helpful.



thanks in advance.

View 1 Replies View Related

Error Installing SQL Server 2000 Developer Edition

Feb 12, 2007

Hello, I hope someone knows the answer to this issue. I am trying to install SQL Server 2000 Developer Edition and once I get to the screen that is asking for the SQL Server instance and Login Information I receive the following error when trying to proceed.

(Report Server database is a different version and cannot be used for this installation)

I have installed reporting services 2000 developer edition many times and I have never seen this error.

View 2 Replies View Related

Error Installing Sql Server 2005 Express Edition

Apr 4, 2007

I am trying to install sql server 2005 express edition.But i get an error stating that



sql server setup unexpectedly failed. For more information review the detup summary log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGsummary.txt



Summary.txt looks like this.It has only these 3 lines of information nothing else other this, which i have seen in many posts.


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600)
Time : Tue Apr 03 22:36:33 2007


I am using windows xp. Probably many of you might have had this problem.Could anyone please provide me with some help.Thanks in advance.

View 3 Replies View Related

Error Encountered While Installing SQL Server Express Edition

Dec 20, 2005

I encountered an error when attempting to install Visual Basic Express Edition RTM. During the setup, I selected MSDN Express Edition and SQL Server 2005 Express Edition. Specifically, the SQL Server 2005 EE part of the installation failed. Here's the error I received:

Visual Basic 2005 Express Edition Setup
Error occurred during setup
Visual Basic 2005 Express Edition has been successfully installed.
The following component failed to install:
Microsoft SQL Server 2005 Express Edition x86

I had not installed any betas on this particular PC; however, I had already installed Visual Studio 2005 Pro and SQL Server 2005 Developer Edition.

(I selected SQL Server EE during the VBEE install because the VBEE readme said that the VSEE Editions (except for VWD) only work with SQL Server EE--so I figured I had to install SQL Server EE if I wanted to do any database work with VBEE. Is that the case?)

The following two log files were the only ones containing any error messages. How should I proceed?

C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core.log:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:40:32 2005
Process ID      : 5824
c:211395ac6e4ed715363fsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/11/19 14:40:31
Complete: LoadResourcesAction at: 2005/11/19 14:40:31, returned true
Running: ParseBootstrapOptionsAction at: 2005/11/19 14:40:31
Loaded DLL:c:211395ac6e4ed715363fxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:40:32, returned true
Running: ValidateWinNTAction at: 2005/11/19 14:40:32
Complete: ValidateWinNTAction at: 2005/11/19 14:40:32, returned true
Running: ValidateMinOSAction at: 2005/11/19 14:40:32
Complete: ValidateMinOSAction at: 2005/11/19 14:40:32, returned true
Running: PerformSCCAction at: 2005/11/19 14:40:32
Complete: PerformSCCAction at: 2005/11/19 14:40:32, returned true
Running: ActivateLoggingAction at: 2005/11/19 14:40:32
Complete: ActivateLoggingAction at: 2005/11/19 14:40:32, returned true
Running: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32
Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5824" returned false.
Running: PerformSCCAction2 at: 2005/11/19 14:40:32
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2005/11/19 14:40:33, returned true
Running: PerformDotNetCheck at: 2005/11/19 14:40:33
Complete: PerformDotNetCheck at: 2005/11/19 14:40:33, returned true
Running: ComponentUpdateAction at: 2005/11/19 14:40:33
Complete: ComponentUpdateAction at: 2005/11/19 14:41:6, returned true
Running: DetectLocalBootstrapAction at: 2005/11/19 14:41:6
Complete: DetectLocalBootstrapAction at: 2005/11/19 14:41:6, returned true
Running: LaunchLocalBootstrapAction at: 2005/11/19 14:41:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706
Aborting queue processing as nested installer has completed
Message pump returning: 1706

C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core(Local).log:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:41:10 2005
Process ID      : 5476
c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/11/19 14:41:9
Complete: LoadResourcesAction at: 2005/11/19 14:41:9, returned true
Running: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9, returned true
Running: ValidateWinNTAction at: 2005/11/19 14:41:9
Complete: ValidateWinNTAction at: 2005/11/19 14:41:9, returned true
Running: ValidateMinOSAction at: 2005/11/19 14:41:9
Complete: ValidateMinOSAction at: 2005/11/19 14:41:9, returned true
Running: PerformSCCAction at: 2005/11/19 14:41:9
Complete: PerformSCCAction at: 2005/11/19 14:41:9, returned true
Running: ActivateLoggingAction at: 2005/11/19 14:41:9
Complete: ActivateLoggingAction at: 2005/11/19 14:41:10, returned true
Running: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10
Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5476" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2005/11/19 14:41:10
Complete: PerformDotNetCheck2 at: 2005/11/19 14:41:12, returned true
Running: InvokeSqlSetupDllAction at: 2005/11/19 14:41:12
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [US05046]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = US05046, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = US05046, Article = XMLDomDocument, Result = 0 (0x0)
Machine = US05046, Article = Processor, Result = 0 (0x0)
Machine = US05046, Article = PhysicalMemory, Result = 0 (0x0)
Machine = US05046, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = US05046, Article = OSVersion, Result = 0 (0x0)
Machine = US05046, Article = OSServicePack, Result = 0 (0x0)
Machine = US05046, Article = OSType, Result = 0 (0x0)
Machine = US05046, Article = AdminShare, Result = 0 (0x0)
Machine = US05046, Article = PendingReboot, Result = 0 (0x0)
Machine = US05046, Article = IEVersion, Result = 0 (0x0)
Machine = US05046, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = US05046, Article = COMPlus, Result = 0 (0x0)
Machine = US05046, Article = ASPNETVersionRegistration, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: US05046
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2005/11/19 14:42:59, returned true
Running: SetPackageInstallStateAction at: 2005/11/19 14:42:59
Complete: SetPackageInstallStateAction at: 2005/11/19 14:43:1, returned true
Running: DeterminePackageTransformsAction at: 2005/11/19 14:43:1
Complete: DeterminePackageTransformsAction at: 2005/11/19 14:43:5, returned true
Running: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5
Complete: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5, returned true
Running: OpenPipeAction at: 2005/11/19 14:43:5
Complete: OpenPipeAction at: 2005/11/19 14:43:5, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2005/11/19 14:43:5
Complete: CreatePipeAction at: 2005/11/19 14:43:5, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2005/11/19 14:43:5
Complete: PopulateMutatorDbAction at: 2005/11/19 14:43:5, returned true
Running: GenerateRequestsAction at: 2005/11/19 14:43:5
 SQL_Engine = 3
 SQL_Data_Files = 3
 SQL_Replication = 3
 SQL_FullText = -1
 SQL_SharedTools = 3
 SQL_BC_DEP = -1
 Analysis_Server = -1
 AnalysisDataFiles = -1
 AnalysisSharedTools = -1
 RS_Server = -1
 RS_Web_Interface = -1
 RS_SharedTools = -1
 Notification_Services = -1
 NS_Engine = -1
 NS_Client = -1
 SQL_DTS = -1
 Client_Components = 3
 Connectivity = 3
 SQL_Tools90 = -1
 SQL_WarehouseDevWorkbench = -1
 SDK = 3
 SQLXML = -1
 Tools_Legacy = -1
 TOOLS_BC_DEP = -1
 SQL_Documentation = -1
 SQL_BooksOnline = -1
 SQL_DatabaseSamples = -1
 SQL_AdventureWorksSamples = -1
 SQL_AdventureWorksDWSamples = -1
 SQL_AdventureWorksASSamples = -1
 SQL_Samples = -1
Complete: GenerateRequestsAction at: 2005/11/19 14:43:11, returned true
Running: CreateProgressWindowAction at: 2005/11/19 14:43:11
Complete: CreateProgressWindowAction at: 2005/11/19 14:43:12, returned false
Error: Action "CreateProgressWindowAction" failed during execution.
Running: ScheduleActionAction at: 2005/11/19 14:43:12
Complete: ScheduleActionAction at: 2005/11/19 14:43:13, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run.  Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run.  Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2005/11/19 14:43:14
Installing: sqlsupport on target: US05046
Complete: InstallSqlAction.11 at: 2005/11/19 14:43:26, returned true
Running: InstallSqlAction.12 at: 2005/11/19 14:43:26
Installing: sqlncli on target: US05046
Complete: InstallSqlAction.12 at: 2005/11/19 14:43:40, returned true
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.21 at: 2005/11/19 14:43:40
Installing: sqlwriter on target: US05046
Failed to install package
Fatal error during installation.
Setting package return code to: 1706
Complete: InstallSqlAction.21 at: 2005/11/19 14:43:50, returned false
Error: Action "InstallSqlAction.21" failed during execution.  Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.9 at: 2005/11/19 14:43:50
Installing: msxml6 on target: US05046
Complete: InstallSqlAction.9 at: 2005/11/19 14:43:54, returned true
Running: InstallToolsAction.11 at: 2005/11/19 14:43:54
Installing: sqlsupport on target: US05046
Complete: InstallToolsAction.11 at: 2005/11/19 14:44:2, returned true
Running: InstallToolsAction.12 at: 2005/11/19 14:44:2
Installing: sqlncli on target: US05046
Complete: InstallToolsAction.12 at: 2005/11/19 14:44:11, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run.  Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run.  Information reported during analysis:
No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.9 at: 2005/11/19 14:44:11
Installing: msxml6 on target: US05046
Complete: InstallToolsAction.9 at: 2005/11/19 14:44:15, returned true
Action "InstallSqlAction" will return false due to the following preconditions:
Condition "Action: InstallSqlAction.21 has finished and failed." returned true.
Installation of package: "sql"  failed due to a precondition.
Step "InstallSqlAction" was not able to run.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallToolsAction at: 2005/11/19 14:44:15
Installing: tools on target: US05046
Complete: InstallToolsAction at: 2005/11/19 14:44:26, returned true
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run.  Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution.  Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000"  failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution.  Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql"  failed due to a precondition.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run.  Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run.  Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run.  Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2005/11/19 14:44:27
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1706
        Error Code: 0x800706aa (1706)
Windows Error Text: The endpoint format is invalid.

  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep  1 22:23:05 2005
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
sqls::HighlyAvailablePackage::manageVsResources
ce: 29539

Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_US05046_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2005/11/19 14:44:52
Message pump returning: 1706

View 2 Replies View Related

Error Installing SQL Server 2005 Developer Edition

Mar 6, 2007

I get the following error installing SQL Server 2005 Developer Edition

Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.

I am installing on Windows XP with Admin privs.

There is nothing listed in COM+ Services for SQL.

The Distributed Transaction Coordinator service is running.

There is a previous installation of SQL 2000 Developer Edition installed.

I have seen some pretty old posts with the same error.

I was wondering if there was a final resolution, service pack, etc. that solves this problem?

View 3 Replies View Related

Installing SQL Server 2005 Standard Edition When Express 2005 Is Already On Server

Sep 30, 2007

I need to install SQL Server 2005 Standard Edition on a new Windows Server 2003 machine that has SQL Server 2005 Express Edition installed by a backup application (Backup Exec). Will I need to uninstall the express edition in order to install the standard edition? Can the two coexist as separate instances or will the standard edition installation simply upgrade the express installation?

Thanks

View 3 Replies View Related

Corrupt Sql.cab File Error While Installing Sql Server 2005 Develooper Edition

Apr 9, 2007

I was successfully able to installing sql server 2005 developer edition all peices except the "Workstation Component, Book Online, Development Tool", the last item in the installation list. It gave errror for bad sql.cab file. Although this developer edition came directly of the box this error came up in many attempts. Upon "Ignore" it gives error 2350.

I am able to run sql server's all the services and able to access it via VS.Net server browser. I can create and change tables etc. but there is no "Management Studio" installed. There is no icon for it either on the desktop or in the Start->SQL Server 2005 menu.

Is it possible to get and copy sql.cab file or entire client component from somewhere else? --Freed download or something? I searched for sql.cab file but it was not in the CD. It could be inside some other file or cmpressed.

Any suggestion.

View 2 Replies View Related

Error Installing KB 921896 (Microsoft SQL Server 2005 Express Edition)

Mar 22, 2008

I receive the error:




Installation Failure

Error Code: 0x734C

Try to install the update again, or request help from one of the following resources.

For self-help options:


Frequently Asked Questions
Find Solutions
Windows Update Newsgroup
For assisted support options:



Microsoft Online Assisted Support (no-cost for issues related to getting updates)


nothing seems to be available for this error.

any ideas?

View 4 Replies View Related

Wots The Difference B/w SQL Server 2005 Standard Edition And Express Edition

Sep 23, 2006

Hello!M a newbie.. I just want to know, that wots the difference b/w SQL Server Standard Edition and Express Edition.?And can I use Visual Studio 2005 (Professional Edition) with SQL Server Express Edition.?

View 1 Replies View Related

Performance Difference Between SQL Server 2005 Standard Edition And Enterprise Edition

Dec 15, 2006

Dear All,We have a database which contains many tables which have millions ofrecords. When We attach the database with MS SQL Server 2005 StandardEdition Server and run some queries (having joins, filters etc.) thenthey take very long time to execute while when We execute same querieson Enterprise Edition then they run 10 times faster than on standardedition.Our database does not use any features which are present in EnterpriseEdition and not present in Standard Edition. We want to know what arethe differences between Standard Edition and Enterprise Edition forperformance. Why should we go for Enterprise Edition when StandardEdition has all the features required.We are presently using evaluation versions of SQL Server 2005 Standardand Enterprise Editions.Thanks and regards,Nishant Sainihttp://www.simplyjava.com

View 23 Replies View Related

Downgrade Path From SQL 2005 Enterprise Trial Edition To Standard Edition

Oct 17, 2007



Hi all--I'm researching the cleanest downgrade path from a trial edition of SQL Server 2005 Enterprise to a licensed Standard Edition copy. It looks like downgrading will entail uninstalling the old version and installing the new version, but I'd like to save the original setup as much as possible. Detaching the old databases will preserve the non-system databases; what method would work best for restoring the system databases?

Thanks!
- Jon

View 1 Replies View Related

Running Advanced Transforms In Enterprise Edition Of SQL Against Standard Edition Databases

Feb 6, 2008

The enterprise edition of SQL server includes some advanced BI features, for example the fuzzy lookup feature of IS. If the IS package lives on an enterprise edition of SQL server and the database the package it is targeting lives on a standard edition of SQL server can the advanced features be used? Can you run a fuzzy look against a database on a standard edition of SQL server when th IS package lives on an enterprise edition of SQL server? THANKS!

View 1 Replies View Related

HELP: Unable To Load SQLBOOT.DLL Following Upgrade From Developer Edition To Standard Edition

Jan 28, 2008

Hi,

I have recently upgraded a SQL x64 server from Developer Edition to Standard Edition, This succeeded without issue. Following a reboot SQL Server yielded the following message


Your SQL Server installation is either corrupt or has been tampered with unable to load SQLBoot.DLL. Please uninstall then re-run setup to correct this issue.

Please can anyone help ?

Many Thanks

Marcus Stuart

View 1 Replies View Related

SQL Server 2005 Workgroup Edition Upgrade To Standard Edition

Feb 8, 2008

I'd like to upgrade from my current SQL Server version: 09.00.3042 (Workgroup edition that comes with SBS upgrade) to the standard edition that I've just purchased. I've attempted to run setup.exe SKUUPGRADE=1 from the command prompt and it just tells me that there's nothing new to install.

I don't really want to uninstall the current installation just to do something that shouldn't be complicated to do, upgrading software versions should not be a difficult process.

Does anybody have any experience with this?

View 9 Replies View Related

Restoring Databases From Enterprise Edition To An Enviroment With Standard Edition

May 23, 2007

I believe it is possible to restore databases from Enterprise edition to an enviroment with Standard edition. We have been able to do it on databases without any partitioned tables. But if a database has partitioned tables it will not start up in the Standard edition after a successful restore. The error log states that the database will not start because partitions are not allowed in Standard edition (which we knew). But we were led to believe that the databases would restore and open fine, the partitions would just not be there in Standard edition. Are we possibly doing something wrong or will this just not work?



Thanks

Chris

View 6 Replies View Related

Can I Run The SQL Server 2005 Developer Edition In Standard Edition Mode?

May 10, 2006

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

View 3 Replies View Related

SSIS Features Comparison Between Enterprise Edition And Standard Edition

Apr 17, 2008

I found so many websites wrote that fuzzy grouping ,fuzzy lookup, term extraction, term lookup,Dimension processing destination adapter and Data mining model training destination adapter only available at Enterprise Edition.
Anyway i still can use these components at Standard Edition.
Is that any features different between these two edition for these components? Thanks

View 3 Replies View Related

Changing From SQL Server 2000 Enterprise Edition To Standard Edition

Feb 26, 2008


Hello all,

Here I need some help or suggestions for the following topic...

I am using SQL server 2000 enterprise edition installed on the machine. Now I wanted to change the edition from enterprise to standard.
There are around 4 user databases exists on the server.
What are the areas I have to take care while doing this? Could I do as normal installation?
No log shipping implemented on the server.

Your suggestions would be very helpful to me.

Thanks in advance.

View 4 Replies View Related

Error - Installing SQL Server Developer Edition 2005 On Vista Home Premium

Apr 17, 2008



Hi,
I have Vista Home premium edition and trying to install SQL Server developer edition 2005 as local administrator. I have already enabled IIS 7 and have Office Ultimate 2007 installed. When I run the set up program, I get a warning titled "Program Compatibility Assistant" that my Operating system may not be compatible with the version of sql server I am installing. It says after setup is complete, I should run SP2 of SQL Server 2005 with 3 buttons as "Check for solutions online", "run this program" and "cancel"...

My question, should I select "run this program" and after the setup completes, download SP2 and apply the patch?

I read some articles in forums that sounds like lot of issues to get sql server working on vista. Can some one direct me to correct options. This is my wife's machine so I dont want to experiment too much and blow her machine away. Please help.

Thanks,
Gaja

View 7 Replies View Related

The Feature(s) Specified Are Not Valid For This Edition Of SQL Server Error When Installing Management Tools On Win 2003 X64

May 23, 2007

I've successfully installed SQL Server 2005 Standard Edition on an Enterprise edition of Windows Server 2003 x64. I'm now (and also tried & failed during the install of the database engine) attempting to install the "Management Tools" component on the same server. However, in all my attempts to do so, I receive the following error:

---

The feature(s) specified are not valid for this edition of SQL Server

---

The message box does not list the features that are not valid but since the only item I've selected to install is the "Management Tools" option under "Client Components" it obviously points to something with that.



Am I missing something or are the Management Tools not supported in my config - most notably SQL Server 2005 Standard edition running on Windows Server 2003 x64?



Thanks.



- Lance

Colorado State University



View 6 Replies View Related

Restoring Master From Enterprise Edition To Standard Edition

Jul 20, 2005

Does anyone know if there are any issues with restoring Master DB ontoa server running Standard Edition from a server running EnterpriseEdition of SQL Server?

View 1 Replies View Related

SQL Statement Execution On Standard Edition Vs Developer Edition

Sep 25, 2007

We have a performance problem with a SQL statement (never completes) on one of our customer€™s sites. They are running SQL Server 2005 Standard Edition with SP2. The server is dual core with 3GB or RAM.

We requested a backup of the database and restored it to a SQL Server 2005 Developer Edition Server with SP2. The server has a single CPU with 2GB or RAM. However the exact same SQL (cut and paste) executes in approx 35 seconds.

We restored the backup of the customers database SQL Server 2005 Standard Edition with SP2. The server is dual core with 2GB or RAM. However as on eth customer site the SQL never completes.

So our question is why is this happening and is there a solution?

Our understanding is that the SQL Server 2005 engine is the same but Developer Edition (aka Enterprise Edition) has additional options.

View 4 Replies View Related







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