What’s the good solution to setup SQL Serve?
First you need to find information what kind of database will be on and the activity. Don’t put production database and development database in the same SQL Server. The security will be the most important part and the size of the disk to have a good setup.
Don’t forget to disable the user sa and take the option Mixed mode to logon into SQL Server. Be sure the services will be logon with a Windows account if is possible. Enable the audit for login fail only and see your log error frequently.
I will add to this post, take control of your SQL Server and you will be happy if nothing happened is an attack occurs in your company.
