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

Relocating Databases to SQL Server

Releasing Databases