Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.
3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.
Previously, I have installed SQL 2005 developer edition simplyfied chinese successfully. But yesterday, I tried to install mobile client software factory. The installation process create a database as following: Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY ( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory. My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem. The OS of my notebook is XP professional, which is upgraded from XP home edition. I login it using a domain user such as: "my company's domainmyaccount". I found it curiously that although I assign myaccount as an Administrator, it will automaticly changed to "SQL$...." account. I don't know why and when the account property is changed. But everytime, when I found, I will assign myaccount as an Administrator back.
3, Performance Monitor Counter registry key problem. To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed. When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly. I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib, the result is: "Last Counter"=dword:0000149c (11128) "Last Help"=dword:0000149d (11129) Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09 and 004, the result is confusing. I can find counter and help key,but both keys contains really a lot of stuff as: (1) first page of Counter key: 1 1847 2 System 4 Memory 6 % Processor Time 10 File Read Operations/sec 12 (2) first page of Help key: 3 The System performance object consists of counters that apply to more than one instance of a component processors on the computer. 5 The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes. 7 % Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%. 9 % Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time. 11 File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as: "Last Counter"=dword:0000149c (5276) "Last Help"=dword:0000149d (5277) But it also doesn't work.
I have VS 2005 and SQL 2005 Developer ed (OS Vista) installed on my pc. When I uninstall SQL 2005, I encounter an error for SQL Reporting (someting to do with unable to read some file). Since then I am unable to reinstall SQL Reporting or uninstall SQL Reporting. I removed all the files from the directory but still I have not been able to do....Please advice...
Since there is not a method to uninstall SP2 for SQL Server 2005 Express, it is recommended to completely uninstall and then reinstall. I have backed up all databases as well as generated a script to recover username/passwords, is there anything else I should be taking into consideration?
I had to do a system restore to solve some other issues now my SQL Server 2005 doesnt work (SQL Server 2000 on the same machine [diffrent instance] does). I have tried to uninstall with add/remove programs but the instance doesnt appear there. I have tried to use the 'ARPWrapper.exe /Remove' command as described in KB909967 wich also fails. I have also tried to reinstall with no sucess. I also tried uninstalling SQL2000 and removing as many references as I could find, again now joy.
Is there a script somewhere to remove everything (although I would like to try and keep the SQL2000 instance)?
I had SQL Server 2005 Express installed on my computer, but was having problems with it interacting with Visual c++ 2005 Express Edition. I uninstalled both items, but now cannot get SQL Server to reinstall. Everything works fine until the installation gets to the "SQL Server Database Services" portion. At that point, I get a failure stating, "The SQL Server service failed to start. For more information see the SQL Server Books Online topics, 'How To: View SQL Server 2005 Setup Log Files' and 'Starting SQL Server Manually'." Behind this modal dialog box, in the install window, it seems to have stopped at "Running action to shutdown instance(Run As Normal User) RANU instance shutdown in progress: MSSQL$SQLEXPRESS"I have tried everything I can find online about this, including use of the Windows Install Clean Up, Aaron Stebner's blog about how to remove a beta version (http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx), Ttools, and the Visual Studio Uninstall program. I have manually deleted the folder for SQL Server from my Program Files folder, I have deleted all mention of the program from my registry, and yet I still cannot get the darned thing to reinstall. My computer is a Pentium Duo-Core 2 6600, running at 2.4 GHz, with 2GB RAM, 129GB of 279GB hard drive space free , with an NVIDIA GeForce 7600 GS video card. As I say, I had the program running, it just won't reinstall. I am logged on as the one and only user, and I have Administrator priveleges. There have been no changes to the PC aside from removing and trying to reinstall the C++ and SQL Server programs. Can anyone give guidance as to what the heck is going on and what to do?? The haed and tail of my error log is below. I am stuck. Thank you.
Regards,
Andy
=== Verbose logging started: 11/1/2007 11:16:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (1C:1C) [11:16:13:234]: Resetting cached policy values MSI (c) (1C:1C) [11:16:13:234]: Machine policy value 'Debug' is 0 MSI (c) (1C:1C) [11:16:13:234]: ******* RunEngine: ******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (1C:1C) [11:16:13:234]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (1C:1C) [11:16:13:234]: Grabbed execution mutex. MSI (c) (1C:1C) [11:16:13:250]: Cloaking enabled. MSI (c) (1C:1C) [11:16:13:250]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (1C:1C) [11:16:13:250]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (DC:EC) [11:16:13:250]: Grabbed execution mutex. MSI (s) (DC:F0) [11:16:13:250]: Resetting cached policy values MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'Debug' is 0 MSI (s) (DC:F0) [11:16:13:250]: ******* RunEngine: ******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'TransformsSecure' is 0 MSI (s) (DC:F0) [11:16:13:250]: User policy value 'TransformsAtSource' is 0 MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (DC:F0) [11:16:13:250]: File will have security applied from OpCode. MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:e02e41a11dc741be12SetupSqlRun_SQL.msi' against software restriction policy MSI (s) (DC:F0) [11:16:15:781]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is not digitally signed MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (DC:F0) [11:16:15:781]: End dialog not enabled MSI (s) (DC:F0) [11:16:15:781]: Original package ==> c:e02e41a11dc741be12SetupSqlRun_SQL.msi MSI (s) (DC:F0) [11:16:15:781]: Package we're running from ==> c:WINDOWSInstaller46c82d.msi MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2B2EF9D0-3876-4021-8F44-FA294E6D3C36}'. MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (DC:F0) [11:16:15:828]: Detected that this product uses a multiple instance transform. MSI (s) (DC:F0) [11:16:15:828]: MSCOREE already loaded, using loaded copy MSI (s) (DC:F0) [11:16:15:828]: Applying multiple instance transform 'qlRun01.mst'... MSI (s) (DC:F0) [11:16:15:828]: Looking for storage transform: SqlRun01.mst MSI (s) (DC:F0) [11:16:15:828]: Validating transform 'SqlRun01.mst' with validation bits 0x809 MSI (s) (DC:F0) [11:16:15:828]: Transform 'SqlRun01.mst' is valid. . . . Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = c:Program FilesMicrosoft SQL Server90COMResources1033 Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C Property(S): SqlFullTextDefaultPath = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = ANDYSSQLServer2005MSFTEUser$ANDYS$SQLEXPRESS Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1 Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1MSSQL Property(S): FTEStartupType = 0 Property(S): FTEStatus = 3 Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.1 Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQLEXPRESS Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90COM Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90 Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1 Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90 Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90 Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program Files Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS:c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLEXPRESS Property(S): CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYNetworkService Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1 Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): CostingComplete = 1 Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1 Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C} Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C} Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030} Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030} Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS Property(S): OutOfDiskSpace = 0 Property(S): OutOfNoRbDiskSpace = 0 Property(S): PrimaryVolumeSpaceAvailable = 0 Property(S): PrimaryVolumeSpaceRequired = 0 Property(S): PrimaryVolumeSpaceRemaining = 0 Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS Property(S): SqlActionManaged = 3 Property(S): SqlNamedInstance = 1 Property(S): SqlStateManaged = 2 Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS Property(S): SOURCEDIR = c:e02e41a11dc741be12Setup Property(S): SourcedirProduct = {B0F9497C-52B4-4686-8E73-74D866BBDF59} Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {04F4B2AC-58A6-4ADD-98ED-84973C96062A} Property(S): ProductToBeRegistered = 1 MSI (s) (DC:F0) [11:19:42:109]: Note: 1: 1708 MSI (s) (DC:F0) [11:19:42:109]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (DC:F0) [11:19:42:125]: Cleaning up uninstalled install packages, if any exist MSI (s) (DC:F0) [11:19:42:125]: MainEngineThread is returning 1603 MSI (s) (DC:EC) [11:19:42:125]: Destroying RemoteAPI object. MSI (s) (DC:38) [11:19:42:140]: Custom Action Manager thread ending. === Logging stopped: 11/1/2007 11:19:42 === MSI (c) (1C:1C) [11:19:42:140]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (1C:1C) [11:19:42:140]: MainEngineThread is returning 1603 === Verbose logging stopped: 11/1/2007 11:19:42 ===
Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should.
Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0.
Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either.
Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express?
I've got a Windows Server 2003 for Small Business Server. It had got SQL installed. But then SQL was uninstalled. Now I need to put SQL back in, but I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?
I would like to reinstall the enterprise manager of sql server 2000,and i have currently sql server 2000 SP4 installed on it.I googled on it, and read that installation of enterprise manager ispossible from the setup disk, however, this is not possible: it rejectsbecause of the service pack.How can I reinstall enterprise manager, without haveing to uninstallsql completely?ThanksPrem
I had installed SQL Server 2005 for the first time in order to study for the SQL SERVER 2005 Implementation and Maintenance exam. Everything was going ok until I got to the section on Partitions. When I attempted to follow the lessons on partitions, I received an error indicating that the Enterprise Edition was needed for Partitions.
I uninstalled SQL Server and re-installed the Enterprise Edition (MSDN disk). When I re-installed, I was not promopted for a new/default instance name). The old instance that had used for the original installation is presented when I attempt to "Connect to Server." When I select that instance and click Connect, I receive the "Cannot connect to <server name>" error message.
How do I re-establish that instance name or create another default instance?
got problem with uninstallin sql so i ended both sql exe files in Services and Progresses then removed c:program filsmicrosoft sql server manually and some keys about sql in registry
when i reinstall, no problem with SQL setup support files SQL Native Client SQL VVS writer couldnt pass thru the "SQL Server Database Services" Installation
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server æœ?åŠ¡æ— æ³•å?¯åŠ¨ã€‚æœ‰å…³è¯¦ç»†ä¿¡æ?¯ï¼Œè¯·å?‚阅 SQL Server è?”机丛书ä¸çš„主题€œå¦‚何查看 SQL Server 2005 安装日志文件€?å’Œ€œæ‰‹åЍå?¯åЍ SQL Server€?。 ( SQL server services fail to start. For more information ... blah blah blah and Start SQL server manually )
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlShutDownRANUInstance%40sqls%3a%3aService%3a%3aStart%40x422
------------------------------ BUTTONS:
&Retry Cancel ------------------------------
when i goto SQL server Configuration Manager, it says:
MMC could not create the snap-in CLSID: {CA9F8727-31DF-41D2-975C-887D84903967}
Hi, I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,
" Required Component Missing (Dialog box heading)
Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251 "
I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.
I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.
Thanks,
CLN
P.S. I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.
I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:
Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.
Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so....
I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked.
My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error thus halting the install.
My question is, has anyone seen, overcome this problem. I can't believe that this is a bug like error as there would be posts about it all over the interweb.... which there isn't.
Any thoughts.
Mike.
(p.s) I know that I shouldn't really try to amend the collation on a sql server, but I have little choice at the moment :-(
i have a DVD set of Visual Studio 2005 Professional Addition. I copy all of its components on my hard disk and then start downloading Visual Studio 2005 Professional Addition from the folder that i have copied on my hard disk. The installation process installs every think visual studio, .net framework 2.0, parser etc but when it reached to insatll SQL Server 2005 , it displays an error "Microsoft SQL Server 2005 setup has encountered an error and will end" and The following components falied to install " Microsoft SQL Server Express Edition x86". I then uninstall the whole visual studio using autorun and then reinstall it, but the problem remain there. Then i search this issue on net and i found an article according to which, i uninstall visual studio again but now this time i manually uninstall the components by folowing the sequence which is given in the that article. Then i delete all the folders and files from the temp folder and again install the visual studio but the problem still exists. I dun know why it is not installing. Please, if anybody knows the solution, reply me soon.
[Microsoft][SQL Native Client][SQL Server]Login failed for user. the user is not associated with a trusted SQL Server connection
Mixed mode is set in the Server Security properties (SQL Server authenticaion and Windows Authentication).
I searched googled and everyone says set the authentication to mixed mode... It is set to mixed mode so I'm all out of ideas. I think if there was an error in the connection string it would give me a different error right? I dont know I'm all out of ideas, any help will be greatly appreaciated.
I€™m unable to install SQL Server 2005 on Win XP Professional 2002 SP2. I tried both with SQL Enterprise and Express editions nothing works. It seems to be installed but I can not find the management studio. Some one PLZZZZZZZZ suggest what to do in order to get it installed.
I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aWaitForServiceState%40x41d
Hi theres, I have installed SP2 on my server (Window server 2003 and SQl Server 2005 standard Edition both are 64 bit). But when i query SELECT @@VERSION. i got that latest installed SP is SP1.Even i have installed SP2 successfully and interactively then where m wrong(Window server have Sp2)
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
I have deployed some reports on the reporting server, i have noticed that every one in the domain in which the reports are published can access the reports, except one user. when he tries to access the report he got the following error message or the blank report.
"An error occured during report processing"
"can no read the next data row for the data set dataset1".
Although this user has all the roles on the reporiting server kike browser,content manager etc.
I'm trying to set up a transactional replication from SQl Server 2005 to SQl server 2000. The Distributor and the publisher are on our server and the subscription is supposed to be on a SQL 2000 server on a different location. Before upgrading to 2005 I didn't have problems - the replication from 2000 to 2000 was working perfectly.
After I succesfully created the distributor and the publication the first problem that I encountered was that when I tried to create the subscription it was giving me an error that I cannot use an IP to acces the server. I realized to fix that issue by creating an Alias in the SQL Server Configuration Manager for the server where I wanted to create the subscription (a push subscription).
Now when I try to add the subscriber it gives me another message "Execute permission denied on object 'sp_MS_replication_installed', database 'master', owner 'dbo'" - so I cannot create the subscriber.
The user that I use to create the subscriber on the 2000 server is dbo for the subscriber database but it doesn't have rights on the master database. Also I realized that on the 2000 server I still have the old subscription but I cannot delete it - for the same reason - no access on the master database. Before upgrading to 2005 I had the exact same rights on the 2000 server.
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
for some reason my Sql Server has stopped and i am not able to restart it at all, do i have to reinstall the complete SQl Software or is there ne way i can start the MSSQL Server
They are corrupt. I cannot get the odbc driver applet for sql serverto open when I click add and I cannot configure any existing ones. Andthe usage of the drivers fail.Other ODBC drivers work.Does anyone know how to reinstall the SQL Server set of ODBC drivers?MDAC wouldn't install, said it was already at current level.Thanks for any ideas.
Hi,I just unistalled Sql Management Express and now I want to install it again but the installer says the product is already installed,Can somebody help me with this
Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message:
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listing being removed from Add or Remove Programs. Most of the sql server programs are still installed. They can be run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed.
Is a complete reinstall of windows xp, programs and data the only solution? I hate to believe it; but, at this point, I see no other choice.
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €œsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
I am developing an app in VB.Net 2005, and I installed SQL Server 2005 locally on my machine. My app access multiple databases on SQL and has worked like a charm in the past. Today, when I go to access my app, I receive an error when trying to connect to the SQL database.
"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connection"
As I said before, this is a local install and worked fine until today. I checked the services running and Here is what I have:
SQL Server Integration Services - Running SQL Server FullText Search - Stopped SQL Server(SQLEXPRESS) - Running SQL SERVER (MSSQLSERVER) - Stopped <---------- I tried restarting this and it times out SQL Server Analysis Services (MSSQLSERVER) - Stopped SQL Server Reporting Services (MSSQLSERVER) - Stopped SQL Server Browser - Stopped SQL Server Agent (MSSQLSERVER) - Stopped
I am unable to start any of these services... they all time out. Any help would be greatly appreciated!