By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.

Test Connection Failed.

Would you like to...

Print this page
Email this to a friend

When installing a workstation you are presented with a database configuration window that must be filled in correctly before you can continue. You can find basic setup information in KB article T0218, you generally only need to input your server name. If this information is not corect, or your server is not configured correctly then you will receive an error stating "Test Connection Failed." You can follow the instructions below to troubleshoot.

1. Make sure that all software firewalls are off on both the server and workstation, or verify that they are not blocking the ports necessary for communication with SQL Server.

2. Verify that the two computers are on the same network and that name resolution is working.
If you use file shares, try browsing files on the server from the workstation using the \\ServerName\Share format. If you're familiar with the Windows Command Prompt, try to ping the server from the workstation by name and make sure it resolves to the correct IP address and responds.

3. Make sure that your SQL Server Browser is running on your server. You can do this by opening Administrative Tools | Services and ensuring that it says 'Started' next to SQL Server Browser.

Related Questions:


No attachments were found.

ServiceLedger KnowledgeBase Copyright © 2020
Powered by AcitveKB Knowledgebase Software