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.

Image 1

Under Object Explorer select Security > New > Login

Image 6

The default Login name for SQL server administrator is  ‘  sa  ‘

Image 7

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

Advertisements