I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check:
- Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.
I looked it up in MSDN and i'm having problems resolving the problem.
How to: Increment the Counter Registry Key for Setup in SQL Server 2005 says I should match the values of "Last Help" and "Last Counter" from these two nodes:
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib]
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09]
However, my Perflib 09 is empty. And i've tried adding values to it but the problem presists.
I'm in the middle of developing a Database for a hospital that measures its audits, inhouse operations, and finance. What we currently have and do everyday is collect data from a large database that is real time with patient data, progess, infomation, etc and dump it into a data warehouse that runs on TSI/Eclipsys. We run reports using a number of programs and dump it into Excel sheets that have charts, reports, etc. This Database for which I'm developing won't come soley from the TSI/Eclypsys source, but this is the only source thats updated regularly. I don't want to have in sync with TSI/Eclipysys in fear that every day when it updates data may be lost, not read, or worse won't be up date if there is a problem. My question is is it possible to run a query from Sequel Server 2005 that will take that data upon request using the reporing features on Sequel Server 2005. i.e. What if I need to run a report on measure B in department 12 from Jan 1-Feb 1, instead of being in sync, can I just write queries to take that information rather than double the data and take up twice the space and trouble. FYI, these datatypes rarely change in the TSI/Eclipsys data warehouse. This sure was long question and didn't intended it to be . Thanks for listening and hope to hear back.
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
The Collect Procedure for the "DTSPipeliner" service in DLL "C:Program FilesMicrosoft SQL Server90DTSBinndtspipelineperf.dll" generated an exception or returned an invalid status. Performance data returned by counter DLL will be not be returned in Perf Data Block. The exception or status code returned is the first DWORD in the attached data.
I have tried to re-register this dll but the error is still there.
i have 2 W2K3 Servers with an SQL 2005 enterprise Cluster. Everything is working fine. We set up a sitescope Server to monitor The SQLs. Everything fine for about 2 months.
But yesterday (nothing changed as i can remember) both SQL Servers get numbers fo Errors with ID 1023 from Perflib. Sitescope gets timeouts while checking VSQL resources, but after a refresh in Sitescope everything is fine again... Where does the 1023 come from and what can I do against it?
Hi...I just installed Sequel Server Express v5 and have a database and tables created. Now trying to create a DSN to connect to the database for my mail server. The mail server and sequel server reside on the same system (windows 2003 server).
I'm choosing a system dsn and have tried local with named pipes, the sequel server name with named pipes and the sequel server name using TCP/IP to connect - they all fail. Not sure what else to do...
I keep encountering this error when I try to install another SQL Server after uninstalling Express: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I've looked up the solution and it says to change the Perflib entry in the register...only I don't seem to have one! this is highly annoying as I can do nothing to remedy the situation. Any ideas?
I'm trying to uninstall Sequel express (RTM) and the uninstallation just stops. no error message, no nothing.
I'm posting my uninstall logs hoping someone has any advice on how to solve this issue.
SQLSetup0014_JUSTIN_SCC.txt
SCCOpenPerformer Added machine: JUSTIN RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: WMIServiceWin32OSWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32OSWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 2 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSLanguage Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: SystemDirectory Property type: 2
Calling add article callback function for article: WMIServiceWin32CompSystemWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32CompSystemWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_ComputerSystem Property name: NumberOfProcessors Property type: 2
Calling add article callback function for article: WMIServiceWin32ProcessorWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32ProcessorWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_Processor Property name: CpuStatus Property type: 2
Calling add article callback function for article: WMIServiceReadRegWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceReadRegWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_REGISTRY DefKey: 0x80000002 Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion Value name: ProgramFilesDir Registry type: 4
Calling add article callback function for article: WMIServiceWin32DirectoryWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32DirectoryWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from Win32_Directory where name='C:\'
Calling add article callback function for article: WMIServiceCIMDataWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceCIMDataWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from CIM_DataFile where name='C:\'
Calling add article callback function for article: XMLDomDocument Callback function returned TRUE Adding Article... Article Id: XMLDomDocument Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION RegisterCallbackFunction registered callback function Callback filter = 0x6
Performing check on local machine JUSTIN Connecting to JUSTIN machine ConnectServer returned 0 (0x0) ConnectServer returned 0 (0x0) Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Creating class instance Win32_ComputerSystem CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0) Enumerating the first class of Win32_ComputerSystem EnumClass of Win32_ComputerSystem returned 0 (0x0) Getting property NumberOfProcessors Get property NumberOfProcessors returned 0 (0x0) Variant value: 1 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property OSLanguage Get property OSLanguage returned 0 (0x0) Variant value: 1033 Getting property SystemDirectory Get property SystemDirectory returned 0 (0x0) Variant value: C:WINNTsystem32 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property SystemDirectory Get property SystemDirectory returned 0 (0x0) Variant value: C:WINNTsystem32 Creating class instance Win32_Processor CreateInstanceEnum Win32_Processor returned 0 (0x0) Enumerating the first class of Win32_Processor EnumClass of Win32_Processor returned 0 (0x0) Getting property CpuStatus Get property CpuStatus returned 0 (0x0) Variant value: 1 Openning namespace \rootdefault GetNamespace \rootdefault returned 0 (0x0) Getting method EnumValues in StdRegProv class GetMethod returned 0 (0x0) Executing method EnumValues in StdRegProv class ExecMethod returned 0 (0x0) Looking for registry type for ProgramFilesDir registry value Registry type for ProgramFilesDir registry value is 1 Getting method GetStringValue in StdRegProv class GetMethod returned 0 (0x0) Executing method GetStringValue in StdRegProv class ExecMethod returned 0 (0x0) Getting registry value ProgramFilesDir Variant value: C:Program Files
Processing article WMIServiceWin32OSWorking Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article WMIServiceWin32CompSystemWorking Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article WMIServiceWin32ProcessorWorking Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article WMIServiceReadRegWorking Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article WMIServiceWin32DirectoryWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article WMIServiceCIMDataWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article XMLDomDocument Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE SccPerformer closed. SCCOpenPerformer Added machine: JUSTIN RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: Processor Callback function returned TRUE Adding Article... Article Id: Processor Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from Win32_Processor
Calling add article callback function for article: PhysicalMemory Callback function returned TRUE Adding Article... Article Id: PhysicalMemory Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from Win32_ComputerSystem
Calling add article callback function for article: DiskFreeSpace Callback function returned TRUE Adding Article... Article Id: DiskFreeSpace Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from CIM_LogicalDisk RegisterCallbackFunction registered callback function Callback filter = 0x6
Performing check on local machine JUSTIN Connecting to JUSTIN machine ConnectServer returned 0 (0x0) ConnectServer returned 0 (0x0)
Processing article Processor Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article PhysicalMemory Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article DiskFreeSpace Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE SccPerformer closed. SCCOpenPerformer Added machine: JUSTIN RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: OSVersion Callback function returned TRUE Adding Article... Article Id: OSVersion Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 2 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: Version Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSType Property type: 2
Calling add article callback function for article: OSServicePack Callback function returned TRUE Adding Article... Article Id: OSServicePack Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 2 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: Version Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: ServicePackMajorVersion Property type: 2
Calling add article callback function for article: OSType Callback function returned TRUE Adding Article... Article Id: OSType Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 4 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSProductSuite Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: SuiteMask Property type: 2 Value: 3 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: Version Property type: 2 Value: 4 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSType Property type: 2
Calling add article callback function for article: iisDep Callback function returned FALSE Skipping Article...
Calling add article callback function for article: AdminShare Callback function returned TRUE Adding Article... Article Id: AdminShare Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_REGISTRY DefKey: 0x80000002 Subkey name: SYSTEMCurrentControlSetServiceslanmanserver Value name: AutoShareServer Registry type: 4
Calling add article callback function for article: PendingReboot Callback function returned TRUE Adding Article... Article Id: PendingReboot Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_REGISTRY DefKey: 0x80000002 Subkey name: SYSTEMCurrentControlSetControlSession Manager Value name: PendingFileRenameOperations Registry type: 4
Calling add article callback function for article: PerfMon Callback function returned FALSE Skipping Article...
Calling add article callback function for article: IEVersion Callback function returned TRUE Adding Article... Article Id: IEVersion Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: select * from CIM_DataFile where Name='C:\WINNT\system32\shdocvw.dll'
Calling add article callback function for article: DriveWriteAccess Callback function returned TRUE Adding Article... Article Id: DriveWriteAccess Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: select * from Win32_Directory where Name='C:\Program Files\Microsoft SQL Server' or Name='C:\Program Files'
Calling add article callback function for article: COMPlus Callback function returned TRUE Adding Article... Article Id: COMPlus Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
Calling add article callback function for article: ASPNETVersionRegistration Callback function returned TRUE Adding Article... Article Id: ASPNETVersionRegistration Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION
Calling add article callback function for article: MDAC25Version Callback function returned TRUE Adding Article... Article Id: MDAC25Version Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION RegisterCallbackFunction registered callback function Callback filter = 0x6
Performing check on local machine JUSTIN Connecting to JUSTIN machine ConnectServer returned 0 (0x0) ConnectServer returned 0 (0x0) Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property OSProductSuite Get property OSProductSuite returned 0 (0x0) Getting property OSType Get property OSType returned 0 (0x0) Variant value: 18 Getting property ServicePackMajorVersion Get property ServicePackMajorVersion returned 0 (0x0) Variant value: 4 Getting property SuiteMask Get property SuiteMask returned 2147749890 (0x80041002) Getting property Version Get property Version returned 0 (0x0) Variant value: 5.0.2195 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property OSType Get property OSType returned 0 (0x0) Variant value: 18 Getting property ServicePackMajorVersion Get property ServicePackMajorVersion returned 0 (0x0) Variant value: 4 Getting property SuiteMask Get property SuiteMask returned 2147749890 (0x80041002) Getting property Version Get property Version returned 0 (0x0) Variant value: 5.0.2195 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property ServicePackMajorVersion Get property ServicePackMajorVersion returned 0 (0x0) Variant value: 4 Getting property SuiteMask Get property SuiteMask returned 2147749890 (0x80041002) Getting property Version Get property Version returned 0 (0x0) Variant value: 5.0.2195 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property SuiteMask Get property SuiteMask returned 2147749890 (0x80041002) Getting property Version Get property Version returned 0 (0x0) Variant value: 5.0.2195 Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 0 (0x0) Getting property Version Get property Version returned 0 (0x0) Variant value: 5.0.2195 Openning namespace \rootdefault GetNamespace \rootdefault returned 0 (0x0) Getting method EnumValues in StdRegProv class GetMethod returned 0 (0x0) Executing method EnumValues in StdRegProv class ExecMethod returned 0 (0x0) Looking for registry type for PendingFileRenameOperations registry value Registry type for PendingFileRenameOperations registry value is 0 Getting method EnumValues in StdRegProv class GetMethod returned 0 (0x0) Executing method EnumValues in StdRegProv class ExecMethod returned 0 (0x0) Looking for registry type for AutoShareServer registry value Registry type for AutoShareServer registry value is 0
Processing article OSVersion Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article OSServicePack Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article OSType Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article AdminShare Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article PendingReboot Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article IEVersion Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article DriveWriteAccess Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article COMPlus Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article ASPNETVersionRegistration Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE
Processing article MDAC25Version Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE SccPerformer closed.
SQLSetup0014_JUSTIN_Core(Local)
Microsoft SQL Server 2005 Setup beginning at Wed Apr 19 11:08:18 2006 Process ID : 2312 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/3/19 11:8:18 Complete: LoadResourcesAction at: 2006/3/19 11:8:18, returned true Running: ParseBootstrapOptionsAction at: 2006/3/19 11:8:18 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/3/19 11:8:18, returned true Running: ValidateWinNTAction at: 2006/3/19 11:8:18 Complete: ValidateWinNTAction at: 2006/3/19 11:8:18, returned true Running: ValidateMinOSAction at: 2006/3/19 11:8:18 Complete: ValidateMinOSAction at: 2006/3/19 11:8:18, returned true Running: PerformSCCAction at: 2006/3/19 11:8:18 Complete: PerformSCCAction at: 2006/3/19 11:8:18, returned true Running: ActivateLoggingAction at: 2006/3/19 11:8:18 Complete: ActivateLoggingAction at: 2006/3/19 11:8:18, returned true Running: DetectPatchedBootstrapAction at: 2006/3/19 11:8:18 Complete: DetectPatchedBootstrapAction at: 2006/3/19 11:8:18, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2312" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2006/3/19 11:8:18 Complete: PerformDotNetCheck2 at: 2006/3/19 11:8:18, returned true Running: InvokeSqlSetupDllAction at: 2006/3/19 11:8:18 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 [JUSTIN] 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. Instance Name = SQLEXPRESS Trying to find install through Instance Name Install Type = 1 If possible, determine action Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.InstallSku Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" Machine = JUSTIN, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = JUSTIN, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = JUSTIN, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = JUSTIN, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = JUSTIN, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = JUSTIN, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = JUSTIN, Article = XMLDomDocument, Result = 0 (0x0) Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.InstallSku Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" Machine = JUSTIN, Article = Processor, Result = 0 (0x0) Machine = JUSTIN, Article = PhysicalMemory, Result = 0 (0x0) Machine = JUSTIN, Article = DiskFreeSpace, Result = 0 (0x0) Machine = JUSTIN, Article = OSVersion, Result = 0 (0x0) Machine = JUSTIN, Article = OSServicePack, Result = 0 (0x0) Machine = JUSTIN, Article = OSType, Result = 0 (0x0) Machine = JUSTIN, Article = AdminShare, Result = 0 (0x0) Machine = JUSTIN, Article = PendingReboot, Result = 0 (0x0) Machine = JUSTIN, Article = IEVersion, Result = 0 (0x0) Machine = JUSTIN, Article = DriveWriteAccess, Result = 0 (0x0) Machine = JUSTIN, Article = COMPlus, Result = 0 (0x0) Machine = JUSTIN, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = JUSTIN, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: JUSTIN ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> Failed to find help file for LCID :1037 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2006/3/19 11:8:30, returned true Running: SetPackageInstallStateAction at: 2006/3/19 11:8:30 Complete: SetPackageInstallStateAction at: 2006/3/19 11:8:30, returned true Running: DeterminePackageTransformsAction at: 2006/3/19 11:8:30 Complete: DeterminePackageTransformsAction at: 2006/3/19 11:8:31, returned true Running: ValidateSetupPropertiesAction at: 2006/3/19 11:8:31 Complete: ValidateSetupPropertiesAction at: 2006/3/19 11:8:31, returned true Running: OpenPipeAction at: 2006/3/19 11:8:31 Complete: OpenPipeAction at: 2006/3/19 11:8:31, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2006/3/19 11:8:31 Complete: CreatePipeAction at: 2006/3/19 11:8:31, 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: 2006/3/19 11:8:31 Complete: PopulateMutatorDbAction at: 2006/3/19 11:8:31, returned true Running: GenerateRequestsAction at: 2006/3/19 11:8:31 SQL_Engine = -1 SQL_Data_Files = -1 SQL_Replication = -1 SQL_FullText = -1 SQL_SharedTools = -1 SQL_BC_DEP = -1 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = -1 Connectivity = -1 SQL_Tools90 = -1 SQL_WarehouseDevWorkbench = -1 SDK = -1 SQLXML = -1 Tools_Legacy = -1 TOOLS_BC_DEP = -1 SQL_Documentation = -1 SQL_BooksOnline = -1 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2006/3/19 11:8:34, returned true Running: CreateProgressWindowAction at: 2006/3/19 11:8:34 Complete: CreateProgressWindowAction at: 2006/3/19 11:8:34, returned true Running: ScheduleActionAction at: 2006/3/19 11:8:34 Complete: ScheduleActionAction at: 2006/3/19 11:8:35, 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. Skipped: InstallSqlAction Skipped: Action "InstallSqlAction" was not run. Information reported during analysis: No install request found for package: "sql", install will be skipped as a result. 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. 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. Skipped: InstallToolsAction.11 Skipped: Action "InstallToolsAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.12 Skipped: Action "InstallToolsAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.18 Skipped: Action "InstallToolsAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.20 Skipped: Action "InstallToolsAction.20" was not run. Information reported during analysis: No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.22 Skipped: Action "InstallToolsAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.9 Skipped: Action "InstallToolsAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "tools", install will be skipped as a result. Skipped: 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: 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. 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: InstallSqlAction.11 Skipped: Action "InstallSqlAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "sql", install will be skipped as a result. Skipped: InstallSqlAction.12 Skipped: Action "InstallSqlAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "sql", install will be skipped as a result. Skipped: InstallSqlAction.21 Skipped: Action "InstallSqlAction.21" was not run. Information reported during analysis: No install request found for package: "sqlwriter", referred by package: "sql", install will be skipped as a result. Skipped: InstallSqlAction.9 Skipped: Action "InstallSqlAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "sql", install will be skipped as a result. Skipped: InstallToolsAction Skipped: Action "InstallToolsAction" was not run. Information reported during analysis: No install request found for package: "tools", install will be skipped as a result. Skipped: 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. Skipped: UninstallForMSDE2000Action Skipped: Action "UninstallForMSDE2000Action" was not run. Information reported during analysis: Action: "UninstallForMSDE2000Action" will be skipped due to the following condition: Condition "Action: InstallSqlAction was skipped." returned true. Skipped: UninstallForSQLAction Skipped: Action "UninstallForSQLAction" was not run. Information reported during analysis: Action: "UninstallForSQLAction" will be skipped due to the following condition: Condition "Action: InstallSqlAction was skipped." returned true. 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: 2006/3/19 11:8:36 Complete: ReportChainingResults at: 2006/3/19 11:8:37, returned true Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result. Message pump returning: 0
Hi, We have recently upsized an access db to a sequel server db. The queries in access have been made into views in sql. ASP will be the front end. We are having problems passing an input from a form into a view. In access the parameter had to match what was selected on the form but sequel doesn't like it. At the moment, for testing purposes, the value has to be hard coded i.e. case_id = 64. Is there anything is ASP that can help? Thank you
I've written a Union query that joins 16 different tables. I need to somehow make this into a permanent view so that i can query directly from excel to extract specific data - i guess i can set up excel to pull straight from this view then ?
I'm used to running excel VB code to SQL via Access (linking access up) but want to cut out the middleman now.
Any ideas ?
An example of the Union Query i have built is below :
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
I have two Win 2003 r2 servers. These are not production servers. They are very lightweight boxes for testing apps. Everything worked find when all was on one svr01 except ... too slow.
- I installed svr02 as member of Domain svc01 ... should I make svr02 a child Domain svr01?
- Currently, I cannot add any kind of data connection via Visual Studio..
hi whenever i install ms sql 2005 express edition, only the configuration manager gets installed. but i need sql query analyzer. can anyyone tell me why it doesnt get installed. also plz let me the what should i do to get query analyzer installed..
Hi: I try to install SQL Server 2005 but it gives warning message. My computer configuration is Pentium III 900 HZ, 512 RAM with operating system windows 2000 Pro and service pack 4 and 10 GB free space. It gives warning on operating system. Also Visual Studio. Net 2005 is already installed on my comupter.
- SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Operating System Minimum Level Requirement (Success) Messages * Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success) Messages * Operating System Service Pack Level Requirement.
This is my first task of installing sqlserver 2005 on 64 bit machine in windows 2003 environment. As a DBA what are the thnigs i need to know for the successful installation of sqlserver 2005 and what the things that are need to be installed along with sqlserver, and what are the accounts to be created like all the things i need to know..
I have to install SQL Server 2005 on SBS Standard 2003. I am already running Sql Server Desktop Engine with three instances: MSSQL$SHAREPOINT, MSSQL$SBSMONITORING, MSSQL$BLUECOAT. I am wondering how the installation is gonna affect my system. I do need SQL Server 2005 for the new financial software which is intalled 2morrow. What shall I put as the instance during the installation. Is Sql Server Desktop Engine gonna be replaced by SQL Server 2005?
i had downloaded .Net and SQL Server 2005 from microsoft site. In SQL Server 2005 after installation i get only Configuration Tools and 3 subtopics. I am able to create table only through . NET but am not able to work independantly with SQL Server 2005. Can anyone advice me!!
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
I trying to Install on Windows XP with Service pack 4, OS.
I am trying to install the Developer Edition of SQL Server 2005 version for which it is not able to load many packages as it says IIS services, Integration Services Etc,. were not installed and if they were ignored then rest will be loaded and thereafter I could not either login or invoke either any.
Can anyone suggest me where it went wrong and what I need to do with instructions.
Unfortunately for me, I am not a DBA - even though I have always filled that role where ever I have been. That being said, I have always been fortunate enough to have someone else more knowledgeable than I to perform the initial build of the SQL Servers I have used and managed. So, I have the following question...
I just finished installing and configuring a new dedicated SQL Server (it is nice too). One of the included discs it he MSDN Library. Do I need to install that too? Is there any reason to or not to install it? I would appreciate any feedback.
At stage: Visual Studio Integrated Development Environment 2005
Coping new files dv_commoner.hxs Directory....... 89818
Last lines in SQLSetup0001_ADH1_PPESku_1.log:
........
MSI (s) (40:C8) [10:32:18:640]: Executing op: ChangeMedia(MediaVolumeLabel=SQLDEV,MediaPrompt=Please insert the disk: Microsoft Visual Studio 2005 Premier Partner Edition - ENU Disk 1,MediaCabinet=1\_1519_RTL_x86_enu_VSCC_Help_Collection.cab,BytesPerTick=32768,CopierType=1,,,SignatureRequired=0,,,IsFirstPhysicalMedia=1) MSI (s) (40:C8) [10:32:18:656]: Executing op: FileCopy(SourceName=92310|dv_commoner.hxs,SourceCabKey=commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8,DestName=dv_commoner.hxs,Attributes=16384,FileSize=89818,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=8.0.50730.10000,Language=1033,InstallMode=58982400,,,,,,,) MSI (s) (40:C8) [10:32:18:656]: File: C:Program FilesCommon FilesMicrosoft SharedDevHelpVSCCv8.0dv_commoner.hxs; To be installed; Won't patch; No existing file MSI (s) (40:C8) [10:32:18:656]: Source for file 'commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8' is compressed
Hi, SQL Server 2005 has been installed on windows server 2003 machine by the support team. Microsoft SQL Server Management Studio 9.00.3042.00 Now this machine has been passed on to me to create databases, tables, etc... On this server, I open the management studio and I get the connect to server windows. What should the entries in the connect to server window be for me to get to the next stage where I can start building databases. At present, I tried local or localhost and windows/sql authentication. Still can not get to the management studio window. Any thoughts please? Thanks
I have a couple of questions reagrding SQL Server 2005 SP2?
1) Do I need to install SP1 and its accumulative hotfixes before applying SP2??
2) Anyone know what is SQL Server 2005 V 9.0.3033?? I saw it in a couple of SQL 2005 servers that suppose to have SP2 installed. I thought SP2's version is 3042??
We have the Windows server 2003 R2 Service PAck 2 , we got updated to this version after i installed automatic updates today,and i am having problems with setting up maintenance plan in SQL server 2005 (9.0.1399)
Hence i am trying to install Sql server 2005 SP1, but the read me file says that this installation is compatible only with Windows server 2003 SP1
Also, i received this error when i tried to install SQL server 2005 SP1 yesterday
"The image file hotfix.exe is valid, but is for a machine type other than the current machine"
I am confused, Can someone help me out in this regard?
I'm trying to re-install the ms sql server 2005 but I keep getting the following message:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. ------------------------------
This is my second time installing the ms sql server. I couldn't create a new database connection using odbc, I constantly got error messages so i decided to install it with windows and sql authentication (earlier i installed it only with windows authentication).
Hello Experts,I have a Windows Server 2003 For Small Business Server SP 2. Is it possible to install SQL Server 2005 on Windows Server 2003? I am intending to switch to SQL Server 2005 from SQL Server 2000 (on Windows Server 2000).Please advice. Thanks in advance.Regards,Suman Ghosh
I have just purchased SQL Server 2005 and a new Dell 2800 server to run it on. I was told by my Dell rep to configure the server with the following drives. 2 - 36GB drives in a RAID 0 (15,000 RPM), 2 - 73GB drives in a RAID 0 (10,000 RPM) and 3 - 146GB drives in a RAID 5 (10,000 RPM). Dell pre-installed the OS on the 36GB drive. I was told to install SQL on the 73GB drives and the data (primarily TIFF images) on the 146GB. The server is a 64bit machine with Windows 2003 Server and 4GB of RAM. I was told to put the transaction logs on a different physical drive that the database to speed the writes. Is this a correct installation? Is there any information on a best practice installation? I have spent about 6 hours on MS and Google trying to find an answer. Thanks for any help you can give. Recap of Dell recommendation:
2 - 36GB Mirrored Drives = OS 2 - 73BG Mirrored Drives = SQL Server 2005 3 - 146GB RAID 5 Drives = Data (Images)
Is this correct? Where should the Transaction Logs Be?
