<div>
Thanks very much. That did the trick.
</div>


<div>
<div class="content wysiwyg-content">
In SQL Server 2012, I am unable to connect to &nbsp;SQL Server using Windows Authentication (via SQL Server Management Studio). I can sign on with the SA user using SQL Server Authentication and with another SQL Server login that I added. Just can't sign on with Windows Authentication.<br />
<br />
According to the Server Properties, the server is set up for mixed mode (SQL Server and Windows Authentication mode).<br />
<br />
The message that is thrown when I attempt to login with Windows Authentication is that the Login failed for User MXSVA\Administrator.<br />
<br />
Any ideas?
</div>
</div>


In SQL Server 2012, I am unable to connect to  SQL Server using Windows Authentication (via SQL Server Management Studio). I can sign on with the SA user using SQL Server Authentication and with another SQL Server login that I added. Just can't sign on with Windows Authentication.

According to the Server Properties, the server is set up for mixed mode (SQL Server and Windows Authentication mode).

The message that is thrown when I attempt to login with Windows Authentication is that the Login failed for User MXSVA\Administrator.

Any ideas?

MS SQL Server Windows Authentication not working

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.