Suggested ways to manage SQL server password - A Guest Post by Jyoti Prakash | SansSQL

Saturday, March 7, 2015

Suggested ways to manage SQL server password - A Guest Post by Jyoti Prakash

Security management of SQL server is equally important and you must know that how to manage it. The most initial step to make your SQL server authentic is password security, which required management. Whether it is server or database, all the roles are simplified by security administration by allowing every individual user inherit permissions granted, denied, or abolished to those roles. Although there are multiple areas where user has to put the passwords, which require a proper handling.

SA account is a special login, which is provided for the complete backward compatibility. It is assigned to system admin to fix the roles, which cannot be changed. Therefore, SA account is the most often attacked account and deserves special attention. Here in this article you will get to know about the various rules to manage your SA password. Make sure your password must be random, complex, long and most important not used for multiple instances.
If you are looking for an efficient way to manage your passwords, it is advisable that follow the given techniques to keep track of all your passwords, in case of multiple servers you must use them. There could be multiple ways, here are some of them:

Store Password list
If your number of passwords count is manageable then you can just list them on a sheet and store that hard copy in a safe location. It is advisable that do not store the soft copy of this document as it could be a security risk. This is a very secured way to manage passwords, but could be risky if you have lost the hard copy.

Somewhere this method is not very convenient way to manage passwords as at the time of changing passwords, you have to immediately access this list. If in that case you are not in the situation to access this list. Then this list might become incomplete or become wrong over the time. Therefore, it is recommended that you should opt this method only if you have a reliable and diligent person to take care of this list.

Use Cloud storage
If your organization distributes teams with a rich number of users then, it would be difficult for you to manage all the passwords in the hard copy format. Therefore, to manage such large number of password list you can use several cloud based password management systems that let you to share passwords with the entire team. Many password management tools allow you to your passwords locally so that no one can access your passwords except authenticated users, ever if any other organization using the same password management service.

Local Password storage
Some people do not believe on cloud systems, if you are the one, then a local password store like KeePass, Password Safe, might make more sense to you. Such local password store facilitates multiple powerful features, which make them most trustable and secured ways to manage passwords.

With these tools the password store in encrypted format on a local system. To encrypt the stored password keys, tool uses powerful algorithms that make it infeasible for the attacker. These passwords are handled in such a manner that the system memory will also never store an unencrypted password.
However, these tools also have some shortcomings as well, but in terms of security they are much better.

Enterprise Password Managers
If you belongs to a really big enterprise and have number of servers to manage then enterprise password management tools might be the best thing you are looking for.

An Enterprise password manager not only used to store the passwords, however, they provide various other features as well. This tool can automatically manage access auditing and temporary access. This tool can also allow people to quickly access in case of emergency at the time of creating a 'loud' audit entry as well as sending relevant notifications to the authenticated people.
These tools can also schedule the time for regular password change. For example, you can use this feature to change your SA passwords on monthly or quarterly basis without any user interaction.

Do not use Password
In case you do not feel that there is a requirement of any password, so for this SQL Server also has a feature to disable its Authentication. If this is what you required then your all the authentication and password management system completely depends upon Active Directory. In this mode, you are allowed to control anyone's access up to a particular limit by just including the account into the appropriate AD group, this action can be easily analyzed. Additionally, You will also have a simple process to take all those accounts back out of those groups after a particular interval.

The best advantage of this approach is, that you do not have to manage multiple passwords therefore do not have any risk of security in terms of loss passwords. Here you can easily disable SQL Authentication, therefore, can say that it is the most secured way to handle sysadmin access to your SQL Server instances. Although it is not applicable in every case but this option is surely a considered to a good one.

Conclusion:
In the above mentioned information, you can see various ways to manage your SQL Server SA passwords. Each technique has its own pros and cons, so you have to choose the one according to your requirements. However, in case after following a proper way you have lost your password due to any reason then there are professionalSQL password recovery tools available that can access SQL master database file and allow you to reset your lost or forgotten SQL SA and other individual user passwords. You can choose a reputed and reliable product if you are facing any of such problems. 

About Jyoti Prakash
Jyoti is a Sr. DBA - SQL Server at Stellar Data Recovery and has written several article on SQL Server disaster recovery planning & fixing. In addition, she spend her time on Technical forums helping people with the issues related to SQL server.

107 comments:

Daniel Joseph said...

SAP Training Visit Us,
Sap training in chennai | SAP Success factor training in chennai | Workday training in chennai | Success factor training in chennai

Andria BZ said...

Thanks for sharing this niche useful informative post of SAP HCM & ABAP tips to our knowledge, Actually SAP is ERP software that can be used in many companies for their day to day business activities it has great scope in future if anyone wants to take sap training in Chennai get here.
SAP ABAP Training In Chennai | SAP MM Training In Chennai

Mary prince said...

Thanks for this opportunity. I think so all you said is correct in real sequence. But major industries mean not to be true.

Java training in Chennai | Android training in chennai | IOS training in chennai

Anonymous said...

Bind blowing. You have achieved your target. People should follow your blog for getting more information and their basic needs.

Java training in Chennai | Android training in chennai | IOS training in chennai

Anonymous said...

Awesome blog. I got impressed really. Just can’t imagine your tech. Your notice point is very clear and can be short little more. I need the elaborated story of your mentioning.

Java training in Chennai | Android training in chennai | Java training in Chennai

glennparyy said...

Your sequence is very unique and vague. I can observe few more things which I left in my blog.

Java training in Chennai | Android training in chennai | Java training in Chennai

Sonika Rawat said...

SQL Server Password Recovery program helps you to easily recover password of both the SQL server accounts: SA and user. It is compatible with all the versions of MS SQL Server. The latest version of SQL Server is MS SQL Server 2014. Download and install trial version on your computer to check its efficiency.
Visit :- Recover SQL Server SA Password: Unlock SQL Server Account


Thanks

rebeka christy said...

Your blog is really useful for me, and I gathered some information from this blog. I did SAP Training in Chennai, at FITA Academy. It's really useful for me to make a bright career in IT industry.

Anonymous said...


Thanks for sharing this excellent post. Its really very informative and interesting. Keep update your blog. For a best Android training in Chennai please refer this site.
Regards....
Android Course in Chennai


kovalan Jayamurugan said...

Excellent post!!! Selenium automation testing tool makes software and web application process lot simpler. Keep on updating your blog with such awesome information. Selenium Course in Chennai

Abina Ragav said...

Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us... ANDROID Training in Chennai

Ramya Bala said...

Great article post i really enjoy to read this article about SQL server concept

SAP Training in Chennai

Aneesha Nasrin said...

your posted blog is awesome... i managed my SQL server with password..thanks

Informatica Training in Chennai

Aamala Ahona said...

A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.


Peridot Systems Chennai Reviews

Ridhima said...

Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up.

SEO training in Adyar

Jessy Jessy said...

I would like to thank you for your nicely written post, its informative and your writing style encouraged me to read it till end. Thanks! Funny Videos

Jessy Jessy said...

I am currently writing a research report on Scope of Economics and Economist and I have been exploring your blog for a few hours. Thank you for your post it proved helpful for me. Viral Videos

Jessy Jessy said...

I have never read such quality post/article as yours, ever on the web. Your post/article is very detailed and insightful yet easy to understand. Please write more frequently for this/our community.

Melisa said...


Quite a useful post, I learned some new points here. Thanks admin please keep posting updates regularly to enlighten our knowledge.
Regards,
JAVA Training in Chennai|Android Training in Chennai|iOS Training in Chennai

Nikshitha S said...

The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. The angular js programming language is very popular which are most widely used.
Angularjs Training in Chennai | Angularjs training Chennai

Jones Sathya said...

Yep well said, really its been a struggle to manage those SQL Server passwords, Useful post- Got to know about something needed about passwords of Server - Best Selenium Training in Chennai

Stalin Vinoth said...

the post is good
ETL taining institute in chennai

Geetha Devi said...

Awesome blog..i'm waiting for next updates.
Best Selenium Training in Chennai |Selenium Training in Chennai | Best Selenium Training Center in Chennai
Best Automation Testing Training in Chennai

Nikshitha S said...

Very useful content thanks for sharing such a informative content which provided me the required information on the various technology.
AngularJS Training in Chennai | AngularJS course in Chennai

Mohana M said...

Excellent sharing. Testing is a wonderful field for IT peoples. Want to learn Selenium Online Training reach GangBoard. Hadoop Online Training

Mohana M said...

Excellent sharing. Testing is a wonderful field for IT peoples. Want to learn Selenium Training reach GangBoard. Hadoop Online Training

Evelin Harriet said...

Thank you for Sharing. I'm working in brave technologies private limited, We are the best erp software developers based in chennai. erp providers in chennai

Shivani Yuvanjalin said...

I have read your blog it's very interesting and informative. Keep sharing.
erp in chennai

venkatweetz said...

Very Nice Blog I like the way you explained these things. I’ve been looking for ways to improve my website and overall rankings.I hope your future article will help me further.Take SEO Training in Chennai to mould yourself.

sivanesan said...

The best thing is that your blog really informative thanks for your great information!
erp in chennai

Brave Technologies said...

Really nice post.Thanks for your great information! Keep sharing.
erp software in chennai

anitha a said...

Thanks for sharing this useful information and that's great one.
Web D School

whatis seo said...

Great post thanks for this lovely post. Keep sharing Digital Marketing Course Fees

deepti said...

Thanks for sharing this helpful Blog...

C & C++ Training in Chennai | Online Training Institute in Chennai | No.1 C & C++ Training in Velachery

vini vinitha said...

Nice Blog.Thank you for Sharing. I'm working in brave technologies private limited.we are leading cloud erp solution in chennai

venkatesh krishna said...

very insightful article. SEO Training Community

Krishna Veni said...

Complete Interesting article, Great and nice post, Thanks for sharing your valuable information, your article helps me lot.
IOS Training in Velachery | Best IOS Training in velachery

venkatesh raghunath said...

Good and nice information, thanks for sharing your views and ideas.. keep rocks and updating

Software Testing Training in chennai | Android Training in chennai

jitendra sharma said...

Buying a franchise can be an investment in your future. But as with any major decision, you should thoroughly research the franchise industry, the franchise model and the pros and cons of owning a franchise.
Franchise Opportunities | Franchise Opportunities India

ALINAAMEL said...

I found a lot of interesting information here. A really good post, very thankful and hopeful that you will write many more posts like this one.

Webdesign Lüdenscheid

SKARtec Academy said...

Very Nice Blog I like the way you explained these things. I hope your future blog posts will help me further enhance my knowledge.

annika romy said...

Informative and impressive. Keep Updating
office 2013 professional plus key deutsch

wiztech Automation Solutions said...

Thanks for sharing in this blog...its really useful for us..

Embedded system training in Chennai
PLC training in Chennai
plc, scada training in Ernakulam, Kerala
Ieee final year projects in chennai
Best plc training institute in Chennai
VLSI training in Chennai
PLC training institute in Chennai
PLC training Centre in Chennai
PLC training institute in Ernakulam
Embedded system training institute in Chennai

srihariparu said...

I have read your blog its very attractive and impressive. I like it your blog.
Embedded Project Center in Chennai | Best Embedded Project Center in Velachery

Rigid Box said...

Thanks for sharing. this article wonderful website Information provided in this website are very nice.. Again Thanks for this article..

Indus Associates said...

Thanks !! for sharing this article Lovely

Eva juna said...

nice post.i like it
ssd festplatte

katrinahelen said...

very useful to us.i really like it
personalrekrutierung


Lakhsar Engineers said...

Very Nice !! Keep Updating Article like this !! Wonderful content i got from this website.

lotus said...

Amazing news. Thanks for this blog. Very good knowledge and very good information. No.1 Dot Net Project Center in Chennai | No.1 Dot Net Project Center in Velachery

Ganesh Kumar said...

Very interesting and useful information you have shared about server management. You described this post as easy understandable for freshers. Thank you.

Java Classes in Chennai | Java Course in Chennai

john kevin said...

I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done.


sas training in bangalore

anudeep bichal said...

Good topic selection from the author and nice presentation and thankyou for choosing DB related topics

Android training in bangalores

anudeep bichal said...

Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.

java training in bangalore

Rilon Welding Coimbatore said...
This comment has been removed by a blog administrator.
Vinoth Kumar said...
This comment has been removed by a blog administrator.
Vel Murugan Properties said...
This comment has been removed by a blog administrator.
sherin angel said...
This comment has been removed by a blog administrator.
srihariparu said...

Thanks for sharing the information. i really enjoyed your blog article and always read your blog.
Robotics Project Center in Chennai | IEEE Robotics Project Center in Chennai

sehatwanita said...

This information is very useful. thank you for sharing. and I will also share information about health through the website

Penyebab Benjolan dileher seperti jakun
Pengobatan penyakit Meningioma
Cara Mudah Menghilangkan Keloid
Pengobatan Alami Tuntaskan Keputihan
Obat Luka Bernanah bekas Caesar
Obat Alami Menurunkan tekanan Darah Tinggi
Obat Penyakit kulit Eksim

katrinahelen said...

amazing
jobbörse Neunkirchen

raj kumar said...

I feel really happy to have seen your webpage and look forward to so
many more entertaining times reading here. Thanks once more for all
the details.


white label website builder

preethi Shetty said...

Nice blog with good collection of information which helps a lot.
Best Online Software Training Institute | SQL Server Training

vijaya kumar said...

Nice blog with good collection of information

Best Online Software Training Institute | webMethods online training

Divya D said...

Informative blogs.. Thank you for sharing your thoughts...Continue more

Selenium training in Velachery | Selenium training in chennai

Coimbatore Ooty Taxi said...

Wonderful ! Thanks for Sharing this article keep update this kind of nice articles ..

srihariparu said...

I am happy to read your blog,its really awesome with useful information.keep sharing
Best Summer Courses in Nanganallur | No.1 Summer Courses in Nanganallur

Bee Yes said...

Wonderful ! Thanks for Sharing this article keep update this kind of nice articles ..

Meta Forum said...

Thanks for sharing this informative article. This is really awesome.
http://www.metaforumtechnologies.com/dot-net-training-in-chennai

Sugantha Raja said...
This comment has been removed by the author.
Sugantha Raja said...

Personally I feel this is the wonderful article to know the Suggested ways to manage SQL server password. Keep your good work

Hadoop Training Institute in Chennai | Hadoop/Bigdata Training in Chennai

deepika ranjith said...




Keep sharing such type of useful information

Linux Admin Training in Chennai

brunagari said...


really good
jobbörse südwestfalen

Prasanth Krishnan said...

Thanks for sharing with us

Dot Net Training in Chennai

brunagari said...

really good
Jobvermittlung

renuka devi said...

Nice Articles, Useful Info

Best Java Training in Chennai | JEE Training in Chennai | Best Java Training Institute in Chennai

Venkatesh Krishna said...

Thanks for the insightful article Notifying Ninja

Kingsly David said...

Great Blog to Read,Its gives more useful information. Thanks for sharing.

Java Training in Chennai | Web Designing Training in Chennai

anushka sharma said...

Impressive post. Awesome article on SQL server.PLC SCADA training in chennai

Apsara G said...

It’s Good to share good things, Explained well... RPA Training in Chennai | Blue Prism Training in Chennai

Apsara G said...

It’s Good to share good things, Explained well... RPA Training in Chennai | Blue Prism Training in Chennai

Gandhi I said...

Extraordinary blog. You put Good stuff. All the themes were clarified briefly.Thanks for sharing that post. Keep in blogging.
Digital Marketing Training Institute in Chennai | SEO Training in Chennai

vijaya kumar said...

Wonderful information. Thanks for sharing

AWS Training in Chennai | AZure Cloud Training in Chennai

Awe Tech Water Purifier said...

Good stuffs from this blog I got very interesting points in this article

Deepika Analy said...

Thanks for making me this article. You have done a great job by sharing this content in here. Keep writing article like this.

React Training
React Training in Chennai

Mirnalini Sathya said...

Really an interesting blog on which I gain some new technology updates.
Selenium training in chennai
Selenium training institute in Chennai
iOS Course Chennai
mobile application development training in chennai
Best Android Training Institute in Chennai
Best Android Training in chennai

Robotic Process Automation Tutorial said...

Very informative article.Thank you admin for you valuable points.Keep Rocking
rpa training chennai | rpa training in velachery | best rpa training in chennai

mercyroy said...

Nice Article,Great experience for me by reading this info.
thanks for sharing the information with us.keep updating your ideas.
Cloud computing courses in Bangalore
Cloud Computing Course in Anna Nagar
Cloud Computing Training in T nagar
Cloud Computing Training in Sholinganallur

Sri Nithya said...

Interesting blog, it gives lots of information to me. Thanks for sharing such a nice blog.
Blue Prism Training Chennai
Blue Prism Training Institute in Chennai
Robotics Process Automation Training in Chennai
Blue Prism Training in Chennai
Machine Learning Course in Chennai
UiPath Training in Chennai

pavithra dass said...

Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
CCNA Training in Chennai
DevOps Training in Chennai
DevOps certification Chennai
DevOps certification
CCNA course in Chennai
CCNA Training institute in Chennai

akshaya raja said...

This technical post helps me to improve my skills ,thanks for this wonder post I expect your upcoming blog, so keep sharing...
Spoken English in Chennai
Best Spoken English Institute in Chennai
English Coaching Class in Chennai
Best English Coaching Center in Chennai
English Coaching in Chennai
English Coaching Centre in Chennai

vishnu said...

Thanks for this wonder article I am expecting more from your upcoming blog, So keep sharing

Linux Training in Chennai | Linux Certification | Linux Certification Courses in Chennai | Linux Training in Adyar | Linux Training in Velachery | Linux Training in Tambaram

sharmi chithra said...

It is very excellent blog and useful article thank you for sharing with us, keep posting.

Spoken English Course in Chennai
English Speaking Course in Chennai
Spoken English Training center in Chennai
Spoken English Classes in Anna Nagar
Spoken English Training in Velachery
Spoken English Training in Tambaram
Spoken English Training in Adyar

Robotic Process Automation Tutorial said...

Very informative article.Thank you admin for you valuable points.Keep Rocking
rpa training in chennai | rpa training in velachery | trending technologies list 2018

nanadhini chandran said...

Nice Article,Great experience for me by reading this info.
thanks for sharing the information with us.keep updating your ideas.
software testing course in bangalore
Software Testing Training in Anna Nagar
Software Testing Training in T nagar
Software Testing Training in OMR

Aman CSE said...

Such a wondrful post on Blueprism .This post really helps the students who want to gain knowledge of Blueprism .Thank you sharing such a wonderful post on Blueprism .
Thanks and Regards,
blue prism training institute in chennai
uipath training in chennai
best blue prism training in chennai

pavithra dass said...

Hi,
I must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.
Web Designing Course in chennai
Java Training in Chennai
website design training
Web Designing Institute in Chennai
Java Training Institute in Chennai
Best Java Training Institute in Chennai

Annie said...

Awwsome informative blog ,Very good information thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us. Aviation Courses in Chennai | Best Aviation Academy in Chennai | Aviation Academy in Chennai | Aviation Training in Chennai | Aviation Institute in Chennai

sultana mohammed said...

In the beginning, I would like to thank you much about this great post. Its very useful and helpful for anyone looking for tips to help him learn and master in Angularjs. I like your writing style and I hope you will keep doing this good working.
Angularjs Training in Bangalore
Angularjs Training Institute In Bangalore
Angularjs Course in Bangalore
Android Development Training in Bangalore
Android Development Course in Bangalore
Best Android Training in Bangalore

Meera Kumar said...

Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
R Programming Training in Chennai | R Programming Training in Chennai with Placement | R Programming Interview Questions and Answers | Trending Software Technologies in 2018

mercyroy said...

Informative post,It is useful for me to clear my doubts.I hope others also like the information you gave in your blog.
best german classes in bangalore
learn german language in bangalore
Best German Training Institute in Anna nagar
German Courses in T nagar

Vicky Ram said...

Great informative bog. Thanks for sharing such a valuable information with us.

Article submission sites
Guest posting sites

Aruna Ram said...

Wonderful Blog!!! Your post is very useful informative.Thank you for sharing the article with us. keep more updates.....
SEO Course in Aminjikarai
SEO Training in Vadapalani
SEO Course in Chennai
SEO Course in Karappakkam
SEO Training in Padur
SEO Classes near me

mercyroy said...

Thanks for sharing,this blog makes me to learn new thinks.
interesting to read and understand.keep updating it.
Best AWS Training in Bangalore
AWS Certification Training in Bangalore
AWS Training in anna nagar
AWS Training in T nagar

Anjali Siva said...

Useful content, I have bookmarked this page for my future reference.
RPA Training in Chennai
RPA Training near me
Robotics Process Automation Training in Chennai
RPA courses in Chennai
Blue Prism Training in Chennai
UiPath Training in Chennai

Anbarasan14 said...

Thanks for sharing these effective tips. It was very helpful for me.

English Speaking Classes in Bangalore
English Training Institutes in Bangalore
Spoken English Classes Bangalore
Best Spoken English Classes in JP Nagar Bangalore
Spoken English Institute in JP Nagar
Spoken English in JP Nagar
Spoken English Coaching Center near me

LindaJasmine said...

Awesome Post. Your writing is very unique. The choice of words stood as an exemplary piece of work. Thanks of sharing.
Html5 Training in Chennai
Html5 Courses in Chennai
Html5 Training
Html5 Course
Html5 Training Course
Html5 Training for Beginners
Best Html5 Course
Best Html5 Training

Post a Comment

Ads