sql server connect: 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?

- Have you tried other methods of authentication through the ASP page?
- HAve you tried connecting with the ASP page on the same machine as SQL
Server?

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Hi Vikram,

Yes, I was able to solve the problem by having the site admin open the
page on the server and reestablish the connection to the database there.

Thanks!

Kristen Wagner




*** Sent via Developersdex http://www.developersdex.com ***