How To Create Local Database In Sql Server 2008

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

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

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

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

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

Change Port on a Spring Boot Application when using intelliJ

Change Port on a Spring Boot Application when using intelliJ Two ways to change the port that the embedded Tomcat is using in a Spring Boot Application. The first way is to modify the application properties in the resources folder: Update application props in Spring Boot Application There are a couple issues with this approach. You might only want this port change in your local environment and if you check it in by accident you might break things. Alternatively, you can use a command line parameter. Go to Run -> Edit Configurations -> VM options Then enter in the following argument: -Dserver.port=8090 Then click apply and OK and attempt to run the application again. Update port using VM option

Building Microservices with JHipster

Check out this article on Medium and LinkedIn Pulse, for a brief overview of microservices as a primer for working with JHipster to build web applications with a Microservices backend. Building microservices with Jhipster JHipster is sponsored by Ippon Technologies(https://www.ippon.tech/).