Search code examples
sql-serverwindows-server-2012windows-serversql-server-2014-express

SQL Server login failed in Windows Server 2012

I have a problem to login to SQL Server 2014 Express edition using a SQL Server user.

I have this problem in Windows Server 2012. In normal Windows machine I can create user and login. I changed the authentication mode to mix and did the all thing in Internet but still I got login error.

Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

If anyone can please help me.

Solution

  • I found the problem. It was conflict with previous installation instant. After I remove everything and reinstall SQL again make it work.