sa is prompted in adp

[Sonic76]

I created a .adp database with a sql 2000 backend.
Whenever a user connects to the db, he is prompted with the sa username and a blank password. How do you disable that annoying and dangerous sa username? (disable the pop up not the user)

 

[jrbarnett]

Open the File menu and choose Connection, then change the connection details to an account with far more restrictive permissions. Click OK to save the information then reopen it.

By setting SQL Server to use only domain authenticated logins, you remove the ability to use the sa SQL account, but it does lock out all the other SQL authenticated accounts on that server as well, and it is advisable to have a strong password set on it nonetheless.

John