<div>
Which kind of certificate do you need for the SQL Server?
</div>


Which kind of certificate do you need for the SQL Server?

<div>
User authentication to the server.
</div>


<div>
Could you explain in detail what you plan to do with it?!
</div>


Could you explain in detail what you plan to do with it?!

<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.<br />
What are the Best Practice steps for doing this?<br />

</div>
</div>


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?


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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.