+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, What does 'this computer will be used as a Sims SQL server' tick box do? in Technical; Hi all, I am just about to move sims to a new server which has SQL already installed. Should I ...
  1. #1

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83

    What does 'this computer will be used as a Sims SQL server' tick box do?

    Hi all,

    I am just about to move sims to a new server which has SQL already installed. Should I tick the box during simsinst 'this computer will be used as a Sims SQL server' or does this simple install a free version of SQL.

    One other question will I have any issues with the new server being named something else and having a different ip?

    Thanks for you time.

  2. #2
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    In regard to the server being called something else and having a different IP address, it's all fine as long as you ensure that everything which points to SIMS is changed.

    It all depends on the way you've set it up though, if your workstation connect.ini's redirect to the shared S:\ drive then you'll need to change the connect.ini on the shared drive only.

    You'll also need to move the DMS over and change the settings both using the DMconfig utility and SIMS.net.

    Let us know how it's all set up and then we can advise accordingly.

  3. #3

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    HI,
    Just Changed connect.ini (s:\Sims) to point at new server and changed sims.net/tools/setups/doc man server to 'computer name = new server name'. Is that correct?

    Do I still need to use the DMconfig util you have mentioned?

    Thanks

  4. #4

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    also when you say DMS do you mean DOCSTORAGE folder?

  5. #5

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    and to answer my own question

    The document Server is important because it deals with reports and any documents attached to students. Knowing where it is is equally important.

    By Default it gets installed at the SIMS Servers C:\ drive under "DocStorage" but most schools have modified this - to find exactly where your document server library is do the following:

    On your SIMS Server open a command prompt and go to the directory the document server lives in:

    Ususally - "correctdriveletter:\Program Files\SIMS\SIMS .net Document Server"

    From here run the command DMCONFIG

    This will tell you the protocol used to connect, the port the service runs on and the directory it resides in (the port must be available past your servers firewall).

  6. #6
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    15
    Aha, I was just about to start to explain and I see you've found it

    (I went to lunch!)

  7. #7

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    ok looks like i do need to use the DMconfig util. When I run it it says doc storage is on C but it should be D.

    I have done a few forum searches but not found anything directly helpful. Can someone please help.

  8. #8

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    Can anyone help, its near the end of the day and I am not back at this school for a week.

    Thanks

  9. #9

    Join Date
    Apr 2010
    Posts
    2,038
    Thank Post
    83
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    I used this command dmconfig /D:\DOCSTORAGE to change docstorage directory location.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 21st June 2010, 10:46 AM
  2. Server Room Monitoring - Tick Sheet
    By dsm in forum How do you do....it?
    Replies: 1
    Last Post: 17th March 2010, 09:48 AM
  3. SIMS communication with SQL server
    By dhicks in forum MIS Systems
    Replies: 9
    Last Post: 14th December 2007, 09:05 AM
  4. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 12:58 PM
  5. sql server sims sa password
    By Uraken in forum MIS Systems
    Replies: 18
    Last Post: 27th February 2007, 08:09 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
  •