Forum Discussion

neil_lindberg's avatar
neil_lindberg
Ideator I
6 years ago

Login failed for user 'innovator' - MSSQL

I actually found a locked thread that answers this after 20 or so comments. No answer is marked as accepted. There are other very similar threads. None have a screenshot to tell the story of what to do. It ends up I had to enable mixed mode auth for the db. One comment from 9 years ago eluded to this, but with no "How-to", so:

Right-click on DB name at root of tree and select "Properties". Enable Mixed-Mode as shown:

After this is done right-click on DB name again and select, "Restart".

Viola! Well, for me anyway. I really really really think the installer should have told me to do this.

Database Management
Installation
Login

2 Replies

  • tonyadams's avatar
    tonyadams
    Ideator I
    3 years ago

    You're right, the installer should have prompted you to enable mixed-mode authentication during the installation process if it's required for your application. io games

  • tonyadams's avatar
    tonyadams
    Ideator I
    3 years ago

    You're right, the installer should have prompted you to enable mixed-mode authentication during the installation process if it's required for your application. In any case, thank you for sharing your solution with others who may encounter a similar problem in the future. io games