Programmatically create Logins and grant permission to SQL Server Database using C# .Net

Question

i would like to know how to make login for a specific user with specific mapped database and password in SSMS then use that login in ASPNet WebConfig

Mudassar · Accepted Answer

To create Logins you need to connect to database using Admin account and then use the following queryCREATE LOGIN mudassar WITH PASSWORD  391234539 MUSTCHANGENow to use this Login you can pick connection string from WebConfig and just replace Username and Password with the one created

Mudassar · Answer

meaning next time if you want use to change password forcefully If not required remove itAnd for permission queries referhttpwwwmssqltipscomsqlservertip1138givingandremovingpermissionsinsqlserver

Programmatically create Logins and grant permission to SQL Server Database using C# .Net

Company

Explore

Follow us

Contact Us