Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What steps should I take if SQL check is unable to connect to a particular server?

April 26, 2017Connect particular server sql steps

0

Posted

What steps should I take if SQL check is unable to connect to a particular server?

1 Answer

0

Posted

STEP 1: Please check the following items: • Ensure that the name of the database server is correctly entered. • The account that SQL check uses to access the database server computer must have Windows administrator permissions on the database server. • The account that SQL check uses to access the SQL server must have System Administrator (sa) privileges on the SQL Server instance. • The database server must have the Remote Registry service enabled and started. • Ensure that the port that SQL Server is running on (default of 1433) is not blocked via a firewall, router, etc. STEP 2: Once the criteria above have been satisfied, please verify the database server can be “seen” from the SQL check machine. • Go to Start>Run>CMD (Enter). • Type “ping SERVERNAME” (Enter). If the ping is successful, the database server can be “seen” from the SQL check machine. If is it not, consult with your Network Administrator in order to make the server available over the network. STEP 3: Please use Perform