Share via

How to create a Database for Power BI Report Server

Jorziño Barradas 20 Reputation points
2024-11-15T16:17:04.8766667+00:00

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,069 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,944 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,066 Reputation points
    2024-11-18T01:50:17.4733333+00:00

    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.

    0 comments
  2. Olaf Helper 45,206 Reputation points
    2024-11-18T06:57:35.2866667+00:00

    "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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.