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