Simple set-up of sa account for SQL Server 2008 R2

Some update for my current web development: After doing some unit testing by using NUnit (which have been said in previous post), today I was about to set up my local version for SQL Server database service. Since SQL database service for my company’s UAT server is using sa account with weak password, it took me quite sometime to figure out how to set up my local SQL database service.

The setup took quite some time because it is not default configuration to use enabled sa account and weak password at the same time. However, after successfully figured it out, I just want to share this tips so that people with similar difficulty can just refer to this tips.

First, you should open your SQL Server Management Studio and on the database service in Object Explorer, right-click and go to Properties. On Properties window, you select Security tab and make sure that Server Authentication option is set to ‘SQL Server and Window Authentication mode’. See figure below:

Security setting

After that, you should restart your SQL database service. Go to Control Panel -> Administration Tools -> Services. And then, you should look for your current SQL service instance and restart it. After that, login again to SQL Server Management Studio and look for sa account under Security -> Logins folder in Windows explorer. Click on sa account icon, right click and choose Properties.

Under general option, make sure that Enforce Password Policy left unchecked as shown in figure below:

Password setting

Assign password to this sa account and repeat it on Confirm Password text box. Then, under Status option, make sure that Login is enabled for sa account:

Login setting

After everything is done, click OK and then disconnect from the database service. Then, when you restart and open SQL Server Management Studio, you should be able to use sa account with your assigned password to login to your local SQL instance.

About edwinlt

I am currently Indonesian expatriate working in Singapore. I am currently working as security researcher in National University of Singapore. I write this blog to share to readers about my life principle on various aspects, like religion, politics, business, relationship, and technology. I am interested in alternative worldviews because I found that many things taught to us by establishments are not true and harmful. My dream is to become self-sufficient in food and energy. Hopefully, someday I can have my own fruit garden and my own power plant and able to sell my electricity to power company. I hope readers enjoy my blog.
This entry was posted in Work and tagged , , , . Bookmark the permalink.

1 Response to Simple set-up of sa account for SQL Server 2008 R2

  1. True, there are comedians that cuss a lot,
    but you got to earn that right before you do that. Think of
    this as a way to document your improvements over time, and eventually
    it will be a very effective PR tool. He hosted Comedy Central’s’The Man Show’ as well as the ubiquitous pseudo-porn for the sexually crippled,
    ‘Girls Gone Wild’, both solely and shamelessly for financial gain.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s