Just then, i have encountered a puzzling error about a newly created login user that I have just created in database. For some odd reason, i keep getting login error even though i have checked that both username and password is correct.
It turned out that the SQL Server is not setup properly. The security setup in SQL server was set to "windows authentication" only where it is supposed to be both "SQL and Windows authentication".
to enable this, right click the SQL Server, click properties, under security tab you will see the radio button. Select "SQL Server and Windows Authentication mode"
Remember to restart the SQL Server as the changes will not take effect before a reboot. To reboot, right click SQL Server -> Restart
You Sir, have just saved my day!
ReplyDeleteRegards