Re: Does changing to "Windows auth only" affects all the db on the server, right ?
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/14/04
- Previous message: Marlon Brown: "Does changing to "Windows auth only" affects all the db on the server, right ?"
- In reply to: Marlon Brown: "Does changing to "Windows auth only" affects all the db on the server, right ?"
- Next in thread: Marlon Brown: "Re: Does changing to "Windows auth only" affects all the db on the server, right ?"
- Reply: Marlon Brown: "Re: Does changing to "Windows auth only" affects all the db on the server, right ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 14 Dec 2004 00:52:21 +0100
Hi
Windows Authentication is an Instance wide change.
If you have existing DB's with applications that do not support it,
installing another instance of SQL Server, specifically for MOM will do the
trick.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marlon Brown" <marlon_brown@hotmail.com> wrote in message
news:eGZhWgW4EHA.2288@TK2MSFTNGP11.phx.gbl...
> FOlks, in order to accomodate MOM database, I need to change SQL
> authentiation from "SQL and Windows auth" to "Windows authentication
only".
>
> If I understand correctly, that's a global setting on SQL server right ?
By
> doing that to accomodate MOM and I will be changing the way processes and
> people authenticate to all other databases as well ?
> SQL 2000 SP3a
>
>
- Previous message: Marlon Brown: "Does changing to "Windows auth only" affects all the db on the server, right ?"
- In reply to: Marlon Brown: "Does changing to "Windows auth only" affects all the db on the server, right ?"
- Next in thread: Marlon Brown: "Re: Does changing to "Windows auth only" affects all the db on the server, right ?"
- Reply: Marlon Brown: "Re: Does changing to "Windows auth only" affects all the db on the server, right ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
