Re: Changing passwords / Blocking SA login attempts

From: Fox Bortniker (fox@connexions.net)
Date: 02/13/03 

From:     Fox Bortniker <fox@connexions.net>
Date: Wed, 12 Feb 2003 17:41:59 -0800

Great, that brought me to it. Just one question. I have a pre-existing
set of templates running in a database that are in PHP. They are
numerous and complex. They use my name for login via SQL. If I change
the authentication to Windows where you said to do so, is that for all
authentication or is that just for the SA account ? I am afraid that if
I change that, the other template will not allow me to log in as the
admin for the application. Is this going to happen ? Will I need to find
out how to change the log in that is built into that set of templates so
I can change it as well ?

Thanks,
Fox

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Can no longer connect as sa
    ... Is there a reason you need to connect using SQL authentication? ... > Login failed for user 'sa'. ... > I can't figure out what is slightly different in the connection string. ...
    (microsoft.public.sqlserver.setup)
  • Re: [PHP] Is this the best way?
    ... I am attempting to add a little error checking for a very simple login system. ... So maybe I should edit my authentication function... ... I recommend lower or upper case only for sql entity names ... really be either attempting an authentication *or* outputting some message ...
    (php.general)
  • Re: Can no longer connect as sa
    ... > Is there a reason you need to connect using SQL authentication? ... >> Login failed for user 'sa'. ... >> I can't figure out what is slightly different in the connection string. ...
    (microsoft.public.sqlserver.setup)
  • Re: I cant login to Sql no matter what i try! im ignorant and i need help :)
    ... sql) Mixed authentication. ... Go into the server properties in the Enterprise ... >>requested in login 'T254DN_Staging'. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ODBC login problem
    ... "Login failed for user 'XXXXX'. ... SQL Server connection". ... make sure the target SQL 2005 server is configured to allow both Windows and SQL authentication. ...
    (microsoft.public.sqlserver.security)