Solved

Are Microsoft SQL Server 2008 Express Edition login packets encrypted by default?

Posted on 2013-12-09
1
284 Views
Last Modified: 2013-12-09
If you do not install a certificate nor set any options are SQL Server's login packets encrypted by default? This is all we are interested in, not encrypting the actual data, and reading Msoft's help would seem to indicate that they are always encrypted as long as you are using the proper data access components. Does anyone know if this is true. All we are looking to do is to protect the sa password from packet sniffers and the like. We are currently using Sql server 2008 express edition.

Thanks
0
Comment
Question by:exptech
1 Comment
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39706181
From 2005 onwards, login credentials are encrypyed using a self-signed certificate. So the short answer is: Yes.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Connect to an SQL server ActiveX 10 23
TSQL Challenge... 7 35
Query for timesheet application 3 17
Use column to search string column 2 9
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

808 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