>I just read the How to: Access SQL Server Using Windows Integrated Security, and I am confused about the following statement:
>
>
>If SQL Server is a remote server, select the Basic Authentication check box
and clear the Integrated Windows authentication check box.
>
>
>If I check Basic Authentication, isn't it going to ask for my username/password everything I access this?
>
>I guess I thought the difference between Integrated Windows Authentication and Basic Authentication was the fact that with Integrated it would use your credentials that you are logged onto your domain with.
Yes it's really confusing:( However read it as whole. This line is from that topic:
"In IIS, only Basic Authentication logs users on with a security token that flows across the network to a remote SQL server. "
You'd also see it's saying change anonymous to a local domain account and in SQL server authenticate that user. To say it in summary it needs basic authetication to ask permission to logon to remote SQL server.
Cetin