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

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

Date: Wed, 7 Jul 2004 21:57:19 -0400

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)