You mention more than 1 instance is on the server - have you specified the Instance Name when selecting the SQL Server?
Also, is the SQL Browser service running - if not you may not be able to identify the correct ports to connect on.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am attempting to create the reporting services database for usage in MECM. The reporting services installed fine (install only), but once I get to the Database tab and try to connect to the database server to create the database, it fails by timing out when trying to connect (see dialog). I am using Authentication Type: Current User - Integrated Security (domain user account loaded with permissions on that server - used by several other SQL apps).
Full text of error message:
Could not connect to server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes provider, error: 50 - Could not open a connection to the SQL Server)
We are using two named instances, so the ports are dynamic. I have made sure all ports are active (netstat).
I also made sure of the following:
I have checked the Application Event log and SQL/Reporting Server logs without any hints of the problem.
What could be causing this issue? I have spent hours troubleshooting something that should be so easy.
You mention more than 1 instance is on the server - have you specified the Instance Name when selecting the SQL Server?
Also, is the SQL Browser service running - if not you may not be able to identify the correct ports to connect on.
Yes, the instance is embedded from the Reporting Server installation.
As mentioned in the OP, all services are running.
Thanks.
Hi @Thomas Simon ,
Please make sure you are using the correct instance name.
When you connect to a default instance, machinename is the best representative for the instance name.
When you connect to a named instance such as sqlnewname, you need to specify the instancename as follows: machinename\instancename where you enter in the SSRS server name.
Also go to the task manager--services--restart your MSSQLSERVER service.
More details, please also refer this.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
The error you are receiving is a generic "cannot connect to server" message. It does not help in any way diagnose the issue.
Have you installed a SQL Server "Database Engine"? It sounds like you have not, you have only installed SSRS. The screen print is the SSRS Instance Name, not the SQL Server DATABASE ENGINE instance name.
Please verify you have a SQL Server Database Engine installed.
Was this ever resolved as I now have the same problem with SQL server 2022 and SSRS 2022