Posts

Showing posts from February, 2014

How to set up a SQL Server 2008 Local Database

Image
Setting up and Configuring your Microsoft SQL Server 2008 Local Database
Download SQL ServerDownload SQL Server Express.  Express is the Free edition of MS SQL Server

http://www.microsoft.com/en-us/download/details.aspx?id=1695


Install your SQL Server InstanceClick the Start button -> Click Microsoft SQL Server 2008 -> Click Configuration Tools -> Select SQL Server Installation CenterSelect Installation -> Select New SQL Server stand-alone installation




Get your Local SQL Server Service Up and Running
Open up the SQL Server Configuration Manager
Click the Start button -> Click Microsoft SQL Server 2008 -> Click Configuration Tools -> Select SQL Server Configuration Manager

Start up the SQL Services

You want to ensure the following services are in the "Running" State and then you want to set the following services to automatic Start mode.  SQL Server:  SQLEXPRESS SQL Server Browser
Right click each service -> Select Properties -> Select Service Tab




Setup Auth…