The login failed when connecting to SQL Server XXX

zzheng

Hi, Guys, I have this error when i am using 2009 web service.

1) SQL Server is installed in my local PC
2) Navision Web Server is in my local PC
3) Navision Web Service is in my local PC
4) I create a website which is calling Navision Web Service, this website is installed in another PC.
5) I am using windows authentication for this website.
So when everytime i run the website from my VS2010, the webservice is working well, everything is fine,

but after i deployed my website to the other PC, I always got error "The login failed when connecting to SQL Server XXX".

Any idea how to find out why?

zzheng

I have deployed the website to my local machine,
now eveything is in the same machine,
but i still have the same error,
](*,)

zzheng

I have checked the SQL Log, it said that "Login failed for user "IIS APPPOOL\.net2.0". Reason: Token-based server access validaion failed with an infrastructure error

So meansing that, when it access SQL, it is using "IIS APPPOOL\.net 2.0", not my windows log in.

Anyone knows that how can i change the setting, so that it will use windows authentication to log in?

zzheng

Anyone knows in the IIS application POOL, the DefaultAppPool, for the Identity to ApplicationPoolIdentity or NetworkService?

geronimo

isn't the problem in the site/app itself?

You can check here for all kinds of connections to web services:
http://blogs.msdn.com/b/freddyk/