Unable To Reinstall SQL Server 2005

Aug 3, 2006

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 NTCurrentVersionPerflib09
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.

View 3 Replies


ADVERTISEMENT

Unable To Reinstall SQL Server 2005

Aug 3, 2006

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 NTCurrentVersionPerflib09
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.

View 1 Replies View Related

Unable To Reinstall Or Uninstall SQL Reporting

Jan 25, 2007

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...

Thanks

Malik

View 1 Replies View Related

Reinstall SQL Server 2005 Express

Apr 18, 2008

 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?

View 4 Replies View Related

Sql Server 2005 - Cannot Reinstall/uninstall

Apr 10, 2008

Hi,

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)?

View 3 Replies View Related

SQL Server 2005 Express Won't Reinstall

Nov 1, 2007

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 ===

View 5 Replies View Related

Can't Uninstall Or Reinstall SQL Server 2005 Dev

Nov 11, 2006

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.

The error info that I'm geting is:

LinkID: 20476

Product Name: Microsoft SQL Server

Product Version: 9.00.2047.00

Message source: setup.rll

Message ID: 50000

EvtType: stateengine
esourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716



I get the same data during setup or uninstall. Neither of which completes.

Needless to say this is driving me nuts. I'm trying to learn VB.NET programming and many of the examples use SQL Server.

Any help would be appreciated.

View 16 Replies View Related

Can't Reinstall Sql Server 2005 Express

Oct 30, 2007

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?

View 11 Replies View Related

How To Reinstall SQL 2005 In Windows Server 2003 For SBS?

Oct 18, 2007

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?

View 3 Replies View Related

Unable To Reinstall Enterprise Manager From Original Disk: Service Pack Rejected

Jun 21, 2006

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

View 4 Replies View Related

Reinstall SQL Server 2005 Problem (cannot Connect To &&<server&&>)

Mar 11, 2007

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?

Regards - Tony



View 1 Replies View Related

Failed To Reinstall SQL 2005 Express After Removing It Manually

Nov 30, 2007



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}

View 1 Replies View Related

Visual Studio 2005 Unable To Connect To SQL Server Express 2005

May 26, 2008

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.

View 3 Replies View Related

Unable To Debug SQL Server 2005 Stored Procedures From Another Workstation Running Visual Studio 2005

Sep 18, 2006

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'.

Any ideas.



Thanks,

View 2 Replies View Related

SQLRUN_SQL.MSI Is Not Valid For Service Pack 1 SQL 2005 Command Line REINSTALL

Jun 28, 2006

Hello,

I have recently tried to run this command line utility for SQL Server 2005 -

"start /wait sqlfodersetup.exe /qb INSTANCENAME=myinstance REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[password] SQLCOLLATION=SQL_Latin1_General_CP1_CI_AI"

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 :-(



View 16 Replies View Related

Reinstall Sql Server 2000

Feb 3, 2008

I need to reinstall on one production server. What steps to be taken before uninstall and install

I am new to SQL Server, please can anyone guide me on this?

View 1 Replies View Related

Unable To Install SQL Server 2005

May 7, 2007

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.
 
Thanks ...
and sorry for my english. 

View 6 Replies View Related

Unable To Connect To SQL Server 2005 Though VBA

May 15, 2008

Hi, I'm not a DBA and our DBA is not available.

I get the following error for my connection string when I try to connect to a specific database on the SQL Server 2005:

Below is the connection string:

cnn = "data source=" & CompanyT & ";driver=VPC-002BALGORD\SQLEXPRESS;AttachDBFilename=" & ArInvoice.FilePath & ";username=sa;password=balgord;Trusted_Connection=no"
SQLdb.Open cnn

I get the following error:

[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.

Thank you.

Regards,

Irena V.

View 1 Replies View Related

Unable To Install SQL Server 2005 On XP

Jul 20, 2007

Hi,

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.

Thanks,
Hari

View 1 Replies View Related

Unable To Install SQl Server 2005 SP2

Mar 31, 2008

Hello,
i cant installthe service pack 2 for sql server 2005.
i get this error code 1063.
what does that mean ?

thank you

View 1 Replies View Related

I Am Unable To Install SQL Server 2005 On Win XP SP2 Box

May 28, 2006

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

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------




View 7 Replies View Related

Unable To Update SQl Server 2005 SP2....

Apr 3, 2007




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)

View 2 Replies View Related

Fail To Install SQL Server 2005 (Clustering): SQL Server Setup Was Unable Add User

Oct 24, 2007

Hello all,

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....

View 6 Replies View Related

One User Unable To Access The Reports From SQL Server 2005 Reporting Server.

Jul 6, 2007

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 tried many things but still problem persists.



Can anyone tell me the exact reason for this ?

I shall be extremely thankfull.





View 1 Replies View Related

Unable To Create Subscriber On A 2000 Server From A 2005 Server Publisher

Dec 1, 2006

Hi,

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.

Any help would be appreciated.

Thanks.

View 4 Replies View Related

Setup Issue: Unable To Install SQL Server 2005 Express On Windows 2003 Server SP2

Aug 17, 2006

Hello Experts,

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.

Help! :(

View 1 Replies View Related

Reinstall SQL Server Without Loosing The Data

Mar 26, 2002

hi Everybody,

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

View 1 Replies View Related

How Do I Reinstall The SQL Server ODBC Drivers?

Jul 23, 2005

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.

View 2 Replies View Related

Cannot Reinstall Sql Server Management Express

Jun 13, 2007

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

View 3 Replies View Related

Can't Uninstall Or Reinstall Nonfunctioning Sql Server

Mar 16, 2006

In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=299240#299240&SiteID=1

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.

View 48 Replies View Related

Unable To Connect To SSIS Or SSRS On SQL Server 2005 Standard Edition Server Via Desktop Connection

Mar 8, 2008

Hi,

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.

What do I do next please?

View 4 Replies View Related

Unable To Connect To SQL Server 2005 Worked Before

Mar 6, 2007

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!

View 4 Replies View Related

Unable To Uninstall SQL Server 2005 Express

Jul 15, 2005

When I try to un install SQL Server Express (VS 2005 Beta 2), which is not functional, I get an error message:

View 5 Replies View Related







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