How to troubleshoot error "Unable to connect with master database with authentication method provided"?
Issue Description: The error "Unable to connect with master database with authentication method provided" usually occurs when Automation Suite is not able to connect to SQL server.
Root Cause: It may be due to either DNS issue, network connectivity or incorrect credentials. Following error is thrown,
Resolution: To troubleshoot such issues,
- Perform the DNS validation using following command,
# host
- The above command should resolve to IP address
- Perform the network connectivity check using following command,
# nc -zv
- Default port number is 1433.
The above command should connected
- Perform the manual credential check using following command
# yum remove mssql-tools unixODBC-utf16-devel -y
# yum install mssql-tools unixODBC-devel -y
# /opt/mssql-tools/bin/sqlcmd -S -U
- For custom port, use following command to check credentials check
# /opt/mssql-tools/bin/sqlcmd -S , -U
- Once successfully logged in, a command prompt is obtained to run commands.