To test the connection for validity, click Test Connection button. The following message will confirm its validity.
If the connection is invalid, an appropriate error message will be displayed instead.
Then you will need to fix the Connection parameters (credentials, server name, …) or check network connectivity (is the SQL Server accessible from here ?)
The server was not found
Usually after a long timeout, if the error message says “Unable to connect […] The server was not found or was not accessible”, check that the server is accessible from this machine on that port.
If the message says “login failed for user”, then Alpana successfully connected to the server, but the credentials were invalid.
Check if that SQL user exist and the password is correct.