Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Delegation From Server 2012 IIS 8.5 to SQL 2012

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
0
Niall292
Asked:
Niall292
  • 3
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
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
0
 
Niall292Author Commented:
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
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
 
Niall292Author Commented:
We finally found the problem and it was nothing to do with my code. We have trusted domains and the Web server was in one domain but FQDN was for the other domain

Once it was changed everything worked

Ex. The webserver in GB domain should have been called  webserver.GB.lan but was called webserver.US.lan
once it was changed to proper LAN everything worked
0
 
Niall292Author Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now