<div>
when you say post to sql server do you want iis to add/update/query sql server?<br />
<br />
Could you show the relevant part of your code that is failing
</div>


when you say post to sql server do you want iis to add/update/query sql server?

Could you show the relevant part of your code that is failing

<div>
No matter what I try &nbsp;query or insert. If i log on to the web server and run the website from there it works perfectly. That's why I suspect a delegation issue
</div>


No matter what I try  query or insert. If i log on to the web server and run the website from there it works perfectly. That's why I suspect a delegation issue

<div>
There's no 'NT AUTHORITY\ANONYMOUS LOGON' user in SQL Server 2012.<br />
You need to give access in SQL Server 2012 for the correct user.
</div>


There's no 'NT AUTHORITY\ANONYMOUS LOGON' user in SQL Server 2012.
You need to give access in SQL Server 2012 for the correct user.

<div>
This took a lot of searching and was something I would never have thought of, only I could not find any problems and had to ask for a network guys help
</div>


This took a lot of searching and was something I would never have thought of, only I could not find any problems and had to ask for a network guys help

<div>
<div class="content wysiwyg-content">
I have set up delegation loads of times with wins 2003 but now we are moving to 2012 servers using IIS 8.5 but I cannot get delegation to work. Is there something different. <br />
I have set up to use windows authentication, turned off anonymous, Set impersonate to true<br />
Set up the SPNs but still when I do a post to the SQL server I get a SQL error<br />
<br />
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'<br />
<br />
Is there something new I have to do or am I missing something<br />
<br />
Thanks in advance
</div>
</div>


I have set up delegation loads of times with wins 2003 but now we are moving to 2012 servers using IIS 8.5 but I cannot get delegation to work. Is there something different. 
I have set up to use windows authentication, turned off anonymous, Set impersonate to true
Set up the SPNs but still when I do a post to the SQL server I get a SQL error

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Is there something new I have to do or am I missing something

Thanks in advance

Delegation From Server 2012 IIS 8.5 to SQL  2012

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.

Microsoft SQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.