mixed authentication mode

Question

does mixed mode mean that user has to enter two passwords - one at the level of windows and another to login to sqlserver - for the same user?

Answer 1

hi,

Authentications @ SQL Server: This is security setting at SQL Server which determines the security context of SQL Server. Mixed Mode allows both SQL and Windows Logins, where as Windows Authentication mode only allows windows Logins. You can choose authentication while logging on to SQL Server like so

Coming to you Question, I have to say NO - If you are logging in using Windows Authentication, user need not have to enter any credentials. Windows credentials are used here to connect to SQL Server provided that the user has been set up with access @SQL Logins.

Only when using SQL Server authentication you need to use Login Name and Password to connect to SQL Server.

Hope this helps

Many Thanks

Bhanu  

Answer 2

No. It means that user can either use windows authentication or SQL authentication.

---

--sIbu

Answer 3

No, it plays dual role you can use Windows or Sql server authenticating For Windows you don’t need to enter password

 

Answer 4

Mixed mode means SQLServer authentication can also be used in addition to Windows authentication. Windows Authentication requires you to have a system account/domain account to connect to server instance. But sometime there requires need of giving ad-hoc restricted access to some users. In such cases you can create a sql server login and assign it restricted permissions and pass it on to concerned people.

One more thing is in SQLserver authentication you always need to provide a password whereas in Windows authentication you dont need to specify password as its based on integrated security.

---

Please Mark This As Answer if it solved your issue
Please Mark This As Helpful if it helps to solve your issue
Visakh
----------------------------
My MSDN Page
My Personal Blog
My Facebook Page

Answer 5

does mixed mode mean that user has to enter two passwords - one at the level of windows and another to login to sqlserver - for the same user?

Simple answer NO. If user is connecting with SQL Server logiin he has to enter just SQL login and password.

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP