Forum Discussion
Configuration Manager - Can't connect to the database server
Hi Antoine,
First, verify that the server name and username you typed in is correct. Make sure current user account has access to this SQL Server Database Engine. Please test whether you can connect to database engine in SSMS using current credential.
Based on my research, in most cases, the above error message occurs because the Database Engine instance that hosts the report server database is not configured for remote connections.
To resolve the issue, please follow the steps as suggested in this thread.
- Open the SQL Server Configuration Management tool.
- Expand “SQL Server Network Configuration”, and click the “Protocols for MSSQLSERVER”.
- Enable both “TCP/IP” and “Named Pipes” protocols. And then restart the SQL Server service
For more suggestion to troubleshoot this problem, please refer to:
An error has occurred while establishing a connection to the server.
Best regards,
Yuliana Gu
Hi Antoine,
First, verify that the server name and username you typed in is correct. Make sure current user account has access to this SQL Server Database Engine. Please test whether you can connect to database engine in SSMS using current credential.
Based on my research, in most cases, the above error message occurs because the Database Engine instance that hosts the report server database is not configured for remote connections.
To resolve the issue, please follow the steps as suggested in this thread.
- Open the SQL Server Configuration Management tool.
- Expand “SQL Server Network Configuration”, and click the “Protocols for MSSQLSERVER”.
- Enable both “TCP/IP” and “Named Pipes” protocols. And then restart the SQL Server service
For more suggestion to troubleshoot this problem, please refer to:
An error has occurred while establishing a connection to the server.
Best regards,
Yuliana Gu
Hi Yuliana !
Thank you very much for your help :) It was indeed a SQL Server problem, it's fixed now.
Kind regards
Antoine