How to set up a SQL Server 2008 Local Database


Setting up and Configuring your Microsoft SQL Server 2008 Local Database


Download SQL Server

Download 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 Instance

  • Click the Start button -> Click Microsoft SQL Server 2008 -> Click Configuration Tools -> Select SQL Server Installation Center
  • Select Installation -> Select New SQL Server stand-alone installation

SQL Server Installation Center Image
Select 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
SQL Server Configuration Manager Image
Setup SQL Server Config 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


SQL Server Config Manager Console
Start up required SQL Server Services


Setup Authentication to your Local SQL Server




  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Click "Connect to Object Explorer" and select Server Name:

[YOUR_PC_NAME]\SQLEXPRESS

Example: 

Your Computer\SQLEXPRESS or (localhost)\SQLEXPRESS


Setup Authentication for your SQL Server


Finding your PC Name:
Click the Start Button -> Right-click My Computer -> Properties -> Computer Name tab


Control Panel Console - Basic Information
How to find your PC Name on the network



Configure your User Accounts and Permissions


Create a Login Account: 


  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Connect to your Local SQL Server
  • Click on the expand tree button for your Local Server -> Security -> Right-click on Logins -> Select New Login

Setup the Password for the New User: 

Un-check the following settings:



  • Enforce password policy
  • Password expiration 
  • User must change pw(Since this is local) 


Set the Default database -> This DB

Grant roles to New User Account: User Configuration Page


  • Map to your database -> grant db_owner role Status Page
  • Grant Permissions to connect then Enable Login
Permissions and Roles config in User Account Console
Setup Permissions and Roles




Setup Network and Authentication


Enable all Authentication Modes


  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Connect to your Local SQL Server
  • Right-click your Local Server -> Select Properties -> Select Security Tab -> Enable SQL Server and Windows Authentication Mode

Network Configuration

Enable TCP/IP



  • Open SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for SQLEXPRESS -> Enable TCP/IP
Network and Auth Configuration
Enable TCP/IP and set up authentication method


Restart your SQL Local Server Service

  • You will have to restart your SQL Server after enabling TCP/IP



Popular posts from this blog

Spring Boot Internationalization with Default Locale for Message Strings

Change Port on a Spring Boot Application when using intelliJ