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.
Yes this looks correct
eg Data Source=ABCD;Initial Catalog=contoso
you may use build connection and Test Connection to check :
I think, it is correct. With SQL datasource you can also use:
If still cannot connect, which error mesage is raised?
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!