SQL Express Reporting Server 2014

Question

I have a problem getting my SQL SSRS service working. Version: SQL Express 2014

When I try to start SQL SSRS in services, the service starts, but looking at the event viewer it fails to connect to report server.

EVENT ID:107
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.

My understanding is that the service connects to the SSRS databases using the rsreportserver.config file. So in my head the fault must lie there.

I then checked whether I can connect to the reporting server database using the credentials specified in rsreportserver.config.

I created a .UDL file and successfully connected to the database using:

user: sa
pass: testing

I then decided to rewrite the configuration file using rsconfig utility.

-c -s SERVERNAME -i SQLEXPRESS -d ReportServer$SQLEXPRESS -a SQL -u sa -p testing -t

This works without any problems or errors.

Regardless the service continuously does not connect to the reporting database.

Also when I use the Reporting Services Configuration Manager - DATABASE connection details. I cannot successfully connect to the database using the same SA account and password. Nor can I actually create a new database within Reporting Services Configuration Manager using the sa account or the administrator account (both which can actually connect to the database using the UDL file).

Any help would be greatly appreciated.

Answer 1

Found the problem in the end. The TCP/IP protocol in the SQL server configuration Manager did not have 1433 set as the port + none of the IP's were active and enabled. Once I enabled and changed port to 1433 and restarted all worked.