Forum Discussion

Lane Schafer's avatar
Lane Schafer
Icon for Microsoft rankMicrosoft
Jul 24, 2017

Manage SQL creds in Excel

When creating a database connection using excel to a SQL server which has previously been connected to Excel keeps trying to use some old credentials and won't ask me for new ones. Where can I managed these credentials so that I can flush the old creds and input new ones. The old creds never worked so a connection object doesn't exist for this database but these creds seem to be cahced and upon failure to connect the only options I get are retry, cancel or edit but edit doesn't let me do anything with the way I'm authenticating.

1 Reply

  • Of course, right after posting I answer my own question. I found the solution in Query editor >> Data source settings OR From the ribbon, "Get Data >> Data source settings".

Resources