I am trying to install SQL server 6.5 for my SMS server. The installation stops with the message "could not connect to SQL server". There was evaluation version of SQL server 6.5 previously in the same server. I doubt that it was completely removed as when I try the upgrade option instead of install option, I get a message " early beta version of SQL server 6.5 detected". I am unable to use the deinstall option in the setup as it is dimmed. How do I completely remove all the files and registry entries so that I can do a fresh install?
I have run sql server 2000 and analysis manager on my laptop for a few months with no probs. On Monday I tried to connect to my computer server from sql server ent manager and it said "no datasource found." and something else about MS ODBC drivers being invalid. Analysis services still worked fine. I tired to connect and add servers and it just would not recognise anything so became software I could not use at all. I then uninstalled all sql server products on my computer. I thought a fresh reinstall would do the job. However now when I try to install sql server I get an error in the installation. It says that it cannot connect to the datasource and installation fails. It tells me to look in a sqlstp log and the bottom of this log is below
15:50:25 Begin Action: DialogShowSdUninstall 15:50:28 ShowDlgUninstall returned : 1 15:50:28 End Action DialogShowSdUninstall 15:50:28 Dialog 0x80000000 returned: 1 15:50:28 End Action ShowDialogsHlpr 15:50:28 ShowDialogsGetDialog returned: nCurrent=0x0,index=0 15:50:28 End Action ShowDialogs 15:50:29 Action CleanUpInstall: 15:50:29 StatsGenerate returned: 2 15:50:29 StatsGenerate (0xc0200805,0x2,0xf000000,0x400,1033,303,0x2,0x1,0 ,0,0 15:50:29 StatsGenerate -1,rj) 15:50:29 Installation Failed.
I havent shown the rest of the log because there is a lot of it. If needed I can copy in the rest.
The rest of the installation up to this point seems fine. HOwever it doesnt install the unistall files so I cannot uninstall SQL Server now. There is 105 MB of the program on my computer which I can only delete although I havent done this yet.
Why wont sql server let me install? It is a really annoying problem because it worked fine last Friday and then on Monday it went wrong and I cannot remember doing anything to make this happen. All MS updates are up-to-date. Any help is greatly appreciated
Above are the errors that i get when im tryin to install SQL 2005 i think its the DATA base side of it i managed to install the Configuration tools and things just cant install the Data base side where u can actually do something with it.
I am trying to install SQL Server 2005. I just installed Microsoft Visual Studio 2005(.NET). I got an option in my Start -> Programs for Microsoft SQL Server 2005. But I don't see how to bring up the query analyzer. It just has options for Configuration Tools ->SQL Server Configuration Manager,SQL Server Error and Usage Reporting, SQL Server Surface Area Configuration.
Did I install it wrong by chance? Do I need to do something else now? Do I need to configure it? If yes, how do I do that? Could anyone lead me in the right direction please? Thanks!
I have no idea how to proceed since I've never installed this before. Could anyone please help me install or do whatever needs to be done to it so I can bring up the query analyzer/user interface and be able to use SQL?
When trying to install SP4, I do not receive any notification of the install i.e. click on setup and then nothing. Checked *.out log and receive the following:
2006-08-08 10:40:57 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3616 2006-08-08 10:40:57 - ? [101] SQL Server 1LTZ0Q version 8.00.194 (0 connection limit) 2006-08-08 10:40:57 - ? [102] SQL Server ODBC driver version 3.81.9031 2006-08-08 10:40:57 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local) 2006-08-08 10:40:57 - ? [310] 2 processor(s) and 1016 MB RAM detected 2006-08-08 10:40:57 - ? [339] Local computer is 1LTZ0Q running Windows NT 5.0 (2195) Service Pack 4 2006-08-08 10:40:57 - ? [129] SQLSERVERAGENT starting under Windows NT service control 2006-08-08 10:40:57 - + [260] Unable to start mail session (reason: No mail profile defined) 2006-08-08 10:40:57 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Novice - Where to set up the mail profile and CPU idle condition?
I am having trouble installing SQL Server 2005 on a new machine at a hosted company. I am only installing the minimum, SQL Databaes Services. It errors out at the end and says see log. I have installed SQl 2005 10 times with no problem at other locations. The service won't even start it says error 3 path unkown. If I look for the path it shows in the service it hasn't been created, the files and directories were not created at that directory location. I tried to install bot as a Domain Admin and Local Admin accounts.
Here THe summary Log., Core(local) and Core Log files below.
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790) Time : Tue Mar 20 02:48:40 2007
Machine : CATCSAP021211 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_OWC11_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_BackwardsCompat_1.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Microsoft SQL Server 2005 Setup beginning at Mon Mar 19 19:49:04 2007 Process ID : 1300 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/2/19 19:49:4 Complete: LoadResourcesAction at: 2007/2/19 19:49:4, returned true Running: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4, returned true Running: ValidateWinNTAction at: 2007/2/19 19:49:4 Complete: ValidateWinNTAction at: 2007/2/19 19:49:4, returned true Running: ValidateMinOSAction at: 2007/2/19 19:49:4 Complete: ValidateMinOSAction at: 2007/2/19 19:49:4, returned true Running: PerformSCCAction at: 2007/2/19 19:49:4 Complete: PerformSCCAction at: 2007/2/19 19:49:4, returned true Running: ActivateLoggingAction at: 2007/2/19 19:49:4 Complete: ActivateLoggingAction at: 2007/2/19 19:49:4, returned true Running: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4 Complete: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__1300" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/2/19 19:49:4 Complete: PerformDotNetCheck2 at: 2007/2/19 19:49:4, returned true Running: InvokeSqlSetupDllAction at: 2007/2/19 19:49:4 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [CATCSAP021211] Trying to find Product Code from command line or passed transform If possible, determine install id and type Trying to find Instance Name from command line. No Instance Name provided on the command line If possible, determine action Machine = CATCSAP021211, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = XMLDomDocument, Result = 0 (0x0) Machine = CATCSAP021211, Article = Processor, Result = 0 (0x0) Machine = CATCSAP021211, Article = PhysicalMemory, Result = 0 (0x0) Machine = CATCSAP021211, Article = DiskFreeSpace, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSServicePack, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSType, Result = 0 (0x0) Machine = CATCSAP021211, Article = iisDep, Result = 0 (0x0) Machine = CATCSAP021211, Article = AdminShare, Result = 0 (0x0) Machine = CATCSAP021211, Article = PendingReboot, Result = 0 (0x0) Machine = CATCSAP021211, Article = PerfMon, Result = 0 (0x0) Machine = CATCSAP021211, Article = IEVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = DriveWriteAccess, Result = 0 (0x0) Machine = CATCSAP021211, Article = COMPlus, Result = 0 (0x0) Machine = CATCSAP021211, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = CATCSAP021211, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: CATCSAP021211 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/2/19 19:51:1, returned true Running: SetPackageInstallStateAction at: 2007/2/19 19:51:1 Complete: SetPackageInstallStateAction at: 2007/2/19 19:51:1, returned true Running: DeterminePackageTransformsAction at: 2007/2/19 19:51:1 Complete: DeterminePackageTransformsAction at: 2007/2/19 19:51:3, returned true Running: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3 Complete: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3, returned true Running: OpenPipeAction at: 2007/2/19 19:51:3 Complete: OpenPipeAction at: 2007/2/19 19:51:3, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/2/19 19:51:3 Complete: CreatePipeAction at: 2007/2/19 19:51:3, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2007/2/19 19:51:3 Complete: PopulateMutatorDbAction at: 2007/2/19 19:51:3, returned true Running: GenerateRequestsAction at: 2007/2/19 19:51:3 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = 3 Connectivity = 3 SQL_Tools90 = 3 SQL_WarehouseDevWorkbench = 3 SDK = 3 SQLXML = 3 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/2/19 19:51:4, returned true Running: CreateProgressWindowAction at: 2007/2/19 19:51:4 Complete: CreateProgressWindowAction at: 2007/2/19 19:51:4, returned true Running: ScheduleActionAction at: 2007/2/19 19:51:4 Complete: ScheduleActionAction at: 2007/2/19 19:51:4, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Skipped: InstallDTSAction Skipped: Action "InstallDTSAction" was not run. Information reported during analysis: No install request found for package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.11 Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.12 Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.18 Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.22 Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.9 Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result. Skipped: InstallNSAction Skipped: Action "InstallNSAction" was not run. Information reported during analysis: No install request found for package: "ns", install will be skipped as a result. Skipped: InstallNSAction.11 Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.12 Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.18 Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.22 Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.9 Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result. Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2007/2/19 19:51:4 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallSqlAction.11 at: 2007/2/19 19:51:5, returned true Running: InstallSqlAction.12 at: 2007/2/19 19:51:5 Installing: sqlncli on target: CATCSAP021211 Complete: InstallSqlAction.12 at: 2007/2/19 19:51:6, returned true Running: InstallSqlAction.18 at: 2007/2/19 19:51:6 Installing: owc11 on target: CATCSAP021211 Complete: InstallSqlAction.18 at: 2007/2/19 19:51:13, returned true Running: InstallSqlAction.21 at: 2007/2/19 19:51:13 Installing: sqlwriter on target: CATCSAP021211 Complete: InstallSqlAction.21 at: 2007/2/19 19:51:18, returned true Running: InstallSqlAction.22 at: 2007/2/19 19:51:18 Installing: bcRedist on target: CATCSAP021211 Complete: InstallSqlAction.22 at: 2007/2/19 19:51:28, returned true Running: InstallSqlAction.9 at: 2007/2/19 19:51:28 Installing: msxml6 on target: CATCSAP021211 Error: MsiOpenDatabase failed with 110 Failed to install package The installation source for this product is not available. Verify that the source exists and that you can access it. Error: MsiOpenDatabase failed with 110 for MSI {5A710547-B58E-488B-828D-CA9A25A0533C} Setting package return code to: 1612 Complete: InstallSqlAction.9 at: 2007/2/19 19:51:28, returned false Error: Action "InstallSqlAction.9" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallToolsAction.11 at: 2007/2/19 19:51:28 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallToolsAction.11 at: 2007/2/19 19:51:33, returned true Running: InstallToolsAction.12 at: 2007/2/19 19:51:33 Installing: sqlncli on target: CATCSAP021211 Complete: InstallToolsAction.12 at: 2007/2/19 19:51:34, returned true Running: InstallToolsAction.13 at: 2007/2/19 19:51:34 Installing: PPESku on target: CATCSAP021211 Complete: InstallToolsAction.13 at: 2007/2/19 19:53:48, returned true Running: InstallToolsAction.18 at: 2007/2/19 19:53:48 Installing: owc11 on target: CATCSAP021211 Complete: InstallToolsAction.18 at: 2007/2/19 19:53:51, returned true Running: InstallToolsAction.20 at: 2007/2/19 19:53:51 Installing: BOL on target: CATCSAP021211 Complete: InstallToolsAction.20 at: 2007/2/19 19:55:37, returned true Running: InstallToolsAction.22 at: 2007/2/19 19:55:37 Installing: bcRedist on target: CATCSAP021211 Complete: InstallToolsAction.22 at: 2007/2/19 19:55:40, returned true Error: Action "InstallToolsAction.9" failed during execution. Error information reported during run: Action: "InstallToolsAction.9" will be marked as failed due to the following condition: Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context: Prereq package will be failed due to the previous installation attempt returning: 1612 Installation of package: "msxml6" failed due to a precondition. Action "InstallSqlAction" will return false due to the following preconditions: Condition "Action: InstallSqlAction.9 has finished and failed." returned true. Installation of package: "sql" failed due to a precondition. Step "InstallSqlAction" was not able to run. Skipped: InstallNSAction.10 Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result. Running: InstallToolsAction.10 at: 2007/2/19 19:55:40 Installing: sqlxml4 on target: CATCSAP021211 Complete: InstallToolsAction.10 at: 2007/2/19 19:55:44, returned true Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Action "InstallToolsAction" will return false due to the following preconditions: Condition "Action: InstallToolsAction.9 has finished and failed." returned true. Installation of package: "tools" failed due to a precondition. Step "InstallToolsAction" was not able to run. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Running: ReportChainingResults at: 2007/2/19 19:55:44 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1612 Error Code: 0x8007064c (1612) Windows Error Text: The installation source for this product is not available. Verify that the source exists and that you can access it.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
I was having trouble with SQL server 2005 and reporting services. Finally I had to un-install and then re-install, had trouble with uninstalling initially. I couldn't use Add/Remove to remove Microsoft SQL Server 2005 until I found this command: "%ProgramFiles%Microsoft SQL Server90Setup BootstrapARPWrapper.exe" /Remove from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1
So I was able to remove (from what I know) all traces of SQL 2005 and its configuration tools. However when I reinstall it, I only have the configuration tools installed. Going to Start>>Microsoft SQL Server 2005 - configuration tools is all i have. Going to Add Remove Programs I can see Microsoft SQL Server 2005 along with Microsoft SQL Server Native Client.
When I use windows exploerer the only folders I see in c:Program FilesMicrosoft SQL Server are: 80, 90, InetPub, MSSQL.1, MSSQL.2, MSSQL.3
when I install SP2 everything but PRODUCT INSTANCE Database Services MSSQLSERVER
install correctly.
After that nothing changes.
My questions are; do I really have SQL Sever installed so that I can create and edit queries, reports, etc. And if I do how do I access it? It seems like something is left over telling the installer that I already have SQL already installed but not the configurations tools. So it just installs them.
I downloaded the 2 CD ISO Format from msdn to install SQL Server 2005 English Developer Edition on my XP SP2 box.
I currently have SQL 2000 running. So Sql Server 2005 Dev Edition is to run side by side in a named instance.
From CD1, I launched default.hta and could not install Database Services. The log mentioned could not find a 'valid copy of xxx.msi' where xxx is VSS writer, Database Services or SQL XML4 etc...
I tried 3 times and each time it damaged my SQL2000 beyond repair.
I've developed a desktop application for a company. It uses click once deployment and has a few prereqs: .NET Framework 2.0, j# .NET redistributable, windows installer 3.1 and SQL Server 2005 express edition.
Most of the time the application downloads and installs fine. However, one user has a problem. I'm fairly certain it's machine / OS related and I wonder if there is a way to get around it.
The user has a Windows 2000 machine, Pentium III, with 512 MB of RAM.
On their first try, they received an error while installing SQL Server 2005 Express. The error code the user found in the install log was 70095. Apparently the user found some information directing them to install the current MDAC 2.8 SP 1. After rebooting and trying the install again, it errored out. The new error code is 1706. Below is the install log.
As I said, I'm faily certain it's an OS issue, but I do hope there is a way around the issue other than trying to get the user to upgrade. If you need any other information, please let me know and I'll try to get it from the user.
Thanks,
AaronThe following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.0.4 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpDotNetFXdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer' Read string value '6.0.2800.1106' Setting value '6.0.2800.1106 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 6.0.2800.1106 {string} Running checks for command 'DotNetFXinstmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'DotNetFXinstmsia.exe' is 'Bypass' Running checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'DotNetFXdotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'DotNetFXdotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Visual J# .NET Redistributable Package 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPvjsrdpchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'VJSRDPInstalled' Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' The following properties have been set for package 'Microsoft Visual J# .NET Redistributable Package 2.0': Property: [DotNetInstalled] = 1 {int} Property: [VJSRDPInstalled] = 1 {int} Running checks for command 'VJSharpRDPvjredist.exe' Result of running operator 'ValueNotEqualTo' on property 'VJSRDPInstalled' and value '0': true Result of checks for command 'VJSharpRDPvjredist.exe' is 'Bypass' 'Microsoft Visual J# .NET Redistributable Package 2.0' RunCheck result: No Install Needed Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package 'SQL Server 2005 Express Edition', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': true Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed EULA for components 'SQL Server 2005 Express Edition' was accepted. Copying files to temporary directory "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" Downloading files to "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" (12/14/2006 11:16:32 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://go.microsoft.com/fwlink/?LinkId=37280&clcid=0x409' to 'C:DOCUME~1craigpLOCALS~1TempVSD8.tmp' Download completed at 12/14/2006 11:17:02 PM Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Installing using command line '"C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
I am installing Visual Studio 2005 Professional Edition. Everything goes well until the installation of SQL Server Express occurs. SQL Express installation progresses fine until very end of the installation. At that point it becomes stuck.
The installation says "Current component is installing" and is stuck on that message. The installer does not seem to be frozen as the picutres changes. However CPU usage for the setup processes is 0.
I have disabled all virus scanning software already.
Sorry if this seems to be very basic question. But after 5 hours I am thinking may be I am missing something.
I had always setup the dbs in server environment and I had never any issues but on my new Vaio Laptop with XP. Last time it was rather easy and I can not remember such issues. I downloaded (MSDE 2000) Release A from Microsoft and setting it up.
I set it up with the with the same parameters using an .ini file, I used Notepad to create a file named MyParameters.ini with these contents:
I find that my Visual studio is showing the instance at "Vaio/MSSQL" where Vaio is my Laptop. The setup created a folder in D:MSDEMSSQL$MSSQL and not in the target directory MSDE!!
Also my enterprise manager can not find it at all.
Also In visual studio I dont seem to be able to connect using my sa_password.
When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem.
Is there any fix to this? I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it.
This is the end of the log file for my SQL Server installation:
MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS Action start 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (c) (00:04) [20:47:22:140]: Invoking remote custom action. DLL: C:DOCUME~1KYLEOL~1LOCALS~1TempMSI1AA.tmp, Entrypoint: CheckIIS <Func Name='LaunchFunction'> Function=CheckIIS MSI (c) (00!60) [20:47:22:155]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'. <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Wed Oct 18 20:47:22 2006 <Func Name='CheckIIS'> Action 20:47:22: CheckIIS. Detecting Installed IIS MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'. MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'. Skipping RS Feature Dependency Check <Func Name='GetXMLAttributeValue'> Error to find XML node /configuration/system.web/compilation <EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'> Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returned 2". After this error message when I check the sql server configuration manager, I still see the old instances running.
I followed up another forum suggestion where I completely installed the old CTP and used the tool provided in the DVD(sqlbuw) to uninstall it but it only removes the one instance and leaves the rest on the system.
I will really appreciate help...
ERRRR:...
icrosoft SQL Server 2005 Setup beginning at Sun Nov 19 16:49:19 2006 Process ID : 5736 c:87450d2367f159d42610acad33156dbcsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/10/19 16:49:18 Complete: LoadResourcesAction at: 2006/10/19 16:49:18, returned true Running: ParseBootstrapOptionsAction at: 2006/10/19 16:49:18 Loaded DLL:c:87450d2367f159d42610acad33156dbcxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/10/19 16:49:19, returned true Running: ValidateWinNTAction at: 2006/10/19 16:49:19 Complete: ValidateWinNTAction at: 2006/10/19 16:49:19, returned true Running: ValidateMinOSAction at: 2006/10/19 16:49:19 Complete: ValidateMinOSAction at: 2006/10/19 16:49:19, returned true Running: PerformSCCAction at: 2006/10/19 16:49:19 Complete: PerformSCCAction at: 2006/10/19 16:49:19, returned true Running: ActivateLoggingAction at: 2006/10/19 16:49:19 Complete: ActivateLoggingAction at: 2006/10/19 16:49:19, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5736" returned false. Running: PerformSCCAction2 at: 2006/10/19 16:49:19 Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435 Product "{2373A92B-1C1C-4E71-B494-5CA97F96AA19}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{CD080F4B-BF2C-4A0E-B923-CDA7F6EAB1C9}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{481DFF26-7C67-4085-9A27-758283EA494A}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 CTP" Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP" Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Notification Services CTP" Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP" Product "{90032DD0-ABEE-4424-AC1E-B076BDD4E350}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06 The Product Name is "Microsoft SQL Server 2005 Tools CTP" Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435 Error: Action "PerformSCCAction2" threw an exception during execution. Return Code: 70032 Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result. Message pump returning: 70032
In order to deploy a corporate application on WM 5 devices, I've built an autorun.exe that performs some calls to wceload.exe to install cab files.
Everything is installing correctly, except SQL Mobile 3.0 (and its replication library). Here is the files the autorun.exe installs : compact framework 2.0 SP1 (NETCFv2.wm.armv4i.cab) french strings (System_SR_FR.cab) Sql mobile 3.0 (sqlce30.ppc.wce5.armv4i.CAB) Sql Mobile 3.0 replication (sqlce30.repl.ppc.wce5.armv4i.CAB) and also app cabs (app.cab, app2.cab, etc...)
The command line I execute in the autorun.exe is this one :
wceload.exe fullpath_to_cab_file.cab /silent
when I run this command line, I get no error (exit code of wceload.exe is 0). Bu when I run the application (a C# app) I get an error that one the assembly cannot be loaded. A further investigations later, I discovered that if I install sql mobile (the two cab files) by clicking on the cab on the device through files explorer, not only I get no error while installing, but also the application works correctly.
So I have two questions : 1. what can be possible reasons that make the autorun.exe fails to install Sql Mobile ? 2. In a more general way, how can I correctly handle wceload errors ?
FYI, I don't care about certificates, since the chosen device is a device where the security has been turned off. Another precision : the final users won't have access to a computer to deploy the app. That's why I choose to use an autorun.exe file.
I am having trouble getting the Critical Update for SQL Server 2005 Service Pack 2 (KB 934458) to install successfully. Message simply states the updates was unsuccessful. After that I am unable to connect to SQL Server via SSMS. Only rebooting the computer allows me to reconnect. Then Automatic updates won't leave me alone and wants to try it again. Hmmmmm.
I then tried to download (SQLServer2005-KB934458-x86-ENU.exe) and try it again. While running the update I noticed it was now referred to as "Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3054". Are these the same thing? Any hoot, it still fails to install. As each component failed, for what looks to be the same reason (See below), I allowed the installation wizard to report it's findings back to Microsoft.
Oh and one other observation. It appears as though Microsoft had a similar issue when they release SS2k5 SP1. They issed a workaround. See http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918357. If this is the same problem, why wouldn' t they try to fix it before releasing SP2?
Any way back to my current issue, clicking on the View Summary at the Installation Complete dialog reveals the following. Can someone help?
Thanks!!!
Time: 04/06/2007 10:04:01.859 KB Number: KB934458 Machine: PEPE OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3054 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition SQL Server Database Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER SQL Server Analysis Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER SQL Server Reporting Services 2005 (MSSQLSERVER) ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Notification Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Integration Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3050 x86 DEVELOPER
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID
********************************************************************************** Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Analysis Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB934458_sqlrun_as.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Reporting Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB934458_sqlrun_rs.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Notification Services 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB934458_sqlrun_ns.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Integration Services 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB934458_sqlrun_dts.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Tools and Workstation Components 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB934458_sqlrun_tools.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 1635
-------------------------------------- End of View Summary ---------------------------------------
For information purposes I went ahead and included below the tail end of the first failing process where it looks to go cattywhompus. The end of the log file (highlighted in yellow above) looks like this:
...
MSI (s) (10C) [09:51:23:343]: Opening existing patch 'C:WINDOWSInstaller2a6c7048.msp'. MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: C:WINDOWSInstaller2a6c7048.msp 3: -2147287038 MSI (s) (10C) [09:51:23:343]: Couldn't find local patch 'C:WINDOWSInstaller2a6c7048.msp'. Looking for it at its source. MSI (s) (10C) [09:51:23:343]: Resolving Patch source. MSI (s) (10C) [09:51:23:343]: User policy value 'SearchOrder' is 'nmu' MSI (s) (10C) [09:51:23:343]: User policy value 'DisableMedia' is 0 MSI (s) (10C) [09:51:23:343]: Machine policy value 'AllowLockdownMedia' is 0 MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media enabled only if package is safe. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558} MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath). MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Now checking product {4A35EF4A-D868-4B15-A84D-3E8925AA9558} MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media is enabled for product. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Attempting to use LastUsedSource from source list. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Trying source d:e2ba478890840dab90ccafHotFixSQLFiles. MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: d:e2ba478890840dab90ccafHotFixSQLFilessqlrun_sql.msp 3: -2147287037 MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Source is invalid due to missing/inaccessible package. MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing net source list. MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing media source list. MSI (s) (10C) [09:51:23:359]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp' MSI (s) (10C) [09:53:21:359]: Note: 1: 1314 2: sqlrun_sql.msp MSI (s) (10C) [09:53:21:359]: Unable to create a temp copy of patch 'sqlrun_sql.msp'. MSI (s) (10C) [09:53:21:390]: Note: 1: 1708 MSI (s) (10C) [09:53:21:390]: Note: 1: 2729 MSI (s) (10C) [09:53:21:406]: Note: 1: 2729 MSI (s) (10C) [09:53:21:406]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (10C) [09:53:21:437]: MainEngineThread is returning 1635 This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package. C:WINDOWSInstaller9b7a85.msi MSI (c) (C0:90) [09:53:21:437]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (C0:90) [09:53:21:437]: MainEngineThread is returning 1635 === Verbose logging stopped: 4/6/2007 9:53:21 ===
It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2, I get this when running msiexe /x {the number for the beta}
Could someone please help me, I need to have this install to take courses this weekend, Want to complete the install today, which is Friday.
Hi. I am taking a certification class for which I recieved MSDE 2000 SQL server to use. I had a version that came with my textbook installed, and uninstalled it to use this one. Now I can no longer install either version, when I try it gives me a "instance name specified is not valid" error message when I start the installation, then kills it. Anyone have any ideas?
i am having some trouble installing SQl server Reporting Services.well, in order to install the reporting services i have to installServicePack 3a.so through my installation of package 3a i am encoutering some trouble.i was able to comlete the first part of the installation i receivethis error message: Instance name specified is invalidso, my question is: once you have SQL Server installed, where can yougo to find the name of the instanceand once i find it, can i rename it?i originally installed SQL Server a while ago. during the setup, i donot recall a particular name i might have given it.
"None of the selected features can be installed or upgraded. Setup cannot proceed because no effective change is being made to the machine..."
this shows when trying to install SQL Server 'Management Tools', under Client Components, in the Tools install section, although i manually select 'Entire feature will be installed' (initially, all features are ticked off with a red X).
this error message shows up regardless of which feature i choose to install. it wouldn't even install books online.
I'm new to SQL Server and am now learning how to operate SQL Server Express 2005.
I'm getting the following error when attempting to install Visual Web Developer 2005 SP1.
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch"
My machine runs on XP Pro SP2, .NET Framework 3.5.
Currently, what i have got on the computer are as follows Microsoft SQL Server 2005: SQL Server Management Studio Express, SQL Server Configuration Manager.
Hi, I have installed SQL Server 2005(Express edition) and Visual Basic 2005(Express edition) along with the SQL ServerBusiness Intelligence Development Studio and SQL Server Management Studio Express. However when I open BIDS, VS2005 opens instead and there are only 2 templates for new projects. I dont find the other templates for creating new projects that should be present in BIDS . Could some one please tell me how to get the other new project templates??
I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx
It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message:
"There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor"
Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing.
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
Hey - I'm having a bit of trouble getting this website to run off of my local host. I'm running IIS with SQL Server Express. Here's the connection info from the Web.config file in the website... <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=asdf" cookieless="false" timeout="20" /> ...and here's the error I'm getting...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) Stack Trace: 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) +739123System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105System.Data.SqlClient.SqlConnection.Open() +111kpl_testweb.Eventcal.bind_ddlocation() in E:WebsR2G2007controlsEventcal.ascx.vb:131kpl_testweb.Eventcal.Page_Load(Object sender, EventArgs e) in E:WebsR2G2007controlsEventcal.ascx.vb:94System.Web.UI.Control.OnLoad(EventArgs e) +98System.Web.UI.Control.LoadRecursive() +71System.Web.UI.Control.LoadRecursive() +154System.Web.UI.Control.LoadRecursive() +154System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4310any tips for me? I'm not even sure where to start here...
I downloaded a sample blog sample from Scot Mitchel and wanted to try it out. I attached the .mdf file to SQL Server 2005 but noticed that, when I create users they don't come into the database that I attached, though all the necessary aspnet_ tables are in there but in the dedicated table I didn't see any new user. My dedicated database (LocalSqlServer) is in another database. I have the connectionstring made up in the machine.config file in the LocalSqlServer name.So I thought that the web.config does override the settings in the machine.config I could easily place this in my web.config:<remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=TESTINGDBSERVER;Initial Catalog=ScotBlog;Integrated Security=True" providerName="System.Data.SqlClient"/>But that too doesn't do the trick. Does anyone have an anwser on what's going wrong here? And especially how I can solve this...
I am having trouble using the CONTAINS function in sqlserver(enterprise manager). I am typing the following:Select *FROM mytableWHERE CONTAINS(myfield,'mystring')This returns the error:Query Designer encountered a MS Design Tools error:ODBC error:[Microsoft][ODBC SQL Server Driver]'CONTAINS' is not arecognizedfunction name.[Microsoft][ODBC SQL Server Driver][SQLServer]Statement(s) couldnot be prepared.According to the T-SQL reference on msdn this is a supported function?Am I typing something incorrectly? If this is not supported, isthere an equivalent to this function? In my field I have some commadelimited values ie 'apple,orange'. So I need to be able to discernwhich records contain orange. The LIKE keyword doesn't seem to workfor this scenario. Any help would be greatly appreciated.
Greetings We're having trouble getting the Agent started. The service is set to login as NT AUTHORITY/System. In an effort to attempt to diagnose the problem we changed the service (using Service Control Manager) to login as a user with Administrator rights on the server and we got the same error, except for that user.
[298] SQLServer Error: 18456 Login failed for user NT AUTHORITYSYSTEM [SQL STATE 28000] [298] SQL Server Error: 4060 Cannot open database "EP_SessionState" requested by the login. The login failed [SQL STATE 42000]
I'm sure this is a common problem with an easy solution however I can not find out much about EP_SessionState through Google and was hoping someone could help.
