Re: Security and Authentication Mode
From: BP Margolin (bpmargo@attglobal.net)
Date: 10/27/02
- Next message: [MS] Hai-Wei Xu: "RE: Is there possibility to get client IP address within SQL Server?"
- Previous message: Gidi Ehrenhalt: "Security and Authentication Mode"
- In reply to: Gidi Ehrenhalt: "Security and Authentication Mode"
- Next in thread: Bob: "Security and Authentication Mode"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Sun, 27 Oct 2002 12:57:19 -0500
Gidi,
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
The authentication mode of SQL Server is stored in the registry, and a
restart of SQL Server is necessary for the change in authentication mode to
be effective. Thus there really is, IMHO, no good reason for a T-SQL script
to be doing this, although you can certainly use the undocumented extended
stored procedures xp_regread and xp_regwrite to read and write registry
information.
Why not just use Enterprise Manager to change the authentication mode?
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Gidi Ehrenhalt" <gidi_e@givenimaging.com> wrote in message
news:2e7101c27dc5$11c6b660$35ef2ecf@TKMSFTNGXA11...
> 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
- Next message: [MS] Hai-Wei Xu: "RE: Is there possibility to get client IP address within SQL Server?"
- Previous message: Gidi Ehrenhalt: "Security and Authentication Mode"
- In reply to: Gidi Ehrenhalt: "Security and Authentication Mode"
- Next in thread: Bob: "Security and Authentication Mode"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
