| An administrator installing SQL Server desktop engine | | | | null, blank, simple, or well-known password, when an |
| must assign a strong password to SQL Server from | | | | instance of MSDE 2000 is switched to Mixed Mode, |
| security point of view. SQL databases are repository | | | | the MSDE instance can then be easily accessed by |
| of various critical data of an organization. You can't | | | | unauthorized users. The SA account cannot be |
| just make it fall prey to any kind of unauthorized or | | | | dropped, and it must always be protected with a |
| illegitimate use, with weak or easily guessable | | | | strong password to help restrict unauthorized access. |
| passwords. This article throws light on how to | | | | Any user who gains access to an instance of MSDE |
| specify a strong SA (System Administrator) | | | | 2000 indirectly get full control on that instance of |
| password when you install SQL Server Desktop | | | | MSDE, and have the ability to access any resources |
| Engine. MSDE 2000 is the other name for SQL Server | | | | that the MSDE service account has. |
| Desktop Engine. | | | | To avoid such circumstances, you can use custom |
| .MDF files are also secured with passwords to avoid | | | | application code to install MSDE or SQL Server |
| any un-authorized use. Sometimes complexity in SQL | | | | Desktop Engine. For that observe the given points. |
| password results in administrator or user forgetting it | | | | If the user is going to set up MSDE in Mixed Mode, |
| or he just lost that password. In such times,SQL | | | | and is going to use the SA account, request a strong |
| Server Password Recovery software proves to be | | | | password for the SA account from the user. Use |
| elixir. | | | | that password in the MSDE setup. |
| Even if the SQL instance is using Windows | | | | If the SA account is not used, generate a random |
| authentication, you must provide a strong password. | | | | string, and then pass that string as the SA password |
| We know that while using Windows authentication, | | | | to the MSDE setup. |
| the SA account is not used by any user. But the | | | | If somehow you forget the SQL server database |
| current instance can later be switched to Mixed | | | | password or you have lost the SQL server database |
| Mode, and then the SA account becomes an active | | | | .MDF password, you need to recover the SQL Server |
| login. Therefore, it is suggested that you should not | | | | password immediately. What should be your course |
| assign the password blank or NULL. It should have | | | | of action to deal with such awkward situation where |
| strong encryption. | | | | you don't want to compromise with the security of |
| If the SA (SQL authentication login) account has a | | | | SQL database? |