<div>
<div class="content wysiwyg-content">
I have a WCF service running in IIS 6. &nbsp;<br />
In IIS it is set to “Enable anonymous access”. &nbsp;I set the User name to “domain\useraccount” and set the password.<br />
In the web config in the &lt;system.web&gt; section I have &lt;identity impersonate=&quot;true&quot;/&gt;<br />
<br />
This is the connection string: “Server=ANTWRISE\BCW;Datab<wbr />ase=DBNAME<wbr />; Trusted_Connection=True;”<br />
<br />
When I attempt to connect to the database I get this error: <br />
Cannot open database &quot;DBNAME&quot; requested by the login. The login failed.<br />
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
</div>
</div>


I have a WCF service running in IIS 6.  
In IIS it is set to “Enable anonymous access”.  I set the User name to “domain\useraccount” and set the password.
In the web config in the <system.web> section I have <identity impersonate="true"/>

This is the connection string: “Server=ANTWRISE\BCW;Database=DBNAME; Trusted_Connection=True;”

When I attempt to connect to the database I get this error: 
Cannot open database "DBNAME" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

problem connecting to sql from wcf service running in IIS 6

Windows Communication Foundation (WCF) is a tool used to implement and deploy a service-oriented architecture (SOA) to support distributed computing where services have remote consumers. It features a runtime and a set of APIs in the .NET Framework for building connected, service-oriented applications. Services typically have a WSDL interface (Web Services Description Language) that any WCF client can use to consume the service, regardless of which platform the service is hosted on. WCF implements many advanced Web services (WS) standards such as WS-Addressing, WS-ReliableMessaging, WS-Security, RSS Syndication Services, WS-Discovery, routing and better support for REST services.

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.