The following steps may be required before you can complete the installation; first, check that the database location, username and password are correct. You must also have SQL Server or SQL Server Express configured for mixed mode authentication. The steps below are documented for SQL Express, but are similar for all editions of SQL Server, using SQL Server 2005 Management Studio.
These steps can be completed even while the .NET StockTrader installation remains in progress at the database creation dialog.
Steps to Configure SQL Express for Mixed Mode Authentication
Step 1. If you do not already have SQL Server Management Studio installed, download and install SQL Server Management Studio Express from MSDN at:
Step 2. Start/Run SQL Server Management Studio Express from the Windows Start menu.
Step 3. Right-click on the top icon (.\SQLExpress) and choose properties.
Step 4. Choose the Security tab.
Step 5. Change Server authentication to SQL Server and Windows Authentication Mode
Step 6. Click the OK button to apply the change.
Step 7. Right click on the same top icon (.\SQLExpress) and choose Restart.
Step 8. Open the Security folder. Right click on the sa account and choose Properties.
Step 9. Type in and assign a new password–but remember the password you choose! Click the OK button to save the new password.
Step 10. Again right-click on the sa account and choose Properties.
Step 11. Choose the Status tab. Change Login from "Disabled" to "Enabled". Click OK to apply the change.
Step 12. From StockTrader setup, login to .\SQLExpress (or [remoteservername]\SQLExpress)
using the now-enabled sa account, and the password you chose for it.
Filed under: SQL2005