While installing SQL server if you had selected ‘Mixed Mode’ then the ‘Connect to Server ’ window offers either Windows Authentication or SQL server Authentication. By default in Database Engine Configuration ,Windows authentication mode is enabled.
Typical scenario is when you try to connect a SQL database from within NetBeans IDE ,while developing a Java application,it needs only SQL server authentication.
Step by step we shall see how to enable this in SQL server Management Studio.
Login into SQL Server using Windows Authentication.
Under Object Explorer select Security > New > Login
The default Login name for SQL server administrator is ‘ sa ‘
The sa login is a default login with full admin rights for SQL Server.So it is very essential to set up a strong password for sa login.
After creating a sa login you can see this under Security > Login
alselectro 