When you specify the user name in the DSN Creation dialog box and click Authenticate, the Designer verifies whether the user profile exists.
If the user profile exists, the Designer uses the existing profile to extract metadata. A dialog box appears that prompts you to enter password for the user name. Verify that the user name is the same as specified in the DSN Creation dialog box. Enter password and click OK.
If the user profile does not exist, the Server Name option is enabled. Enter server name and authenticate the user profile.