Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am new here and new to Power BI and I'm having some errors. Hopefully someone will be able to help. I have uplaoded Power BI dashboard and created gateway on-premises. Now, I want the dashboard, which pulls out the data from sql objects, to refresh automatically. I wanted to create an sql connection but I'm having this error message:
Unable to create connection for the following reason: Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request.
The creadentials are correct. And I tried different options of authentication, nothing seems to be working.
I appreciate any help!
Regards
Renata
Solved! Go to Solution.
Hi johnbasha33,
Just wanted to add that this has been resolved. The server needed to be added to the SQLTrustedServers in the config file.
Regards
Renata
Hi johnbasha33,
I had to park this task for some time but I came back to it. Thank you for your response. I've checked everything based on your suggestions and all is correct and enabled. But I stil can't connect to SQL server. This is the error message I have:
Hi johnbasha33,
Just wanted to add that this has been resolved. The server needed to be added to the SQLTrustedServers in the config file.
Regards
Renata
It sounds like your Power BI gateway is having trouble authenticating with SQL Server. Here are a few things you can check to resolve the issue:
Since you're connecting to an on-premises SQL Server, make sure SQL Server authentication is enabled:
Open SQL Server Management Studio (SSMS)
Run the following query to check the authentication mode:
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') AS AuthMode;
1, it means SQL Server is only allowing Windows Authentication.
0, both Windows Authentication and SQL Authentication are enabled.
If needed, enable SQL Server Authentication:
SELECT name FROM sys.sql_logins WHERE name = 'your_username';
CREATE LOGIN your_username WITH PASSWORD = 'your_password';
USE your_database;
CREATE USER your_username FOR LOGIN your_username;
ALTER ROLE db_datareader ADD MEMBER your_username;
ALTER ROLE db_datawriter ADD MEMBER your_username;
telnet your_sql_server 1433 from the machine where the gateway is installed to see if it's reachable.
DOMAIN\username.
Let me know what errors you see after trying these steps! 🚀
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |