locked
Secure Data Access using a Windows Forms Application RRS feed

  • Question

  • Can I write a Windows Forms application that runs, say, on my home computer and accesses a SQL Server database managed by my ISP in a secure manner? I understand that if the application is web-based, then security (SSL) certificates can make all data travelling over the internet encrypted and difficult for hackers to make use of. But is it possible to build the same kind of encrption/decryption functionality into a Windows Forms application?

    Do I have to use WCF? And, if so, do I use a WCF Service Library, Service Application or Workflow Service Application. Note that the client Windows Forms application is a simple add/edit/delete of (mostly) single (small) records that will be written to individual tables - not a hugely complex data capture app.


    Saturday, May 11, 2013 4:15 PM

Answers

All replies

  • Hi Shaun,

    Welcome to the MSDN Forum.

    Base on my understanding, you can make a encrypted connection in a winforms application, and this feather is supported on server side, you can config it like this way: http://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx 

    This way will keep the data safe when transmit, and this is the same whatever the client is a web client or winforms client.

    I hope this is clear.

    Best regards,


    Mike Feng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Proposed as answer by Mike Feng Monday, May 27, 2013 11:11 AM
    • Marked as answer by Mike Feng Tuesday, May 28, 2013 3:36 AM
    Tuesday, May 14, 2013 5:04 AM
  • Thanks for your response Mike.

    I received an email from my potential ISP (DiscountASP.Net) telling me that it is not possible to securely communicate from a home computer to their ISP-managed SQL Server database.

    So I just emailed the ISP and asked if it was technically possible and outside their scope of services, or not technically possible.

    Hopefully, I'll hear back soon.

    Thanks again.

    Sincerely,

    Shaun



    Tuesday, May 14, 2013 11:30 PM
  • Hi Mike,

    I got a response from my potential ISP and was told your proposed solution is technically possible, but not offered by such ISP.

    I'm learning about using web services to facilitate communication between the Windows Forms client and a Wcf service, but I can't seem to get things working.

    I've tried to create a detailed explation here, but am told I cannot post images or links until you are able to verify my account.

    What does this mean?

    What do I need to do to better communicate the details of my problem?

    Please advise.

    Thanks,

    Shaun


    Wednesday, May 15, 2013 3:25 AM
  • Hi Shaun,

    >>I've tried to create a detailed explation here, but am told I cannot post images or links until you are able to verify my account.

    What does this mean?

    Based on my understanding, that means you need to verify the account you communicate with is not malicious account, it is illegal. As you know, we usually be warning that don't open a unknown link, maybe it contains virus, the same to picture.

    You can verify my words with him/her.

    Best regards,


    Mike Feng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.


    • Edited by Mike Feng Wednesday, May 15, 2013 6:44 AM
    Wednesday, May 15, 2013 6:44 AM
  • Sorry Mike - It was late and I guess I wasn't clear.

    I want to post images/code to this MSDN website, but it tells me my account needs to be verified before I can do so.

    How to I get my account verified so that I can post code, etc. on MSDN?

    Thanks,

    Shaun

    Wednesday, May 15, 2013 10:52 PM
  • Hi Shaun,

    Try this: http://social.technet.microsoft.com/wiki/contents/articles/15960.how-to-verify-your-msdntechnet-forums-account-so-that-you-can-post-images-and-links.aspx  

    Best regards,


    Mike Feng
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, May 20, 2013 5:51 PM