Is it possible to use SQL Server Authentication instead of Windows Authentication?

Yes, you can use SQL Server Authentication. However, this requires creating a SQL Server login with a username and password. It's generally recommended to use Windows Authentication whenever possible for enhanced security as it leverages the user's existing Windows credentials. However, if Windows Authentication isn't feasible, SQL Server Authentication is a viable alternative.