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: Friday, December 2, 2016 1:42 PM
Points: 2,940, Visits: 3,702
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: Thursday, October 6, 2016 12:21 AM
Points: 1, Visits: 33
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: Wednesday, November 23, 2016 10:58 AM
Points: 1, Visits: 67
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: Monday, September 12, 2016 1:50 PM
Points: 48, Visits: 267
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:54 PM
Points: 2,008, Visits: 7,222
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: Today @ 1:59 PM
Points: 34,363, Visits: 18,582
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:42 PM
Points: 4,107, Visits: 9,198
You can do a brute force dictionary query against the sys.sql_logins table.

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



"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Post #1726965
Posted Wednesday, October 21, 2015 7:44 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

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

Add to briefcase «««1234»»

Permissions Expand / Collapse