+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS communication with SQL server in Technical; Hello All, I'm confused about how, exactly, SIMS operates, and I just want to make sure I've got the right ...
  1. #1

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,621
    Thank Post
    1,239
    Thanked 777 Times in 674 Posts
    Rep Power
    235

    SIMS communication with SQL server

    Hello All,

    I'm confused about how, exactly, SIMS operates, and I just want to make sure I've got the right idea and avoid any potential security holes.

    So, I understand that SIMS is a client-server based application, with a Windows-based GUI application that talks to a SIMS server. This SIMS server stores its data inside an MS SQL server. As far as I can figure out, the SQL server doesn't have to accept connections off anything except the SIMS server. If the SQL server and SIMS server are on the same machine, the SQL server doesn't even need to accept any network connections whatsoever, it just needs to be able to talk to SIMS via ODBC or whatever.

    Is the above correct? Am I assuming wrong here - does the SIMS client, for some reason, write directly to the SQL server? If the SQL server is needed to be available to accept connections from places other than the SIMS server, is there some way (perhaps using a VPN in some way?) to reduce any security risk?

    --
    David Hicks

  2. #2

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,918
    Thank Post
    708
    Thanked 550 Times in 365 Posts
    Blog Entries
    3
    Rep Power
    204

    Re: SIMS communication with SQL server

    I will ask my capita friends...

    Russell

  3. #3

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: SIMS communication with SQL server

    @dhicks: Run WireShark on a machine running SIMS and see what it does

  4. #4
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33

    Re: SIMS communication with SQL server

    There is no SIMS server application as such - when people talk about their SIMS server they're basically talking about a SQL server hosting their SIMS database and support files.

    SIMS.net also has a document management server which complicates things slightly. That does run as a service, but needn't be on the same server as your SQL Server.

    My understanding is that for most SIMS use, the SIMS.net client is writing pretty much directly to SQLServer.

  5. #5
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31

    Re: SIMS communication with SQL server

    Quote Originally Posted by dhicks

    As far as I can figure out, the SQL server doesn't have to accept connections off anything except the SIMS server. If the SQL server and SIMS server are on the same machine, the SQL server doesn't even need to accept any network connections whatsoever, it just needs to be able to talk to SIMS via ODBC or whatever.

    David Hicks
    I'm with you scary avatar dude from Greater Manchester, 'cept one detail!!

    The SIMS Server Machine (Not SQLServer) may need to accept network connections to provide a mapped drive to anyone running the old launcher modules.

    This might also be necessary if you are delivering SIMS .net's connect.ini via a mapped drive for any reason. Apart from that I think the SQL Server authenticates everything else via the logins listed in the SIMS.mdf / Master.mdf,

    DocServer certainly makes things even more fun, I'd love to get a crystal explanation on it....

  6. #6
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,424
    Thank Post
    10
    Thanked 488 Times in 428 Posts
    Rep Power
    111

    Re: SIMS communication with SQL server

    Old launcher, Nova and clients checking for updates will need file access in fact.

  7. #7
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33

    Re: SIMS communication with SQL server

    Quote Originally Posted by DMcCoy
    Old launcher, Nova and clients checking for updates will need file access in fact.
    Yes superfletch/dmccoy, I wasn't very clear... sql ports and smb share ports are both required. I'm not sure how the docstorage files are delivered exactly as I believe they are encrypted and not with standard windows/ntfs encryption, so they may not be served up directly over smb.

  8. #8

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,621
    Thank Post
    1,239
    Thanked 777 Times in 674 Posts
    Rep Power
    235

    Re: SIMS communication with SQL server

    > I think the SQL Server authenticates everything else via the logins listed
    > in the SIMS.mdf / Master.mdf,

    Ah, I was hoping it did something like that - SQL Server not letting anything connect to it except explicitly allowed machines. Hmm, looks like some point over the winter holiday I'd better double-check our SIMS server and see what, exactly, can connect to what.

    --
    David Hicks

  9. #9

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,918
    Thank Post
    708
    Thanked 550 Times in 365 Posts
    Blog Entries
    3
    Rep Power
    204

    Re: SIMS communication with SQL server

    Well here goes direct from horses mouth as to say...


    SIMS .net is a 3 tier application.
    It has a database which sits in a Microsoft SQL Server.
    It has a Business Layer containing the business logic which sits in
    DLL's.
    It has a User Interface Layer (the SIMS application that you interact
    with as a user).
    Both the Business and User Interface layers sit on a Client machine and
    reside in the SIMS .net directory.
    When SIMS .net is run, a connection is made to the SQL Server from the
    client.
    The SIMS file server is not used by SIMS .net applications for
    connecting to the SQL Server.

    Hope that helps

    Russell

  10. Thanks to russdev from:

    vikpaw (28th January 2008)

  11. #10

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,621
    Thank Post
    1,239
    Thanked 777 Times in 674 Posts
    Rep Power
    235

    Re: SIMS communication with SQL server

    [russdev wrote:]
    > SIMS .net is a 3 tier application.

    Thanks very much for the explanation, that makes things a bit clearer.

    --
    David Hicks

SHARE:
+ Post New Thread

Similar Threads

  1. PDA to PDA communication - Voice calling
    By Paid_Peanuts in forum How do you do....it?
    Replies: 2
    Last Post: 19th November 2007, 04:29 PM
  2. Manager / Technician Communication Solution
    By sqdge in forum How do you do....it?
    Replies: 47
    Last Post: 14th June 2007, 03:45 PM
  3. AutoIT process communication
    By NetworkGeezer in forum Scripts
    Replies: 2
    Last Post: 9th May 2007, 08:00 PM
  4. Wired and Wireless communication
    By Samson in forum Wireless Networks
    Replies: 2
    Last Post: 26th March 2007, 10:13 AM
  5. exchange server lost communication
    By choran in forum Windows
    Replies: 4
    Last Post: 3rd July 2006, 05:11 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
  •