Category Archives: Windows Server 2012 R2

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 database 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 [...]

Windows Updates to avoid 2: Telemetry send loads of data to Microsoft

As I have already written here, Microsoft released a lot of unwanted updates for Windows 7 SP1 and Windows 8.1 recently to promote the update to Windows 10. Now they want to get more data out of your system. By releasing a couple of "Telemetry" updates, they hope to get the same data from you as they get with Windows 10. In addition, these updates slow down your machine and use disk space. Here is the list you need to uninstall KB3022345 KB3068708 - Replaces KB3022345 KB3075249 KB3080149 To Read more [...]

Windows: Run commands to start Control Panel items

Sometimes it is faster to access Control Panel items via command line than clicking and searching in the UI. To use a command, just press <Windows-Key>-R, which will open the Run window. Then just type the command and press <Enter>. For the .cpl files, the "control" command can even be left out, so that is even less to type. Control Panel Applet Command OS Accessibility Options control access.cpl XP Action Center control /name Microsoft.ActionCenter 8, 7 control Read more [...]