Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post 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.

7 Replies

  • 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
      Post 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