I have freshly installed ISS with SQL server and asp.net mvc application. I want my app to use windows authentication. On my application side, i know that i have good connection string, because i was running it on my local machine and it was working fine.
On my new remote server, it does not want to work - so i changed connection string to use credentials - sa, and it worked. So i obviously am lacking some configuration there for windows auth.
As far I did is I added network service to my sql server logins, and granted it admin privileges. Also, my application pool is running as network service. It still doesn't work, what did i miss?
Edit for clarification: WinAuth is enabled in my sql server.