BASIC QUESTION: We have a small application that uses a MSSQL database to save data. We want to use Windows-Authentification to allow each client (15 in total) to connect to the database to write/read in a table.
For now, we ask the database administrator to create in the database the 15 users (adding their Windows name). We ask to do it directly in Microsoft SQL Server Management Studio or to use our utility. If the administrator is connected to the database with our utility and s/he has enough rights, s/he can create the users directly from our Utility.
Is this normal practice? Or there should be a single user saved in the server/database, and all clients should use this user to access the server/database?
Note: The clients connect directly to the server database. We have not developed a server application between clients and database. (slightly edited question)