Change Authentication Mode on SQL Server 2012 Express
By default configuration, SQL Server allows only Windows authentication mode. However, if you have some legacy or custom application that needs to access SQL Server using ‘sa’ account, you …
Tag: SQL Server 2012
Install Sample Database Adventure Works on SQL Server 2012 Express
There are many benefits of sample databases, for example, it can be use for learning or studying database-related subjects, or use to test your script/query, etc. In those previous …
Enable Remote Connection on SQL Server 2012 Express
I wrote articles about how to enable remote connection on SQL Server 2008 and SQL Server 2005 many years ago. However, I want to keep its content more up-to-date …
How to Install SQL Server 2012 Management Studio Express
SQL Server Management Studio Express (SSMSE) is a free and easy-to-use tool from Microsoft for manage SQL Server Express, see SQL Server Management Studio Express for more information. On …
How to Install SQL Server 2012 Express
Microsoft SQL Server is one of the most popular database management software used around the world. There are many editions available for SQL Server 2012, see Editions and Components …
[Solved] “Saving changes is not permitted” on SQL Server Management Studio
If you modify structure of database table which requires the table to be recreated and try to save it in SQL Server 2008, you may receive an error message. …