Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Get Data from SQL server : Username ???

Hi,   When Get Data from SQL Server, where we can input the username and password ?   After OK button, obviously there is an error          
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    admin_xlsior ,

     

    Please check if the username and password in valid, then click data Edit queries-> Data source settings then click clear permissions.

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi admin_xlsior ,

 

After providing Server and Database input, press "OK" and you will be prompted for credentials where you will need to select database on the left panel and input username and password, find the screenshots for the same.

 

Thanks,

Bhavankit

  • admin_xlsior's avatar
    admin_xlsior
    Icon for Post Prodigy rankPost Prodigy
    7 years ago

    I thought so and expected to, but after click OK there is no such window, then directly to the error message.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Then, click on File->Option and Settings->Options->Clear cache (both).

      After that try to connect.

       

      Thanks,

      Bhavankit

      • admin_xlsior's avatar
        admin_xlsior
        Icon for Post Prodigy rankPost Prodigy
        7 years ago

        I'm not sure which clear cache you are refer to, but I can only find the one in Data Load section. Is it correct ? 

         

        I'm not sure what is the connection to user profile / database, but I did.

         

        Thanks