In this previous post, I have explained how to install an update to ESXi when you are offline.
Find below the instructions to use when your ESX host is connected to the internet:
Login to ESX via SSH (e.g. with PuTTY)
Run the command to allow the traffic to the Internet
esxcli network firewall ruleset set -e true -r httpClient
Run the command to install the update
esxcli software profile update -d https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/vmw-depot-index.xml -p ESXi-5.5.0-20140902001-standard
Wait Read more [...]
It happens sometimes that we need to rename a database. It is good to know that what happens behind the scenes is different from what you may be expecting. The SQL Server renames the presenting name of the DB only, but not the file names.
To rename the files, you need to use the following script to rename the files of OldDB to NewDB.
ALTER DATABASE OldDB MODIFY FILE (NAME = OldDB, FILENAME = 'C:\...\NewDB.mdf');
ALTER DATABASE OldDB MODIFY FILE (NAME = OldDB_log, FILENAME = Read more [...]
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 [...]