Configuring SQL Server or SQL Server Express For Mixed Mode Authentication

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:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: