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

From: Bill (webobjectfan@yahoo.com)
Date: 08/31/02 

From: "Bill" <webobjectfan@yahoo.com>
Date: Fri, 30 Aug 2002 18:55:27 -0700

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: Microsoft Web Data Administrator
    ... > login USING WINDOWS NT Integrated Security.... ... if you can not connect using SQL Server authentication at all, ...
    (microsoft.public.sqlserver.msde)
  • Re: 2000k connect from outside domain
    ... You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... Changing a Windows password is always completely invisible to SQL Server. ... The Windows login is completely separate from a SQL Server login, ... If you are using SQL Server Authentication, then one doesn't even have to ...
    (microsoft.public.sqlserver.security)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Permissions on a database
    ... It maps them into the database as a dbo rather than as their UserName who is ... > I didn't want to give them access to the Windows server at all. ... > why I was having them do Sql Server Authentication. ...
    (microsoft.public.sqlserver.server)