MS SQL Server supports two types of authentication to connect to SQL Server Instance installed on machine.
Two types of authentication modes are :
1.Windows Authentication.
2.SQL Server Authentication.
It also supports Mixed mode authentication (We can login into SQL Server using both windows authentication and SQL Server Authentication mode.).
We have to specify authentication mode of SQL Server during installation of SQL Server Instance on machine.
Consider that you have selected SQL Server Authentication mode during installation.
When you login into SQL Server using SQL Server Authentication mode we have enter username and password for sql login.These username and password we need to specify during installation process of SQL Server.
If we specify UserName with Domain Name in login of SQL SERVER Authentication mode then SQL Server will throw an error
Cannot connect to SQL Server .
Error :18456
Severity : 14
State: 6 like this .
SQL Server allows only SQL logins in the SQL Authentication mode. These logins are defined within SQL Server.Windows Domain Name is not allowed by SQL SERVER in SQL SERVER Authentication mode.
If we are including domain name in Login field then it is like an windows authentication mode. That’s why SQL Server throwing an above error.
So,When we are try to login using SQL Server Authentication mode we should specify username alone in login field of connection wizard.
Got questions? Email us at: vembu-support@vembu.com for answers.
Follow our Twitter and Facebook feeds for new releases, updates, insightful posts and more.
