SQL 2008 SA account locked out
- oktober 20th, 2010
- Write comment
Connect from the same server (via terminal), server administrators are by default granted access to SQL Server. Then issue:
ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK
Archive for the ‘System administrators’ Category
Connect from the same server (via terminal), server administrators are by default granted access to SQL Server. Then issue:
ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK
http://www.google.com/support/enterprise/static/gapps/art/users/en/glook/google_apps_sync_chart.pdf
If you have any information in your Outlook that is not syncronized to Google Apps Server, you should consider extra file-backups. TODO: which folders to backup?
If you have a lot of Postfix queue but there are some legitimate mails too, you can run the following command. This will remove mails going to a specific domain.
# mailq | tail -n +2 | head -n 100000 \| grep -v "delivery temporarily suspended" \| awk 'BEGIN { RS = "" } \# $7=sender, $8=recipient1, $9=recipient2 \{ if ($8 ~ /yahoo.com.tw/) \print $1 } ' \| tr -d ’*!’ | postsuper -d -
The command above only parses the first 100 000 rows of your queue. This is for giving you fast response if your search criterias gave any result.
To run search the whole queue, remove ”| head -n 100000″.