Skip to main content

Error - Power BI Report Server: The Service is not available.The report server can’t connect to its database

I was working on a Power BI Report Server project. Even though it is not the mainstream, It fits well for clients who are reluctant to move to the cloud due to data regulations. Everything was working fine respective to Power BI Report Server configurations. Today, when trying to log in to the "Power BI Report Server Portal", encountered this horrible error 😏

Error Message



The service is not available.

 Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details.

 First I connected to the report server database and see whether it's up and running. It is working!... Then, I google it and try to find a solution for that. There wasn't a straight forward solution out there as this error message also a genetic one. My next move was digging into this by starting to read the log files. 

 You can find the Power BI report server log files from below path. (If not go each folder by folder to find logs)
C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles



 It was noticeable the exception thrown when validating the integrity of encrypted data. "Deleting encrypted keys" did not work well for me as in one of the community portal answer.  

 In Power BI forum, sashankpappu has given an answer and marked as solution, Install Power BI Report Server in Developer Mode instead of Free Trail for 180 days. (This has to be done while installing PBI Report Server.) for a similar problem.

 However, I can't guarantee what happened during the installation as this installation was done by the client. 

 Luckily 😎 In my case, this is a fresh deployment and I did not have any existing connections/reports deployed in the reporting portal. So,  I straightly go and create a new report server database, which solved this problem. 

After creating a new database, able to connect successfully and access to the Power BI report portal. 

This is not the best solution to this problem. Because, if you have already deployed 25+ reports you are in great trouble 😁. So, if you had the same issue, and figured out what exactly behind it and as well as the solution, please leave a comment about it in the comment section below. Because that helps a lot for me and the readers of this post. Thank you and happy reporting ✌
Labels:

Comments

Post a Comment

Popular posts from this blog

Step-by-Step Twitter Sentiment Analysis Using Power BI Streaming Dataset, Microsoft Flow and Azure Text API

Sentiment Analysis is known as Opinion mining or emotion AI which is a branch of Natural Language Processing and text analytics where systematically identify, extract, quantify, and study affective states and subjective information. This kind a analysis widely apply to analyse the product or service reviews, voice of the customer, survey responses from online and social media feeds to analyze the attitude of the customer. Basically from the sentiment analysis the output would be either Positive, Negative or Neutral.  There are various algorithms and methods to do a sentiment analysis out there. In this post here I'm doing a sentiment analysis for iPhone 8 product by analyzing twitter feeds. Because, I wanted to know what others are thinking about the latest phone released by Apple. In order to do this task I'm using,  Microsoft Azure cognitive services : Text Analytics (to run the sentiment analysis algorithms to get out the results)  Microsoft Flow ...
5 comments
Read more

How to Get Row Counts for all Tables in your SQL Database

This is the simplest method to get the row counts of all tables in your SQL Server database. Might be useful when you are doing the data testing over your BI project.     select   schema_name (tab.schema_id) , tab.name  as  [table],         sum (part.rows)  as  [rows]     from  sys.tables  as  tab          inner join  sys.partitions  as  part              on  tab.object_id  =  part.object_id where  part.index_id  IN  ( 1 ,  0 )  //   0 :  Table   without  PK,  1 :  table   with  PK and   schema_name (tab.schema_id)  =   'dbo'   group by   schema_name (tab.schema_id) , tab.name --order by sum(part.rows) desc  
Post a Comment
Read more

COVID-19 Situation in Sri Lanka: Real-time Dashboard using Power BI

[Updated on March 28, 2020] COVID-19  is a new strain that was discovered in late December, 2019 and by now it has been started to spread all over the world including 199 countries. There are around 26,000 people were died due to the virus and 580,000 confirmed cases at the moment I update this blog post. Though, the fatality rate is lower when compared to other viruses in similar strains like MERS and SARS . However, the biggest challenge most of the countries facing right now is to accommodate the patients with the growing numbers at every minute. The public was asked by the government to avoid nonessential gatherings as much as possible to stop spreading this deadly virus. Even though there were not many cases found in Sri Lanka, from March first week, they found the initial case a patient who works as a tourist. Now the situation is turning to worst after they found many cases especially tourists who are born Sri Lankans came down from Italy and European countries....
4 comments
Read more