|
Home > Archive > MS SQL Server security > September 2005 > Enterprise Manager Showing Wrong Authentication Mechanism
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Enterprise Manager Showing Wrong Authentication Mechanism
|
|
|
| This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?
| |
| Sue Hoegemeier 2005-09-14, 3:23 am |
| How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@discussions.microsoft.com> wrote:
>This is strange,
>
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>
>Anyone know of this bug? And how to fix?
| |
|
| Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:
> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
>
> -Sue
>
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@discussions.microsoft.com> wrote:
>
>
>
| |
| learner. 2005-09-17, 3:23 am |
|
--
_-=?/today_-=?/354
"Chuck" wrote:
> This is strange,
>
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only being
> Windows Authentication...
>
> Anyone know of this bug? And how to fix?
| |
| learner. 2005-09-17, 3:23 am |
|
--
_-=?/today_-=?/354
"Chuck" wrote:
[color=darkred]
> Yes, I am currently logging in as an SQL login account. This client of mine
> does not use Windows authentication...
>
> "Sue Hoegemeier" wrote:
>
|
|
|
|
|