Network Installation – Error Messages

When clicking the Test Server button, you may receive an error message. Below are some error messages and their causes.

Message: Server <the server’s name> has no instance named <the instance name>.
cause 1: misspelled Instance Name
cause 2: Server Configuration Manager has TCP/IP "Disabled"

Message: Unable to get information from SQL Server: <the server’s name>.
cause 1: "SQL Server Browser" service is not 'started'
cause 2: if you are able to get a "Connection Successful" when running Enterprise ON the server, but not from any other machine, try turning off the Fire Wall of the server

Message: Network error IOException: Connection refused: connect
cause 1: "SQL Server (MYSQLEXPRESS)" service is not 'started'
cause 2: SQL Server Manager Studio, securities set for Window Authentication only, not SQL Authentication
cause 3: entered a port number, but it's a SQL Express using an instance

Message: Login failed for user 'tritech'.
cause 1: entered wrong password
cause 2: entered wrong user id
cause 3: SQL Server Manager Studio, Status sets the "Permission to connect to database engine:" set to 'Deny'

Message: Login failed for user 'tritech'. Reason: The account is disabled.
cause 1: SQL Server Manager Studio, Status sets the "Login:" set to 'Disabled'

Message: Network error IOException: Connection timed out: connect.
cause 1: The SQL Server uses a Named Instance but the settings entered do not have Named Instance checked