Bradl

I'm unable to install SQL Express 2005 on a windows 2003 server.  I have installed it on several 2003 servers, but for some reason, the one I need it on will not install.  I have tried the manual install, and the command line install.  Both give the same error.  Setup gets to the point where it is configuring the server, and then I get the following error.

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.

At this point in time, I can go to services and see that the SQL Service is running, so it has started.  However, upon failure, when I hit cancel, the process rolls back, and takes the SQL service out of services and uninstalls it.  Below is a copy of the entire log.

Thanks,

Brad

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time            : Tue Jan 10 15:38:38 2006
 
Machine         : MACHINE1
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_MACHINE1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : MACHINE1
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_MACHINE1_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : MACHINE1
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_MACHINE1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : MACHINE1
Product         : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_MACHINE1_MSXML6_1.log
--------------------------------------------------------------------------------
Machine         : MACHINE1
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: 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.
--------------------------------------------------------------------------------
Machine         : MACHINE1
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_MACHINE1_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: No process is on the other end of the pipe.
Error Number    : 29515
--------------------------------------------------------------------------------



Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

QuanT

This site might help:

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

Take a look at message #4.

 





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

CougarKitE

I am having the exact same issue, in fact, it seems every other machine I try to install SQL Server 2005 on has some sort of installation issue. I've never come across a piece of software with so many installation issues. If you know the solution please email me at cougarkite@hotmail.com.




Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Test Uzer

Having the same sort of problem with Microsoft SQL Server 2005 (not express or EE)

It won't even install "SQL Server Database services" as I get the "The error was: [Microsoft][SQL native Client]Shared Memory Provider: No process is on the other end of the pipe."

So any links to "Connectivity Issue Troubleshoot " are useless. It is an install!





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

nelusan

I have the same problem, and this is my second day of hell since this problem occurs. It seems like there were people facing this problem but there's nobody trying to actually give an answer to it. First I received a message sounding like:

connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)

------------------------------
For help, click:
http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
Server Name: NELUSAN\SQLSERVER2005
Error Number: 233
Severity: 20
State: 0

And then I unninstalled my sql server and I wanted to install it again but NO i wouldn't let me - it keeps giving me this stupid message that has the log u showed in the first post. So people, PLEASE, I BEG U give us the other people a solution to the problem.

Possibly this problem occured after I installed Microsoft Interactive Designer. But I can get it - what's the connection between them.






Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

nelusan

Same problem here. I guess somebody on this MSDN forum has to know. I hope :(. I'm running out of pacience. Gotta get myself an MySql connection provider.




Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Test Uzer

 

I did eventually get the installation to work .... but.... after doing dozens of installs (read days of mucking arround) with and without various options to no avail.

In my case I'd had previously had sql server express 2005 installed and then removed. 

Here is what worked for me:

1. Uninstall SQL Server 2005, and all the MSXML6  etc that gets installed... everything!!

2. Make sure SQL Server Express 2005 is fully uninstalled.

3. Go to the registry and remove all the stub entries for SQL & SQL Express  HKLM\Software\Microsoft\Microsoft SQL Server

4. Make sure there were no SQL & SQL Express files on the disk including and database data and log files.

5. Got a fresh copy of SQL Server Express 2005 from MS (not the visual studio version that was installed there before) and installed.

6. Installed SQL Server 2005 ok.

If I uninstall SQL Server Express 2005 ... SQL Server 2005 stops working and I get the "No process is on the other end of the pipe" message back again.

If SQL Server Express 2005 is not installed  ... SQL Server 2005   won't install and I get the "No process is on the other end of the pipe" message back again

So I'm stuck with an Express installation on my machine just so I can have SQL Server 2005 running, but I can have Express stopped and things work just fine.

 





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

fhhowdy

I had the same problem, but it turned out that it was due to using the wrong authentication method. I had created a sql user, but had failed to change the allowed authentication methods for the server. I used the *wonderful* sql server management studio express to change the server authentication from Windows Authentication mode to SQL Server and Windows Authentication mode.

To set this property, open the studio (you can download this free from the SQLExpress website), and right click on the server. Select properties, then expand the security page. Change the Server Authentication and you're good to go.

Cheers.





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Samuel D. Colak

Dear All,

Its been a fustrating few hours but i finally managed to solve the above problem in relation to the design changes that have been implemented in the new service pack for sql 2005.

Well to cut a long story short, all those attempting to access the db via webservices or http should check under the iis admin tool (goto asp.net and then edit configuration and then impersonate a user (as opposed to the default network-service account)) - i thought i could add this account to the sql security policy but it couldnt find the global builtin account. Weird eh

It seems that someone revoked by default the network service account as being considered SYSTEM. how i worked this out - well i have a couple of sql instances running and couldnt understand why on earth on one i had no problems at all and then after i did.

If anyone needs a helping hand in this, give me a shout at my email address.

Regards.





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Devo64

No one has really answered the question. Not one detail was provided on how to fix.

I am having this problem, and in my experience I have never run into something as cryptic and crappy as SQL Server 2005.

I am a self-professed Microsoft fan, but this sucks. I want my money back.






Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Devo64

Sorry for the rant - I found the problem I was having which may be different from anyone else. I found it by trying to install SQL 2000 and running into a similar install issue. I boiled down to the way SSL certs were installed on my computer. Yes SQL uses SSL certs for data encryption.

I actually had two certs installed - both generated using the selfssl tool used to create certs for development machines. I am not sure which one or the fact I had multple caused my install problem.

Nevertheless, removing the certs solved the problem. I was able to install. Please review following topic regarding SQL 2000 install - solution also applied to SQL 2005:

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

I will not install a new cert via self ssl until I am certain I am doing so correctly from a SQL Server standpoint. When I have that figured out I will post another entry on how to install SSL certs without damaging SQL Server.






Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

nelusan

Thanx, it seems like this had been the problem. From what I remembered I played a little with the selfssl.exe tool. I am pretty satisfied now that I know the answer to my qyestion. So from what i've seen so far this error message is from one of two causes: bad authentification or bad certificates.




Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

BellaTrenkova

Thank you so much for the tip!

What made the difference for me was noticing that the Express installation property pages default to the NETWORK SERVICE account as opposed to the Local System (SYSTEM) account. In the previous installation attempts I repeatedly used the SYSTEM account - this used to be the default back in the happy days. In my last installation (after I installed Express) I chose the Network Service account. It all went smoothly. After the installation I tried to be smart and I modified the MSSQL service to run under the Local System account - immediately after restart I got the same error. I turned it back to the network service account and got it working. I didn't have the nerve/time to uninstall Express and install SQL2005 under the network service account. (This last step would prove if Express is really needed or if it is really just a matter of using network service vs. local system.)

The really strange part in our case is that we used to have well working SQL2005 installation which was an upgrade from SQL2000. At some point I restarted the service and it started giving the error. After that, I tried to uninstall and install without any success until I saw your posting and tried it as a last resort. I have no explanation whatsoever what "broke" the services. No one here would admit doing anything to the server.





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Chandra.Sekhar

You guys are really wonderful. I was troubleshooting like hell for a week and you solved it.

IT WAS THE CERTIFICATE ISSUE WHICH DIDN'T LET ME INSTALL SQL 2005 on WINDOWS VISTA ULTIMATE.

Thanks again.

Sekhar.





Re: Visual Studio Setup and Installation Shared Memory Provider: No process is on the other end of the pipe.

Marty McGee

Yep, it definitely was a CERTIFICATE issue that was conflicting with MS SQL's ability to communicate with the MSSQLSERVER service. Once I removed all my PERSONAL certificates that I created using SelfSSL.exe from the computer (MMC console), the installation continued without this annoying and misrepresented error. Now everything works as it should.

I spent two hours on the phone with Microsoft SQL tech support. They mentioned that this error "No process is on the other end of the pipe" is a circumstance of SQL not being able to communicate with the service.

Hope this helps all with headaches. Thanks Bhanu of MS SQL Server Support!

- Marty McGee