DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: SQL Server security

  1. #1
    Join Date
    Dec 2003
    Location
    Italy
    Posts
    250

    SQL Server security

    Hello guys,
    We're changing the way we use secure connections between our .NET applications (VB and C#) and SQL Server.
    Currently we're encrypting the connection strings in our code but we MUST decrypt it before "sending" it to SQL Server.
    I've been told that SQL Server 2000 (the version we're currently using) has it's own encryption system.
    Does anybody knows how to activate it, configure it and use it in .NET applications ?

    Thank you all

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    AFAIK, as of SQL Server 7.0 credentials are automatically encrypted when using the SQL Server client libraries. Of course the most secure method is to use Integrated Windows Security since no user ID and password information is actually passed across the network.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Dec 2003
    Location
    Italy
    Posts
    250

    SQL Server security

    Thnx Paul
    And is it possible to use it in connection strings form within projects ?, do you know where can I find information about how to use it in connection strings ?

    Thank you

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    Encrypting user ID and password information in a connection string is different than what I am referring to. I'm not aware of any way to pass encrypted credentials from a connection string and have SQL Server decrypt it before attempting to log the user into the database.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Sep 2005
    Posts
    1
    You can use SSL to encrypt the communication between SQL Server and the client application. You would install an SSL certificate on the SQL Server and a root certificate on the client application machine. You would then configure the Client Network Utility on the client application machine and the Server Network Utility on the SQL Server to set it up.

Similar Threads

  1. SQL Server Developer in Calgary Canada
    By Dan Staggs in forum Careers
    Replies: 0
    Last Post: 08-07-2002, 11:04 AM
  2. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  3. establishing security
    By Chris Boyle in forum Security
    Replies: 1
    Last Post: 06-20-2001, 11:59 AM
  4. Re: Sort problem in MS SQL Server 7.0
    By D. Patrick Hoerter in forum Database
    Replies: 1
    Last Post: 06-26-2000, 04:57 PM
  5. Re: ODBC error
    By Devaraj in forum Enterprise
    Replies: 0
    Last Post: 05-11-2000, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center