I'm writing a vb.net application which connects to a db using integrated security. However, I wanted to implement a login screen so that the user enters their NT user name and password for initially connecting. This is because our information governance team wants to verify that someone else is not using a machine without authorization. By attempting to connect initially using the user name and password, I can "verify" they are who they say they are and then continue to use integrated password.
Also, I want to create database roles and assign NT user names to those roles. How can I assign a nt login to a database role?
I'd suggest that your "information governance team" need to offer a solution, instead of spouting rubbish like this.
Does your company have a framework (Single Sign On, for example) that would be the correct way of launching apps.