Several years ago, I had developed a VB.NET application that attaches to SQL Server with Windows Authentication that we use at our company. Recently, I was asked to add a user who is in a non-trusted domain. I have changed the SQL Server authentication to mixed mode and added the person in Security->Logins and Database->Security->Users. But honestly, I have no idea what to do next. I am by no means a professional programmer, but I do have a decent understanding of VB and SQL.
I really don't want to add a uid and password in an additional connection string in the app.config.
What I would like to do is have the application check for authentication on load. If the user has Windows authentication, proceed normally. If the user has SQL authentication, go to a login screen.
But I will be happy to entertain other suggestions.
Any help would be appreciated. Any code snippets would be helpful too.