Forum Discussion

m-colbert's avatar
m-colbert
Resolver III
3 years ago

Gateway Folder Data Source using FQDN to a Different Domain - Invalid Credentials

I have a situation where a new gateway was setup on a different domain than where the shared folder resides. Networking is appropriately configured since from the gateway I can access a shared folder on Daimn A from the gateway on Domain B. I can open Windows Explorer, enter the folder as \\server.domaina.com\sharename, I get prompted from credentials and enter domaina\user and the password. Everything connects and I see the contents of the fodler. 

 

However, when I try to setup a data source on this gateway and use the same settings; Data source type = Folder, Full path is the same as what is entered into Windows Explorer \\server.domaina.com\sharename, using Windows authenication with user name as domaina\user and the users password. I re-rtyped and copied and pasted the values to be sure I dont have a typo. When I click Create, I get the error message:

 

Unable to create data source. Invalid connection credentials.
Details: xxxxx: The credentials provided for the Folder source are invalid. (Source at \\xxxx.xxxx.com\shared\pass.) xxx Gateway: Gateway on endpoint 'sb://wabi-us-north-central-e-primary-relay37.servicebus.windows.net/6d7c53e7-xxxx-xxxx-xxxxx-781366338d5f/' is unreachable.
 
Is there something missing or there a known issue when crossing domains?
Thanks

1 Reply

  • I found three 3 possible solutions:

    1. Create a trusted relationship between the two domain controllers.
    2. If the first option it's not possible, make sure the same user and password are created in both domain controllers. eg. domainA\user-smb and domainB\user-smb. When you create the connector ask the same domain controller where de PowebiConnector is installed.

      3. The other option is to create the user and password in the server that you install de powerbigateway like a local account, then when you make de connector use .\user_smb

    I understand the Authentication method: "Windows" start a Windows session with the "Windows Username" in the powerbigateway installed. if the user has access the connexion is successful but if not the services use the credential vault.

     

    In my case, I installed the PBGT in a WS 2022 Standart and matriculate in a domain, I solved the same use with the second method, but for a standalone storage a solved with the 3rd method. 

    1