Re: More on that login problem - found the logs -

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ben:

I see that I'm using both SQL Server and Windows authentication; I see too
that under
"Startup service account" (also in the security tab) startup runs the
System Account. WHen I choose "This account" it defaults to "LocalSystem"
and a password I don't now - I'm scared to try this -
Under "registered SQL server properties" "Use windows NT authentication"
is checked. WHen I try to use SQL authenticaton nothing works - no matter
what
combo of login name and password I try ....
Should I try to make a new SQL server registration ?

All this is clear as mud - if anyone from MS reads this; boys, why do you
have
to make it so hard, so confusing , so badly documented ? It's hard enough
using it
productivly when you can get it in in the first place ...






"Ben Nevarez" <bnevarez@xxxxxxx> wrote in message
news:#cQs$CX7FHA.3684@xxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> Verify that you are using both SQL Server and Windows authentication using
> server Properties and look in the Security tab (I believe that you are
> really using both SQL Server and Windows authentication since log messages
> for Windows only authentication would show "Login failed for user 'sa'.
> Reason: Not associated with a trusted SQL Server connection").
>
> Which account are you using to connect to the database? Has the password
for
> this account been changed?
>
> Ben Nevarez
>
>
> "Barrett Bonden" <arthur@xxxxxxxxxxxxxxx> wrote in message
> news:sIJff.13085$ha2.13022@xxxxxxxxxxx
> > 2005-11-18 12:50:12.09 logon Login failed for user 'sa'.
> > 2005-11-18 12:50:36.85 logon Login succeeded for user 'NT
> > AUTHORITY\SYSTEM'. Connection: Trusted.
> >
> > and some more that might be useful -
> >
> > 2005-11-18 12:50:40.92 logon Login succeeded for user 'NT
> > AUTHORITY\SYSTEM'. Connection: Trusted.
> > 2005-11-18 12:51:01.35 logon Login succeeded for user 'NT
> > AUTHORITY\SYSTEM'. Connection: Trusted.
> > 2005-11-18 12:51:53.71 logon Login failed for user 'sa'.
> > 2005-11-18 12:57:55.45 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 12:58:01.80 logon Login failed for user 'sa'.
> > 2005-11-18 12:58:07.73 logon Login failed for user 'a'.
> > 2005-11-18 12:58:16.75 logon Login failed for user 'a'.
> > 2005-11-18 12:58:23.83 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 12:58:37.46 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 12:58:37.46 spid9 Starting up database 'test'.
> > 2005-11-18 12:58:37.46 spid9 Opening file C:\MSSQL7\DATA\test.mdf.
> > 2005-11-18 12:58:37.49 spid9 Opening file C:\MSSQL7\DATA\test.ldf.
> > 2005-11-18 12:58:39.34 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 12:58:42.93 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 12:59:00.99 logon Login succeeded for user 'ART\art'.
> > Connection: Trusted.
> > 2005-11-18 13:55:32.21 logon Login succeeded for user 'ART\w tilman'.
> > Connection: Trusted.
> > 2005-11-18 13:55:34.14 logon Login succeeded for user 'ART\w tilman'.
> > Connection: Trusted.
> > 2005-11-18 13:55:35.05 spid10 Using 'xpsql70.dll' version '1998.11.13'
> > to
> > execute extended stored procedure 'xp_msver'.
> >
> >
> > Can connect with Windows NT authentication, but not with SQL server
auth.
> > So
> > all my
> > code has stopped working ...
> > When I try to make a new SQL Server registration
> > I get server does not exist or access denied...
> >
> >
> >
>
>


.

Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Security context issue (weird behavior)
    ... The SQL Server is setup to use mix mode authentication. ... The users have a domain account. ... To log in to the SQL server I use an ADO connection. ... I tried to view the pages from another machine with the anonymous access ...
    (microsoft.public.data.ado)
  • Re: SQL Connection String using Domain Account
    ... Web.Config but now have the problem that the web site will not run under ... you can have a username/password set up in sql server - but this would ... The DBA has given me a Domain user account with rights to ... I am unable to get a connection to the database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How can IIS access the database without having ASPNET account in the database
    ... As you can see I use the Integrated Security. ... This means it is checking if you have rights to SQL Server, ... account Tony when accessing the database from Visual Studio and when IIS is ... You altered the connection string to have a user name and password. ...
    (microsoft.public.dotnet.framework.aspnet)