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
Management
- 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)
Deliverable(s)
- Quick fix only
- You should be able to log in using the credentials.
Prerequisite(s)
- Database server access
- Screen sharing, if applicable