topic Data Source Connection String in Report Server

Data Source Connection String

UncleLewis — Tue, 26 Oct 2021 20:12:13 GMT

Hi all,

Using Power BI Report Server

Trying to create a new data source to SQL Server

I used connection string like this

Data Source = ServerName;Initial Catalog = my_db

I'm using my Windows credentials

But I still cannot connect

Is my connection string correct

The server name and Catalog(db) are stright from SSMS.

Thanks,

-w

josef78 — Thu, 28 Oct 2021 17:12:23 GMT

I think, it is correct. With SQL datasource you can also use:

ServerName;my_db

If still cannot connect, which error mesage is raised?

AbhiSSRS — Thu, 28 Oct 2021 19:23:54 GMT

Yes this looks correct

eg Data Source=ABCD;Initial Catalog=contoso

you may use build connection and Test Connection to check :