Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Unanswered: linked server via secure connection

    I am trying to setup a linked server to a MySQL database over at my hosting company.
    I would like the communication between the SQL server and the MySQL database to be via a secure connection. anyone know how to do this?
    my DB is SQL 2000

  2. #2
    Join Date
    Nov 2002
    Posts
    14

    Re: linked server via secure connection

    Do you just want to manage the remote MySQL from your local console, or you want your SQL Server to perform actions over the remote MySQL as part of its work?
    Zlatko Michailov
    Z-SQL

  3. #3
    Join Date
    Nov 2002
    Posts
    3
    basically, i would like to do selects and updates to the MySQL server with data from the SQL server.

  4. #4
    Join Date
    Nov 2002
    Posts
    14
    First you need a crtificate server (could be internal) and have both machines obtain certificates from it. I know there is a Certificate Server included in the MSDN subscription but I don't know how exactly to set it up. Shouldn't be a big deal.

    Then in the Client Network Utility on the SQL Server machine check the Force Protocol Encryption box.
    Zlatko Michailov
    Z-SQL

  5. #5
    Join Date
    Nov 2002
    Posts
    3
    thanks, i will try that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •