[1-day-delivery] Troubleshoot connectivity issues in SQL Server

Title: [1-day-delivery] Troubleshoot connectivity issues in SQL Server
Category: 1-day-delivery
Tag(s): SQL Server, Troubleshoot, Connectivity
Description: You want to troubleshoot and fix SQL Server connectivity issues.

Common Issue(s)

  • A network-related or instance-specific error occurred while establishing a connection to SQL Server
  • "Cannot generate SSPI context" error when using Windows authentication to connect SQL Server
  • Troubleshooting "Login failed for user" errors
  • Timeout expired messages when connecting to SQL Server
  • An existing connection was forcibly closed by the remote host
  • Users may not be able to connect remotely to SQL server using TCP/IP protocol
  • The certificate received from the remote server was issued by an untrusted certificate authority error when you connect to SQL Server


  • Fixed-time: 1 working day(s)
  • Fixed-scope: 1-10 logins
  • Fixed-price: $100

Work Breakdown

  • Verify that the instance is running
  • Verify that the SQL Server Browser service is running
  • Verify the server name in the connection string
  • Verify the aliases on the client machines
  • Verify the firewall configuration
  • Verify the enabled protocols on SQL Server
  • Test TCP/IP connectivity
  • Test local connection
  • Test remote connection

Out of Scope

  • Root Cause Analysis (RCA)


  • Quick fix only
  • You should be able to log in using the credentials.


  • Database server access
  • Screen sharing, if applicable