How to create a Database for Power BI Report Server

Question

Hi All,

I am using SQL Server 2022 with Windows Authentication.

I have downloaded the Power BI Report Service instance on my machine.
I am trying to create a new database using the Report Server Configuration Manager.

As Service Account, I have "Virtual Service Account".
I have enabled the TCP/IP and Name Pipes in the SQL Configuration manager.

When I am creating the database, there are some details already populated for example server name and authentication type -> Current User - Integrated Security.

However, when I am testing the connection, I receive the following message:

"Could not connect to server: Login failed for user <my user>

Any help will be much appreciated!

Answer 1

Hi @Jorziño Barradas,

Is your SQL Server in 'mixed mode authentication' ? This is necessary to login with a SQL server account instead of a Windows login.

You can verify this by checking the properties of the server and then SECURITY, it should be in 'SQL Server and Windows Authentication Mode'。

Make sure the Current User has full access to login to the SQL Server. If not, you may need to add the account to SQL Server Login.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

"Could not connect to server: Login failed for user <my user>

You get the error message, because "<my user>" don't have the permissions to logon SQL Server; so grant permissions for the login.

Answer 3

Hello everyone,

I appreciate all the help and support that I have received.

My apologies for the late delay (I was out of the office for a couple of days).

Please provide me with some time to analyze and implement the solutions provided and I will get back with a response shortly.

Thanks again, much appreciated!