Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

Script out passwords Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2014 9:10 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 3, 2016 9:22 AM
Points: 326, Visits: 437
Keep 'em comin' boyz!!! Too fun....dork dork!!


Thank you!!,

Angelindiego

Post #1557550
Posted Wednesday, April 2, 2014 9:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:46 PM
Points: 2,830, Visits: 3,489
Ha ha ha. Nice.

I was scared for a moment that this was a real script, until I checked the comments.

Thanks,
webrunner


-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1557570
Posted Thursday, April 3, 2014 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 21, 2015 8:20 AM
Points: 7, Visits: 44
Pretty slick!!!
Post #1558058
Posted Friday, October 9, 2015 1:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 6, 2016 2:59 AM
Points: 1, Visits: 31
Must Have!!!
Post #1726750
Posted Friday, October 9, 2015 6:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 10:31 AM
Points: 1, Visits: 43
That was class!!
Post #1726818
Posted Friday, October 9, 2015 8:46 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 26, 2016 1:59 PM
Points: 46, Visits: 247
Well played!

Although it might be worth mentioning here that you can script out login creation statements (with SID and password hash) to move logins from one server to another, which will work with databases restored from the same server. That's kind of what I thought this might be, when I first read the title. Microsoft offers this (https://support.microsoft.com/en-us/kb/246133) but their script can definitely be improved upon... although I don't think I've seen a good one posted anywhere? (I've seen a nice Powershell version, but not T-SQL.) Would there be any interest in that sort of thing?
Post #1726881
Posted Friday, October 9, 2015 8:54 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:14 AM
Points: 1,792, Visits: 6,110
You have wayyyyy too much time on your hands Steve.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Post #1726887
Posted Friday, October 9, 2015 12:29 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:21 PM
Points: 33,667, Visits: 17,754
Michael L John (10/9/2015)
You have wayyyyy too much time on your hands Steve.


That is certainly not true.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1726960
Posted Friday, October 9, 2015 12:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:03 PM
Points: 3,479, Visits: 8,065
You can do a brute force dictionary query against the sys.sql_logins table.

http://www.sqlservercentral.com/Forums/FindPost1623412.aspx



"If you break a few eggs, then make an omelet."
Post #1726965
Posted Wednesday, October 21, 2015 7:44 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 7,764, Visits: 739
Funny. I actually thought you had something there.
Post #1729720
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse