Question about Windows login vs. SQL login

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J. Cairn - 27 Oct 2006 00:52 GMT

I understand the basic difference (I think), but there's something that
doesn't make sense. Our SQL Servers are set to mixed mode
authentication. All of the third-party apps have their own logins,
which were created during install, by the vendor or per the vendor's
instructions. Those are SQL logins.

Based on that, we can't switch to Windows-only authentication. If we
did that, the third-party apps would not work because they all use SQL
logins. Is that correct or am I missing something?

Thanks in advance.

Reply to this Message

Sue Hoegemeier - 27 Oct 2006 01:38 GMT

That's correct. If the vendor unfortunately does not give
you the option to select the logins and authentication type
and has their app set to use just their SQL Logins, then you
have to use mixed mode to support the SQL Logins required by
the app. You are not missing anything. The vendors might be
but not you.

-Sue

>I understand the basic difference (I think), but there's something that
>doesn't make sense. Our SQL Servers are set to mixed mode
[quoted text clipped - 7 lines]
>
>Thanks in advance.

Reply to this Message