Can't Get SS Express SP2 To Install On Vista Build 5744
Nov 14, 2006
Having had no luck getting prior versions of Sql Server Express to install on Vista RC2. I was hoping that SP2 would install with no problems however I'm still getting the same error as before and can't find any working solution to this anywhere on the web.
The actual error I'm getting occurs when the install tries to start the SQL Server service and connect. I get
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
This error apparently also occurs on other platforms than Vista. Any ideas how to get past this? The Vista install is still pretty much a clean install.
I'm trying to install sql express sp2 2005 in my laptop but i can't, give me this error
Machine : W7J Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_W7J_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515
I'm choosing Windows autentication mode, so i don't know it says "sa" user.
I purchased a Dell laptop with Vista. I then downloaded MSSQL Express Edition with Advanced Services (after first downloading .NET 3.5) and when it tried to run the executable, it gave an error that it was not a valid win32 app.
How to I correct this and successfully install MSSQL Express?
Code Snippet[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out. " [06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out. " [06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
[06/05/07,11:30:10] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed. [06/05/07,11:52:13] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession*** I try to install it from visual studio net professional 2005, every time it fails. Any idea?
I am unable to install Business Contact Manager for Outlook 2007. I sought help in the BCM forum, but the developer who I spoke with came to the conclusion that it is a SQL Server Express problem that I am experiencing, and so he recommended that I come here for help.
I am running on Vista Ultimate.
Every attempt I have made to install BCM (and later SQL Express Server 2005 separately, see below) has failed at the same point, with the same error message:
"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
Today I attempted to install SQL Express Server SP2 separately on its own, the idea being that if this worked, then I might be able to install BCM on top of it. I attempted the SQL EE SP2 installation after uninstalling all remnants of previous installations to the best of my ablity. The SP2 installation failed at the same point, and had the same appearance, as I saw in all prior attempts. (The installer reported no errors or warnings in its system checks prior to beginning the actual install.)
Here is the summary log from this trial:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Tue Apr 03 15:39:02 2007 Machine : LUMACRAFT-1 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : LUMACRAFT-1Product : SQL Server Database ServicesError : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.--------------------------------------------------------------------------------Machine : LUMACRAFT-1 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------
The pertinent section from the SQLSetup0008_user_SQL.log seems to be:
MSI (s) (F0:88) [15:42:00:403]: Invoking remote custom action. DLL: C:WindowsInstallerMSI118F.tmp, Entrypoint: Do_sqlScript<Func Name='LaunchFunction'>Function=Do_sqlScript<Func Name='GetCAContext'><EndFunc Name='GetCAContext' Return='T' GetLastError='203'>Doing Action: Do_sqlScriptPerfTime Start: Do_sqlScript : Tue Apr 03 15:42:00 2007Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Apr 03 15:42:00 2007SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Tue Apr 03 15:42:05 2007SQL_ERROR (-1) in OdbcConnection::connectsqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Error Code: 0x80074818 (18456)Windows Error Text: Source File Name: libodbc_connection.cppCompiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcConnection::connect@connectSource Line Number: 148---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsOriginial error was 80074818 (18456)iptSqlScriptHlprError Code: 18456Other things that I have tried include disabling UAC, and running BCM setup.exe 'as administrator'.
Any advice on how to get SQL EE installed, so that I can ultimately install BCM, will be greatly appreciated.
I have a new laptop with VISTA. I've enabled IIS with all features turned on. When I install SQL Server 2005 Express I get a warning stating IIS is either not installed or disabled. Any ideas? Thanks.
I have been trying to install SQL Express SP2 (SQLEXPR32.exe) on a Window Vista Home Premium for past 2 days . After failing I tried installing SQLEXPR_ADV. (Maybe I have a corrupted download, desperate enough to try anything.). However it keeps showing the following 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.
I have search through the forums. One of the possibilities is due to a WMI repository corruption. Tried fixing it, but the problem still persists. (Maybe I am doing it the wrong way , I have downloaded the WMIDiag scripts, not too sure if i ran it correctly).
Below is the installation summary:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Thu Mar 15 02:13:51 2007
ATLANTIS : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online. Machine : ATLANTIS Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0013_ATLANTIS_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ATLANTIS Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0013_ATLANTIS_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ATLANTIS Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0013_ATLANTIS_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ATLANTIS 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 : ATLANTIS Product : Microsoft SQL Server 2005 Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0013_ATLANTIS_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 --------------------------------------------------------------------------------
What are the other possibilities and fixes? Please help.
When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL_ERROR (-1) in OdbcStatement::execute_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401)Windows Error Text: Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug 2 16:21:02 2006 Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.
Any suggestions on how to get SQL Server to install on Vista?
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 6000) Time : Thu Jul 26 21:21:43 2007
Machine : CHARLIE Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I have tried this several times and each time get the same result. I even installed Visual Studio 2008 beta 2 - everything but SQL Server Express installed fine. The error I get when running the SQL Server 2005 Express download is (from the log file):
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Mon Nov 12 22:31:11 2007 Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Mon Nov 12 22:31:11 2007 SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections Service MSSQL$SQLEXPRESS started at Mon Nov 12 22:31:18 2007 SQL_ERROR (-1) in OdbcConnection::connect sqlstate=IM003, level=-1, state=-1, native_error=160, msg=Specified driver could not be loaded due to system error 193 (SQL Native Client).
Error Code: 0x800700a0 (160) Windows Error Text: One or more arguments are not correct. Source File Name: libodbc_connection.cpp Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcConnection::connect@connect Source Line Number: 148
Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: Specified driver could not be loaded due to system error 193 (SQL Native Client). Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
I have no idea what the error is or how to fix it; I've enountered a number of postings related to install errors but none match exactly.
I do have the full log. Thanks in advance for any/all help!
Past one week I have been struggling to install SQL server express edition on my laptop which is preinstalled with Vista Basic. After it commences installation, it says the .net 2.0 on the system in corrupted.
Please let me know how to proceed ASAP... i have a project due for submission this week!
I have tried to install SQL Server 2005 Express several times with no success. I have followed the instructions to remove all SQL files on the Programs menu. Then, when I attempt to install it again, it only goes as far as the database where it stops and gives the error message: SQL Server cannot write system databases to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again.
It doesn't give options and I can only abort the installation.
Does anyone have a remedy for a technologically challenged person?
Steps to install SSX (& Reporting Serivces) on 64 bit Windows Vista Ultimate
I struggled quite a bit over the past few days to complete this install. The sequence of steps is less obvious than those for Windows XP Pro on a 32 bit machine.
I recorded all the steps in one place in cookbook style for non-technical (but database capable) users like myself. I have referenced appropriate other postings and sources for detail steps. These are steps I found useful, you may be in a different situation.
My environment is as follows: -New HP dv9000 w/ 2GHz and 2GB memory -Factory installed Windows Vista Ultimate. Note this includes .NET Framework 2.0 so I did not have to deal with installing that. -I have no extant databases or SQL Server that I am trying to convert or upgrade!
Setup Steps Before Install: 1) Turn off User Account Control. At present, I am a one-user operation with close control over my system and there seemed to be issues with getting reporting services set up right with UAC. I may come back and modify this step later on and certainly would change this for any releasable systems.
1a)Go to Control Panel Home --> User Accounts --> Turn User Account Control on or off. 1b)Unselect Use User Acount Control. 2)Set up your IIS 7.0 for Reporting Services. IIS 7.0 has IIS 6.0 Compatibility features turned off out of the box. You will turn them on with this step. This is needed for both Reporting services and to enable the Adminscripts that are used in Step 3 below.
2a) Use the Control Panel --> Programs --> Turn Windows features on and off function. This is quite nicely desribed with screen shots at: http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957 These steps worked for me although they are labeled Vista Beta 2.
3)Set up your 64 bit machine to run 32 bit ASP.NET This capability is needed to make sure you pass the System Configuration Check for Reporting Services. I don't know the full implications of this step and wonder if it might eventually bite me if I have to flip-flop between 32 and 64 bit ASP.NET or have them both run at the same time.
3a) Open a command line window by: Start --> Accessories -- Cmd Prompt 3b) In this window type: cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
At some point, you may wish to go back to 64 bit. For that, see the posting by MihaelaE as an Answer in the SQL Server Reporting Services Forum under a thread started by fagster on 3/8/2007.
Now to actually install SQL Server.
1) Download the 64 bit SSX. This step fooled me for a while as the 64-bit downloads are 'below the fold' on the web page.
1a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
1b) Scroll down the page and below Step 5, Register, you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Express Edition, click here." 1c) Follow the "click here" to get the download.
2) Install the package from step 1c and you will get SQL Server Express.
2a) The install may fail and complain about not finding a valid SQL Server Native Client Install, sqlncli_x64.msi. You will have to extract the files manually and then run the sqlncli_64.msi package by itself. Then you can go back to step 2 and should be successful. To do this, see post of Mike Wachal on 4/5/2007 to SQL Server Express Forum, titled "Cannot Install SQL Server Express on Vista Ultimate -- cannot find MS SQL Server Native Client".
3) Now add in the SQL Server Management Studio Express 64 bit version.
3a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
3b) Scroll down the page and below Step 5, Register you will see this text which takes you to the download you want: "* For the 64-bit install of SQL Server 2005 Management Studio Express, click here."
3c) Follow the "click here" to get the download.
4) Now add the SQL Server Reporting Services.
4a) Go to the SSX download page: http://msdn.microsoft.com/vstudio/express/sql/download/
4b) Scroll to Step 3 Download and Install (in the middle of the page) and download SQL Server Express Edition with Advanced Services SP2. 4c) Install, but at the Feature Selection screen, disable all components EXCEPT Reporting Services. You already have the other components installed. 4d) In the install, you will get a screen called "Report Server Installation Options". Go ahead and select the "Install but do not configure the server" radio button.
5) Go ahead and configure SQL Server Reporting Services. I'm not highly skilled in this area so I recommend the SQL Server Express Video "Learning Video 10: Getting Started with Reporting Services". This is found at: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx I found this video to be cogent and useful.
That's what it took me to get SQL Server Express installed with reporting services on a 64 bit Vista Ultimate system. Sorry if this is so long but I wanted to cover all the steps that hung me up.
To forum moderators: If I have any errors that will lead people astray, I'm more than happy to correct them.
This posting is "AS IS" with no warrantees and caveat emptor.
I have Vista Home premium installed on my system. I installed SQL server 2005 express SP2. When I am trying to attach Advetureworks database by using following script, i get the following error.I am logged in as administrator.What kind of permission i have to set so that i can install the database.Any help will be appreciated.Script is :
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_Data.mdf". Operating system error 5: "5(Access is denied.)".
I am trying to install SQL Server Express - (the non ADV version) and get the following error.
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".
I have 64 bit Vista Ultimate running on an HP dv9000.
I am using the download from the bottom of the download page for SSX where it says 64 bit version.
Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.
I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.
I would appreciate being pointed at the right downloads for what seems to be a simple install.
Ok ive tried looking everywhere for a solution but i just cant find one... please help me
I need to install SQL Server 2005 (for reporting services mainly) on Vista, but i have issues.
I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.
The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."
Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.
A walkthrough or something would really help...
P.S Im running on Vista Ultimate and trying to install SQL Server 2005 Enterprise.
I don't seem to be able to get AdventureWorksBI installed in Vista. I am running SQLServer 2005 sp2.
When I try to install I get an error: Error 1316 A network error occurred while attempting to read from the file <path>AdventureWorksBI[1].msi.
If I try to repair the install, I get the message Error 1321: The installer has insufficient privileges to modify the file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_data.mdf
My login has administrator privileges. I have installed and uninstalled for days, so I am not certain what I have mucked up in my registry.
Perhaps the AdventureworksDW examples don't work in Vista? Do I need to wipe the drive and install XP?
I've been having some problems trying to install SQL Sever 2005 on my local Vista machine. Using the ISO file that I've downloaded from the MSDN site (twice now) I get an error stating that the Sql.cab file is corrupt. I at first thougt that this was because of a corrupt download but now I wonder because of a second issue. I downloaded the Express version (twice also) and it will not install either. The error for this comes in the initial unpacking of files with a corrupt file as well. As a side note, when I installed Visual Studio 2005 I received an error on the SQL express install that said 'Unexpected value returned' from some process. If anyone can help, I would appreciated the saved hair follicles.
I am unable to make SQL Server 2005 work under Vista. As soon as I try to register a server I get a message saying error 40. It does not seem as straightforward as SQL 2000. Under Registered servers I can see a green arrow and a local instance called paul-pc.... I have no idea what credentials to put into the login properties. I am from an Access background so this is new to me. I would appreciate it if someone can talk me through the process
I've just done a clean install of Vista Ultimate (release). SQL Server 2005 will only install the client tools - it refuses to install any of the server components (including the default instance).
I get the "SQL Server Edition Operating System Compatibility (Warning). " I installed the missing IIS 7.0 which got rid of the IIS warning message.
Hi, I have all updates for Vista, tried to install SQL Server 2005 SP2, the following log file:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Wed Mar 26 12:20:54 2008
USER-PC : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. Machine : USER-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQL.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Workstation Components, Books Online and Development Tools Warning : Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server 2005 Tools Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_Tools.log --------------------------------------------------------------------------------
Setup succeeded with the installation, inspect the log file completely for status on all the components. Time : Wed Mar 26 12:23:51 2008
When I try to start SQL Server it times out. SQL Server Express is running ok. Can you help me get this started? Thank you, Lucy
I'm loading the dev version of sql 2005 on vista ultmate. I'm not seeing the manager tools. I've installed sp2. In the services it says sql express but not sql server. I read the requirments for the dev version and it didn't list vista. Any ideas?
When I try to install Reporting Services on my Vista x64 machine, the following happens: In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning. On the following section, Reporting Services is greyed out so cannot be installed.I have found many posts on this matter and all of them suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.
I have also installed SP2, but again this didn't help when I returned to the original installation.
I am trying to run SQL Server 2005 on VISTA. When I install I am informed I must run SP2. Which of the following is the correct servic pack?
SQLServer2005SP2-KB921896-IA64-ENU.exe
392.4 MB
DownloadDownload
SQLServer2005SP2-KB921896-x64-ENU.exe
339.4 MB
DownloadDownload
SQLServer2005SP2-KB921896-x86-ENU.exe
282.4 MB
DownloadDownload
When I install I get a warning that IIS is not running. IIS IS running. Is this why I need the service pack? I am not getting anything added to program files that allows me to manage SQL Server. I am looking for Enterprise Manager, MMC, or some such thing. How can I get it to install? Is this related to Vista and SP2?
I've installed Windows Vista 64 bit on my pc (I had XP Pro). Also I've installed the management studio of SQL Server 2005 developer edition which I've uses also on my XP machine.
I've a online server at "myserver.myprovider.com". With C:WindowsSystem32cliconfg.exe a made a TCP/IP alias to with the name "MySql". In XP I then can connect in Sql management studio to "MySql" and everyting works perfect (I also use some other programs which needs the cliconfg alias.
After I installed Vista, I take the same steps (I've done this over 30 times, but in XP). When I then want to connect to "MySql" in management studio, I get this error: (translated from dutch) "Cannot connect to MySql. Maybe this error is caused by the fact that the SQL Server don't allow external connections. Error: 53.
I just recently purchased a sony with Vista business preloaded. It seems like it came with MS 2005 Sql Server but I'm not sure what edition. I went to the start menu to locate the Management Studio however the only option was the Configuration file. I went to MS site and downloaded the 2005 Sql Server Express Edition with Advance Service SP2 and it installed correctly. I believe this edition comes with Management Studio. However when I went to my Start Menu, the Management Studio file is still not there. How do I fix this problem? I am new to the MS Sql so a detail explanation will be appreciated. Thanks in advance.
I downloaded SQL Server 2005 Express Edition with Advenced SP2, it failes to install Database Server Service and returns an error that it cannot connect to ODBC driver
Hi, I have all updates for Vista, tried to install SQL Server 2005 SP2, the following log file:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Wed Mar 26 12:20:54 2008
USER-PC : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. Machine : USER-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_SQL.log -------------------------------------------------------------------------------- Machine : USER-PC Product : Workstation Components, Books Online and Development Tools Warning : Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : USER-PC Product : Microsoft SQL Server 2005 Tools Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_USER-PC_Tools.log --------------------------------------------------------------------------------
Setup succeeded with the installation, inspect the log file completely for status on all the components. Time : Wed Mar 26 12:23:51 2008
Hi, I don't know, how I can install the SQL Server 2005 XE (Express Edition) on Windows Vista RTM Ultimate, I have a problem... I don't know what happend, I tried to connect to the Database and the Studio Magnament threw:
TITLE: Connect to Server
------------------------------
Cannot connect to 1SQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
Error mientras se establecía la conexión con el servidor. Al conectar con SQL Server 2005, el error se puede producir porque la configuración predeterminada de SQL Server no admite conexiones remotas. (provider: Interfaces de red SQL, error: 26 - Error al buscar el servidor o instancia especificado) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------ What's the problem?
Ok ive tried looking everywhere for a solution but i just cant find one... please help me
I need to install SQL Server 2005 on Vista, but i have issues.
I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected.
The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..."
Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point.
A walkthrough or something would really help...
P.S Im running on Vista Ultimate and trying to install SQL Server 2005 Enterprise Edition
I want to ask a question, I am using Windows Vista Home Premium Edition in my notebook, I installed Visual Studio 2005 in it, it is working properly. Now I want to install SQL Server 2005 Enterprise Edition in it, in the begining it was giving me errors while installing Sql Server 2005 Enterprise Edition, but then it installed properly, but the problem is I cant see the "SQL Server Management Studio" in installed SQL Server, I think it is not installed properly.
I was struggling with installing reporting services from Sql 2005 dev edition on windows vista. I somehow managed to install the SQLExpress edition for Reporting Services, but now i want to unistall it and install Sql Reporting Services from Sql 2005 Dev edition CD.
When I try to unistall the SQlExpress Reporting Servie instance, the screen which says unistalling components disappears in a couple of secs and when i refresh the list of programs installed under Programs and features, i can still see SQLExpress Reporting Servies, i do not understand why this is happening and probably this is the reason behind not able to see the Reproting Services check box ungreyed when installing SQL 2005 dev edition. CAN SOMEONE HELP ME ON THIS PLEASE?
