SQL Server: Difference between revisions
From DirectWiki
No edit summary |
Added Firewall Configuration |
||
| Line 17: | Line 17: | ||
:::# Select "SQL Server 2008" and "SQL Server Management Studio" | :::# Select "SQL Server 2008" and "SQL Server Management Studio" | ||
2. [http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ Enable remote connection to SQL Server 2008] | 2. [http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ Enable remote connection to SQL Server 2008] | ||
::* Express edition's default installation doesn’t allow remote connection so you have to enable it manually. | |||
3. [http://technet.microsoft.com/en-us/library/ms175043.aspx Configure Window's Firewall for Database Engine Access] | |||
::* This allows your instance of SQL Server to be visible on your internal network. | ::* This allows your instance of SQL Server to be visible on your internal network. | ||
::* | ::* If you are using another firewall beside Windows, please allow the same type access as described in the article. | ||
4. [http://msdn.microsoft.com/en-us/library/cc645923.aspx Enable FILESTREAM] | |||
::* This allows for large files to be stored and managed within the database. | ::* This allows for large files to be stored and managed within the database. | ||
::* Make sure all 3 boxes are checked on the FILESTREAM tab. | ::* Make sure all 3 boxes are checked on the FILESTREAM tab. | ||
Revision as of 18:42, 11 May 2011
Microsoft SQL Server 2008
Direct's new products are built on top of industry standard Microsoft SQL Server 2008. Some of the benefits include speed, reliability and cost. The express edition is FREE and holds databases up to 4Gb in size.
|
Important: The latest version is SQL Server 2008 R2. |
Requirements
The following requirements must be met before Direct Systems can install their software. Upon completion, support staff must have access to the server, logged in as the same user that installed the database.
1. Install Microsoft SQL Server 2008 with SQL Server Management Studio
- If possible, install on the same server where the program files will be located.
- On the website SQL Server Management Studio is called Management Tools.
- When prompted to supply credentials, we suggest choosing "Windows Authentication". If you choose to supply a password, please make note of it.
- We suggest using Microsoft Web Platform to install. It runs seamlessly and automatically detects 32-bit/64-bit.
- Download and run Web Platform
- Search for "SQL Server 2008"
- Select "SQL Server 2008" and "SQL Server Management Studio"
2. Enable remote connection to SQL Server 2008
- Express edition's default installation doesn’t allow remote connection so you have to enable it manually.
3. Configure Window's Firewall for Database Engine Access
- This allows your instance of SQL Server to be visible on your internal network.
- If you are using another firewall beside Windows, please allow the same type access as described in the article.
- This allows for large files to be stored and managed within the database.
- Make sure all 3 boxes are checked on the FILESTREAM tab.
