Does changing to "Windows auth only" affects all the db on the server, right ?

From: Marlon Brown (marlon_brown_at_hotmail.com)
Date: 12/14/04


Date: Mon, 13 Dec 2004 15:04:22 -0800

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



Relevant Pages

  • Re: Windows service
    ... I've actually done this before (we were hitting an Oracle DB that didn't support Windows Auth), using both the COM+ method recommend by the PAG group, and using the DPAPI method others have recommended. ... Windows Auth to the SQL Database is better in every way. ... I have not seen NT Authenticated user used for a means of connecting to a SQL Server database by any application, ... Some DBA's have a special sequence of characters to kind of encrypt the psw a kind of their own blend or take on the psw. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Windows 2003 Web Server and SSPI Authentication from ASP
    ... If IIS and SQL are on different boxes, and you want the web user to be ... the IIS server in Windows Auth and use Kerberos. ... register the SPN for SQL Server as well as trust the IIS machine for ...
    (microsoft.public.sqlserver.security)
  • osql Connection
    ... I have SQL 2005 installed and running. ... package that connects to it using Windows Auth and everything works great. ... Problem is I have another 3rd party software that doesn't use Windows auth ... The user has been setup on the SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Windows service
    ... [SQL Auth vs Windows Auth] ... and granted it acccess to the database. ... When I do see SQL Auth used, it's confessed to me in hushed ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Linked server using Windows Auth across untrusted domains
    ... to a SQL 2008 in domain2 using windows auth. ... The only way to log with Windows authentication in SQL Server, ...
    (microsoft.public.sqlserver.security)

Quantcast