How do you create the cert request file for SQL Server 2005?

We have developed a client-server application written in visual basic and with SQL Server 2005 and want to enable SSL Encryption with a certificate. According to verisign, we need to create the cert request file from the SQL server. I did a web search and haven't come up with documentation on how to do that. Any help would be appreciated.
Thanks, Tarah
iharmony24Asked:
Who is Participating?
 
ParanormasticConnect With a Mentor Cryptographic EngineerCommented:
Yes, use the name of the server, not the SQL instance.  This would be the name of however you are accessing the server - either the hostname, FQDN, or IP address - usually you want the hostname for SQL.
0
 
ParanormasticCryptographic EngineerCommented:
You can request one from another box if necessary, just put in the SQL server's machine name for the CN.  Then open Certificates MMC and export it from personal store, including private key, then import it on SQL box.
-or-
Open the Certificate MMC, point to local computer account not user
Right click on personal, All tasks, Request new certificate, follow the wizard and install the cert.
0
 
iharmony24Author Commented:
Just to make sure that I have this correctly:
I did nslookup from a remote computer with the ip address of the computer with the SQL Server installed on it.
I also did SELECT @@ServerName through SQL Server.

The two names were different. The one that I would use is the one I got from nslookup, right? Because the name I got from nslookup is the machine name, while the second is the SQL server name.

Just want to double check before I create the request.
Thanks for your help,
Tarah
0
 
iharmony24Author Commented:
Thank you for your help. This was the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.