Why is SQL Server 2008 R2 not working?
When i try to connect to SQL Server (2008 R2) using Windows authentication: Checking the Windows Application event log, i find the error: Login failed for user ‘AVATOPIA\\ian’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.
How to login to SQL Server in SA mode?
Should be able to login then. If your instance is called SQLEXPRESS, then you need to use .\\SQLEXPRESS or (local)\\SQLEXPRESS or yourMachineName\\SQLEXPRESS as your server name – if you have a named instance, you need to specify that name of the instance in your server name. Run this query after logging in sa mode..
Can you connect to SQL Server with Windows Authentication?
We can connect to 8 other SQL Servers on the domain using Windows Authentication. Just this one, whitch is the only one that is 2008 R2 is failing. So i assume it’s a bug with **2008 R2*.
Do you need to be sysadmin for SQL Server 2008 R2?
You do not need to be a member of the sysadmin fixed server role to simply connect to your SQL Server 2008 R2 instance. BTW, during the R2 install, one is able to specify login (s) that need to be added to the sysadmin fixed server role.
How to troubleshoot SQL Server SA login failure?
If you connect using Windows authentication with the account you’ve created when you create your DB instance you can troubleshoot with right click database –> Database properties and select the below security option. Check sa login under security option by double clicking.
What happens when database user fails to login?
Login failed for user ‘DatabaseUser’. Even worse, when this happens – every activity that involves database fails with same error message. So for a few minutes the database and thus whole website is down. But I’m not able to recreate this no matter what I do and I’m only able to see this in exception logs.