I am trying to install MS SQL Express Advanced in my Laptop to be used in conjunction with ColdFusion programming environment. Abs newbe with MSSQL.
It looks like the Management Studio Express has not been installed. I have tried to install the 64bits stand alone from msdn.microsoft. but my processor does not support it.
Please please advise.
ThankYou very much
ContiW
i have a toshiba Satellite Pro 4300 laptop (15 GB and 64mb Ram and NT Server 4.0 service pack 6)...in other words enough space to install the two..
i installed SQL Server 7.0 (server)..it runs fine..but after this, when i install 6.5 on it, it goes thru the installation process and comes back with an error message saying 'access denied'...i have logged in as administrator so access rights should not be a problem...the CD is fine because i have done the same process on a desktop without errors...if someone can throw some light on this problem, it will be highly appreciated
thanks in advance,
resh
Hello Friends at dBForum !!
:confused: I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration:
Pentium III
Brand :Toshiba
Speed: 500 Mhz
RAM : 192 MB
Hard Disk :6 GB
Space Available:4 GB
O.S.:Windows 98
The computer works pretty good and run different applications. I was trying to install MS-SQLSERVER 2000 and I checked out the software and hardware requierements for that and everything seems to be fine. The reason that I need it its because of my trips, and its incredible I have a desktop computer with almost the same configuration and runs pretty good.
When you have a problem installing SQL-SERVER 2000 you have a file called cnfgsvr with all the explanation. I got this at hand so you can see better the problem:
Iniciando servicio ...
Conectando con el servidor ...
driver={sql server};server=3110CT;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=3110CT;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]No existe el servidor SQL Server o se ha denegado el acceso al mismo.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).
Error de configuración del servidor SQL Server.
This is what I got after the installation fails: Here is the log sequence, and I got this from a file called sqlstp2000:
14:37:28 CoreCOM
14:37:28 CoreCOMRes1033
14:37:28 CoreCOMResIntl
14:37:28 CoreTool
14:37:28 CoreToolRes1033
14:37:28 CoreToolResOther
14:37:28 DBLibCli
14:37:28 SFExt
14:37:28 SFExtActiveX
14:37:28 SFExtActiveXRes1033
14:37:28 SFExtActiveXResIntl
14:37:28 SFExtRes1033
14:37:28 SFExtResIntl
14:37:28 Trace
14:37:28 TraceRes1033
14:37:28 TraceResOther
14:37:28 MiscCore
14:37:28 MC
14:37:28 MCMC1033
14:37:28 MCMCIntl
14:37:28 MCHelp
14:37:28 SQLMgr
14:37:28 SQLMgrRes1033
14:37:28 SQLMgrResIntl
14:37:28 SvrTool
14:37:28 SvrToolRes1033
14:37:28 SvrToolResIntl
14:37:28 DTSUI
14:37:28 DTSUIRes1033
14:37:28 DTSUIResIntl
14:37:28 MSOlap
14:37:28 MSOlapRes1033
14:37:28 MSOlapResIntl
14:37:28 ATL
14:37:28 ATLwinnt
14:37:28 ATLwin9x
14:37:28 MFC42U
14:37:28 VC
14:37:28 VB
14:37:28 SQLAdHlp
14:37:28 SQLAdHlpRes1033
14:37:28 SQLAdHlpResOther
14:37:28 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:37:28 End Action LogSelectedComponents
14:37:28 Begin Action InstallPkgs:
14:37:28 Begin Action: Locked Connectivity Files Check
14:37:29 ConnectivityLocked returned: 0
14:37:29 The operation completed successfully.
14:37:29 End Action: Locked Connectivity Files Check
14:37:29 El programa de instalación está instalando Microsoft Data Access Components (MDAC)...
14:37:29 E:X86Othersqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
14:38:10 ExitCode: 0
14:38:10 El programa de instalación está instalando Microsoft Management Console (MMC) ...
14:38:10 E:X86Otherinstmmc.exe /Q
14:38:36 Process Exit Code: (0)
14:38:36 Se está instalando el Coordinador de transacciones distribuidas de Microsoft (MSDTC)...
14:38:36 E:X86Otherdtcsetup.exe /q:a /r:n
14:38:53 Process Exit Code: (0)
14:38:53 /Q:A /T:C:WINDOWSTEMPixp001.tmp
14:38:53 El programa de instalación está instalando la Ayuda HTML...
14:38:55 HTML Help installer exit code: 0
14:39:18 End Action InstallPkgs
14:39:18 Begin Action MoveFileData:
14:39:18 Enabled SELFREGISTERBATCH
14:39:18 Enabled CORECOMPONENTHANDLING
14:42:27 ComponentMoveData exit code: -117
14:42:27 ComponentMoveData: -117
14:42:51 No se puede leer el archivo especificado. Puede ser a causa de una conexión de red de bajo rendimiento. Corrija el problema y reinicie el programa de instalación. ( This message says that the computer can not read the specified file or its a problem related to a network connection of low performance. According to the message here shown, I have to fix the problem and reinstall. ) I did it, even I deleted the entries related to this on the windows registry and after restarting the problem stills...
Archivo: E:X86SETUP....Install
eplmerg.sql
14:42:51 Begin Action: MoveFileDataSpecial
14:42:52 End Action: MoveFileDataSpecial
14:42:52 Action CleanUpInstall:
14:42:52 StatsGenerate returned: 2
14:42:52 StatsGenerate (0x0,0x1,0xf0000,0x0,1034,303,0x0,0x1,0,0,0
14:42:52 StatsGenerate -1,Alessandro)
14:42:52 Installation Failed.
On the other hand, I tried to install MS-SQLSERVER 7.0 ( you know if I can get do it with MS-SQLSERVER 2000 ) and this is what I got :
2005-02-17 13:08:26.77 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )
2005-02-17 13:08:26.84 kernel Copyright 1987-1998 Microsoft Corporation.
2005-02-17 13:08:26.84 kernel Reservados todos los derechos.
2005-02-17 13:08:26.84 kernel Registrando los mensajes de SQL Server en el archivo 'C:MSSQL7logERRORLOG'.
2005-02-17 13:08:27.00 kernel initconfig: número de conexiones de usuario limitado a 32767.
2005-02-17 13:08:27.01 kernel SQL Server se iniciará con clase de prioridad 'normal'( se detectó 1 CPU).
2005-02-17 13:08:27.21 kernel User Mode Scheduler configured for thread processing
2005-02-17 13:08:28.61 server Directory Size: 8087
2005-02-17 13:08:28.68 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2005-02-17 13:08:28.74 spid1 failed to get sqlservr image range
2005-02-17 13:08:28.78 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 SQL Server iniciado en modo de usuario único. Se permiten las actualizaciones en los catálogos del sistema.
2005-02-17 13:08:28.79 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 Recovering only master database
2005-02-17 13:08:28.85 spid1 Iniciando la base de datos 'master'.
2005-02-17 13:08:28.85 spid1 Opening file C:MSSQL7datamaster.mdf.
2005-02-17 13:08:28.97 spid1 Opening file C:MSSQL7datamastlog.ldf.
2005-02-17 13:08:29.06 spid1 Cargando el método de intercalación Unicode de SQL Server.
2005-02-17 13:08:29.16 spid1 Cargando el orden y conjunto de caracteres no Unicode de SQL Server.
2005-02-17 13:08:29.41 spid1 4 transacciones confirmadas en la base de datos 'master' (1).
2005-02-17 13:08:29.41 spid1 0 transacciones deshechas en la base de datos 'master' (1).
2005-02-17 13:08:29.65 spid1 El servidor no tiene nombre.
2005-02-17 13:08:29.65 kernel Se utiliza 'SQLEVN70.DLL' versión '7.00.623'.
2005-02-17 13:08:29.72 kernel Se utiliza 'OPENDS60.DLL' versión '7.00.00.0623'.
2005-02-17 13:08:29.83 ods Utilizando 'SSMSSH70.DLL' versión '7.0.623' para escuchar en ''.
2005-02-17 13:08:29.89 ods Utilizando 'SSMSSO70.DLL' versión '7.0.623' para escuchar en '1433'.
2005-02-17 13:08:30.09 ods Utilizando 'SSMSRP70.DLL' versión '7.0.623' para escuchar en '3110CT'.
2005-02-17 13:08:31.11 spid1 El método de intercalación Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'English' (Id. = 1033).
2005-02-17 13:08:31.11 spid1 estilo de comparación = 196609.
2005-02-17 13:08:31.11 spid1 El orden no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'nocase_iso' (Id. = 52).
2005-02-17 13:08:31.11 spid1 El juego de caracteres no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'iso_1' (Id. = 1).
2005-02-17 13:08:31.19 kernel Warning: override, autoexec procedures skipped.
2005-02-17 13:10:23.67 kernel SQL Server terminará debido a una petición de 'detención' del Administrador de control de servicios.
Accordiing to the message shown in the bottom line, we may see its like the installation were stopped because of a request of the Control Service Manager. I never stop the installation or something like that but I dont have a clue why or where is the problem here.
My desktop computer is standalone and works without problems. Of course I read that if you have PWS ( Personal Web Server ) running you may need to stop that first, and then proceed. I did it and it never worked.
If you have any suggestion about it, this would be greatly appreciated.
Thank you so much,
Cordially,
Alessandro Barbieri - Peru
I am attempting to install SQL Server 2005 on a Laptop with Windows 2003 Standard Edition.
The installation fails and the File Summary.txt has the following entries:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Time : Fri Nov 30 09:36:53 2007
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Fri Nov 30 09:38:41 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SCC.log
The Log File, SQLSetup0004_<hostname>_Core.log, has the following entries:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 03 08:54:09 2007
Process ID : 2980
C:SAP_CDCD2x86EnterpriseEditionServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/11/3 8:54:9
Complete: LoadResourcesAction at: 2007/11/3 8:54:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9
Loaded DLL:C:SAP_CDCD2x86EnterpriseEditionServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9, returned true
Running: ValidateWinNTAction at: 2007/11/3 8:54:9
Complete: ValidateWinNTAction at: 2007/11/3 8:54:9, returned true
Running: ValidateMinOSAction at: 2007/11/3 8:54:9
Complete: ValidateMinOSAction at: 2007/11/3 8:54:9, returned true
Running: PerformSCCAction at: 2007/11/3 8:54:9
Complete: PerformSCCAction at: 2007/11/3 8:54:9, returned true
Running: ActivateLoggingAction at: 2007/11/3 8:54:9
Complete: ActivateLoggingAction at: 2007/11/3 8:54:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2980" returned false.
Running: PerformSCCAction2 at: 2007/11/3 8:54:9
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Complete: PerformSCCAction2 at: 2007/11/3 8:54:9, returned true
Running: PerformDotNetCheck at: 2007/11/3 8:54:9
Complete: PerformDotNetCheck at: 2007/11/3 8:54:9, returned true
Running: ComponentUpdateAction at: 2007/11/3 8:54:9
Complete: ComponentUpdateAction at: 2007/11/3 8:55:6, returned true
Running: DetectLocalBootstrapAction at: 2007/11/3 8:55:6
Complete: DetectLocalBootstrapAction at: 2007/11/3 8:55:6, returned true
Running: LaunchLocalBootstrapAction at: 2007/11/3 8:55:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1605
Aborting queue processing as nested installer has completed
Message pump returning: 1605
Regards
Ok, this is my setup;
Laptop
Installed Visual Web Developer ExpressInstalled SQL Server Express
Server
Windows 2003 serverIIS is working and runs asp 2.0 scriptsInstalled SQL Server 2005 which is running, has remote connections enabled and the SQL browser is also runningThe windows firewall is turned OFF
Router
I have opened port 1433 to point to the server(TCP) and 1434 to point to the server (UPD)
The Problem
Locally on my laptop everything works fine, I can't actually see SQL Express but if I enter MICKEYsqlexpress then connecting to databases works fine.I've setup ftp on the server and I've created a new website using VWD on my laptop, it's connected via FTP and created the website fine, and it runs no problem.
I am in a remote location so I am not connected to the local network, but even if I connect to the local network using VPN I still cannot get this to work. The problem is I am unable to get VWD to connect to SQL on my server. I've tried installing VWD on the server, and it seems the SQL server fine, and shows as just the server name which is "GOOFY".
In VWD on my laptop I've tried entering the server as just "GOOFY" and also "GOOFYmssqlserver" and on both occassions I can an error message saying that a connection to the server couldnt be reached, and it's usually because the server is not setup to accept remove connections (but mine is). It also says something about "Named Pipe", but I've checked the server and that option is not enabled, I have TCP/IP enabled on the SQL server of the server.
Can anyone help me to make a remote sql connection to my server?
When I run the install script, I always get a warning that the hard drive (space?) won't support the install, but I have installed successfully with the new tools etc. and I still have 20 gigs left on my laptop. Why is this warning given?
thx,
Kat
Hi
I have installed SQL Server Express 2005 on my machine.
I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.
Can these 2 Editions coexist with each other, or any troubles you think might encounter?
Thanks
Please tell me what I am missing here. I've got an XP Pro machine with SQL Server Express running and a laptop with XP running the Management Studio Express. This is on my home network which is wireless. I can't see any databases on the XP Pro machine from the laptop. Is there something besides just installing SQL Server that I need to do? I've checked forums, documentation and co-workers but no luck. Thanks in advance
View 2 Replies View RelatedI am trying to install SQL2k5 Express on a Win 2k server.
The install throughs an error during the "native client" setup, saying it is missing a MSI for it. I have verified via checksum that the download from MS is correct.
Have any of you guys had this error ?
Hi,
How do I create a new instance for SQL Express? Also the machine also has MSDE Installed if that should be taken into consideration.
Thanks.
Hi,
I just installed SQL 2005 express. It did not prompt me for a selection for the collation. How do I tell what collation it is installed at? And how do I tell whether it is case sensitive or not?
Thanks,
Razzle
Hi,
I am installing SQL Server 2005 on a server that is currently running SQL Express. My reason for installing full SQL is due to the database size limitation of SQL Express.
Can anyone give me advice on whether I should unistall SQL Express before installing SQL Server 2005 or just install over the top of Express.
Thanks
Hello
I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working.
Can anyone help with this?
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
Could I have downloaded the wrong package?
hi, Im trying to install SQL express 2005 on my Desktop Computer and I keep running into the error "Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed .Net Framework 2.0 is either not installed on this system or is corrupt"
when infact it is installed.. any sugestions?
By the way im Running Windows X64 Pro with a AMD athlon X2 3800+ CPU and 2GB of Corsair DDr2 ram
I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".
The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.
As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.
When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem.
Is there any fix to this? I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it.
This is the end of the log file for my SQL Server installation:
MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (00:04) [20:47:22:140]: Invoking remote custom action. DLL: C:DOCUME~1KYLEOL~1LOCALS~1TempMSI1AA.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (00!60) [20:47:22:155]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Wed Oct 18 20:47:22 2006
<Func Name='CheckIIS'>
Action 20:47:22: CheckIIS. Detecting Installed IIS
MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
So, I read this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=416220&SiteID=1, which suggested that I could call SQLEXPR32.EXE (the SP2 download) with the relevant commandline args in exactly the same way I could call setup.exe. Namely, if I were to call:
Code Snippetsetup.exe /qb /settings "c:/setup.ini"
then I should be able to use
Code SnippetSQLEXPR32.exe /qb /settings "c:/setup.ini"
where my setup.ini contains
Code Snippet[Options]
ADDLOCAL=SQL_Data_Files,SQL_Replication,Connectivity
INSTANCENAME=AuctionI
SAPWD=auctioni_000
SECURITYMODE=SQL
However, this doesn't seem to be working at all - the commandline params to SQLEXPR32.EXE are completely ignored, and it runs as if they were not specified.
Would be great to get some help on this. I'm equally happy with the set of commands I need to call in order to extract SQLEXPR32 and then run setup, but SQLEXPR32 seems to extract to a random GUID dir, and automatically start setup, neither of which is condusive to automating it.
Thanks,
Dan
I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything.
My problem is that now that I have SQL Express installed I cannot seem to connect to anything. I was specifically trying to convert an Access database to SQL Server format, and I keep getting a "connection failed" error. I don't seem to have any way to start SQL Express. Does it have to be started or is it running by default? What am I doing wrong?
Hi,
I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returned 2". After this error message when I check the sql server configuration manager, I still see the old instances running.
I followed up another forum suggestion where I completely installed the old CTP and used the tool provided in the DVD(sqlbuw) to uninstall it but it only removes the one instance and leaves the rest on the system.
I will really appreciate help...
ERRRR:...
icrosoft SQL Server 2005 Setup beginning at Sun Nov 19 16:49:19 2006
Process ID : 5736
c:87450d2367f159d42610acad33156dbcsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/10/19 16:49:18
Complete: LoadResourcesAction at: 2006/10/19 16:49:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/10/19 16:49:18
Loaded DLL:c:87450d2367f159d42610acad33156dbcxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/10/19 16:49:19, returned true
Running: ValidateWinNTAction at: 2006/10/19 16:49:19
Complete: ValidateWinNTAction at: 2006/10/19 16:49:19, returned true
Running: ValidateMinOSAction at: 2006/10/19 16:49:19
Complete: ValidateMinOSAction at: 2006/10/19 16:49:19, returned true
Running: PerformSCCAction at: 2006/10/19 16:49:19
Complete: PerformSCCAction at: 2006/10/19 16:49:19, returned true
Running: ActivateLoggingAction at: 2006/10/19 16:49:19
Complete: ActivateLoggingAction at: 2006/10/19 16:49:19, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5736" returned false.
Running: PerformSCCAction2 at: 2006/10/19 16:49:19
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2373A92B-1C1C-4E71-B494-5CA97F96AA19}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{CD080F4B-BF2C-4A0E-B923-CDA7F6EAB1C9}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{481DFF26-7C67-4085-9A27-758283EA494A}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Product "{90032DD0-ABEE-4424-AC1E-B076BDD4E350}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Tools CTP"
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
I previously installed and uninstalled SQL Express on my laptop. The second time when I try to reinstall SQL Express, it gives me an error and hault the installation.
Here is the error message:
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.msi'.
Does it mean the setup file is corrupted or something else is causing the error.
Please help, thank you.
I have just installed Sql Express
But one installed all I have available to me is
Sql Server Config Man
Sql Server Error reporting Usage
Surface area config
IDoes any one know how to get the other features like the databases and reporting installed
thanks for any help Sammy
I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.
A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).
Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.
Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.
The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:
Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
It has been pointed out that the following services should have been stopped prior to removal.
SQL Server Active Directory Helper
SQL Server Browser
SQL Server FullTest Search (SQLEXPRESS)
SQL Server Reporting Services (SQLEXPRESS)
Surely this should be managed by the Add/Remove process!
I was able to successfully re-install the program as long as I created a new instance.
What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?
TIA
Steve
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005.
Use Add or Remove Programs to remove these components, and the run SQL
Server 2005 Setup again.
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
I used Add/Remove Progs and used the list in the order suggested to
remove all beta versions of VB, SQL, .NET and etc. Nothing is
listed. I do have VB6 PRO. I have looked for directories
and removed all. I have searched for SQLexpress in the registry
and eliminated all I could find. I reinstalled .Net 2.0 and I'm still
finding this problem.
Microsoft SQL Server 2005 Setup beginning at Thu Jun 08 17:37:43 2006
Process ID : 164
c:90b92fd6a1de42b9eesetup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/5/8 17:37:43
Complete: LoadResourcesAction at: 2006/5/8 17:37:43, returned true
Running: ParseBootstrapOptionsAction at: 2006/5/8 17:37:43
Loaded DLL:c:90b92fd6a1de42b9eexmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/5/8 17:37:43, returned true
Running: ValidateWinNTAction at: 2006/5/8 17:37:43
Complete: ValidateWinNTAction at: 2006/5/8 17:37:43, returned true
Running: ValidateMinOSAction at: 2006/5/8 17:37:43
Complete: ValidateMinOSAction at: 2006/5/8 17:37:43, returned true
Running: PerformSCCAction at: 2006/5/8 17:37:43
Complete: PerformSCCAction at: 2006/5/8 17:37:43, returned true
Running: ActivateLoggingAction at: 2006/5/8 17:37:43
Complete: ActivateLoggingAction at: 2006/5/8 17:37:43, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__164" returned false.
Running: PerformSCCAction2 at: 2006/5/8 17:37:43
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP (SQLEXPRESS)"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible
components from beta versions of Visual Studio, .NET Framework, or SQL
Server 2005. Use Add or Remove Programs to remove these components, and
then run SQL Server 2005 Setup again. For detailed instructions on
uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
Thank you for your assistance.
Hi,
We're creating an installer package for SQL Express 2005 and I'm using the built-in setup project in VS 2005 to create my MSI.
Everything appears to be working well, excpet that on Windows XP Home the SQL Express package is exiting with an error code 70002. I've googled for several days now and simply can't find any help on the 70002 exit code. Can anyone help ?
The command line arguments (I've split them onto seperate lines for clarity) we're passing to "sqlexpr32.exe" are : -
/qn
INSTANCENAME=OurInstance
SAPWD="OurPassword"
ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
SQLBROWSERAUTOSTART=1
SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
ASACCOUNT="NT AUTHORITYSYSTEM"
RSACCOUNT="NT AUTHORITYSYSTEM"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
SQLAUTOSTART=1
It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2, I get this when running msiexe /x {the number for the beta}
Could someone please help me, I need to have this install to take courses this weekend, Want to complete the install today, which is Friday.
After installing Visual Studio 2005 everything has installed fine EXCEPT SQLSERVER 2005. I remember having had the same problem some moths ago, but can't remember now how to fix it. I deinstalled VS2005 and installed back again, but the result was the same. SQLSERVER failed to install
thanks
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
Could I have downloaded the wrong package?
hello, I am having some problems installing the sql 2005 express that comes with the asp.net 2.0
It says that the installation failed thats all. Anyone with that kind of problem?
Question----------Is term "machine-name" refer to as the name that you name the pc when u first setting up a new pc from out the box?
So if my pc name is {Delldata} when i 'm installing SQLEXPRESS. ,you have a choice of default instance SQLEXPRESS., and browse for instance.do i have to name the instance delldata/SQLEXPRESS for the name instance.to work
Or leave it as SQLEXPRESS and hit next?
I just tried installing SQL Server Management Studio Express Edition (SSMSEE?) and it wouldn't install because I had the "regular" SQL Server Management Studio already installed. Is that correct? The version I installed was a CTP. Is the final version going to have the same limitations?
===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
I am working on Win2K Pro & had SQL Server 2005 Express & SQL Server Management Studio installed. The SQL Server name was MerverSQLEXPRESS. Due to some unavoidable reasons, I had to repair (& not re-install) Win2K but after doing so, I found that I am not able to connect to the database server. I uninstalled all the components related to SQL Server 2005 Express (like Management Studio, Support Files, BOL etc.) from my m/c & then restarted my m/c.
After doing so, I first re-installed SQL Server 2005 Express & other related components (I intended to install SQL Server 2005 Management Studio after installing SQL Server 2005 Express). While installing SQL Server 2005 Express, all the steps get executed successfully except for the last one which happens to be SQL Server Database Services. At this point, I get the following error:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
The problem is after I click the OK button, I am not even given the option to change the instance name! The Status message corresponding to SQL Server Database Services just says Setup failed. Refer to the Setup log for details. Finally, when I click the Next button, the next dialog finishes the Setup (showing the Finish button).
Now how do I overcome this problem? Please note that the Authentication mode I am using is Windows Authentication.
Someone please suggest me a concrete solution. It's driving me nuts! My receding hairline is getting further receded!
Lastly, please note that, as far as possible, I would like to keep the instance name as MerverSQLEXPRESS only.
Hi everyone
I have just installed SQL Server 2005, default settings. I have attempted to add a new ODBC driver using Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN tab - Add - SQL Server - default settings, but it fails.
I did all this for MySQL some months ago, but I must have forgotten something.
Please can someone tell me what to do next.
Thanks in advance.
Jonathan