Can’t log into SQL Server 2012 with domain admin account
I recently migrated a database from SQL Server 2008 to a new server running SQL Server 2012. Everything worked fine, but it was annoying me that I couldn’t log into the database (using SQL Server Management Studio) as a domain administrator – specifically DOMAIN\administrator. Logging in as the SQL user “sa” worked fine, but using Windows Authentication I got the error: Error Number: 18456 Severity: 14 State: 1 Line Number: 65536 Now, I’ve had similar to this before, and the …