This is an old revision of the document!
Playground
Installing Microsoft SQL Server Express
Download and install Microsoft SQL Server Express:
https://go.microsoft.com/fwlink/p/?linkid=2216019&clcid=0x409&culture=en-us&country=us
On the finish screen, you will be asked to install Microsoft SQL Server Management Studio (SSMS), continue the process and install it. Or you can install SSMS from the Windows “Start” menu afterwards. Go to Start > All Programs > Microsoft SQL Server Version # > SQL Server Installation Center, select “Install SQL Server Management Studio” link to install.
Set up Microsoft SQL Server Connection
Microsoft SQL Server Express needs to have correct settings and parameters for successful connection.
1: Make Sure the Database has TCP/IP Enabled
MIStudio connects a database using TCP/IP, making sure the database has TCP/IP enabled.
To check if TCP/IP is enabled
1. Open the SQL Server Configuration Manager from Start > All Programs > Microsoft SQL Server Version # > Configuration Tools > SQL Server Configuration Manager.The Sql Server Configuration Manager window is displayed.