I created an application role on the database.

Using the Data Link Properties dialog I chose the provider.  Then on the Connection tab, I had to type in the Server name because it did not appear in the combo box or drop down menu.  I don't know if that was the first problem or not.

I put in the application role name and password under "Use a specific user name and password:"

I checked Allow saving password.

When i got down to number 3, "Select the database on th server," I clicked the combo box and got an error: "Login failed for user 'FAELOGIN'. Reason: Not associated with a trusted SQL Server connection."

Then another message box displays: "Login failed.  Catalog information cannot be retrieved."

I don't know why i'm alway running into these stupid issues!