Re: Login Failed Error: Frontpage 2000 to SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kristen Wagner (kwagner_at_twcny.rr.com)
Date: 07/08/04 

Date: Wed, 7 Jul 2004 22:22:15 -0400

Let me add one more piece of information:

The web server and SQL server for the data results page are running on the
same box. I can save the data results page to my own computer, with the same
web settings, and the page will load correctly on my web server, connecting
successfully to the database server. When I view the SQL Server log, my
successful attempt says "Login succeeded for user "messenger." Connection:
non-trusted.

No doubt I am overlooking something obvious here. What is it?

Thanks,
Kristen

"Kristen Wagner" <kwagner@twcny.rr.com> wrote in message
news:OHljw6IZEHA.4092@TK2MSFTNGP11.phx.gbl...
> Hello,
>
> I posted this last week but was unable to resolve the problem.
>
> I am reconstructing a web site for a remote customer and have a login
> failure with an FP2000 database results page. This page contains a
database
> results section generated by Frontpage. The connection is also generated
by
> FP via the Web Settings option--there is no other connection string.
>
> When I look at the Web Settings for this page, FP verifies the database
> connection. In other words, when I test the connection from the FrontPage
> file, the connection is verified. The data results section of the page
> connects as well when I browse through those settings, and the connection
> test works. The global.asa file is passing the correct username and
password
> to SQL Server, which is configured for Mixed Authentication. The login is
a
> SQL Server login. I can also connect directly to the SQL database in
> question, using Enterprise Manager, with the same username and password
that
> fails over ASP.
>
> Database Results Error
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'messenger'.
>
> The SQL Server log for these connections says "Login failed for user
> "messenger".
>
> What am I overlooking?
>
> Thanks again,
> Kristen Wagner
>
>

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)