MS SQL server 2005 or 2008 / 2008 R2:
The SQL server (mixed mode) authentication.
MS SQL 2005 Express / 2008 Express / 2008 R2 Express:
enabled login for the 'sa' user,
enabled remote connections,
enabled TCP/IP protocol.
Note: after any changes to the above, you must restart the sql service, to have the changes take effect.Article ID: 64, Created On: 8/8/2008, Modified: 10/31/2011