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:
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:
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:
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.