Forum Discussion

MichaiahGartner's avatar
MichaiahGartner
Frequent Visitor
7 years ago
Solved

Cannot retype proper credentials to access SQL Server

When you first connect to a new database, you're given the option to use certain credentials (Windows, Database, Microsoft Account). I had accidentally put in a typo, and was unable to connect as a result. Now, whenever I try to reconnect, it doesn't give me the option to try different credentials and automatically tries to connect me with the credentials that I previously used. I have tried to restart my laptop but it won't work.

  • Go  to File-> Options and Settings -> Data Source Settings , choose the data source -> Edit Permissions    and edit your credentials

  • Anonymous's avatar
    Anonymous
    7 years ago

    In the same page ( suggested above) , you can select the connection and slect "clear permissions" will clear the history and it will prompt you the login detals net time you login.

     

    Thanks

    Raj

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    Go  to File-> Options and Settings -> Data Source Settings , choose the data source -> Edit Permissions    and edit your credentials

    • Anonymous's avatar
      Anonymous
      Not applicable

      In the same page ( suggested above) , you can select the connection and slect "clear permissions" will clear the history and it will prompt you the login detals net time you login.

       

      Thanks

      Raj