Forum Discussion

Icon for Post Prodigy rank

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

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.

Icon for Post Prodigy rank

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

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
Post 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
- Anonymous
  Not applicable
  7 years ago
  Yes, I am talking about that cache.
  Is it work for you?
  
  Thanks,
  Bhavankit
  - admin_xlsior
    Post Prodigy
    7 years ago
    No, it's not working.
    
    Just FYI, I'm sign in already, and the SQL Server I want to connect (which is Azure SQL DB) has a different username and password. Is it because I'm signing with different username cuzing the problem, but this supposed to be normal, right?
    
    It should give us another login for the database, but it did not.
    
    Thanks

Related content