+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
MIS Systems Thread, NovaT6 export to SQL funtion in Technical; Hi I have NovaT6 setup as a satellite install on our Timetabler's laptop and computer and although he has the ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19

    NovaT6 export to SQL funtion

    Hi

    I have NovaT6 setup as a satellite install on our Timetabler's laptop and computer and although he has the relevant SIMS permissions (Timetabler), he doesn't appear to be able to export to SQL without getting prompted to enter credentials before the Transfer wizard appears. To work around this he's currently using a full access user but this obviously isn't ideal.

    Anyone else had this problem and know what I need to do to allow access on his normal permissions? Capita support have been coy in supporting this which makes me think they don't know what the cause is.

  2. #2
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,187
    Thank Post
    446
    Thanked 168 Times in 165 Posts
    Blog Entries
    3
    Rep Power
    63
    Whenever you do an export from T6 to SIMS it always asks for your username/password here, presumably from a security point of view and to prevent accidental transfers?(or are you saying it doesn't happen on any other computer?)

  3. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    With Timetabler SIMS permissions this shouldn't prompt for credentials. It won't even accept the timetablers credentials so isn't simply a safetynet. I have a test machine myself which doens't prompt for credentials for the same user so reckon this has something to do with NTFS permissions on a file somewhere but have already relaxed this a fair amount so am a little unsure what else I can try.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    On a normal workstation, it could go through if you were using credentials linked to AD, but that might not work on a satellite. Mine goes through with no password. The timetabler has to provide credentials, i'm guessing the same happens on a satellite. Though we tend to move the dataset from satellite to main PC before it's sent.

    In the days of T4, you'd have a login to Nova as well, and that would control what you could do.

    When you say he's using a full access user, what do you mean? He's having to use a sysman type account for the credentials to send..? Or do you mean the PC account. Is the test machine a satellite too?

    They'll need permissions on the local folders, C drive, windows, temp, etc, as well as on the SIMS share, for the snova / etc. folders.

  5. #5
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by randle View Post
    With Timetabler SIMS permissions this shouldn't prompt for credentials. It won't even accept the timetablers credentials so isn't simply a safetynet. I have a test machine myself which doens't prompt for credentials for the same user so reckon this has something to do with NTFS permissions on a file somewhere but have already relaxed this a fair amount so am a little unsure what else I can try.
    As the Timetabler for 3 decades or so and a user of Nova for what seems for ever (way before it belonged to Capita/SIMS), I welcome the fact that I have to insert my user name and password everytime that I need to create a new Maintenance Dataset and again to send that Dataset to SQL.
    I would not want this to be automatic - for me it is a safeguard for my Timetable which, after all, is the basis around which the rest of the SIMS functions! Your Timetabler should be glad that this protection exists!
    This is normal procedure! It is probably also why Capita are so 'coy'! If they advise schools on how to bypass this system, and something does go amiss, then there could be some comeback on Capita systems and the advice they have given!
    Last edited by Sivadam; 6th December 2011 at 07:40 AM.

  6. #6
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Regardless of whether it's welcomed or not it never used to happen here and doesn't on my test machine and as far as Capita are concerned it shouldn't be either! There's also a wizard that you need to go through before the actual transfer is final so isn't that this action is final and irriversable! Even if it was a case of simply entering credentials as a precaution, it wouldn't be so much of an issue but it's not accepting the Timetabler's credentials and requires sysman level access to perform this task so something isn't right.

    The test machine is a satellite installation too which is why I'm a tad baffled.

    NTFS permissions look ok so doesn't look like it's that.
    Last edited by randle; 6th December 2011 at 11:08 AM.

  7. #7
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    I follow what you are saying and everybody works differently.

    Personally, I would never connect my Satellite NT6 (and I have 2 different ones - Home PC and Laptop!) directly to the SIMS Network.
    There is too big a risk of the different installations not being synchronised. That is why I would save a modified satellite .spl to a data stick or, even better, to my Dropbox folder, and then load it in to SIMS via my School Workstation's installation of NT6.
    Doing it that way ensures that each instance has an up-to-date dataset!

    Horses for courses!

  8. #8
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Hmmm this may be where I'm going wrong. I was under the impression that you had to install NT6 as a satellite to use it in the first place! A regular install of SIMS doesn't appear to install this by default so using what instructions I have and obtained from Capita support, I installed NT6 from the NovaSatelliteSetup.exe file found in the setups dir. If this isn't the way to install NT6 on a networked machine, how should this be done?

  9. #9
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Does this help = from SupportNet.
    KB20319 - Nova-T6 How to access Nova-T6

  10. Thanks to Sivadam from:

    randle (6th December 2011)

  11. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    It should be installed by default, assuming you've paid for the suite and it's licenced. Then if you have permission in SIMS you get the option under the Focus menu. Add yourself to timetabler role and see what you see.

  12. Thanks to vikpaw from:

    randle (6th December 2011)

  13. #11
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Well I feel like a complete numpty!! What possessed me to think that I needed to install NT6 as a satellite is beyond me!!

    How embarrassing....Can you delete threads on here...don't want any evidence of my stupidity!!

    This is working as expected now that I've removed the satellite installed folders from the computers. Sorry for wasting your time and will have to learn to use my brain from now on

  14. #12
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Don't beat yourself up about it. We all have to learn. I have lost count of the number of stupid bits of advice that I have dished out on SupportNet forums - mainly from not reading the threads correctly but partly to do with senility setting in!

    As a matter of interest, if you do not use SupportNet then I suggest that you do. It is easy to find solutions to problems via the Solution Search facilty (where the KB came from!). And if you can't, then there are some very experienced users on the SupportNet Forums!
    Last edited by Sivadam; 6th December 2011 at 08:31 PM.

  15. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    It's not stupidity mate, it's just a lack of the right knowledge. Your support team should have been able to direct you.
    You should get yourself access to SupportNet http://support.capitaes.co.uk/newlogin/login.asp as all the resources are on there.
    This thread will be useful for someone else making the same mistakes, and will appear on searches, so you're doing the community a favour

  16. #14
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    594
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    I know, I know. It's just when you look back over and realize that it's called a "Satellite" installation for a reason

    I have in the past used SupportNet forums but when looking noticed that it seemed to be mainly LA support rather than school tech support posting there. Not that it made much difference as still posted anyway but do prefer to post here as is one place for all problems which so far has worked out quite well for me.

    Thanks again guys

  17. #15
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by randle View Post
    .... I have in the past used SupportNet forums but when looking noticed that it seemed to be mainly LA support rather than school tech support posting there. Not that it made much difference as still posted anyway but do prefer to post here as is one place for all problems which so far has worked out quite well for me...
    There are two sets of Forums on SupportNet. One is for the LAs and other SIMS Support Units. The second is for Schools! Never the twain shall meet is supposed to be the rule!
    However, the Capita Product Managers sometimes post to the Forums. Otherwise, it is just School Users on the School site, and there are some very, very experienced ones too! The Forums are intended for self-help! It's a pity that the two audiences are separate in some ways, as LAs can learn from Schools and vice versa!
    If you had posted this issue in SupportNet then I would have been on to it quicker than I was in here!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Automate a Database Export to a schedule
    By FN-GM in forum How do you do....it?
    Replies: 10
    Last Post: 14th July 2008, 08:44 PM
  2. FMS Upgrade to SQL and CFR reports
    By wesleyw in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 08:58 AM
  3. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  4. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 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
  •