TSFLLC
asked on
SQL Server Express login - Inappropriate to use sa user id with connection string in a VB.NET application??
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.
Sincerely,
Phil Tate
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.
Sincerely,
Phil Tate
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Eric,
Ignore my request. The explanations for CREATE LOGIN & CREATE USER inside SQL help appear to give me what I need.
Thank you for your promptness!
Phil Tate
Ignore my request. The explanations for CREATE LOGIN & CREATE USER inside SQL help appear to give me what I need.
Thank you for your promptness!
Phil Tate
ASKER
I have searched, but not that dilligently I must admit, for some code that shows how I can programmatically create a login. During my database setup routine I would login as sa to my instance just to attach my custom database and then create my single remote user login.
Can you post a link or code that shows how to do this appropriately with the necessary read/write rights?
Thanks much.