Get Data from SQL server : Username ???

[admin_xlsior]

Hi,

When Get Data from SQL Server, where we can input the username and password ?

After OK button, obviously there is an error

[Anonymous]

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]

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

[Anonymous]

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

After that try to connect.

Thanks,

Bhavankit

[admin_xlsior]

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]

Yes, I am talking about that cache.

Is it work for you?

Thanks,

Bhavankit

[admin_xlsior]

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

[v-yuta-msft · Accepted solution]

@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.