SQL Server DBA Interview Questions | How to change Server Authentication modes in SQL Server

preview_player
Показать описание
SQL Server DBA Interview Question and Answer
"
If you have installed SQL Server Instance with Windows Authentication Mode and later you want to change to Mix Mode (SQL Server and Windows Authentication Mode), How would you do that and does it require service restart?"

Complete list of SQL Server DBA Interview Questions by Tech Brothers
Рекомендации по теме
Комментарии
Автор

MY machine is showing ""Some of your configuration changes will not take effect until sql server restart"" so do we have to restart???? Thank you

tushibhaque