A A A

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Connection Error 233 : No process at the other end of the pipe
January 31, 2013
5:08 pm
Lo0oM
Admin
Forum Posts: 217
Member Since:
September 30, 2012
Offline

Hi

Full connection error:

provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.

 

OS: Windows server 2003R2

MSSQL servers 2005 and 2008 installed on the same server.

 

Description:

In my case this problem occurs after moving server from domain to workgroup (human factor) by somebody from the 3-d side. Please never give Administrator permissions to another man :) What is strange, the MSSQL 2008R2 server continued working without any problem.

 

Solution:

I deleted all certificates used by MSSQL servers to start and manually created a new one for them.

1. Open SQL Server Configuration Manager, go to "SQL Server Network Configuration".

2. Click on "protocols for MSSQLSERVER" and choose properties.

3. Click on Certificates tab and remember the name of certificate. ("mycert.local" for example).

4. Run mmc console, choose file->add/remove snapin

5. Click on Certificates->local computer. Enter.

6. Expand Certificates->local->Certificates

7. locate mycert.local and delete it.

8. Download Windows SDK  and install it.

9. Run: Start->All Programs->Microsoft Net Framework SDK-> SDK command prompt

10. Run:

makecert -r -pe -n "CN=newmycer.local" -b 01/01/2000 -e 01/01/2036

-eku 1.3.6.1.5.5.7.3.1 -ss my -sr localMachine -sky exchange
-sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12

11. Run: 
certutil -store "new" "newmycer.local"

12. Go to steps 1-3 and choose "newmycer.local" on Certificates tab. Enter
13. Restart MSSQL server process in SQL Server Configuration Manager.

You will now succeed with connection without error.

Sources: Configuring Certificate for Use by SSL


Thank you.
Forum Timezone: UTC 0

Most Users Ever Online: 31

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 3

Forums: 20

Topics: 214

Posts: 214

Newest Members: Lo0oM

Administrators: Lo0oM (217)