I created a power bi report which takes data from an sql server database. Everything works fine when I upload it to power bi online service. But when I upload it to power bi report server, I click manage and select data sources to connect the report to the sql server datasource it dosn’t work. With windows authentification it always throws wrong credentials. With base authentification it always throws this error : Unable to connect
The report server was unable to connect to the data source with the information you entered. Make sure you have entered the connection string and credentials correctly.
Hide error details
Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server cannot be found or cannot be accessed. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Unable to open a connection to SQL Server)

I tried different logins and creating new accounts in sql server, trying to upload the dataset seperatly all to no avail