SQL Server Express login - Inappropriate to use sa user id with connection string in a VB.NET application??
Posted on 2006-10-25
I don't know what is appropriate or inappropriate when it comes to using a connection string inside VB.NET when multiple users connect to SQL Server.
I have an application that I have working properly with multiple users, however they are connecting using a user id I manually created. I have several issues because of my inexperience with using SQL Server & VB.NET together.
1) Is it inappropriate to login ALL remote users with ONE user id?
2) If so, is there a posting I can refer to that explains how to set up logins in my SQL database programmatically through .NET as I create a login within my application?
3) If not, is it inappropriate to use the 'sa' user id?
All words of wisdom are greatly appreciated.