SQL Server Help

Introduction

This topic provides links to how to guides and other useful information about Microsoft SQL Server.

SQL Resources

Any advice in this section should be taken in conjunction with your own IT support, and IRIS are not responsible for any changes made to anti-virus or firewall software. It is a customer's own responsibility to ensure that any changes are suitable for their own environment.

• Microsoft SQL Server Express is only recommended for installations of up to six users. For full system requirements please click here.

General Help

• How to change the location of SQL Server Data and Log files

• How to change Auto Growth settings

• SQL Server 2012 fails to install Database Engine Services and SQL Server Replication

• How to reset the Log File in SQL Server Management Studio

• How to download and install SQL Server 2012 Express

• How to download and install Microsoft SQL Server 2008 R2 with Tools

• How to run a SQL script

• How to restart the SQL Services

• How to identify the SQL Server and Instance name using the IRIS Main Menu

• How to identify the SQL Server and Instance name using the Command Prompt

• How to Set SQL Server to use Mixed Mode Authentication

• How to Unlock The Iris Database (After an Upgrade Fail)

• IRIS Startup Failure - SQL Server Does Not Exist Or Access Denied

• IRIS Startup Failure - SQL Server Does Not Exist Or Access Denied Win 7

• How to Shrink Database Files with SQL 2008 R2

• How to create a workstation specific SQL Server connection using cliconfg