MS SQL Server 2014 is available for a 180 day trial period. The installation package is available on the official Microsoft download center. Harris employees have access to the Developer version for less than $50. See program on Sharepoint.
Administrator rights are required to install and manage MS SQL SERVER. Many functions and commands need to be run or executed as an Administrator.
Remember there are three (3) things needed to establish a connection.
- What? ….. Type of Server (i.e. MS SQL Server 2012, Oracle, Sybase…)
- Where? …. Instance or Database Name (a default database can be used)
- Who? …… Logged in window’s user (Windows Authentification) or MS SQL SERVER user with password
Important Setup Parameters
When installing there are many choices to make and each scenario entails other decisions on ways to do it.
Setup possibilities are almost limitless and the impact can be big. Fortunately, the default values are well setup and can be used successfully when unsure or no access to Google.
There are many different possibilities and the use of Virtual Machines (VM) is recommended.
GENERAL
- Documentation Choose Local Help so the books and documentation get copied during installation. Quicker and friendlier. Handy if internet not available.
- Authentication method Choose the Mixed method … both MS SQL SERVER and Windows authentication.
- Type of Logs (Recovery Mode) Should never be set to Full unless in a Production Environments.They keep on growing until a full backup made.
SERVICES
- SQL Agent Service Can be turned on later when needed. Used to schedule jobs…
- Integration Services (ETL) Full blown version is optional and pricey on MS SQL Server and unavailable on Express. Kettle from theOpenSource Pentaho Community can be used,
- Reporting Services only if using SSRS
- Remote Blob Services (RBS) to use a guid link to images stored outside of the database. This is a major improvement on performance and is transparent to users. It can be easily printed by Crystal Report, SSRS, etc.
SECURITY
Accounts, Connections, Users and Roles (groups).
- Group Policies To see Group policies defined, run CMD as admin and type gpresult / r
- Roles Before defining Roles in MS SQL SERVER or in GOVERN, check with the IT department to see what groups are already defined on the database.
Server Installation (Step by Step)
Step by Step instructions to install MS SQL Server 2014
Create ODBC Connection
- ODBC Use SQL Native Client in 2012 and install AS Admin. Note, the name reverts back to ODBC in 2014.
Loading...