Re: I couldn't change authentication to mixed mode. Why?

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sat, 31 Aug 2002 14:45:15 -0400

Bill,

Taking a wild guess ... in order for SQL Server to change the authentication
method, SQL Server must be restarted. You don't mention whether you
restarted SQL Server after changing the authentication method.

-------------------------------------------
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.

"Bill" <webobjectfan@yahoo.com> wrote in message
news:1094a01c25091$7a57ce50$39ef2ecf@TKMSFTNGXA08...
> I am trying to connect to SQL Server 2000 through a Web
> Application using JDBC. I was told that JDBC can only
> connect to SQL Server by SQL Server authentication method,
> and not Windows-integrated authentication method.
> Therefore, I need to change the SQL Server authentication
> to Mixed mode: Windows and SQL Server Authentication.
> However, every time after I changed the option in the
> Server/Properties/Security, SQL Server kept rolling back
> to the Windows-only option. I then tried to change the
> option from Edit SQL Server Registration Properties. But
> after I supplied the user id and password, I got the error
> message: "Login Failed for user Bill. Not Associated
> with a Trusted Connection."
>
> Has anyone seen this problem ? What's wrong with it? and
> How I am supposed to fix it. Please help !
>
> Thank you very much.
> Bill
>
> PS: by the way, I was able to use ASP.NET to connect SQL
> Server successfully. But I was using Window-integrated
> authentication method.

Relevant Pages

  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)