Secure database connection in sql server 2008. SSL Certificate add failed, Error:1312 error
Hi,
We have 2 tier application, VB6.0 client connecting to sql server 2008 db. I want to secure my data transmission between the client and sql server, currently queries are transmitted in clear text this is security vulnerability issue. I'm trying to the secure
database connection, created certificate using the following command on makecert.util
makecert -r -pe -n "CN=FQDN" -b 10/12/2012 -e 01/01/2036 -eku 1.3.6.1.5.5.7.3.1 -ss my -sr localMachine -sky exchange -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12 OutputPath
then I added into MMC Add Snap-in->Certificate-> Local Computer
then I run the following command in netsh
netsh http> add sslcert ipport=ip:port certhash=f0a6412b75b9519cb59c683c5372fba6d9a40b33 appid={guid}
SSL Certificate add failed, Error:1312
A specified logon session does not exist.It may already have been terminated.
Windows Server 2008 R2 64 bit
Steps followed:
Applied KB981506 hot fix.
Removed all entries in C:\ProgramData\Microsoft\Crypto\RSA folder
But no luck. Pl help me with some solution.
December 13th, 2012 4:01pm
Hi,
Thanks for posting in Microsoft TechNet forums.
Please check the suggestions in the threads below to see if they can be helpful in your situation.
SSL Certificate add failed, Error: 1312 A specified logon session does not exist. It may already have been terminated
http://social.technet.microsoft.com/Forums/da-DK/winserversecurity/thread/71bc4438-6f59-4ebc-a991-f6eb7c5769da
SSL Certificate add failed, Error: 1312
http://social.technet.microsoft.com/Forums/en/winservergen/thread/68452008-a89b-40ba-9927-472efcfafc99
Have a nice day.
Regards
Kevin
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2012 8:10am