Forum Discussion
PBIRS config error at setup database
Hi qplc
This error typically occurs during Power BI Report Server (PBIRS) configuration when the Report Server database creation step tries to connect using a SQL profile / credential that SQL Server does not recognize. Although the message “profile name is invalid” looks unusual, it generally points to a problem with the SQL connection settings — such as using a SQL alias that isn’t configured correctly, a wrong SQL authentication mode, or missing permissions. When you configure PBIRS, the wizard attempts to run database creation scripts under the credentials you supplied, and if SQL Server cannot validate the login profile or resolve the connection, the script execution fails.
To fix this, first verify that you can connect manually to the SQL instance using the same credentials and server name (or alias) you entered in the PBIRS configuration tool. Make sure SQL Server Browser service is running and the SQL instance is reachable over the network if you’re pointing to a remote server. If you're using a SQL alias, confirm it exists in SQL Server Configuration Manager (both 32-bit and 64-bit alias entries may be required). Also confirm that the service account used by PBIRS has dbcreator / sysadmin rights during the setup phase because it needs to create the ReportServer and ReportServerTempDB databases. If SQL authentication is being used, ensure mixed-mode authentication is enabled in SQL Server. After validating connectivity and permissions, retry the configuration wizard. In most cases, correcting the SQL connection parameters or granting the proper roles resolves this issue and allows PBIRS to complete database configuration successfully.