When creating a New Login in SQL Server, just under where you type the password are checkboxes. One of them says "User must change password on next login". That's why your passwords kept not working. Everytime you changed the password in MSSQL that box was checked. Then you need to set the Role as you did (though having a login with as few permissions as necessary is a good idea for production). Still liked your tutorial
@CodeTega
Ай бұрын
That makes sense! I appreciate it! Been a minute since I've worked with Microsoft products. I appreciate the feedback. For anyone reading this follow what gemininix said!
@geminix5845
Ай бұрын
@@CodeTega Doesn't help when you're in a hurry either lol. Been there MANY times my friend :)
@anthonylosego
4 күн бұрын
Sometimes I find myself talking to KZitem videos. lol "Uncheck Enforce Password Policy" and assign your login to your database. It's good practice to not use sa for uber access. But just making a user account doesn't automatically assign rights. Sure you can set the default database, but that is not rights. OR you can make the user to god mode (sa) but if you just went into the database and assigned db_read, etc, you'd have been fine and not had the data retrieval web app log in with all power to drop database, etc. As with the other comment, good tutorial for the mssql require. I always wondered what the back end was for ms sql dbs were in react apps. As a .net framework dev for desktop apps, it's nice to find info on how these fiddly web app things work. lol
Пікірлер: 5