Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk (WHD) Documentation > Web Help Desk Administrator Guide > Set up the application > Configure Microsoft SQL Server

Configure Microsoft SQL Server

Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 943 Votes: 0 Revisions: 4

To configure SQL Server for your Web Help Desk deployment, use the SQL Server Configuration Manager to enable TCP/IP on SQL Server. When completed, use SQL Server Management Studio for SQL Server to create and configure SQL Server to the Web Help Desk database instance.

Enable TCP/IP on SQL Server

Configure the following settings in the SQL Server Configuration Manager.

Setting Value
TCP/IP Protocol Enabled in SQL Server Network Configuration > Protocols for SQL 20xx
IP Address

127.0.0.1 (if installed on the Web Help Desk server)

Server IP address (if installed on a separate server)

TCP Port 1433
IPAll
TCP Dynamic Ports Blank
TCP Port 1433

Create and configure your SQL Server database

Configure the following settings in the SQL Server Management Studio for SQL Server to create and configure SQL Server to the Web Help Desk database instance.

Setting Value
SQL Server and Windows Authentication Mode Enabled
Login Name whd
SQL Server Authentication: Password Enabled and configured
SQL Server Authentication: Enforce password policy Disabled
SQL Server Authentication: Enforce password expiration Disabled
SQL Server Authentication: User must change password at next login Disabled
Database name whd
Database owner whd

 

 
Last modified

Tags

Classifications

Public