Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DoctorDude100
Starting Member
3 Posts |
 Posted - 2012-03-06 : 10:10:06
|
| I have several servers all over US. Our apps utilizes certificate to talk to the DBs.This weekend, most of our locations had problems accessing the data.After researching we found out that the certificate was not selected under SQL Server Configuration Manager, SQL Server Network Configuration, Protocols for MSSQLSERVER, Certificate Tab... We had to go to each Server and reassign the Certificate again. We had already done this while building the servers. We cant understand why the certificate was not selected.I can't find anything on the SQL Server Logs or Windows event log showing the reason for the certificate to get deselected. No Windows update has been applied in Months.Has anybody has the same experience? Anybody may explain why this happened?The Dude |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Certificate - SQL Server Network Config Protocol