1) SQL for Windows Vista / Windows 7
MSDE doesn’t run on Windows Vista and Windows 7. User must install SQL Express in this OS.

2) Install MSDE and SQL2005 in one machine
Two different SQL server can be install in one machine provided they are installed using different instance name. By default SQL Express 2005 instance name is \SQLEXPRESS whereby MSDE instance name is blank.

3) SQL Express 2005
Requirement: Microsoft .NET Framework 2.0 and Microsoft .NET Framework 3.5

4) WinPRO, TimePRO and E.VIS
User name and password for sql server access is store in the *.tab files. Hence, if you copy database file from other server which has different user name and password. Copy back the .tab file from your original PC software’s .tab file into customer-copy-back software’s folder will enable user software to access your sql server. Else, you won’t be able to access if customer sql server username and password is different from yours.

5) Turn on Mixed Mode Authentication after you install MSDE

Please back up the registry before you modify it

By default, the value of the LoginMode Windows registry subkey is set to 1 for Windows Authentication. To turn on Mixed Mode authentication after you install MSDE, you must change this value to 2. The location of the LoginMode subkey depends on whether you installed MSDE as the default MSDE instance or as a named instance.
If you installed MSDE as the default instance, the LoginMode subkey is located in the following registry subkey:

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

If you installed MSDE as a named instance, the LoginMode subkey is located in the following registry subkey:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name \MSSQLServer\LoginMode

To change the value of LoginMode to 2, follow these steps:
In Control Panel, open the Services tool, and then stop MSSQLSERVER and all other related services (such as SQLSERVERAgent).
On the Start menu, click Run, type regedt32, and then click OK to start Registry Editor.
Locate either of the following subkeys (depending on whether you installed MSDE as the default MSDE instance or as a named instance):
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\

-or-
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Name\MSSQLServer\

In the right pane, double-click the LoginMode subkey.
In the DWORD Editor dialog box, set the value of this subkey to 2, verify that the Hex option is selected, and then click OK.
Restart the MSSQLSERVER service and the SQLSERVERAgent service for this change to take effect.

6) What happen if I forget SQL server password
You can use SQL management studio to login under windows mode. From there, you can change or create password for user “sa” so that you can login using mixed mode.

7) Installation failed due to installed component detected
This error is caused by unclean uninstallation of previous SQL database. Some of the file, services is not being uninstalled properly. In this case, please follow this steps:\
a) Delete the MSSQL folder in C:\Program Files\
b) Go to control panel -> admin tools -> services. Stop and disable all SQL related services. Double click on the services to get the service name.
Then run command prompt and key in the following command: sc delete . If it returns sc delete SUCCESSFUL, the services has been deleted. Repeat this step for all SQL services.
c) Use registry editor to delete Microsoft SQL Server from “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\”