Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Pre Login HAndShake Error in Sql Server - 2005 SSMS Expand / Collapse
Posted Monday, June 3, 2013 2:26 PM


Group: General Forum Members
Last Login: Monday, December 1, 2014 9:05 PM
Points: 184, Visits: 653
I did following after goggling and reading some topics but finally certificate renaming works.

1) Check all services

2)Enabled TCP/IP in SQL Server Configuration

3) All Firewall are off

4) Enable Remote Connection

5) SQL Server Browser Service is enabled

6) Created exception of sqlbrowser.exe in Firewall

7) Protocol Encryption set up off, checked other Network protocol settings but didn't work.
8) I also tried Surface Area configuration for services & connections
9) moved TCP before named pipes in the protocol order
Post #1459457
Posted Monday, June 3, 2013 2:55 PM



Group: General Forum Members
Last Login: Today @ 2:36 AM
Points: 7,933, Visits: 14,357
Renaming what certificate? Can you list the steps?

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1459468
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse