+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, moved sims sql database but logins not moved in Technical; I`m moving sims from one sql 2008 server to another I`ve detached the database from one and reattached it to ...
  1. #1
    Jamie_a's Avatar
    Join Date
    Dec 2006
    Location
    Sheffield
    Posts
    82
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    moved sims sql database but logins not moved

    I`m moving sims from one sql 2008 server to another I`ve detached the database from one and reattached it to the other but cant login as the logons havent transferred over. All users are down as users under the sims database but arnt there as logins any ideas where I`ve gone wrong and how I can rectify it?

    Thanks

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Firstly, by this I assume that you are not using AD integration, you are using separate SIMS passwords?

    Did you use the SIMS db attach tool to detach the database? If so there should have been the option to drop SQL logins. I believe (not used in a year) that if you use this option the passwords can transfer with the database.

  3. #3
    maestromasada's Avatar
    Join Date
    Apr 2009
    Posts
    166
    Thank Post
    93
    Thanked 14 Times in 13 Posts
    Rep Power
    12
    just checking the basis, have you update the connect.ini file to point to the new server?

  4. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    have you allowed remote connections to the sql server - i think by default this is disabled

SHARE:
+ Post New Thread

Similar Threads

  1. Moved from Capita SIMS to Serco Facility?
    By mb2k01 in forum MIS Systems
    Replies: 17
    Last Post: 12th February 2010, 11:44 PM
  2. Moved or moving to SIMS or other MIS
    By alandickey41 in forum MIS Systems
    Replies: 2
    Last Post: 11th March 2009, 06:26 PM
  3. Sims moved to a new domain
    By edie209 in forum MIS Systems
    Replies: 9
    Last Post: 16th November 2007, 06:22 PM
  4. Is EduGeek faster since we moved the database? (Poll)
    By Dos_Box in forum Comments and Suggestions
    Replies: 25
    Last Post: 20th July 2007, 05:32 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
  •