SQL Server - ODBC Connection and Encryption
Asked By dm1608
17-Nov-09 09:14 AM
Hello --
I am currently running SQL 2005 Standard and have a have a rich client
application that communicates with SQL using ODBC connections.
For PCI compliance, I need to begin encrypting the session (at least
authentication information) and was wondering what the best options are.
Since most of my clients are customers, I am hoping there is a way I can turn
on some default encryption (and enforce it) instead of having to use SSL or
some other certificate.
Any help, blog posts, or guidance would be appreciated.
SQL Server
(1)
Seehttp
(1)
Communicates
(1)
Ms131691
(1)
Packets
(1)
ODBC
(1)
Dang
(1)
SSL
(1)
Dan Guzman replied to dm1608
Yes, login packets are encrypted by default. See See
http://msdn.microsoft.com/en-us/library/ms131691(SQL.90).aspx for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches and off to the races. It quit seconds left to the installation and bombed with the same errors as the Crystal Reports Server install. The error is the same whether I try to install MSDE by itself or
SQL Express: Failed Reinstall SQL Server Dear Setup Experts: I am trying to reinstall SQL Express after playing with it some. I uninstalled it, and now, it refuses to reinstall in the face. Any ideas what this log file means and how I can get SQL Express installed? I really do not want to have to reinstall my whole system. * ** ** Start of Log File Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203
Changed server NIC and IP address; can't connect to sql server SQL Server I changed the nic on a sql server 2008 server and gave the server a new ip address. The server has access to the LAN
sql server tutorial SQL Server I dled the c# samples from msdn Tried to run the create database sample (connects to sql server) the docs says visual studio required. . .i only have express is there no way to express is not going to run the sample? 2009-11-24 18:32:46.95 Server SQL Server is now ready for client connections. This is an informational message; no user action
updating through a loop statement SQL Server I am using a loop to update a table dynamically, meaning that only certain fields time. I have a feeling that it is sending the various update statements to the sql server as quickly as it goes through the loop. Is there a way to pause the sp_executesql as I have to build the statement with various variables. Hope this made sense SQL Server Programming Discussions SQL Server 2008 (1) SQL Server (1) Informix (1) Oracle (1) Stored procedure (1) INNER JOIN (1