Category Archives: SQL 2012

SQL Server 2012 Express: How to get access to the DB when you have lost all passwords

It can happen that you lose all passwords or that you delete the users in a DB, so you have no access or limited access to the databse instance. There are many articles on the Internet that talk about SQL password crackers or other strange methods (some cost you money) to sort this out, but there is a much better and simpler method. For this to work, you need access to the server console (for example via RDP). The trick is to activate and reset the password for the sa account, then login with Read more [...]

SQL Server 2012 Express: How to install on a Windows 2012 R2 Domain Controller

While it is not recommended (mostly due to security reasons), SQL can be run on a Domain Controller. But the following 2 points have to be considered: The order is important: SQL can be installed on a DC. But a SQL server cannot be made a DC. So: DC first, then SQL You cannot use the following 3 accounts for the SQL service: Local Service, Network Service, MSSQL$SQLEXPRESS Although I used these guidelines, it did not work for me. Near the end of the install, when the SQL service is started Read more [...]