Now as we have successfully installed SQL EXPRESS on our machine. Let’s go to configure it. Click the Start button on windows Dashboard and type ‘SQL Server Configuration Manager’ in the search box. Click ‘SQL Server Configuration Manager’ to open it

Now expand SQL Server Network Configuration and click to select Protocoles for SQLEXPRESS

Double click the named Pipes so that the Named pipes properties dialog box pops up. Select Yes from the drop down menu next to Enabled

When you click the Apply button, System will inform you to stop and start the serever so that our changes may take effect. So click OK

Now double click TCP/IP to pop up TCP/IP Properties dialog box. Select Yes from the drop down menu next to Enabled and click the Apply Button.

Now click to select SQL Server services – the top one on the left side bar. On the right side bar click to select SQl Server(SQLEXPRESS) and click the Stop button to stop the services.

Now do the same as was instructed above but this time click the Run to restart the services

Now double click SQL Server Browser to pop up SQL Server Browser Properties dialog box. Click on the Service tab that appears and select Automatic from the drop down menu next to Start Mode. Click Apply and click Ok.

Now again click to select SQL Server Browser. and click the Run button to start browser

That’s Completed. Your final set up should look like that you see in following image