+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Urgent Help needed.. Can't logon to sims.net in Technical; Hi, We have been experiencing sims problems and advised to run the indexing patch....Ran the patch, never finished and received ...
  1. #1

    Join Date
    Mar 2012
    Location
    United Kingdom
    Posts
    76
    Thank Post
    22
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Urgent Help needed.. Can't logon to sims.net

    Hi,

    We have been experiencing sims problems and advised to run the indexing patch....Ran the patch, never finished and received an error ( I don't know what the error was as I was never there to see it)

    We can no-longer login to sims with an error stating :-

    "unable to set application role"

    Any Ideas ???

    Thanks in advance

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Database is still locked, if you've got management studio I think it'll say it's set as restricted_user. Change it multi_user should do it

    alter database sims set multi_user with rollback immediate

    Failing that, restore it from the backup it created. Actually that might be safer

  3. #3

    Join Date
    Mar 2012
    Location
    United Kingdom
    Posts
    76
    Thank Post
    22
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    How do I do a restore from the backup it created??

  4. #4
    paul's Avatar
    Join Date
    Jun 2005
    Location
    Preston
    Posts
    170
    Thank Post
    2
    Thanked 12 Times in 8 Posts
    Rep Power
    21
    Backup will be located in the backups directory within the default SQL Server application location on the server (usually D:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Backup), you will need to run dbattach.exe from on the server to restore.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,439
    Thank Post
    368
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Yer, what Paul said. Run dbattach and restore from the latest backup in your mssql10.sims2008\backup folder.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 1st July 2014, 08:34 AM
  2. Replies: 7
    Last Post: 15th March 2012, 03:02 AM
  3. [SIMS] Urgent Help needed !! Can't logon to sims.net
    By artfulmatt in forum MIS Systems
    Replies: 13
    Last Post: 2nd December 2010, 11:02 PM
  4. Urgent Help needed!
    By The_GuRu in forum Network and Classroom Management
    Replies: 27
    Last Post: 20th February 2008, 09:20 AM
  5. Replies: 11
    Last Post: 6th September 2007, 07:10 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
  •