+ Post New Thread
Results 1 to 9 of 9
Coding Thread, Open MSSQL to the internet or implement a web service on the SQL server in Coding and Web Development; I am moving forward with my Cashless Catering system, and am now planning the Sharepoint WebPart for it. Now, the ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,377
    Thank Post
    525
    Thanked 2,613 Times in 2,019 Posts
    Blog Entries
    24
    Rep Power
    891

    Open MSSQL to the internet or implement a web service on the SQL server

    I am moving forward with my Cashless Catering system, and am now planning the Sharepoint WebPart for it.

    Now, the problem I have is this - creating one which is installed on a local sharepoint install, within the local network is easy. There's no issues there. However, our sharepoint install isn't local. It is provided by our LEA and as such has its own set of usernames and passwords etc...

    This means I have to maintain a link within my software between the LEA provided account names and our parent database. Relatively easy to do, yes.

    The big question comes to accessing the data on our network. As far as I can see it, I have a couple of choices.

    1. Use a web service - which can be limited to exactly what I want to expose. Disadvantage is adding an extra layer of complexity, and therefore an extra thing to go wrong/maintain.
    2. Open the MSSQL server to the internet, and using a limited user account to restrict what that user can do. Disadvantage - potentially easier to 'hack' the server, as it is a direct link to MSSQL rather than via IIS.
    3. Hire teams of racing pigeons to carry the data...

    Ideas?

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,377
    Thank Post
    525
    Thanked 2,613 Times in 2,019 Posts
    Blog Entries
    24
    Rep Power
    891
    Bump...

  3. #3

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    I'm surprised you have to ask - a web service is nearly always safer, because it's controllable and it can keep detailed logs.

  4. #4

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328
    Best practise would be to implement this as a web service - the added layer has a couple of benefits which I think out-weigh the disadvantage of extra maintenance. Web service:

    1. ensures that data is always in provided in the correct format, regardless of DB changes behind the scenes.
    2. can easily be manipulated and interrogated at a later date by other software (also ties in with #1)
    3. security - goes without saying that this is more secure than opening up SQL to outside, even with IP and user-based access in place


    The web service layer also allows you to do anything you want - cache, log, format, and add custom security where appropriate.

  5. #5

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,733
    Thank Post
    1,294
    Thanked 797 Times in 693 Posts
    Rep Power
    239
    Quote Originally Posted by localzuk View Post
    This means I have to maintain a link within my software between the LEA provided account names and our parent database.
    Is there no approved method of getting two Sharepoint installs to synch usernames/passwords? I thought that was kind of the point of using Sharepoint - it would deal with all the tedious backend stuff for you?

    My preference would be for a web service, but I don't really know the exact situation you're trying to sort out so that's just my completly un-informed opinion.

    --
    David Hicks

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,377
    Thank Post
    525
    Thanked 2,613 Times in 2,019 Posts
    Blog Entries
    24
    Rep Power
    891
    Quote Originally Posted by dhicks View Post
    Is there no approved method of getting two Sharepoint installs to synch usernames/passwords? I thought that was kind of the point of using Sharepoint - it would deal with all the tedious backend stuff for you?
    The system I have has parents stored in it with SIMS external ID's only as their reference - the issue is linking them to the sharepoint install, not working between 2 sharepoint installs.

    Also, I think I may end up biting the bullet and building a web service. They're not hugely complex to build, and as people have said, they have some advantages.

  7. #7

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328
    I would try to keep it as simple as possible - SOAP with WSDL can get mega-complex. Stick with the most native REST/JSON/XML implementation that is available to both platforms/systems.

  8. #8

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,377
    Thank Post
    525
    Thanked 2,613 Times in 2,019 Posts
    Blog Entries
    24
    Rep Power
    891
    Quote Originally Posted by webman View Post
    I would try to keep it as simple as possible - SOAP with WSDL can get mega-complex. Stick with the most native REST/JSON/XML implementation that is available to both platforms/systems.
    I'm building everything in C# so, creating a web service is simple - declare structs, declare methods, declare exception handlers and publish.

  9. #9

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,417
    Thank Post
    644
    Thanked 965 Times in 665 Posts
    Blog Entries
    2
    Rep Power
    328
    Ah, easier than I anticipated. Sounds like you have your solution sorted then



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 30th September 2008, 04:24 PM
  2. OPEN - e-procurement service for schools
    By beeswax in forum Budgets and Expenditure
    Replies: 0
    Last Post: 1st March 2008, 07:31 PM
  3. Open Source CMS that can use MSSQL
    By ICTNUT in forum Windows
    Replies: 4
    Last Post: 29th March 2007, 04:08 PM
  4. No Instance for WSUS in SQL service manager
    By petectid in forum Windows
    Replies: 1
    Last Post: 6th February 2007, 01:05 PM
  5. Internet Blocking Service
    By ajbritton in forum Learning Network Manager
    Replies: 4
    Last Post: 26th January 2006, 09:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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