cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sunny Frequent Visitor
Frequent Visitor

Report server configuration manager - Credentials error

Hi all, I am a rookie to Power BI. I am setting up Power BI Report server (Trial version) on premises to use along with Power BI Desktop. I get an error when I am on the Credentials step in the Report server database configuration wizard. I am connecting to a remote database server. I have selected the option to create a new Report server database on the SQL Server instance. (2016) 

 

According to the documentation I can either use a Network credential or a SQL Server credential. So I used SQL Server credential but it is not allowing to connect. Any suggestions would be appre

error_config.PNG

 

 

4 REPLIES 4
Jon-Heide Established Member
Established Member

Re: Report server configuration manager - Credentials error

Hi Sunny, you should check that the service account has access to the domain and connect across machines. You might try running the service account as network service or a domain account. Also, try running the configuration wizard as an OS administrator, launching it with elevated permissions (just right click and select run as administrator). 

Sunny Frequent Visitor
Frequent Visitor

Re: Report server configuration manager - Credentials errorour

Hi Jon, thanks for your reply. Our SQL Server is in the cloud and we access it through VPN. So when you say about the Service account, does it refer to VPN credentials ? I tried with those credentials but it did not work. And yes I ran it as admin too but no luck.

Sunny Frequent Visitor
Frequent Visitor

Re: Report server configuration manager - Credentials errorour

I have also tried with changing Service Account to Network Service. And then used a Domain\User account to connect to the server where the SQL instance is present. I still get the same error.

Sunny Frequent Visitor
Frequent Visitor

Re: Report server configuration manager - Credentials error

I have checked with the Microsoft vendor and it seems, PBI Report Server should exist in the same box as the Database Server.

This was causing the issue.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)