Solved

Issuing CA digitally signed certificate to a Windows 2003 Enterprise SQL 2005 Server in a Windows 2008 Active Directory.

Posted on 2011-09-16
5
286 Views
Last Modified: 2012-05-12
My issuing Certificate Services CA is running on Windows 2008 Enterprise R2 SP1 server. I am now ready to issue a digitally signed certificate to my Windows 2003 Enterprise SQL 2005 server.
What are the Best Practice steps for doing this?
0
Comment
Question by:lanman777
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 31

Expert Comment

by:merowinger
ID: 36984315
Which kind of certificate do you need for the SQL Server?
0
 

Author Comment

by:lanman777
ID: 37084196
User authentication to the server.
0
 
LVL 31

Expert Comment

by:merowinger
ID: 37098797
Could you explain in detail what you plan to do with it?!
0
 

Author Comment

by:lanman777
ID: 37146937
Sorry for the delay, users will need to have a certificate on their workstation or for their user account before they can access database info on the server.
0
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 37325295
So you need User Certificates not a Certificate for your SQL Server.
You can user Certificate Autoenrollment via Active Directory Group Policies.
http://technet.microsoft.com/en-us/library/cc770546.aspx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question