Troubleshooting Relocations
If HelpDesk Web Admin cannot contact or initialize the SQL Server during relocation:
Check
the SQL Server is running.
Check
the SQL Server is configured to use SQL Server and Windows authentication (Mixed Mode authentication).
Verify
that the SQL Server login account sa exists, is not disabled, and has permissions
to log into the master database in the SQL Server. sa must be system administrator
in SQL Server.
Stop
any antivirus software that is running on the SQL Server computer or the Web server computer.
Verify
that the HelpDesk Web Server computer and the SQL Server computer can communicate through the network
(for example, use Ping to test connectivity).
Try
using the IP address instead of the computer name to identify the SQL Server computer.
To
relocate to a SQL Server instance, click Add a SQL Server to this list
and then type the instance name using the syntax <computer name>\<instance name>.
Verify
that both the SQL Server and the Web server are using the same protocol (by default, TCP/IP). To do this,
use the SQL Server Server Network Utility on the SQL Server computer, and the SQL Server Client Network
Utility on the Web server.
Related Topics