+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 27 of 27
MIS Systems Thread, SIMS & Discover on SQL 2008R2 Cluster Not Supported by Capita? in Technical; Originally Posted by matt40k Add to your maintenance plan - add exec sims.db_p_transfer_login - so it transfers the logins from ...
  1. #16

    Join Date
    Jun 2007
    Location
    Taunton, Somerset, UK
    Posts
    28
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by matt40k View Post
    Add to your maintenance plan - add exec sims.db_p_transfer_login - so it transfers the logins from the MASTER database to SIMS database
    Then after you restore - run exec sims.db_p_install - transfers the logins back and does the SIMS "magic"
    If you get passed first line support @ Capita, they'll be able to tell you this.

    Other (non-SIMS) are to using something like SSIS to transfer the logins.
    Thanks for the info!

  2. #17

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    Sorry to resurrect this one but we've been through all of our cases to locate the advice that you've been given that we "won't support Discover on a cluster" but can't find it. It would be really helpful to have a case reference so that we can speak to the support staff.

    Here's what I have got back from our desk:

    The team have all confirmed that they would support SIMS, Discover etc. on clustered solutions as they do that everyday.

    With regard to not referring a cluster problem to a BA. This is the response:

    SQL Server clustering is transparent to the application, i.e. applications should not be aware they are running against a cluster, i.e. if it works against a SQL Server, it works against a SQL Server cluster.


    We donít test Discover against SQL clusters, again because it should be transparent to the application, so we shouldn't have to.

  3. Thanks to PhilNeal from:

    vikpaw (3rd March 2013)

  4. #18
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,287
    Thank Post
    600
    Thanked 159 Times in 144 Posts
    Blog Entries
    78
    Rep Power
    83
    I was gonna jump in on this...but you've answered! I've been running Sims and Discover on an SQL 2008r2 cluster for the past 12 months without issue so can confirm what @PhilNeal says.

  5. #19
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,115
    Thank Post
    826
    Thanked 357 Times in 281 Posts
    Blog Entries
    60
    Rep Power
    281
    Will that affect the master database in any way?

  6. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    It shouldn't it's all transparent

  7. #21
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,115
    Thank Post
    826
    Thanked 357 Times in 281 Posts
    Blog Entries
    60
    Rep Power
    281
    Sorry didn't spot page 2 when I posted and caused a bit of confusion. I meant the exporting users from the master DB to SIMS DB that Matt was talking about.

  8. #22

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    It doesn't do anything to the master. it just copies the info you need out, then back into the destination system. Using the db as a transport mechanism.

  9. Thanks to vikpaw from:

    CAM (4th March 2013)

  10. #23

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    not really sure how it all works. but if you look at your sims db and expand the security / users you'll find the logins. these are also in master.sys.server_principals view and probably other places too.

  11. #24

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,968
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    probably worth looking at those stored procs to get a better idea.

  12. #25

    Join Date
    Jun 2007
    Location
    Taunton, Somerset, UK
    Posts
    28
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by PhilNeal View Post
    Sorry to resurrect this one but we've been through all of our cases to locate the advice that you've been given that we "won't support Discover on a cluster" but can't find it. It would be really helpful to have a case reference so that we can speak to the support staff.

    Here's what I have got back from our desk:

    The team have all confirmed that they would support SIMS, Discover etc. on clustered solutions as they do that everyday.

    With regard to not referring a cluster problem to a BA. This is the response:

    SQL Server clustering is transparent to the application, i.e. applications should not be aware they are running against a cluster, i.e. if it works against a SQL Server, it works against a SQL Server cluster.


    We donít test Discover against SQL clusters, again because it should be transparent to the application, so we shouldn't have to.
    I am glad that you are now supporting SQL Clusters, however you may want to make your support desk aware of that! Here are two emails in which I was told that you were not supporting it:

    Hi Tom,

    Just been to development and they have confirmed that I have miss informed you. We do not support SQL server in cluster mode. It has been known to work for some schools but officially it is not supported. I apologise for the mis-direction

    Many Thanks,

    Second Tier IT Technical Engineer
    Chelmsford Service Desk


    Second E-mail:

    Hi Tom,

    As I have said before SQL server 2008 R2 in cluster mode is not supported. However, I am willing to remote into the environment and do as much as I can. Be advised that, if the issue is unresolved I am unable to escalate the issue to development simply because of the unsupported product. I will contact you at 12:45pm.


    Many Thanks,

    Second Tier IT Technical Engineer
    Chelmsford Service Desk


    I have removed the name of the Capita representative and case number, however I can forward all the details on to you Phil if you would like.

    Thanks

    Tom
    Last edited by NortyUK; 5th March 2013 at 02:06 PM.

  13. Thanks to NortyUK from:

    PhilNeal (6th March 2013)

  14. #26

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    I'll follow this up - we've clearly got a communication issue here.

  15. #27

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    Issue now discussed with team and message is hopefully clear. We can't give advice on running clusters but we expect our products to run on clusters without change.

  16. Thanks to PhilNeal from:

    FN-GM (6th March 2013)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Replies: 2
    Last Post: 30th April 2012, 02:44 PM
  2. [SIMS] sims.net on sql server 2008_windows 2003
    By Uraken in forum MIS Systems
    Replies: 12
    Last Post: 24th May 2011, 07:57 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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