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.