Problem connecting FP2000 ASP to SQL 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: 06/30/04 

Date: Wed, 30 Jun 2004 13:30:45 -0400

Hello,

I posted this to the FrontPage Programming list last week but was unable to
resolve the problem.

I am reconstructing a web site for a remote customer and have a login
problem with an FrontPage 2000 database results page.

Database Results Error
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'messenger'.

FP verifies the database connection when I look at the Web Settings for this
page. The global.asa file is passing the correct username and password to
SQL Server, which is configured for Mixed Authentication. The
"messenger" login is a SQL Server login. I can connect to the database
server directly, using Enterprise Manager, with the same username and
password that fails over ASP.

What else should I be looking for?

Relevant Pages

  • 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: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)