Installing and configuring MS SQL Server 2008 - rbeckman-nextgen/test-mc GitHub Wiki

  1. Mirth Connect
  2. Home
  3. Examples and Tutorials

Mirth Connect : Installing and configuring MS SQL Server 2008

Created by Adrian Galvan, last modified on Mar 08, 2013

Installation

Icon

Before you proceed make sure you sure your system is up to date (Windows Update) and that you have the most recent version of the .NET framework (http://www.microsoft.com/net/download)

Download and install **SQL Server 2008 R2 Express with Tools **from the Microsoft Download Center.

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

During the install keep hitting continue, all the default settings are the preferred ones.

Configuration

Open Microsoft SQL Server Management Studio and connect using your Windows Authentication

In the Object Explorer on the left navigate to Security > Logins, then right click on the Logins folder and select New Login...

Create your user under General and select SQL Server Authentication

Under Server Roles make sure you set this new user to be a sysadmin

In the Object Explorer right click on the Database folder and select New Database...

Create your new database in the General page

Right click on the server and select Properties

Under Security select SQL Server and Windows Authentication mode

Open the SQL Server Configuration Manager and navigate to SQL Server Network Configuration > Protocols for (your server name) > TCP/IP.

Set the status to enable if hasn't been enabled yet.

Right click on TCP/IP and navigate to the IP Addresses tab.

Blank out the *TCP Dynamic Ports *field under IPAll and set TCP Port to the default value of 1433.

Under SQL Server Services right click on SQL Server (your server) to restart the server and have these changes take effect.

When connecting to this database use the URL: jdbc:jtds:sqlserver://(hostname):1433/(database)

 

Attachments:

[2013-03-08\_082358.png](attachments/22381818/22642721.png) (image/png) [2013-03-08\_082925.png](attachments/22381818/22642722.png) (image/png) [2013-03-08\_083432.png](attachments/22381818/22642724.png) (image/png) [2013-03-08\_083432.png](attachments/22381818/22642723.png) (image/png) [2013-03-08\_083448.png](attachments/22381818/22642725.png) (image/png) [2013-03-08\_085626.png](attachments/22381818/22642726.png) (image/png) [2013-03-08\_083600.png](attachments/22381818/22642727.png) (image/png) [2013-03-08\_083713.png](attachments/22381818/22642728.png) (image/png) [2013-03-08\_084811.png](attachments/22381818/22642729.png) (image/png) [2013-03-08\_083933.png](attachments/22381818/22642730.png) (image/png) [2013-03-08\_084859.png](attachments/22381818/22642731.png) (image/png) [2013-03-08\_085026.png](attachments/22381818/22642732.png) (image/png)

Document generated by Confluence on Nov 11, 2019 08:40

Atlassian

⚠️ **GitHub.com Fallback** ⚠️