>If you want to be prompted for login, remove User Id and Password from the connection string. The SQL Server has to be configure for Mixed mode authentication.
>
>Connection1=Data Source=MyServer;Initial Catalog=MyDatabase;
>
I had to disable the Windows Authentication.