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?
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?
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 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 ===
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.
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?
Can I connect from a SQL Server 2005 database to a SQL Server 2000 database, without establishing a linked server connection.
I need to fire a SELECT query on a SQL Server 2000 database, but don't want to add it as a linked server. Is there any way I can do this or its not possible??
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
Can I connect to remote SQL 2005 server through SQL Server Management Studio Express? I always get a error code 18456 when I try to connect to SQL 2005 server through SQL Server Management Studio Express. I'm sure I enter correct username and password!
I just installed SQL Server 2005 Enterprise edition from my company's DVD. It was installed with the setting of using both Integrated windows authenitication as well as basic named authenication. I installed all the options too: Database Engine, Analysis Services, Reporting Services, SQL Server compact edition, and Integration Services. When I look at services there are: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Browser. All of which are running. Something that took me offguard was the installation did not ask me to provide an SA password. Other than that, the install looked like it went good.
I was able to connect to the local instance of the SQL Server 2005 using the SQL Server Management Studio. I could connect with SA, or connect with Integrated Windows Authenication. Whoohoo. Off and running! As a matter of fact, for the SA account I could use any password and it would still log me in.
First thing I did was I went in to the copy wizard to attempt to copy a database from a server on our network to my local box. First it asked me for the remote server. Then when I specified my local instance in the wizard, the wizard complained that my local instance was NOT SQL Server 2005. Doh! This I didn't understand. I figured maybe I need to check for MS updates. Sure enough, I found that ther was a SP2 and then a hot-fix for that SP2. I applied both. Now I cannot connect from SQL Server Management studio to my local instance of SQL Server 2005 database server. I get the following error:
"An error occurred 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"
However, I went in to see what other services I could connect to, and here's the results:
Analysis Services : OK! Reporting Services (Windows Auth/Basic/Forms) : NG "The reporting Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)" SQL Server Compact Edition : NG "The database cannot be found. Check the path to the database. [ File Name = CCG092 ] (SQL Server Compact Edition ADO.NET Data Provider) Integration Services : OK!
I can connect to other SQL Server databases on our network. However, just not my local one. No one on the network can connect to me either.
I even turned off my windows firewall and still no luck connecting to my own.
So something really went wrong when I applied SP2, however, admittedly from the error message when I tried to use the copy wizard, something was probably already wrong.
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.
Hi all.I am working on asp.net 2.0 with back end as sqlserver 2000. but when trying to connect to the database i am getting the following error displayed An error has occurred 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): An error has occurred 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 connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +115 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1093 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1083 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +351 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +82 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +558 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +126 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +651 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +160 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122 System.Data.SqlClient.SqlConnection.Open() +229 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +114 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +225 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +157 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +68 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +100 System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +100 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +113 System.Web.UI.WebControls.Login.AttemptLogin() +178 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +134 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +107 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +178 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3837
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 can anyone help??????????? regardspravallika
Hi,I've an account with a hosting service provider online for SQL Server database. I've downloaded SQL Server 2005 Express from ASP.Net. How can I use it to connect to my SQL Server Database which is sitting on remote server? The hosting provider gave me following things to connect to the remote database.Server NameDatabase NameUser NamePasswordRegards,A.K.R
i Update SQL Server 2005 SP1 to SQL Server 2005 SP2 but cannot connect SQL Server 2000 SP4. Please Help Me Please
===================================
Cannot connect to sia09-cxdb01cxdb01.
===================================
An error has occurred 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 connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
Would please anyone here give me any idea about how can I connect to SQL Server 2005 analysis services server and send XML request to it programmatically (with Business intelligence development studio in SQL Server 2005)? Thanks a lot.
I have a brand new install of sql server 2005 on brand new WINDOWS SERVER2003 with latest versions. Every thing works fine excepting I get a 404 when I connect to report server from management studio..
all work fine on local machine and with in the network behind the fire wall.
But when I try to connect to report server using management studio on the local server or remote server, I get the following error.
"
TITLE: Microsoft SQL Server Management Studio ------------------------------
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
"
More techinal details
"===================================
Cannot connect to xxxxxxxxxxxx.
===================================
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------ Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection() at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString) at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject() at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------ Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
I have a question about opening files in the Microsoft SQL Server 2005 Management Studio.
In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection.
Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer).
Someone do not have this problem - but we found no option to set it up.
Hello, After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager. Regards, junior
Hi All!!! In my Computer has MS SQL Server 2000(with default Instance) and now I Install MS SQL server 2005(with Instance name: SQL2005 ). Now I want to write Web Application to connect to the both databases (SQL Server 2000 and MS SQL Server 2005), How to Add connection string in my web.config to do it. Help me ??? Thanks & Regards,
I have installed sql server 2005 Express with SQLADV.exe. But when I open Management Studio Express it has error:
Can not connect to server
An error has occurred 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 connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified).I searched on google but did not find any solution. Anyone know about that, please help me.
We have just moved from 2000 to 2005 and ever time I try to open store procedure or function I was getting this error message... [Microsoft][ODBC SQL Server Drive] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO) So I installed "Microsoft SQL Server 2005 Backward Compatibility Components" from "Feature Pack for Microsoft SQL Server 2005 - April 2006" on the client machine and this resolved the issue. Specifically i installed the "SQL Distributed Management Objects (SQL-DMO) feature ....., how I am getting following error message
[SQL-DMO]You must use SQL Server 2005 management tools to connect to this server
HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I have enabled TCP/IP and name pipes and still failed.
One thing needs to be mentioned that I am using a statistic IP in my company and the machine name is together with a DNS suffix just as you see above (hostname.china.***.com)
I also want to connect to another machine which has SQL Express 2005 installed, but failed either.
What is strange is that these two machines can ping to each other with the full qualified name or short name. (ping hostname1 or ping hostname1.china.***.com)
I have some SQL CE database .sdf file on my handheld, and I was trying to connect to that file via SQL Server 2005 Management Studio, and it does not work. I am wondering if there is any good tool that I can use on desktop to connect to sqlce .sdf database file on my handheld?
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 am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
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.
