Login failed for user 'BRUMAPP01\ASPNET' while using win auth

From: Tim VdBergh (tim_at_linkline.be)
Date: 04/28/03 

Date: Mon, 28 Apr 2003 09:52:33 -0700

Helloooo

I'm having a biiig problem setting up authentication on my SQL server
through an ASP page programmed in C#

- My IIS server is set to:
       -deny anonymous logon
       -only allow "integrated windows authentication"

When I log on my page, I get a logon box, after successfully logging on,
I can see my user name printed correctly with this line in HTML:
<%=User.Identity.Name%>

But when I try to connect to my SQL server... I keep on getting the
bloody:

Login failed for user 'MYSERVER\ASPNET'

Arghh Can somebody help me ?

Thanx;
Tim

PS: my connect string is like this:

workstation id=MYWORKSTATION;packet size=4096;integrated
security=SSPI;data source=MYSERVER;persist security info=False;initial
catalog=MYCAT

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Adp to asp web page
    ... of drunk retards that dont understand web development ... when I went into the connection box, it listed my server but in the drop ... Access ADP is merely front end app and IDE for SQL Server, ... ASP is old technology and different from ASP.NET. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: What is the difference between php & asp?
    ... >ASP is a Microsoft product based on the very ackward Visual Basic syntax ... >PHP is a C-Like, ... >need to physically register on the server. ... It works fine with SQL Server and Access if you really really ...
    (alt.php)
  • Cluster questions
    ... I need to install a portal infrastructure that was developed with ASP ... and SQL Server. ... Virtual Server), like NLB. ... The developement of the ASP application is different that the ...
    (microsoft.public.sqlserver.clustering)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: How to Set Datetime on SQL 2000 server
    ... the site on the new server still links to the same SQL ... The asp pages on this new server works fine with all date data. ... least pass language neutral datetime formats to SQL Server ... the desired format. ...
    (microsoft.public.sqlserver.setup)