>Yes, but I would to avoid someone using a connection string such as the one I just described. Because, right now, the security is wide opened.
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;
--sb--