Re: Login failed for user: domain\servername$

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

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$
    ... computer (then SQL Server box), because your ASPNET app runs under the Network Service account of the IIS server. ... "Lance Wynn" wrote in message ...
    (microsoft.public.dotnet.general)
  • Re: Network Service Account
    ... Service account for the SQL Server or the SQL Server Agent services. ... User or Domain User accounts are more appropriate for these SQL Server ... if SQL Server is running under the Network Service account ...
    (microsoft.public.sqlserver.security)
  • RE: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 0x80070534 when changing service account
    ... The only solution that I have been able to find for this error is to RDP into the SQL Server using the new Service account you want the SQL server to run under. ... prefix, an error 0x80070056 "The specified network password is not correct." ...
    (microsoft.public.sqlserver.security)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)