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 ...
2nd February 2009, 08:52 PM #1
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?
IDG Tech News
2nd February 2009, 08:58 PM #2
Dropping the database logins in SQL studio resets the passwords, but doesn't kill the usernames themselves.
2nd February 2009, 09:22 PM #3
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!)
2nd February 2009, 09:24 PM #4
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.
6th February 2009, 07:15 PM #5
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!!
By GreenICT in forum MIS Systems
Last Post: 18th August 2009, 09:48 AM
By Jiser in forum Windows
Last Post: 15th October 2008, 12:53 PM
By FAA in forum Windows Vista
Last Post: 8th September 2008, 11:48 AM
By ajbritton in forum MIS Systems
Last Post: 24th November 2006, 12:31 PM
By Nij.UK in forum Windows
Last Post: 28th September 2006, 08:39 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)