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,135 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,949 questions
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 38,461 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.


  2. Olaf Helper 45,291 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.


  3. Jorziño Barradas 20 Reputation points
    2024-11-25T18:23:54.7533333+00:00

    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!

    0 comments No 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.