Installation Passwords

Question

Installation Passwords

Steve Jones - SSC Editor

SSC Guru

Points: 736160
More actions
July 6, 2016 at 9:10 pm

#77432

Comments posted to this topic are about the item Installation Passwords
July 7, 2016 at 2:18 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

J DBA SSCertifiable Points: 5008 More actions · Answer 1

Thanks for the question Steve.

It's nice that at least in install it is forcing strong passwords. I've worked many a place where the sa password was an easily guessed word or worse blank. Those passwords got changed really quickly.

J DBA

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Good question thanks, guess I am just too used to using all 4!

...

Toreador SSChampion Points: 11365 More actions · Answer 3

I can never pass up the opportunity to post this link

http://xkcd.com/936/[/url]

The Curse of St. Custards SSC Enthusiast Points: 166 More actions · Answer 4

So all 4 would rank as being 'VERY Strong!'

2 would rank as 'meh, well OK then'

1 would rank as 'you gotta be kidding'

🙂

sknox SSChampion Points: 12388 More actions · Answer 5

jon_tout (7/7/2016)
So all 4 would rank as being 'VERY Strong!'
2 would rank as 'meh, well OK then'
1 would rank as 'you gotta be kidding'
🙂

And 0 would rank as 'c'mon, you've got to put SOMETHING in there!'

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

I thought all 4 are required to make the password strong.

It must contain uppercase letters.

It must contain lowercase letters.

It must contain numbers.

It must contain non-alphanumeric characters; for example, #, %, or ^.

Thanks.

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 7

It's strange to see more wrong answers than correct answers (at the time of this writing "3" is 45% of the responses; "4" is 51% of the responses). Coffee sales must be slow this morning.

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 8

SQL_Hunt

SSC-Dedicated

Points: 33518

July 7, 2016 at 7:45 am

#1888921

Ha.Ha. 🙂

Thanks.

Sean Lange SSC Guru Points: 286590 More actions · Answer 9

I would have assumed all 4 but as with most QOTD there must be something to warrant asking the question in the first place. It seems that once again MS can't be consistent with their documentation. Some places say it must be at least 8 characters, others say more than 8. They are so inconsistent with the minimum requirements it is no wonder people can't get it right.

https://msdn.microsoft.com/en-us/library/ms161962.aspx

https://msdn.microsoft.com/en-us/library/cc281849.aspx

correcthorsebatterystaple FTW!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Sean Lange (7/7/2016)
I would have assumed all 4 but as with most QOTD there must be something to warrant asking the question in the first place. It seems that once again MS can't be consistent with their documentation. Some places say it must be at least 8 characters, others say more than 8. They are so inconsistent with the minimum requirements it is no wonder people can't get it right.
https://msdn.microsoft.com/en-us/library/ms161962.aspx
https://msdn.microsoft.com/en-us/library/cc281849.aspx
correcthorsebatterystaple FTW!!!

You can also consider https://msdn.microsoft.com/en-us/library/ms161959.aspx

Thanks to Steve for the question.

webrunner SSC-Dedicated Points: 31859 More actions · Answer 11

Like many others who have posted comments, I also first thought all 4 would be required for a strong SQL password. And it does stand to reason that empirically the password using all 4 would have all of the strengthening properties that are recommended.

But then I thought, did they relax the restriction to 3 because special characters might cause issues when interacting with other systems? Guess I will have to read up on the documentation to find out.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

webrunner SSC-Dedicated Points: 31859 More actions · Answer 12

Toreador (7/7/2016)
I can never pass up the opportunity to post this link
http://xkcd.com/936/[/url]

+1 🙂