Security and Authentication Mode

From: Bob (bob.atkinson@tdh.state.tx.us)
Date: 10/29/02 

From: "Bob" <bob.atkinson@tdh.state.tx.us>
Date: Tue, 29 Oct 2002 09:04:24 -0800

>From Enterprise Manager, highlight the server name, right
click, choose properties, choose security, select "SQL
Server and Windows".

You may need to restart SQL Server for the change to take
effect.

>-----Original Message-----
>Hello,
>I set-up SQL Server on a new machine. The Authentication
>mode at the Security tab of the SQL Server Properties is
>set to "windows only".
>Is there a way to change it to "SQL Server and Windows"
>using a script (transact SQL)?
>If I leave it as it is I get an error, when trying to
>connect: "Login failed. Reason: Not associated with a
>trusted SQL Server connection".
>Thanks
>.
>

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Cannot open database requested in login
    ... Assuming your goal is to use windows integrated ... security then leave out the username ... ASP.NET service) as a login to SQL Server and with access to the ... >> you should see security tab, change authentication to "SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... but does that mean ASP uses the IUSR account to access the SQL ... > There are two sets of authentications: Windows, and SQL Server. ... If using integrated security, ...
    (microsoft.public.inetserver.asp.db)
  • ASP.NET "Custom" Security
    ... SQL Server, DB2, MySQL, Oracle, ... Windows server at the other end. ... to be authenticated by the stored procedure against the ... Is this a reasonable security model? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... the Space Shuttle has some very strong windows -- get my point. ... doubt THE single most significant security flaw -- this is the green light ... spoofing was known about when the protocol was introduced and Microsoft did ... > need to use some other mechanism to connect to SQL Server. ...
    (microsoft.public.sqlserver.security)