What is configuration manager? _Why Windows authentication more secure?

Question

What is configuration manager?

Why Windows authentication more secure?

Please provide your answer in simple way, so that i can understand

---

Thanks And Regards, T.Anil Kumar.

Answer 1

What is configuration manager?

Please provide your answer tome in simple way , so that i can undertand

---

Thanks And Regards, T.Anil Kumar.

Answer 2

configuration manager is a GUI interface where you can make SQL Server Settings, tcp/ip setting,

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 3

The "SQL Server Configuration Manager" (I guess you mean that one) is a tool to configure SQL Server settings for the services (e.g. start mode, service account) and the network connection (e.g. to enable several protocols, tcp port and so on)

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

Would you please check-out below link

SQL Server Configuration Manager

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 5

The big advantage of standardising on Windows Authentication for SQL Server Logon is : auditing and Single Sign On.

---

Jack Vamvas sqlserver-dba.com

Answer 6

For reasons to select Windows vs. Mixed mode, see Choose an Authentication Mode http://msdn.microsoft.com/en-us/library/ms144284.aspx

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty