Please consider registering
September 30, 2012
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.
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.
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
makecert -r -pe -n "CN=newmycer.local" -b 01/01/2000 -e 01/01/2036
-eku 220.127.116.11.18.104.22.168.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.
Most Users Ever Online: 31
Currently Browsing this Page:
Guest Posters: 0
Newest Members: Lo0oM
Administrators: Lo0oM (217)