Re: Login failed for user: domain\servername$

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Norman,
I got it working!

Lance


"Norman Yuan" <FakeName@xxxxxxxxxxxxx> wrote in message news:ORcKiq5WJHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
That is the ServerName\Network Service account being seen from the other computer (then SQL Server box), because your ASPNET app runs under the Network Service account of the IIS server ("ServerName").

"Lance Wynn" <Lance_Wynn@xxxxxxxxxxxxxxxx> wrote in message news:%23LklYooWJHA.4384@xxxxxxxxxxxxxxxxxxxxxxx
I am trying to install an asp.net app onto a windows 2008 server, pointing at a remote sql2005 database, and I am getting the subject error.

I have anonymous access enabled in iis, with the anonymous user being a domain user (domain\someuser)

The odd thing is that the user in the error is not actually a user, but the domain\SERVERNAME$

Can someone tell me what I am missing here? I got this working in about 2 minutes on XP, and never saw any hint of a problem. Yet I've been beating my head against this for 3 hours now. I can barely see through the blood...

The connectionstring looks like this: "Data Source=SQLSERVER;Initial Catalog=DATABASENAME;Integrated Security=True

Thanks for any insight.




.

Relevant Pages

  • Re: Login failed for user: domainservername$
    ... That is the ServerName\Network Service account being seen from the other computer (then SQL Server box), because your ASPNET app runs under the Network Service account of the IIS server. ...
    (microsoft.public.dotnet.general)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... intention of putting it into production in this way. ... is already in production where the IIS server and SQL are on the same domain ... >> Hi Joe, ... which is not on the same domain as the SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: HTTP and SQLXML
    ... you want to expose your SQL Server through a Web Service interface, ... just need to install a certificate on the IIS server and configure the ... "Ralph Krausse" wrote in message ... > I just learned about SQLXML, this is my senario and what I wish to do. ...
    (microsoft.public.sqlserver.xml)
  • Re: Beginner Question XML not working on IIS6
    ... >> I have enabled asp on the IIS server. ... >> put a trace on the SQL Server and know that the page can login to the SQL ... > (also turn off friendly error messages in IE to get a more descriptive error ... > Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis)
  • Replication Server Reconciler Failed (29045-29006) Help Pleaseeee
    ... I am using SQL CE 2.0 and SQL Server 2000. ... me the same errors(i am registering SSCERP20.dll as i am using SQL CE 2.0) ... The DLL SSCERP10.dll must be registered on the IIS server. ...
    (microsoft.public.sqlserver.ce)