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 ...
8th July 2010, 12:09 PM #1
What does 'this computer will be used as a Sims SQL server' tick box do?
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.
IDG Tech News
8th July 2010, 01:53 PM #2
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.
8th July 2010, 02:04 PM #3
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?
8th July 2010, 02:07 PM #4
also when you say DMS do you mean DOCSTORAGE folder?
8th July 2010, 03:26 PM #5
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).
8th July 2010, 03:39 PM #6
Aha, I was just about to start to explain and I see you've found it
(I went to lunch!)
8th July 2010, 03:40 PM #7
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.
8th July 2010, 04:10 PM #8
Can anyone help, its near the end of the day and I am not back at this school for a week.
8th July 2010, 06:42 PM #9
I used this command dmconfig /D:\DOCSTORAGE to change docstorage directory location.
By localzuk in forum MIS Systems
Last Post: 21st June 2010, 11:46 AM
By dsm in forum How do you do....it?
Last Post: 17th March 2010, 10:48 AM
By dhicks in forum MIS Systems
Last Post: 14th December 2007, 10:05 AM
By tscnmuk in forum MIS Systems
Last Post: 20th July 2007, 01:58 PM
By Uraken in forum MIS Systems
Last Post: 27th February 2007, 09:09 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)