Solved

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

Posted on 2013-12-09
1
281 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

810 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