Besa84


Hello everybody!

I am having problems to connect to Sql Server Database Engine. I have recently(yesterday) installed Sql Server 2005 Developer Edition. The installation was totally successfull. Yesterday I was able to connect to Sql Server Database engine via SSMS but today it gives me an error:

A 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.) (Microsoft SQL Server, Error: 233)

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

It is strange because only one day before It worked fine.

Thanks a lot





Re: Cannot connect to Sql server 2005 database engine

Anthony Martin


Never seen that error before. Try restarting the SQL Server service.







Re: Cannot connect to Sql server 2005 database engine

Caddre

It means that you don't have credentials to access the server, you could increase the numbers of connection with sp_configure. Try the link below for details.

http://blogs.msdn.com/sql_protocols/archive/2007/05/16/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error-xxx.aspx







Re: Cannot connect to Sql server 2005 database engine

Buck Woody - MSFT

At the risk of being too basic - I assumed you've followed all the steps here, correct

http://msdn2.microsoft.com/en-us/library/ms345343.aspx

Buck






Re: Cannot connect to Sql server 2005 database engine

Besa84

Well, things are getting more difficult here.

A friend of mine uninstalled Sql Server from my computer, and I can't install it again. I can install all the components except the Database engine. The error is the same that I got when I tried to connect to Sql Server Database engine before it was uninstalled.

I tried to install the same Edition in another computer(Windows XP) and I face the same problem. I can not install the database engine. How can I use the sp_configure store procedure if I don't have any instance installed

Also I can't change, enable or disable the protocols from Sql Server 2005 Surface Area Configuration because of the lack of the instances.

Thank you for your help!






Re: Cannot connect to Sql server 2005 database engine

Besa84

At this point I can not follow these steps because I don't have any instance installed.
I must install the database engine immediately but It always fails because of the same error:

A 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.) (Microsoft SQL Server, Error: 233)

Anything to do
Thank U




Re: Cannot connect to Sql server 2005 database engine

Caddre

WinXP comes with System Restore so roll the operating system back one month if you can see restore point that far back. Then copy all SQL Server related files to your c drive and run setup and choose repair, if repair is not available run fresh install. Hope this helps.






Re: Cannot connect to Sql server 2005 database engine

Besa84

Everything was resolved!

It was because of the SSL certificates that Sql Server 2005 Database Engine could not be installed.
I removed all the certificates and reinstalled Sql Server. Everything was Ok!

Thank you for help!




Re: Cannot connect to Sql server 2005 database engine

Gcarlo

Excuse me for my English

Im Italian

Thank you very mach for your information

I had same problem

I read a LOT of internet information without solution.

The problem was on certificate such you have written.

Have o good life