Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, June 3, 2013 2:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
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