I can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 RepliesI am trying to install SQL Server 2005 Express, but it fails.
View 6 Replies View RelatedI can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 Replies View RelatedHello,
View 4 Replies View RelatedI am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies View RelatedHello,
I've been trying to install SQL Server express edition all day and it errors out every time. I've tried it on two different servers and I get the same errors. Here's what the error log says:
2007-04-20 16:37:52.77 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.2825)
2007-04-20 16:37:52.77 Server (c) 2005 Microsoft Corporation.
2007-04-20 16:37:52.77 Server All rights reserved.
2007-04-20 16:37:52.77 Server Server process ID is 1356.
2007-04-20 16:37:52.77 Server Authentication mode is MIXED.
2007-04-20 16:37:52.77 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-04-20 16:37:52.77 Server This instance of SQL Server last reported using a process ID of 1964 at 4/20/2007 4:37:47 PM (local) 4/20/2007 8:37:47 PM (UTC). This is an informational message only; no user action is required.
2007-04-20 16:37:52.77 Server Registry startup parameters:
2007-04-20 16:37:52.77 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-04-20 16:37:52.77 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-04-20 16:37:52.77 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-04-20 16:37:52.77 Server Command Line Startup Parameters:
2007-04-20 16:37:52.77 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf
2007-04-20 16:37:52.77 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf
2007-04-20 16:37:52.77 Server -m SqlSetup
2007-04-20 16:37:52.77 Server SqlSetup
2007-04-20 16:37:52.77 Server -Q
2007-04-20 16:37:52.77 Server -q SQL_Latin1_General_CP1_CI_AS
2007-04-20 16:37:52.77 Server -T 4022
2007-04-20 16:37:52.77 Server -T 3659
2007-04-20 16:37:52.77 Server -T 3610
2007-04-20 16:37:52.77 Server -T 4010
2007-04-20 16:37:52.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-20 16:37:52.79 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-20 16:37:52.88 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-20 16:37:52.92 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-04-20 16:37:52.93 spid5s Warning ******************
2007-04-20 16:37:52.93 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-04-20 16:37:52.93 spid5s Starting up database 'master'.
2007-04-20 16:37:52.93 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:52.93 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:52.97 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:52.97 spid5s FCB:pen failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf for file number 1. OS error: 5(Access is denied.).
2007-04-20 16:37:52.98 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:52.98 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf". Operating system error 5: "5(Access is denied.)".
2007-04-20 16:37:53.05 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:53.05 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf for file number 2. OS error: 5(Access is denied.).
2007-04-20 16:37:53.05 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:53.05 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf". Operating system error 5: "5(Access is denied.)".
I 'm getting this error on expanding the + nodes in SQL Server Management Studio Express Object Explorer:i.e. Database -> System Databases -> Any DB selected and expanding the Tables node When I click on the nodes for Tables for any of my databases, I see it saying expanding..., but then a message box errors pops up. It was working fine until after my lunch hour when I attempted to create some new tables.Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)Additional Information:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)Could not continue scan with NOLOCK due to data movement. (Microsoft SQL Server, Error: 601)
View 2 Replies View RelatedGreetings,
I have attempted a full install of 2005 Ent on our W2k3 Enterprise
server. When attempting to install all services (SQL Svr database,
analysis, reporting, notification, integration, client
services/components) I get the message: "The features specified are
not valid for this edition of SQL Server". I got the same thing
when attempting to install with various subsets of services. Then I
tried just database services and client components and got the
message: " There was an unexpected failure during the setup
wizard. "
Perusing the core.log, I see:
Fatal Exception caught while installing package: "10"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlchainingsqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196
Has anyone encountered this? One of our guys downloaded the install
files from Microsoft. We don't use CDs anymore. I think there are
files missing.
Thanks for any assistance with this.
Trying to install SQL Server 2005 x64 Enterprise Edition during the "Workstation components, etc." part of the install, the install stops and gives me this error.
----------------------
Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024893
Error message: The system cannot find the path specified.
Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified.
[Abort] [Ignore] [Retry]
----------------------
This install is being attempted on 3 seperate servers all running Windows Server 2003 R2 Enterprise x64 Edition (Service Pack 2).
Futher notes:
Distributed Transaction Coordinator services is setup and running (started).
I checked to make sure there are no MSMQ components in the COM+ Application struture in Component Services.
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Apr 03 19:36:56 2007
(As you can see, there is nothing in the file)
Any ideas what could be wrong?
Thanks
Pedro
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--------------------------------------------------------------------------------
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Mar 04 15:27:03 2007
List of log files:
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Support.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_Core.log
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SCC.log
Downloading and installing VS 2008 Express also created a Miscrosoft SQL Server folder. How do I install the SQL Server 2005 Express?The following is what I found from the HELP menu bar of the VS 2008 Express. Where can I find the sqlexpr.exe?
TIA,Jeffrey
To install SQL Server Express To begin installation, double-click sqlexpr.exe. Note: SQL Server Express is available as a self-extracting executable file (sqlexpr.exe) from both the Visual Studio 2005 CD and the SQL Server Express Web site. SQLEXPR.EXE installs on x86-based computers and to the 32-bit subsystem (WOW64). For more information, see Hardware and Software Requirements (SQL Server Express)
Hi,
I had some issues on my server and had to uninstall .Net Framework 2.0, SQL Server 2005 Express, and SQL Express Toolkit. I installed SQL Server 2005 Express and it seemed to be ok.
Then my problems all started when I tried to install SQL Express Toolkit because I needed to install DTS Wizard again, and it errors out and wouldn't let me install it. So I uninstalled everything that's listed above again.
I then tried to install SQL Server 2005 Express again, and on the second from last screen, while its listing all the components and configuring them, I get the following error as it's configuring the last component... which was the SQL Server Database Services.
TITLE: Microsoft SQL Server 2005 Setup
-----------------------------------------------------------
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
I tried to re-install the SQL Server Express another 7 times wth no luck.
If anyone can point me in the right direction I'd really appreciate it.
Thanks,
Bill
Hi,
I'm getting an error while trying to install SQL Server Express 2005 Express Edition. I'm attaching the log of the installation process here. Please throw some light on the same.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlShutDownRANUInstance
PerfTime Start: Do_sqlShutDownRANUInstance : Sat Mar 08 21:39:12 2008
<Func Name='Do_sqlShutDownRANUInstance'>
Service SQLEXPRESS with parameters '' is being started at Sat Mar 08 21:39:12 2008
Unable to start service (3)
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 316
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 3
MSI (s) (D0!64) [21:39:17:257]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.
.
I installed VS 2008 Express with an option to download SQL Server 2005 Express. I noticed there is a '90' folder under my Microsoft SQL Server folder. I assumed this the folder for SQL Server 2005 Express.
How do I set up my SQL Server2005 Express, so that I can use some sample databases for my VS 2008 Express? Any difference for SQL Server 2005 Express between VS 2008 Expressdownload and SQL Server 2005 Express download?
TIA,Jeffrey
Got this message during install. Veritas pages not much help points to a black help file...
Any advice would be appreciated
08-24-2007,14:29:12 : InitData failed to open the cluster wrapper
08-24-2007,14:29:12 : Executing CLUS_InitData
08-24-2007,14:29:12 : InitData failed to open the cluster wrapper
08-24-2007,14:29:12 : Leaving Init of CDlgLocalChooseCustom
08-24-2007,14:29:13 : Validating Local Options Data
08-24-2007,14:29:13 : Executing CLUS_InitData
08-24-2007,14:29:13 : InitData failed to open the cluster wrapper
08-24-2007,14:29:13 : Executing CLUS_InitData
08-24-2007,14:29:13 : InitData failed to open the cluster wrapper
08-24-2007,14:29:13 : Executing CLUS_InitData
08-24-2007,14:29:13 : InitData failed to open the cluster wrapper
08-24-2007,14:29:13 : Executing CLUS_InitData
08-24-2007,14:29:13 : InitData failed to open the cluster wrapper
08-24-2007,14:29:14 : Validating service account data
08-24-2007,14:29:15 : CDlgSSO Pass Function.
08-24-2007,14:29:15 : After Check for INSTALL_MODE.
08-24-2007,14:29:15 : DlgChooseDBServer Pass Function.
08-24-2007,14:29:24 : m_bUseNativeClient = 1
08-24-2007,14:29:59 : Validating DlgChooseDBServer data
08-24-2007,14:30:08 : Validating DlgChooseDBServer data
08-24-2007,14:30:08 : Drive C: Required: 956 MB Available: 101545 MB
08-24-2007,14:30:08 : m_bUseNativeClient = 1
08-24-2007,14:30:08 : V-225-204: Could not start the SQL server MUNIS2BKUPEXEC with service name of MSSQL$BKUPEXEC ***To search for information about this error, click here
08-24-2007,14:30:08 : Unable to connect to a SQL Server MUNIS2BKUPEXEC on machine MUNIS2.
08-24-2007,14:30:08 : CDlgChooseTapeDrivers Pass Function.
08-24-2007,14:30:08 : After Check for INSTALL_MODE.
08-24-2007,14:30:08 : After Check for INSTALL_CHOICE.
08-24-2007,14:30:08 : After Check for INSTALL_TYPE.
08-24-2007,14:30:08 : CDlgSerialNumber Pass Function.
08-24-2007,14:30:14 : CDlgTSMConfig Pass Function.
08-24-2007,14:30:14 : After Check for INSTALL_MODE.
08-24-2007,14:30:14 : CDlgTSMConfig Pass Function.
08-24-2007,14:30:14 : CDlgCAS Pass Function.
08-24-2007,14:30:14 : After Check for INSTALL_MODE.
08-24-2007,14:30:14 : CDlgClone Pass Function.
08-24-2007,14:30:14 : CDlgClone not passed.
08-24-2007,14:30:14 : CDlgRemoteChooseCustom Pass Function.
08-24-2007,14:30:14 : After Check for INSTALL_CHOICE.
08-24-2007,14:30:14 : Install Summary XML File:
08-24-2007,14:30:14 : C:DOCUME~1ADMINI~1.TOWLOCALS~1Temp2EAB0C0F9-B57B-4865-91A3-DE3B34B1FB02InstallReview.xml
08-24-2007,14:30:14 : Install Summary XSL File:
08-24-2007,14:30:14 : C:BEWS_11D.7170_32BIT_VERSIONWINNTINSTALLBEBinInstallSummary.xsl
08-24-2007,14:30:14 : Install Summary HTML File:
08-24-2007,14:30:14 : C:DOCUME~1ADMINI~1.TOWLOCALS~1Temp2EAB0C0F9-B57B-4865-91A3-DE3B34B1FB02InstallReview.htm
08-24-2007,14:30:14 : Entering GetSQLAndCASOInformation
08-24-2007,14:30:14 : Leaving GetSQLAndCASOInformation
08-24-2007,14:30:14 : MDAC 2.82.3959.0 is installed on this system.
08-24-2007,14:30:14 : m_bUseNativeClient = 1
08-24-2007,14:30:28 : Executing BE_InstallMDAC.
08-24-2007,14:30:28 : MDAC 2.82.3959.0 is installed on this system.
08-24-2007,14:30:33 : Installing .Net Framework 2.0.
08-24-2007,14:30:33 : Checking for .Net Framework 2.0.
08-24-2007,14:30:33 : .NET Framework was detected. Skipping install.
08-24-2007,14:30:34 : Installing Microsoft Report Viewer Redistributable 2005
08-24-2007,14:30:34 : m_bUseNativeClient = 1
08-24-2007,14:30:34 : V-225-204: Could not start the SQL server MUNIS2BKUPEXEC with service name of MSSQL$BKUPEXEC ***To search for information about this error, click here
08-24-2007,14:30:35 : Unable to connect to a SQL Server MUNIS2BKUPEXEC on machine MUNIS2.
08-24-2007,14:30:35 : Executing SQL_GetSQLServerEdition.
08-24-2007,14:30:35 : V-225-204: Could not start the SQL server MUNIS2BKUPEXEC with service name of MSSQL$BKUPEXEC ***To search for information about this error, click here
08-24-2007,14:30:35 : V-225-226: Unable to connect to SQL Server. ***To search for information about this error, click here
08-24-2007,14:30:40 : Executing CRemoveUtility::BERemoveOFO8x
08-24-2007,14:30:40 : Executing CRemoveUtility::RemovePreviousAA8x
Hi all, ive got a problem creating a sql connection.
Lets start from the beginning. I open Visual Studio, create a new empty website and then go to add a new SQL Database (new item > SQL Database). It asks me if i want to put this into the App_Data folder (which i choose 'yes' to), and then this error comes up...
I then decided to try a website template i found that i know works (because i got it running on Visual Studio at work), and this error comes up when i try to build the site...#
Heres a snippet of my machine.config...
Sorry about all the screenshots but im new to sql connections etc. Its all works fine at work and i can add a new database connection etc, but on my Home machine (Vista Ultimate, Visual Studio 2005 Pro, SQL Express).
Im sure its something to do with the machine.config, but i dont know how to rebuild it.
Any help will be appreciated.
Thanks
I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.
After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.
I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.
Thanks in advance for help any of you can suggest.
Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006Process ID : 2036c:6645bd818fccc8ef0bad80e6a12f5bsetup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2006/1/5 23:48:6Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned trueRunning: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6Loaded DLL:c:6645bd818fccc8ef0bad80e6a12f5bxmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateWinNTAction at: 2006/1/5 23:48:8Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateMinOSAction at: 2006/1/5 23:48:8Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned trueRunning: PerformSCCAction at: 2006/1/5 23:48:8Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned trueRunning: ActivateLoggingAction at: 2006/1/5 23:48:8Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned trueRunning: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned trueAction "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.Running: PerformSCCAction2 at: 2006/1/5 23:48:8Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned trueRunning: PerformDotNetCheck at: 2006/1/5 23:48:9Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned trueRunning: ComponentUpdateAction at: 2006/1/5 23:48:9Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned trueRunning: DetectLocalBootstrapAction at: 2006/1/5 23:48:30Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned trueRunning: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30
I am trying to debug a classic ASP application using Visual Web Developer Express and SQL Server Express editions. When my application tries to execute a stored procedure, I get the following error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
Is there a way for me to trace queries that are getting executed in SQL Server Express so I can see which stored procedure is failing? I seem to remember being able to do this with SQL Server 2000. Any other ideas on how to debug SQL Server errors like these using SQL Server Express?
TIA for the help.
Michael
I installed Visual Studio 2005 on my machine, which includes SQL Server Express. I then installed the Developer edition of SQL Server over the top, as that's the edition I wanted. I now get four errors in my Application event log whenever I boot Windows:
MSSQLSERVER - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
MSSQLSERVER - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.
MSSQL$SQLEXPRESS - Performance counter shared memory setup failed with error -1. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
MSSQL$SQLEXPRESS - Error in mapping SQL Server performance object/counter indexes to object/counter names. SQL Server performance counters are disabled.
Any idea what's causing this problem and how I can fix it?
Thanks
Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.
After all the set up:
(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:MSSQL.1MSSQLBackupmyDatabase.back; As I understand D: is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D: drive, and where is that D: drive anyway?
(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:....mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.
Please help me for this.
Regards.
Joey
My machine environment is as follows:
- Windows Server 2003 Standard with SP1
- IIS 6.0 with some "classic ASP" applications running under it (not ASP.NET)
- SQL Server 2000 Client (Enterprise Manager, Query Analyzer etc)
- .NET Framework Runtime 1.1 & 2.0
- Visual Studio.NET 2003 & 2005
I've never installed (or even trusted) any beta/CTP version of either Visual Studio or SQL 2005 (or any other MS trial products for that matter) on my machine.
Initially I installed SQL 2005 Express, and then the RTM version of SQL Management Studio Express.
Later i found this "SQL 2005 Express with Advanced Features" download, and figured that this must be a roll-up of all those features (and then some), so i removed all the old SQL 2005 components and installed this SQLEXPR_ADV.EXE.
I did this twice: the first time with Reporting Services; then removed the whole thing due to errors to be described below; the second time without RS.
The installation process itself is relatively painless, but after it's completed, whenever I open an ASP page from the local IIS server, dozens of warning messages like this would show up in the eventlog:
1.
=============================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1015
Date: 2006-05-22
Time: 2:01:24 PM
User: NT AUTHORITYNETWORK SERVICE
Description:
Failed to connect to server. Error: 0x80070005
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
2.
=============================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1001
Date: 2006-05-22
Time: 2:01:24 PM
User: MYPCIUSR_MYPC
Description:
Detection of product '{A4512736-8D63-4298-9271-5329931FA46B}', feature 'SQL_SSMSEE' failed during request for component '{6EC5DFBD-F6B5-4F02-8432-BFB8B03562B8}'
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
3.
=========================
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1004
Date: 2006-05-22
Time: 2:01:24 PM
User: MYPCIUSR_MYPC
Description:
Detection of product '{A4512736-8D63-4298-9271-5329931FA46B}', feature 'SQL_SSMSEE', component '{180F515D-F56C-40DD-9D71-CC532EA8E286}' failed. The resource '' does not exist.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I can use the Management Studio Express to create a database and tables, but having tons of errors flooding my eventlog is still a serious problem.
Any ideas on how to resolve this?
By the way, I think the total experience with SQL 2005 installation is far worse than SQL 2000, which is a very mature product. It seems that SQL 2005 was rushed out of the door to meet some deadlines so quality was seriously comprised as a result. Sending out a service pack less than 6 months after the RTM release is a testament to this conclusion, right?
Hi,
I'm trying to migrate a MSDE based application into a SQL2005 Express SP2 DB Engine on Windows Vista Business but I'm facing several errors that are blocking me.
Since the installation of SQL2005 Expr. must be done in a silent mode (the end user shouldn't set anything), I'm installing it using this syntax:
SQLEXPRSP2_ITA.EXE -q /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=CSERV DISABLENETWORKPROTOCOLS=0 SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM" SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM" AGTACCOUNT="NT AUTHORITYSYSTEM" ASACCOUNT="NT AUTHORITYSYSTEM" RSACCOUNT="NT AUTHORITYSYSTEM"
The installation proceeds without problems but when my program tries to create the database, a message error appears:
CREATE DATABASE denied on database 'master' (I translated directly from italian).
What I would like is to install SQL 2005 with "Windows Authentication" access instead of "SQL Authentication".
If I install SQL2005 manually by setting a named instance (CSERV), Windows Authentication mode, activating the option "set the local account as SQL administrative account" (translated from italian and suggested with Vista) I get the following error (read from the LOG):
CREATE FILE encountered operating system error 5 (access denied) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerCSERVDataCGIDBDat.mdf'
CSERVData is the folder that the application creates and where the "mdf" and "ldf" files are stored.
So in the first case it seems that SQL2005 don't recognize the local account as administrator even if the user has administrative privileges (at least for Vista), in the second case is Vista that is blocking the action.
What is the solution??
Thank you and regards.
Roberto G.
Problem 1: Upon starting SQL Server Express I get the following error:
"An unhandled exception has occurred in a component in your application....Cannot create a stable subkey under a volatile parent." Clicking OK lets the Server continue and I can use it quasi-normally.
Problem 2: Also, when I try to generate a diagram, I get a message that states
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
But, the database HAS an owner, and resetting the owner (using the Files...) to other users has no effect.
Problem 3: I tried to change the name of a database, and it refused to do so. Except that now all objects under the database name (it is the same old name) have disappeared. Is there a magic folder somewhere that contains all of the tables, etc. that were 'banished' from the server?
Is there a way to detach the databases from Express and reattach them to the SQL Server 2000 I am also running? Last time I tried the 'detach' worked but all the objects were wiped out by the 'attach'. Handy feature.
Thanks
Glen
Hi all,
I downloaded the SSEUtilSetup.EXE and extracted the SSEUtil.exe to a folder of C:drive of my PC that is Windows XP Pro. I plan to learn the CLR programming via user-instance of SQL Server Express. I need to have SQL Server Express Utility installed. Please help and tell me how I can install SSEUtil.exe in my PC and how I use it to interact with SQL Server Express.
Thanks,
Scott Chang
I'm using the login/roles from Visual Studio 2005 in a website.
Is MS SQL Express mandatory? I already have MS SQL 2000 on the box. Is there any way to use that instead?
And if so, will I need to install MS SQL on the box I'm building the webiste on?
Thanks,
oilcan
Hi all,
I am trying to setup a small database on an XP system. Installed SQL Express, installed Management studio Express - no errors
I create a user called Joe using SQL server authentication
I create a database and make Joe the owner
I then try to connect to the database using the Joe account and get an error saying that
Cannot connect to JOE-PCSQLEXPRESS
Additional Information:
Login failed for user joe. The user is not associated with a trusted SQL Server Connection
I then try to do a reverse telnet on 1433 and get an error so I am guessing that there is no listener on that Port.
I remember seeing something needing starting when running express?
What am I not seeing?
I had SQLExpress on my machine. I was having problems so I deinstalled it using Add/remove programs.
deinstalled all components (Microsoft SQL Express).
However, I still see the following when I do Programs -> Microsoft SQL Server 2005 -> Configuraiton tools.- 3 options listed.
I then tried to install SQLExpress again - but it will not let me saying that components are already installed.
Can someone help -
1. I do not understand why still seeing SQL Server 2005 under Programs. Nothing is listed in add/remove programs.
thanks. Been at this awhile.
I am trying to install SQL Express When the install process tries to install SQL Native Client it fails because there is no install package.
I have tried twice and it failed at the same place
I have plenty of disk space.
Any help apprieciated
Rusty
I tried to install the SQL Express 2005 on my PC several times.
However, I got the follwowing message at checking the configuration. "Setup has detected a probelm with Microsoft .Net Framewrok installation and cannot proceed. Microsoft .Net Farmework 2.0 is either not installed on this system or is corrupt."
I installed .NET 2.0 and got the message, "Microsoft .Net Framework 2.0 has been successfully installed."
The message seems to complete the installation of .Net but acutually failed installing the SQL.
Plaese give me advises.
Thank you
The following mesasge is tthat I verified the files of .Net 2.0 after installation.
09/27/07 19:49:41 *********** Log info from SetupVerifier.exe ***********
09/27/07 19:49:41
09/27/07 19:49:41 ################# SUMMARY ##########################
09/27/07 19:49:41 Number of files with correct attributes = 496
09/27/07 19:49:41 Number of files installed but not supposed = 0
09/27/07 19:49:41 Number of files with incorrect version = 0
09/27/07 19:49:41 Number of files with incorrect language = 1
09/27/07 19:49:41 Number of files missing = 0
09/27/07 19:49:41 Number of file warnings = 1
09/27/07 19:49:41
09/27/07 19:49:41 Total files = 497
09/27/07 19:49:41 ######################################################
09/27/07 19:49:41
09/27/07 19:49:41 ################## ERRORS ##########################
09/27/07 19:49:41 Contents of FileLangProb.txt
09/27/07 19:49:41 CompID File Version Language Shared Permanent CRC Excluded
09/27/07 19:49:41
09/27/07 19:49:41 *** File with different language stamp (expected/actual) ***
09/27/07 19:49:41 {77B2DBF7-665A-432C-B1B4-ADD82744DE15} C:Program FilesInternet ExplorerMUI 409mscorier.dll 2.0.50727.42 ENU true false - false
09/27/07 19:49:41 {77B2DBF7-665A-432C-B1B4-ADD82744DE15} C:Program FilesInternet ExplorerMUI 409mscorier.dll 2.0.50727.42 JPN true false 0x18b18a53 false
09/27/07 19:49:41
09/27/07 19:49:41
09/27/07 19:49:41 Contents of FileMissing.txt
09/27/07 19:49:41 CompID File Version Language Shared Permanent CRC Excluded
09/27/07 19:49:41
09/27/07 19:49:41
09/27/07 19:49:41 Contents of FileVerProb.txt
09/27/07 19:49:41 CompID File Version Language Shared Permanent CRC Excluded
09/27/07 19:49:41
09/27/07 19:49:41 ######################################################
09/27/07 19:49:41
09/27/07 19:49:41 ################# WARNINGS #########################
09/27/07 19:49:41 CompID File Version Language Shared Permanent CRC Excluded
09/27/07 19:49:41
09/27/07 19:49:41 *** File with greater version (expected/actual) ***
09/27/07 19:49:41 {1A6D8713-9116-44AE-BA60-4CF0E8C1D58B} C:Program FilesCommon FilesMicrosoft SharedDWDW20.EXE 11.0.6555.0 - false false - false
09/27/07 19:49:41 {1A6D8713-9116-44AE-BA60-4CF0E8C1D58B} C:Program FilesCommon FilesMicrosoft SharedDWDW20.EXE 11.0.6560.0 - false false 0x5b5a178d false
09/27/07 19:49:41
09/27/07 19:49:41 ######################################################
09/27/07 19:49:41
09/27/07 19:49:41 ******** End of log info from SetupVerifier.exe *******
09/27/07 19:49:41
09/27/07 19:49:41 ****ERROR**** VerifySetup returned false for parameters v20_urt_std_x86_ixp.sem and E_FILES
09/27/07 19:49:41 Verification thread is returning 100
The following message is from SQL setup log.
*****************************************************************************************************************************
Microsoft SQL Server 2005 Setup beginning at Thu Sep 27 19:45:19 2007
Process ID : 2992
c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/8/27 19:45:19
Complete: LoadResourcesAction at: 2007/8/27 19:45:19, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/27 19:45:19
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/8/27 19:45:19, returned true
Running: ValidateWinNTAction at: 2007/8/27 19:45:19
Complete: ValidateWinNTAction at: 2007/8/27 19:45:19, returned true
Running: ValidateMinOSAction at: 2007/8/27 19:45:19
Complete: ValidateMinOSAction at: 2007/8/27 19:45:19, returned true
Running: PerformSCCAction at: 2007/8/27 19:45:19
Complete: PerformSCCAction at: 2007/8/27 19:45:19, returned true
Running: ActivateLoggingAction at: 2007/8/27 19:45:19
Complete: ActivateLoggingAction at: 2007/8/27 19:45:19, returned true
Running: DetectPatchedBootstrapAction at: 2007/8/27 19:45:19
Complete: DetectPatchedBootstrapAction at: 2007/8/27 19:45:19, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2992" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2007/8/27 19:45:19
Complete: PerformDotNetCheck2 at: 2007/8/27 19:45:19, returned true
Running: InvokeSqlSetupDllAction at: 2007/8/27 19:45:19
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.3042.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [YA]
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 = YA, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = YA, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = YA, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = YA, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = YA, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = YA, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = YA, Article = XMLDomDocument, Result = 0 (0x0)
Machine = YA, Article = Processor, Result = 0 (0x0)
Machine = YA, Article = PhysicalMemory, Result = 0 (0x0)
Machine = YA, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = YA, Article = OSVersion, Result = 0 (0x0)
Machine = YA, Article = OSServicePack, Result = 0 (0x0)
Machine = YA, Article = OSType, Result = 0 (0x0)
Machine = YA, Article = AdminShare, Result = 0 (0x0)
Machine = YA, Article = PendingReboot, Result = 0 (0x0)
Machine = YA, Article = IEVersion, Result = 0 (0x0)
Machine = YA, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = YA, Article = COMPlus, Result = 0 (0x0)
Machine = YA, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = YA, Article = MDAC25Version, Result = 0 (0x0)
Machine = YA, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: YA
*******************************************
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: Pending Reboot 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
Article: Edition Upgrade Check, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard - unknown error 0x80004003
<EndFunc Name='DisplaySCCWizard' Return='-2147467261' GetLastError='183'>
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Failed to load the Wizard UI. There is either a problem with .Net framework installation or it is not installed. : -2147467261
Message displayed to user
Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt.
Invalid pointer
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_YA_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0011.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0011_YA_SCC.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0011.cab" Error Code : 32
Running: UploadDrWatsonLogAction at: 2007/8/27 19:46:4
Message pump returning: 2147500035
Today, I attempted to install sp2 to my SQL 2005 Express instance and the install dialog would not allow me to check the box next to database services. At the bottom of the dialog it says this edition of SQL Server does not qualify for the update. It allowed other parts of the product to be updated, just not the engine.
This is on a Windows XP, SP2 box.
Shouldn't I be allowed to install the update for the database engine?
Thanks,
Del
I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps here http://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.Can anyone give me an idea of where to start?Thanks
View 4 Replies View RelatedI am using Visual Studio 2005 Standard on XP ProfEverything works well with installation except Sql Server Express was not installed.I tried repairing/reinstalling -> would not install sql server expresssI tried uninstalling and starting over (which was a hassle with all of the manual removals)Still the same problem, everything works well but Sql Server Express will not install. Any suggestions?? Thanx, Jim
View 2 Replies View Related