+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, SIMS: dropping logins when using dbAttach in Technical; I am planning a SIMS/FMS database move to another server for someone however I don't know the actual usernames/passwords held ...
  1. #1
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    SIMS: dropping logins when using dbAttach

    I am planning a SIMS/FMS database move to another server for someone however I don't know the actual usernames/passwords held within the SIMS/FMS databases themselves. I've got hold of the SA username/password which I can login to use dbattach however when I select "drop database logins" on detach, the existing usernames are still present within the database when I re-attach (I can see them using SQL management studio)

    Am I missing something? I thought by dropping logins all you would have left when you re-attach is a default sysman username/password?

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    Dropping the database logins in SQL studio resets the passwords, but doesn't kill the usernames themselves.

  3. #3
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    OK, thanks - do you know what it resets the passwords to? (Feel free to PM that info or point to the relevant info on supportnet!)

    Thanks

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    If I remember correctly it just kills them completely, but I don't have my supportnet access at the moment. I know that the sysman password can be reset simply enough, and the others can then be reset using that in combination with system manager.

  5. #5
    robins's Avatar
    Join Date
    May 2007
    Posts
    44
    Thank Post
    15
    Thanked 5 Times in 5 Posts
    Rep Power
    15
    SQLserver requires a db instance login to map to a database user by way of a matching SID code in system tables. There is a database called Master and a table called sysxlogins. To view, run the following in query analyser...

    select * from master..syslogins (its called sysxlogins in SQL2000)

    compare the "sid" for the account that doen't work with...

    select * from sims..sysusers

    Its possible to use an update statement to make them the same - though messing about with system tables should be avoided!!

SHARE:
+ Post New Thread

Similar Threads

  1. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM
  2. Logins for every child.
    By Jiser in forum Windows
    Replies: 18
    Last Post: 15th October 2008, 11:53 AM
  3. Prevent simultaneous logins and more ...
    By FAA in forum Windows Vista
    Replies: 0
    Last Post: 8th September 2008, 10:48 AM
  4. DBATTACH exit code
    By ajbritton in forum MIS Systems
    Replies: 0
    Last Post: 24th November 2006, 11:31 AM
  5. Speed up Service Pack 2 Logins
    By Nij.UK in forum Windows
    Replies: 4
    Last Post: 28th September 2006, 07:39 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
  •