Hi,
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!
Thanks
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.
Time : Thu Jul 26 21:23:43 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SCC.log
c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
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!
Mary
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?
Thank you.
George
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 :
EXEC sp_attach_db @dbname = N'AdventureWorks',
@filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_Data.mdf',
@filename2 = N'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_log.ldf' ;
Error is :
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_Data.mdf". Operating system error 5: "5(Access is denied.)".
Regards
i've tried to install sql server 2005 express edition several times but when it get to the 'database services' it gives the following error:
SQL Server Setup could not connect to the database service configuration. The error was:
[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
please help
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.
Thanks,
David A. Gilmour
I'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine.
I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch
I'm doing a named instance using the built-in system account with windows authentication mode.
Is there any COMPLETE guide as to how to work through all these installation problems?
I've gotten same results after about six attempts.
These always install:
SQL Setup Support Files
SQL Native Client
SQL VSS Writer
SQL Server Backward Compatibility Files
SQLXML4
SQL Server Books Online
These always fail:
OCW11
SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components; Books Online
Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released?
When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though?
All of the features are green ticked except the OS which has a compatabilty warning (which i expected).
I feel im missing something really simple here....
Cheers
Rob Macnair
I want to install SQL Server 2005 Developer Edition on a computer with Vista Business. It looks like a lot of issues. (1) Can I do this? (2) Does anyone have any instrucions?
Thanks for your help
Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!
View 3 Replies View RelatedHi
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
Thanks
Doug
ok, today i upgraded to Vista, but i can't create database.
create database permission denied in database master. ("Microsoft sql server Error 262")
it must be the Vista thing because i don't have any problem with xp. yes, i the patch installed. I use SQl server management studio with Windows Authentication
Is it possible to install sql express on a 2 cpu Vista pc, even though this is stated to NOT be supported, by assigning CPU affinty, e.g., something similar to c:windowssystem32cmd.exe /C start /afinity 1 notepad.exe?
View 5 Replies View RelatedHi,
Is there any one knows how to fix this, please help! This is urgent.
In the configuration checking, there was only one warning message about operation system (this warning should be ignored according to some advice). When coming to the Component checkboxes, there is only one checkboxe checkable at the last item.
Thanks!
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 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.
View 4 Replies View RelatedWhen 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?
Hi,
Im encountering yet another problem in Vista(Vista Home Premium). I have turned on all IIS features from control panel. When I open http://localhost it gives the error
HTTP Error 404.4 - Not Found
Description: The resource you are looking for does not have a handler associated with it
How should i resolve this?
Also, when I try to install SQL server 2005 express edition, it gives the warning that IIS is not installed, though I have installed all the features and it is running.
I have been struggling for the past one week, just to install SQL server on vista!
Please help.
Thanks
Good day all, I wanted to get some feedback on what I think may be an issue between SQL Server 2005 Express and Vista. Specifically I use Vista Business edition and I was trying to execute the same bit of code on two different machines with the same exact database. The ONLY difference was Vista. See code below...what I doing in XP Professional SP2 was inserting an image into a table. This worked well on XP but the same code failed to actually insert the image. A row was created in 'myTable' but not binary data from the image insert. Can someone please advise or help me - it goes without saying that I an quite frustrated. ;-)
CREATE TABLE myTable(FileName nvarchar(60),
FileType nvarchar(60), Document varbinary(max))
GO
INSERT INTO myTable(FileName, FileType, Document)
SELECT 'titleist-dtsolo.jpg' AS FileName,
'.jpg' AS FileType,
* FROM OPENROWSET(BULK N'C:UsersBrian EvansDesktopgolfPremiumsgolfPremiumsProjectWebImages itleist-dtsolo.jpg', SINGLE_BLOB) AS Document
GO
Selecting from the results yields a row with no image data, and I did verify the path and image before and after running this sample.
Hi!
I am getting error when trying to install SQL 2005 express edition on Windows Vista (32-bit). It says that I don't have the framework (or it's corrupt), but I know that i don't need to install it again because it cames already with Vista.
I tried to install the framework, but it says that i've already the framework installed.
Any help or pointers would be greatly appreciated.
Thank you!
Monica
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.
.
Hi,
I have installed SQL Server 2005 express edition on Windows 2003 Server, but i am unable to make a connection using
sqlcmd -S <servnameinstancename> -U <loginID> -P <pwd> -d <dbname>
but i am able to make the connection using
sqlcmd -S <servnameinstancename>,<portnumber> -U <loginID> -P <pwd> -d <dbname>
What could be the possible reason for this and how can i configure sql
server 2005 express edition to make connections without specifying any
portnumber in the connection string. Both the sqlserver database
service and browser services are running.
Regards
Salil
Hi. I've recently installed (not sure about the exact order):
.NET 2.0 Redist Package
.NET 2.0 Framework SDK
Visual C# 2005 EE
Visual C++ 2005 EE
Platform SDK (Windows Server 2003 R2)
Directx 9 SDK
I just want to start my way up with C# initially. I've been watching some lessons and I'm trying to use some SQL features of Visual Studio EE. Whenever I try to create a SQL item in my project list, I get the following error message box:
Connections to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component, or download from the URL:...
I got the SQL 2005 Express from MS' website, only to get this during (everything set to default) installation:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
I've read through every thread I can find, but can't find an answer for this.
The installation gets all the way to the end, and then stops. I receive the following error message:
"Microsoft SQL Server 2005 Setup has encountered a problem and will end..."
I've tried all the troubleshooting tips. I never had any of the beta or prior versions installed, so I'm not sure what the hangup is.
Can anyone please help me with this?
Charlie
Greetz All.
XP Pro SP2. For days I've been trying to install SQL SERVER 2005 EXPRESS EDITION.
Installation gets to around 95% and stops, citing error 2950. I've applied MS Workaround and
provided Full Rights to folder NetworkService (I have no folder named
Protect), to no avail. Any and all help most welcome. Relevant logs follow.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build
2600)
Time : Wed Apr 09 19:59:03 2008
Machine : GEMINI
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log
Machine : GEMINI
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log
Machine : GEMINI
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log
Machine : GEMINI
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log
Machine : GEMINI
Product : SQL Server Database Services
Error : 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."
Machine : GEMINI
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQL.log
Last Action : InstallFinalize
Error String : 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 (1067) The process terminated unexpectedly.
Error Number : 29503
SQL Server Setup failed. %ProgramFiles%Microsoft SQL Server90Setup
bootstrapLOGSummary.txt.
Time : Wed Apr 09 23:15:10 2008
List of log files:
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SQL.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_Support.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_SCC.log
C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_WI.log
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
------------------------------------------------------------------------------------------------
Microsoft SQL Server 2005 Setup beginning at Wed Apr 09 19:59:03 2008
Process ID : 2148
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version:
2005.90.3042.0
Running: LoadResourcesAction at: 2008/3/9 19:59:3
Complete: LoadResourcesAction at: 2008/3/9 19:59:3, returned true
Running: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup
Bootstrapxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3, returned true
Running: ValidateWinNTAction at: 2008/3/9 19:59:3
Complete: ValidateWinNTAction at: 2008/3/9 19:59:3, returned true
Running: ValidateMinOSAction at: 2008/3/9 19:59:3
Complete: ValidateMinOSAction at: 2008/3/9 19:59:3, returned true
Running: PerformSCCAction at: 2008/3/9 19:59:3
Complete: PerformSCCAction at: 2008/3/9 19:59:3, returned true
Running: ActivateLoggingAction at: 2008/3/9 19:59:3
Complete: ActivateLoggingAction at: 2008/3/9 19:59:3, returned true
Running: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3
Complete: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2148" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following
restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2008/3/9 19:59:3
Complete: PerformDotNetCheck2 at: 2008/3/9 19:59:3, returned true
Running: InvokeSqlSetupDllAction at: 2008/3/9 19:59:3
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 [GEMINI]
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 = GEMINI, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = GEMINI, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = GEMINI, Article = XMLDomDocument, Result = 0 (0x0)
Machine = GEMINI, Article = Processor, Result = 0 (0x0)
Machine = GEMINI, Article = PhysicalMemory, Result = 0 (0x0)
Machine = GEMINI, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = GEMINI, Article = OSVersion, Result = 0 (0x0)
Machine = GEMINI, Article = OSServicePack, Result = 0 (0x0)
Machine = GEMINI, Article = OSType, Result = 0 (0x0)
Machine = GEMINI, Article = AdminShare, Result = 0 (0x0)
Machine = GEMINI, Article = PendingReboot, Result = 0 (0x0)
Machine = GEMINI, Article = IEVersion, Result = 0 (0x0)
Machine = GEMINI, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = GEMINI, Article = COMPlus, Result = 0 (0x0)
Machine = GEMINI, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = GEMINI, Article = MDAC25Version, Result = 0 (0x0)
Machine = GEMINI, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: GEMINI
*******************************************
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 returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup
Bootstrapsqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2008/3/9 20:0:44, returned true
Running: SetPackageInstallStateAction at: 2008/3/9 20:0:44
Complete: SetPackageInstallStateAction at: 2008/3/9 20:0:45, returned true
Running: DeterminePackageTransformsAction at: 2008/3/9 20:0:45
Complete: DeterminePackageTransformsAction at: 2008/3/9 20:0:45, returned true
Running: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45
Complete: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45, returned true
Running: OpenPipeAction at: 2008/3/9 20:0:45
Complete: OpenPipeAction at: 2008/3/9 20:0:45, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2008/3/9 20:0:45
Complete: CreatePipeAction at: 2008/3/9 20:0:45, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following
restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2008/3/9 20:0:45
Complete: PopulateMutatorDbAction at: 2008/3/9 20:0:45, returned true
Running: GenerateRequestsAction at: 2008/3/9 20:0:45
SQL_Engine = 3
SQL_Data_Files = 3
SQL_Replication = -1
SQL_FullText = -1
SQL_SharedTools = 3
SQL_BC_DEP = -1
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = -1
Connectivity = -1
SQL_Tools90 = -1
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = -1
TOOLS_BC_DEP = -1
SQL_SSMSEE = -1
SQL_Documentation = -1
SQL_BooksOnline = -1
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2008/3/9 20:0:47, returned true
Running: CreateProgressWindowAction at: 2008/3/9 20:0:47
Complete: CreateProgressWindowAction at: 2008/3/9 20:0:47, returned true
Running: ScheduleActionAction at: 2008/3/9 20:0:47
Complete: ScheduleActionAction at: 2008/3/9 20:0:48, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "as",
install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package: "as",
install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported
during analysis:
No install request found for package: "msxml6", referred by package: "as",
install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported during
analysis:
No install request found for package: "dts", install will be skipped as a
result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported
during analysis:
No install request found for package: "sqlncli", referred by package: "dts",
install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "dts",
install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package:
"dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported
during analysis:
No install request found for package: "msxml6", referred by package: "dts",
install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported during
analysis:
No install request found for package: "ns", install will be skipped as a
result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported
during analysis:
No install request found for package: "sqlncli", referred by package: "ns",
install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "ns",
install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package: "ns",
install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported
during analysis:
No install request found for package: "msxml6", referred by package: "ns",
install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "rs",
install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package: "rs",
install will be skipped as a result.
Running: InstallSqlAction.11 at: 2008/3/9 20:0:48
Installing: sqlsupport on target: GEMINI
Complete: InstallSqlAction.11 at: 2008/3/9 20:2:8, returned true
Running: InstallSqlAction.12 at: 2008/3/9 20:2:9
Installing: sqlncli on target: GEMINI
Complete: InstallSqlAction.12 at: 2008/3/9 20:3:30, returned true
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "sql",
install will be skipped as a result.
Running: InstallSqlAction.21 at: 2008/3/9 20:3:30
Installing: sqlwriter on target: GEMINI
Complete: InstallSqlAction.21 at: 2008/3/9 20:3:36, returned true
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package:
"sql", install will be skipped as a result.
Running: InstallSqlAction.9 at: 2008/3/9 20:3:36
Installing: msxml6 on target: GEMINI
Complete: InstallSqlAction.9 at: 2008/3/9 20:3:39, returned true
Skipped: InstallToolsAction.11
Skipped: Action "InstallToolsAction.11" was not run. Information reported
during analysis:
No install request found for package: "sqlsupport", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.12
Skipped: Action "InstallToolsAction.12" was not run. Information reported
during analysis:
No install request found for package: "sqlncli", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported
during analysis:
No install request found for package: "PPESku", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run. Information reported
during analysis:
No install request found for package: "owc11", referred by package: "tools",
install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run. Information reported
during analysis:
No install request found for package: "BOL", referred by package: "tools",
install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run. Information reported
during analysis:
No install request found for package: "bcRedist", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.23
Skipped: Action "InstallToolsAction.23" was not run. Information reported
during analysis:
No install request found for package: "ssmsee", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallToolsAction.9
Skipped: Action "InstallToolsAction.9" was not run. Information reported
during analysis:
No install request found for package: "msxml6", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported
during analysis:
No install request found for package: "sqlxml4", referred by package: "ns",
install will be skipped as a result.
Running: InstallSqlAction at: 2008/3/9 20:3:39
Installing: sql on target: GEMINI
Failed to install package
Fatal error during installation.
Setting package return code to: 29503
Complete: InstallSqlAction at: 2008/3/9 20:51:2, returned false
Error: Action "InstallSqlAction" failed during execution. Error information
reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported
during analysis:
No install request found for package: "sqlxml4", referred by package:
"tools", install will be skipped as a result.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported during
analysis:
No install request found for package: "as", install will be skipped as a
result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported during
analysis:
No install request found for package: "rs", install will be skipped as a
result.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported
during analysis:
No install request found for package: "tools", install will be skipped as a
result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run.
Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the
following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not
occur.
Error: Action "UninstallForMSDE2000Action" failed during execution. Error
information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the
following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not
occur.
Installation of package: "patchMSDE2000" failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution. Error
information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the
following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not
occur.
Installation of package: "patchLibertySql" failed due to a precondition.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information
reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following
condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution.
Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the
following condition:
Condition "The Clustered SQL Server instance that hosts is installed."
returned false.
Running: ReportChainingResults at: 2008/3/9 20:51:3
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. :
1067
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
------------------------------------------------------------------------------------------------
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3521
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch:ostCommit
sqls::HighlyAvailablePackage:reInstall
led due to cancel code received from cancel source: 29539
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log" to cab file :
"C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGSqlSetup0005.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/3/9 23:15:31
Message pump returning: 1067
2008-04-09 20:49:34.32 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.1 (Build 2600: Service Pack 2)
2008-04-09 20:49:34.32 Server (c) 2005 Microsoft Corporation.
2008-04-09 20:49:34.32 Server All rights reserved.
2008-04-09 20:49:34.32 Server Server process ID is 2788.
2008-04-09 20:49:34.32 Server Authentication mode is MIXED.
2008-04-09 20:49:34.32 Server Logging SQL Server messages in file
'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2008-04-09 20:49:34.32 Server This instance of SQL Server last reported
using a process ID of 2524 at 4/9/2008 8:42:12 PM (local) 4/9/2008 10:42:12
AM (UTC). This is an informational message only; no user action is required.
2008-04-09 20:49:34.32 Server Registry startup parameters:
2008-04-09 20:49:34.32 Server -d C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLDATAmaster.mdf
2008-04-09 20:49:34.32 Server -e C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLLOGERRORLOG
2008-04-09 20:49:34.32 Server -l C:Program FilesMicrosoft SQL
ServerMSSQL.1MSSQLDATAmastlog.ldf
2008-04-09 20:49:34.32 Server Command Line Startup Parameters:
2008-04-09 20:49:34.32 Server -m SqlSetup
2008-04-09 20:49:34.32 Server SqlSetup
2008-04-09 20:49:34.32 Server -Q
2008-04-09 20:49:34.32 Server -q SQL_Latin1_General_CP1_CI_AS
2008-04-09 20:49:34.32 Server -T 4022
2008-04-09 20:49:34.32 Server -T 3659
2008-04-09 20:49:34.32 Server -T 3610
2008-04-09 20:49:34.32 Server -T 4010
2008-04-09 20:49:34.34 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is required.
2008-04-09 20:49:34.34 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2008-04-09 20:49:34.51 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.
2008-04-09 20:49:34.56 Server The time stamp counter of CPU on
scheduler id 1 is not synchronized with other CPUs.
2008-04-09 20:49:34.57 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2008-04-09 20:49:34.57 spid4s Warning ******************
2008-04-09 20:49:34.57 spid4s SQL Server started in single-user mode.
This an informational message only. No user action is required.
2008-04-09 20:49:34.57 spid4s Starting up database 'master'.
2008-04-09 20:49:34.78 spid4s SQL Trace ID 1 was started by login "sa".
2008-04-09 20:49:34.84 spid4s Starting up database 'mssqlsystemresource'.
2008-04-09 20:49:34.89 spid4s The resource database build version is
9.00.3042. This is an informational message only. No user action is required.
2008-04-09 20:49:35.06 spid4s Error: 15209, Severity: 16, State: 1.
2008-04-09 20:49:35.06 spid4s An error occurred during encryption.
2008-04-09 20:49:35.06 spid4s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
I have been through many Forums and newsgroups but I just end up in a loop.
Im trying to install the basic Microsoft SQL Server 2005 Express Edition. Without advanced services, toolkit and management studio.
First of all it incorrectly says I do not have the recommended specifications but I cant work out what I am missing. I have 20GB free HDD space. 1.2Ghz CPU, 512MB RAM, Windows XP Pro SP2. This meets the Minimum and Recommended.
All the other system checks have green ticks so I just igore the warning about recommended specs and continue to install.
The options I change from the default settings are: 'Default Instance', Built in system account: Local Service, 'Mixed mode' with a password.
It installs the following parts successfully:
MSXML6
SQL Setup support files
SQL native Client
SQL VSS Writer
As soon as it tries to install 'SQL server Database Services' it attempts to start MSSQLSERVER but fails. I try to start it manually and again it fails.
I notice that the Service is looking for the file: "C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER"
However the only 2 folders that exist in "C:Program FilesMicrosoft SQL Server" are "90" and "80", the "MSSQL" folder doesnt even exist.
The SQLSetup0001_PCNAME_SQL.log reports:
MSI (s) (50:C0) [11:48:46:170]: Note: 1: 1708
MSI (s) (50:C0) [11:48:46:180]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (50:C0) [11:48:46:220]: Cleaning up uninstalled install packages, if any exist
MSI (s) (50:C0) [11:48:46:220]: MainEngineThread is returning 1603
MSI (s) (50:E0) [11:48:46:220]: Destroying RemoteAPI object.
MSI (s) (50:08) [11:48:46:220]: Custom Action Manager thread ending.
=== Logging stopped: 02/11/2007 11:48:46 ===
MSI (c) (84:6C) [11:48:46:230]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:6C) [11:48:46:230]: MainEngineThread is returning 1603
=== Verbose logging stopped: 02/11/2007 11:48:46 ===
The Windows error signature contains:
EventType : sql90setup P1 : do_sqlshutdownranuinstance P2 : 0x733f
P3 : sqls__service__start P4 : 0x2 P5 : sqlsetuplib_service.cpp@316
P6 : sqlca.dll@2005.90.3042.0 P7 : sqlrun_sql.msi@9.2.3042.00
Bootstrap Contains:
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_PCNAME_SQL.log
Last Action : InstallFinalize
Error String : 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 (2) The system cannot find the file specified.
Error Number : 29503
None of these logs seem to point to any solutions. Id be grateful if anyone can suggest something.
Many Thanks
have removed bsn contact manager and all sql related files from previous installation attempts, rebooted so should be a clean install - but still it fails
what did I miss or what am I doing wrong?
here are the logs with ref to the two items that fail
~~~
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Professional (Build 6000)
Time : Tue Mar 20 18:30:20 2007
Product : OWC11
Error : Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM.
--------------------------------------------------------------------------------
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.8003.0
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0012_PATRICES-XPS_OWC11_1.log
Last Action : InstallExecute
Error String : Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOFFICE111033SETUP.CHM.
Error Number : 1706
thanks for any help/light/suggestions you can share
I am trying to add a SQL Server 2005 Express Edition Database to my Web Site. But I am unablr to do so.
I am getting the following error: {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
I am unable to understand what exactly is the problem.
Pls Help me out.
Thanx In Advance.
Dear supports,
This is the following Error when i tried to back up database in MS SQL SERVER 2005 Express Edition.
"
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Backup failed for Server 'OFIX07SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_article" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------"
Any one know the solution please help
Rith
Dear Friend ,
I have try to back up database in MS SQL SERVER 2005 SP2 Express Edition ,It shows the following error .Please help me to solve it and tell me why it happend like this.Thanks
"
===================================
Backup failed for Server 'OFIX07'. (Microsoft.SqlServer.Express.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)
===================================
System.Data.SqlClient.SqlError: The backup of full-text catalog 'article' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Express.Smo)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
"
Currently I am just trying to completely remove all Vista Ultimate's knowledge of installed instances of SQLServer 2005 Developer edition.
I cannot do this for some reason. This all began when I tried to install SQLServer 2005 and it installed but I could not connect to it. Now I have two installed instances that I cannot access, after removing all SQL programs from the Programs and Features icon in the control panel.
I tried running "WIndows Installer CleanUp Utility" as I read in a thread on this forum. This did not help. After going thru and removing all SQLServer programs using the "programs and features" icon in control panel... The installation process shows two installed instances of SQLServer 2005.
1) How can I completely erase all Vista Ultimate's knowledge of any SQLServer 2005 install and start over?
I have downloaded SQLServer 2005 SP 2, and run it, but clearly what I should do, and what Microsoft has asked me to do are not working...
2) What should I be doing to install SQLServer 2005 Developer Edition successfully?
I have been a strong supporter of Microsoft, but this is getting me very frustrated.
Please help,
- Chaz