Site Home  »   SQLDBManager Plus Troubleshooting »  SQL Server Monitoring »  SQL Server Fails - Username or Password is Wrong

SQL Server Fails - Username or Password is Wrong

Tags:  

4. Adding a SQL Server fails with error message "The given Username or Password is wrong. Please configure with correct values"

Reason  : The SQL Server Authentication mode is not enabled in SQL Server
Solution : To enable SQL Server Authentication mode in SQL Server Management Studio Object Explorer, open Server Properties > Security > select SQL Server and Windows Authentication mode ( Mixed mode ) there. After you have changed the configurations, restart the SQL Server for the settings to take effect.
Note : Mixed mode is not required if you add the SQL Server using Windows Authentication in SQLDBManager Plus


Post a comment

Your Name or E-mail ID (mandatory)


Note: Your comment will be published after approval of the owner.




 RSS of this page