Can't get SS Express SP2 to install on Vista build 5744

Having had no luck getting prior versions of Sql Server Express to install on Vista RC2. I was hoping that SP2 would install with no problems however I'm still getting the same error as before and can't find any working solution to this anywhere on the web.

The actual error I'm getting occurs when the install tries to start the SQL Server service and connect. I get

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

This error apparently also occurs on other platforms than Vista. Any ideas how to get past this? The Vista install is still pretty much a clean install.

TIA Adrian Heath

Hi Adrian,

The most obvious question is, "did you check the setup logs?" as per the instructions in the message? The setup logs will help track down the root cause of the error. I've installed SSE on many different builds of Vista without problems, so I know it's possible.

Mike

|||

I did but the final entry basically says the same as the displayed error and it was hard to figure out if any other part of the preceeding 5Mb of log was relevant. The complete log entry is as follows. If you have any suggestions what else to look for in the log please let me know.

TIA Adrian Heath

Error Code: 233
MSI (s) (C0!C4) [22:58:58:097]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Nov 17 22:58:58 2006
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Fri Nov 17 22:58:58 2006
Attempt to start service when it is already running
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections
Service MSSQL$SQLEXPRESS started at Fri Nov 17 22:58:58 2006
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=08001, level=-1, state=-1, native_error=233, msg=[Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.

sqlstate=08001, level=-1, state=-1, native_error=233, msg=[Microsoft][SQL Native Client]Client unable to establish connection

Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Aug 2 16:21:01 2006
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 800700e9 (233)
Do_sqlScript
SqlScriptHlpr

|||This can have several causes, the most common problem is that you are using the wrong service account. This thread will help you to narrow down your problems:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=197758&SiteID=1

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thanks

SS Express is now installed

I followed the instructions for removing certificates from here

http://support.microsoft.com/default.aspx/kb/309398/

(mentioned near the bottom of the link suggested above) and the install completed. I'm not sure what the two certificates were from, I guess they are Vista default certificates but if so why have more people not reported this problem?

Oh well it's working now

Thanks again for the help

Adrian Heath

Can't get MSDE2000RelA to install

I am doing a test install on a XPsp2 with the firewall turned off prior to
prod on WinStd2003.
I just want a single install as the default instance?
This is my line:
c:\setup /settings "install.ini" /L*v C:/MSDELog.log
I tired c:\ instead of / thinking a typo...still no go.
The ini contains
[Options]
SAPWD="XXXXX"
DISABLENETWORKPROTOCOLS=0
DATADIR="C:\MSDE2000\"
SECURITYMODE=SQL
Per
http://msdn.microsoft.com/library/?u...asp?frame=true
I tired copying all the 16msi to the setup dir. It is acting like it wants
a msi file specified?
All it does is throw up a GUI Window Installer showing the switches for:
Windows Installer. V 3.00.3790.2180
msiexec /Option <Required Parameter> [Optional Parameter]
Install Options
</package | /i> <Product.msi>
Installs or configures a product
/a <Product.msi>
Administrative install - Installs a product on the network
/j<u|m> <Product.msi> [/t <Transform List>] [/g <Language ID>]
Advertises a product - m to all users, u to current user
</uninstall | /x> <Product.msi | ProductCode>
Uninstalls the product
Display Options
/quiet
Quiet mode, no user interaction
/passive
Unattended mode - progress bar only
/q[n|b|r|f]
Sets user interface level
n - No UI
b - Basic UI
r - Reduced UI
f - Full UI (default)
/help
Help information
Restart Options
/norestart
Do not restart after the installation is complete
/promptrestart
Prompts the user for restart if necessary
/forcerestart
Always restart the computer after installation
Logging Options
/l[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*] <LogFile>
i - Status messages
w - Nonfatal warnings
e - All error messages
a - Start up of actions
r - Action-specific records
u - User requests
c - Initial UI parameters
m - Out-of-memory or fatal exit information
o - Out-of-disk-space messages
p - Terminal properties
v - Verbose output
x - Extra debugging information
+ - Append to existing log file
! - Flush each line to the log
* - Log all information, except for v and x options
/log <LogFile>
Equivalent of /l* <LogFile>
Update Options
/update <Update1.msp>[;Update2.msp]
Applies update(s)
/uninstall <PatchCodeGuid>[;Update2.msp] /package <Product.msi |
ProductCode>
Remove update(s) for a product
Repair Options
/f[p|e|c|m|s|o|d|a|u|v] <Product.msi | ProductCode>
Repairs a product
p - only if file is missing
o - if file is missing or an older version is installed (default)
e - if file is missing or an equal or older version is installed
d - if file is missing or a different version is installed
c - if file is missing or checksum does not match the calculated value
a - forces all files to be reinstalled
u - all required user-specific registry entries (default)
m - all required computer-specific registry entries (default)
s - all existing shortcuts (default)
v - runs from source and recaches local package
Setting Public Properties
[PROPERTY=PropertyValue]
Consult the Windows Installer SDK for additional documentation on the
command line syntax.
Copyright Microsoft Corporation. All rights reserved.
Portions of this software are based in part on the work of the Independent
JPEG Group.
Suggestions?
hi,
CD wrote:
> I am doing a test install on a XPsp2 with the firewall turned off
> prior to prod on WinStd2003.
> I just want a single install as the default instance?
did you get an error installing MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the reply
According to the command it should have created a log...no log exist as
specifed on the switch
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36et5uF50pbjlU1@.individual.net...
> hi,
> CD wrote:
> did you get an error installing MSDE?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
CD wrote:
> Thanks for the reply
> According to the command it should have created a log...no log exist
> as specifed on the switch
>
try
c:\...\>setup /L*v "C:/MSDELog.log"
enclosing the file name...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I tired and it started to insall...I cancelled.
I then went to the ini
I was trying to add some comment for future reference. I was using // to
comment the line.
I changed them to ;
Sorry ... I should have posted all the ini...
I guess I screwed myself...I had searched locally and found some ini that
had both ; and //
I guess ; is prefered.
I am up and running...
THANK YOU FOR YOUR HELP!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36etmrF52uobqU1@.individual.net...
> hi,
> CD wrote:
> try
> c:\...\>setup /L*v "C:/MSDELog.log"
> enclosing the file name...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>