

STEP 4: Select “New SQL Server stand-alone installation or add features to an existing installation”. STEP 3: You will find the same screen given below. If you’re on Windows 7 then you’ll get a compatibility warning. exe you downloaded and select “Run as Administrator”. STEP 2: Make sure you are logged in as an administrator of the machine then right-click on the.


I’m running Windows 7-64bit so I’ll be detailing the steps as it pertains to that OS. STEP 1: Download Microsoft SQL Server Management Studio and select either SQLManagementStudio_圆4_ENU.exe or SQLManagementStudio_x86_ENU.exe depending on your machine’s OS bit-version. If you installed Visual Studio 2010 then you will need the 2008 version (not R2). Okay the first thing you need is to make sure you get the right version of SSMS. There are two types of database available for creating the application with Visual Studio that is *.mdf and *.sdf. Although you can use Visual Studio to create/connect/design databases, I like having SSMS around for advanced management. Visual Studio 2010 installs SQL Server 2008 Express on your machine but doesn’t include SSMS. One of the first things you need to do after installing Visual Studio is to install SQL Server Management Studio (SSMS).
