Oct 13 2011

Lost SA Password for SQL Server (Express)?

Category: Notes to selfCrashingDutchman @ 15:51

Today I had to log in onto a SQL Server for which the password for 'sa'-user was not known to me. After some Googling around, I found this post 'Forgot the SA password in Sql Server 2005'.

In short, what you do is loging on into your Operating System with an account that has Administrive rights, restart SQL Server (Express) in Single user-mode and login to SQL Server express with that account. This way you can change the password for user 'sa' or enable the account when it was disabled.

This turned out to work pretty well. I hope the link above can be of use to someone else.


Sep 16 2011

Windows Mobile Mail - Error synchronizing

Category: Notes to selfCrashingDutchman @ 16:06

I've been pulling my hair out over this a few times already and FINALLY solved it. For me the issue seems that when my provider downloads all its settings to the phone the Internet service is called "Vodafone Live" where the email settings are trying to use "Internet" (which then no longer exists).

Just for future reference (mostly @myself), here is how to solve it:
At your mail inbox: Menu > Tools > Options > Click your email account > Edit Account Setup > press Next until you get to the Outgoing (SMTP) Mail server settings page > Click the Advanced Server Settings link at the bottom > change Network connection to your internet provider (Vodafone Live) instead of the default "Internet"  > carry on through the pages until finished. It should now connect without the Error Synchronising message.