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.