network profile
| bio | website | codepal.co.uk |
|---|---|---|
| location | Skipton, United Kingdom | |
| age | ||
| visits | member for | 5 months |
| seen | May 30 at 11:03 | |
| stats | profile views | 2 |
|
May 14 |
awarded | Editor |
|
May 14 |
revised |
SQL Server service shutdown due to 'bad?' SSL cert added 6 characters in body |
|
May 14 |
comment |
SQL Server service shutdown due to 'bad?' SSL cert No. Rebooting actually caused the problem as at this point the SSL data could not be read and SQL Server refused to start. I actually stopped using this SSL cert so never properly resolved the problem, although I do see that permission needs to be given on the cert for the SSL engine to read it, however, without detailed instructions for Win2012 I'm not brave enough to try it. I can't afford to have SQL shut down in case it fails :-\ |
|
Mar 14 |
comment |
SQL Server service shutdown due to 'bad?' SSL cert So is it possible to give an MSA access to a certificate? |
|
Mar 14 |
comment |
SQL Server service shutdown due to 'bad?' SSL cert This blog post thesqldude.com/2011/08/03/… mentions adding the SQL Server user group account to the cert's permission list, however, it doesn't like the instructions are quite valid for Win2012 as I don't see that user group in my options. My SQL Server runs under the NT Service\MSSQLSERVER account, so perhaps I should give that read-permissions on the certificate under the 'Private Keys' option? |
|
Mar 14 |
comment |
SQL Server service shutdown due to 'bad?' SSL cert Yes this is looking like what's happened. For info, the option to force encryption was set two months ago, with a fresh self-signed cert applied to the next dialog option. There was never a problem until this morning, so perhaps it never worked and we weren't aware until today...? |
|
Mar 14 |
comment |
SQL Server service shutdown due to 'bad?' SSL cert Certificate subject is "elea1.memset.net" and the FDQN of SQL Server is "elea1" (well that's what's at the top of the Object Explorer - please advise if I can get more info elsewhere). We've never connected to SSMS externally even though it was set up to use SSL. |
|
Mar 14 |
asked | SQL Server service shutdown due to 'bad?' SSL cert |
|
Jan 17 |
awarded | Scholar |
|
Jan 17 |
accepted | Decryption not working when SQL Server database copied to new server |
|
Jan 17 |
comment |
Decryption not working when SQL Server database copied to new server Mr Remus Sir - you are a hero! Works like a charm without all the extra messing about. Wish I'd have met you two days ago :-) |
|
Jan 17 |
awarded | Student |
|
Jan 17 |
asked | Decryption not working when SQL Server database copied to new server |
