Trouble In Installing Visual Web Developer 2005 SP
Oct 4, 2007
Hi,
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.
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.
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 installed both SQL 2005 developer and SQL Server 2005 Express Edition with Advanced Services SP2 and Microsoft SQL Server 2005 Express Edition Toolkit.
In every version "SQL Server Business Intelligence Development Studio" was missing. I uninstalled and reinstalled both version but always "SQL Server Business Intelligence Development Studio" was not available and the computer could not find devenv.exe file.
I installed visual studio 2008 as well. For some reason the start menu link for "SQL Server Business Intelligence Development Studio" is ""C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe"" and devenv.exe is not there or anywhere
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I was about to order SQL Server Developer Edition 2005 on Amazon, to use with Visual Web Developer 2005 Express, when I read a user comment that the two are incompatible with each other. Does anyone know for sure if that is true?
What I'm wanting to do is develop an ASP.NET web application on a web host using a SQL Server database. I use VS2003 and SQL Server Enterprise 2000 at work, but I'd like to learn the 2005 editions for this side project. I don't own any of the developer tools/IDEs personally, so I'm trying to find the most affordable way to do this for my home business.
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
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 :-)
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like the following:
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) (Microsoft SQL Server, Error: -1) I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools. My configuration::
Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it.
IIS is installed and the service says its running
VSQL and VWD express versions installed (no errors on installation)
SQL server service indicates it is running
.Net 2.0 framework installed (no errors on installation)
Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental.
Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
Yes I am a newby (or is that newbie) and this is my first post.My Visual Web Developer site work really well on my PC, I read the books took it slowly, created logins and sql tables and then found a good hosting company with Server 2005 ... I though I was one step away from the road to success ... then I hit the big brick wall. Spent hours on Google trying to find some answers without joy ... all I found were lots of users with the same or similar problems ... and some answers that caused more problems !1) Please can someone give my a 'step by step' idiots guide on how to convert my ASPNETDB.MDF content to run on Server 2005. I have Server Management Studio so I am happy about loading the translated files but I don't understand how to break them down into tables and logs.2) Once the files are across can I run a connection string from VWD directly to the tables on the server instead of SQL local ? I assume that is set in web.config !!.... normally I am happy to learn by trial and error. But I can't get around or over this brick wall.Welcome assistance, advice or a ladder ... with simple instructions ?
Hello Im pretty new to development so..... be nice guys. I have VS2005 pro and SQL Server 2005 developer edition installed. When I open VS, in the server explorer i can connet to databases located on the SQL directory (SQL Server runs perfectly) But when i try to add an sql server to my project( add new item --> SQL database) it gives me an error saying "Connection to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component......" HELP! donno what VS wants!
I am currently having problems with the SQL Server 2005 Developer. 1. I have a Windows XP SP2 Japanese version. 2. This machine is connected to a domain managed by Linux server. 3. I login with a domain account and install.
Initially, the intallations were failing with an error message that I do not have administrator right. We created an account on my machine with the same user name as that used for the domain, and gave this administrator rights. With this the installation was completed. However, there is another problem, I cannot connect to the SQL Server.
For the installation, I chose "Local System" with Windows Authentication, but the connection to the database still fails with the error message that remote connection is not supported. I do not understand why I need TCP to accesss a local installation of the SQL Server. However, I followed the procedure outlined in a MS KB to enable TCP. But the connection to the database still fails. I am using the Management Studio to connect to SQL Server. I have also tried creating a database in VS. NET 2005 and this also fails. I have checked the services and all are running.
What is wrong and what can I do? (it takes more than an hour to install this stuff and it is really consuming my time). Any help?
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?
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've done this before but it's been sometime. When I finish installing the MS SQL Server 2005 Developer edition, all I see under the Microsoft SQL Server 2005 folder in the All Programs is Configuration Tools with the following shortcuts: Notification Services Command PromptSQL Server Configuration ManagerSQL Server Error and Usage ReportingSQL Server Surface Area Configuration The are a whole bunch of other programs inside the Microsoft SQL Server 2005 folder that are missing. How do I add those services or program such as the Microsoft SQL Server Management Studio?
Hello, When installing SQL Server 2005 developer, I get the error: Product : Visual Studio Integrated Development Environment 2005Error : Internal Error 2356. _14248_Microsoft_VC80_MFC_x86.msm Any idea why this is happening? Thanks.
Hello Everyone, I have just installed then above softwares and I am trying to work on a very simple application.On my Default.aspx I created a Gridview and connected it to the dabase.Everything works fine?When I try to work on the Security under Website->ASP.NET_Configuration I get the error: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. I see that a lot of people get this problem. Can someone sugest a way out?Thnaks in advancePati2005
I am developing an asp.net app using visual web developer. I am using a sql server 2005 db for the back end. I have learned that I have to restart my machine if I want to work with the db in SQL Server 2005 Express after working with it in Visual Web Developer.
I am wondering why this is. I am assuming that the db is locked when it is used with VWD. Is this correct? Am I refering to it's status of "locked" correctly? Should I call this something else?
Hi Everyone, Recently I installed Visual Studio 2005 which also installed SQL Express Edition with it. I then installed SQL Server 2005 Developer Edition and am now able to see two instances SQLEXPRESS and MSSQLERVER. I do not want to use the Express version anymore, Do I have to have the Express version running or can I have just the Developer Edition ? Please help, can't find any help on the SQL website! Thanks
I am unable to successfully install SQL Server 2005 Developer edition here on a machine at work. Database service and client tools fails to install. I get the message that:"The computer running SQL Server setup does not meet the minimum system requirements for this SQL server release. Microsoft SQL Server is not supported by this operating system."
I am running Win XP pro sp2 with all the latest updates installed. What could be causing this and how do I fix it?
I am awaiting for my developer edition to come through, and was just wondering. I will be installing onto vista premium. so Do i install the SQL server first and then the Service pack afterwards, or the other way around
Hi, I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error"error occured in establishing the connection". I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf? thanks and urgent help needed
i am trying to build a database that contains a coloumn of phone number but i reallly dont know where and how i will be able to give a specific format for phone numbers.. or anything else any common type of information that may have a format..
Will i use Visual Web Developer or SQL Server Management or whatever else to arrange my phone number coloumn?
I tring to install SQL Server 2005 Developer Edition on Windows XP Pro but i not able to to so because of the following errors:-
Action "OpenPipeAction" failed during execution Action "CreatePipeAction" failed during execution. MsiOpenDatabase failed with 87 MsiOpenDatabase failed with 87 for MSI
Action "InstallDTSAction.9" failed during execution. Error information reported during run: Action: "InstallDTSAction.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: 1605
I downloaded SQL Server 2005 Developer Edition (x86) via MSDNAA (the package conatins 2 cd images the download program CRC checked them and all. I'm trying to install it on Windows XP prof. sp2).
When I mount the first CD, the installation menu comes up, if from the Install menu I select
"Server components, tools, Books Online, and samples"
an error message pops up saying:
"The application or DLL D:Setupsetupex.dll is not a valid Windows image. Please check this against your installation diskette."
When I press OK, it pops up again, then after clicking on OK one more time the Microsoft SQL Server 2005 Setup window comes up. After accepting the installation conditions and clicking next, it takes me to the "Installing Prerequisites" phrase, where when I press the Install button, it writes:
"Errors occured during the installation:
Error 193 installing .NET Framework 2.0"
Then the installation freezes, and I must press cancel (after that, the installation breaks saying: SQL Server Setup unexpectedly failed...)
If in the installation menu I choose
"
Install SQL Server Upgrade Advisor"
or
"
Run the SQL Native Client Installation Wizard"
a warning pops up saying:
"This installation package could not be opened.
Contact the application vendor to verify that this is a
valid Windows Installer package."
When I press OK, the warning disappeares, nothing happens.
I have .NET Framework 2.0, running VS2005 Prof. with no problem, had MS SQL Server 2005 Express Edition, but uninstalled it (never used), and just installed the latest MSI.
Searched the net for the "error 193" message, but haven't found anything that actually could help my case.
I get the following error installing SQL Server 2005 Developer Edition
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: You must have administrative credentials to perform this task. Contact your system administrator for assistance.
I am installing on Windows XP with Admin privs.
There is nothing listed in COM+ Services for SQL.
The Distributed Transaction Coordinator service is running.
There is a previous installation of SQL 2000 Developer Edition installed.
I have seen some pretty old posts with the same error.
I was wondering if there was a final resolution, service pack, etc. that solves this problem?
I have just installed Visual Studio 2005, but I cannot install MS Sql Server 2005 at all. It gives me an error that says look in Program FilesMS SQL Server90Setup BootstrapLOGFiles and there is a file which contains the following:
Microsoft SQL Server 2005 Setup beginning at Sat Dec 22 11:51:30 2007 Process ID : 6068 j:5810c5ab299ece9157setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/11/22 11:51:29 Complete: LoadResourcesAction at: 2007/11/22 11:51:29, returned true Running: ParseBootstrapOptionsAction at: 2007/11/22 11:51:29 Loaded DLL:j:5810c5ab299ece9157xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/11/22 11:51:30, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "6068"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/11/22 11:51:30 Complete: ValidateWinNTAction at: 2007/11/22 11:51:30, returned true Running: ValidateMinOSAction at: 2007/11/22 11:51:30 Complete: ValidateMinOSAction at: 2007/11/22 11:51:30, returned true Running: PerformSCCAction at: 2007/11/22 11:51:30 Complete: PerformSCCAction at: 2007/11/22 11:51:30, returned true Running: ActivateLoggingAction at: 2007/11/22 11:51:30 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00EFCFC4Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "6068"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
Also, the SQL Server express also did not install at all when I was installing VS 2005 Pro.
I have a problem installing SQL Server 2005 Developer Edition.
When I start the setup, I get the message:
"SQL Server Setup could not run. Another instance of SQL Server Setup is already running. The running instance must complete before you can run SQL Server Setup again"
I am using Windows XP and have SQL Server 2000 and SQL Server Express 2005 installed.
I shut down both instances before I attempted to do the install but I still get the message.
I checked active tasks but no tasks with SQL* is running.
Hi all i have a page with this code <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="36"> <PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" /> <Columns> <asp:BoundField DataField="ACCOUNT_REF" HeaderText="ACCOUNT_REF" SortExpression="ACCOUNT_REF" /> <asp:BoundField DataField="NAME" HeaderText="NAME" SortExpression="NAME" /> <asp:BoundField DataField="ADDRESS_1" HeaderText="ADDRESS_1" SortExpression="ADDRESS_1" /> <asp:BoundField DataField="ADDRESS_2" HeaderText="ADDRESS_2" SortExpression="ADDRESS_2" /> <asp:BoundField DataField="ADDRESS_3" HeaderText="ADDRESS_3" SortExpression="ADDRESS_3" /> <asp:BoundField DataField="ADDRESS_4" HeaderText="ADDRESS_4" SortExpression="ADDRESS_4" /> <asp:BoundField DataField="ADDRESS_5" HeaderText="ADDRESS_5" SortExpression="ADDRESS_5" /> </Columns> <PagerStyle HorizontalAlign="Center" /> </asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SageConnectionString %>" ProviderName="<%$ ConnectionStrings:SageConnectionString.ProviderName %>" SelectCommand="SELECT ACCOUNT_REF, NAME, ADDRESS_1, ADDRESS_2, ADDRESS_3, ADDRESS_4, ADDRESS_5 FROM SALES_LEDGER"> </asp:SqlDataSource> On my local machien this works great and I'm very happy with it I then uploaded the site onto the server on running the page i get this
ERROR [08001] Cannot find all files in data pathERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 2.00ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
can anyone suggest a eresolution? i'm confused since it works on my local machine fine but not on the server
hello eveyone..i have just downloaded and installed the visaul web developer 2005 express edition and sqlserver 2005 express edition.On top of that i even downloaded and installed the northwind database.But my problem is when i am connecting to the northwind database by clicking toos menu>connect to the database>choose datasource>new connection>..i have provided it with the required information..but as soon as i press "Test Connection" button the following error box displays.. "an error has occured while establishing a connection to the server.when connecting to the sql server2005,this failure may be caused by the fact that under default settings sql server doestnot allow remote connections.(provider:Named piped providers,error:40-couldnot open a connection to sqlserver.)" i have no idea whats is all about..can anyone get me pass this error..
I have SQL Serrver 2005 Express Edition with Advanced Services running on a machine with Vista Home Premium o/s.
I am trying to build the Personal Web Site Starter Kit using Visual Web Developer 2005 Express Edition but keep running into problems when trying to establish user instance. The error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The conmnection will be closed" keeps coming up.
The following services are running:
SQL Server (SQLEXPRESS)
SQL Server Browser
SQL Server Full Text Search
SQL Server VSS Writer
I note from the documentation that a new instance should be created in the directory :
C:Documents and Settings<User>Local SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS.
Unfortunately that directory does not exist on my Vista machine. Is this a fault?
