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

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)
  • ASP + SQL 2000 + Win2k SP4
    ... SQL Server connection. ... OS is Windows 2000 and SP4 on both the IIS server and SQL server, ... enable Integrated windows authentication. ... There is a role for domain users to use giving them execute permissions ...
    (microsoft.public.sqlserver.odbc)
Loading