Forum Discussion
Personal Gateway fails to synchronize SQL server with Windows authentication
Is there any way I can force Personal Gateway to connect to datasources with username, and not e-mail address?
Our company policy is to have two usernames with desktops and different one for servers. And the Gateway seems to select wrong one randomly.
Some hidden config somewhere?
Hi kakkaroolari ,
>>Item 3. Why would Microsoft SQL Server Management Studio would need to be installed in a Windows Server where the personal gateway is running?
If you need to connect to SQL Server in SSMS, you may need to do so.
>>Is there any way I can force Personal Gateway to connect to datasources with username, and not e-mail address?
You can sign in personal gateway with the account which you would like to use in Power BI Service.
For reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
>>If you need to connect to SQL Server in SSMS, you may need to do so.
For sure, but I like to do that from my physical workstation, not from the server via remote desktop.
>>You can sign in personal gateway with the account which you would like to use in Power BI Service.
I can but the gateway does not use the account I select to access data.
In other words, am I incorrect at assuming that: Power BI account MUST be the same as the Windows user that is logged in to machine.
This has changed worse since Fall/November versions, before I could do something with it. Even the File, Folder shares are no longer working. Before it was just SQL (more precise, Analysis services) source.
Is this intended behavior? I'm asking if I have any chance in continuing with our workflow, or do we need to start refactoring our setup?