Unable to login

It has been a while since I used sqlserver on my computer.

When I try to connect to an instance using ssms 2008 I get "Cannot connect to SQL Server/Login failed for user"

Authentication is Windows Authentication.

The login/password has not changed.

In configuration manager "Log on as" is LocalSystem.

Previously for a while I used ssms 2012. Not sure if this has somehow messed it up.

Appreciate it if somebody could help resolve this issue.

August 25th, 2015 12:05am

Hi Vtpcnk,

Please check the following links

https://support.microsoft.com/en-us/kb/555332

http://blog.sqlauthority.com/2014/01/17/sql-server-fix-login-failed-for-user-username-the-user-is-not-associated-with-a-trusted-sql-server-connection-microsoft-sql-server-error-18452/

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 12:25am

If configuration manager for a SQL Server shows "Log on as" is LocalSystem - then it means Windows Authentication?

Atleast for the basic login?

August 25th, 2015 1:09am

Can you share the image of the log in screen ?
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 1:48am

Hi vtpcnk,

In your scenario, please connect to the database engine for SQL Server 2008 via SQL Server Management Studio 2008 using the login which has permission to create and manage logins. Check if the user account has been created as a login under Security tab. If the login exists, please open the Status tab in Login Properties, make sure permission to connect to database engine is granted and the login is enabled.

If issue persists, please share the error message for our analysis.

If you have any question, please feel free to ask.

Best regards,
Qiu

August 25th, 2015 5:45am

Hi,

Could you find the sql server error log ? this blog will help you

http://sqlserver-help.com/2011/06/26/help-where-is-sql-server-errorlog/

In your error log you will find similar messages

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

Find the error for the username that you are trying to login to and post it here.

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 5:51am

August 25th, 2015 6:33am

>Check if the user account has been created as a login under Security tab. If the login exists, please open the Status >tab in Login Properties, make sure permission to connect to database engine is granted and the login is enabled.

At the OS level the login exists. that is what I have logged in as.

I have no way to login to the sql server.



  • Edited by vtpcnk 20 hours 33 minutes ago
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 6:35am

If configuration manager for a SQL Server shows "Log on as" is LocalSystem - then it means Windows Authentication?

Atleast for the basic login?

For a particular system how do I know which user is LocalSystem?

August 25th, 2015 7:07am

Can you please check the message in SQL ERRORLOG?

http://sqlserver-help.com/2011/06/26/help-where-is-sql-server-errorlog/

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 11:03am

From error log :

2015-08-25 11:35:21.21 Logon       Login failed for user 'TOSHIBA\vtpcnk'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2015-08-25 11:50:40.71 Logon       Error: 18456, Severity: 14, State: 11.

On an earlier date I see this message in the log as well :

2015-08-18 11:13:06.91 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
2015-08-18 11:13:06.91 Logon       Error: 18456, Severity: 14, State: 38.

August 25th, 2015 10:27pm

From error log :

2015-08-25 11:35:21.21 Logon       Login failed for user 'TOSHIBA\vtpcnk'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2015-08-25 11:50:40.71 Logon       Error: 18456, Severity: 14, State: 11.

On an earlier date I see this message in the log as well :

2015-08-18 11:13:06.91 Logon       Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
2015-08-18 11:13:06.91 Logon       Error: 18456, Severity: 14, State: 38.

State 11 means your login was authenticated but due to some other reason  it failed. The possible reason is UAC(User access control) can you disable UAC and what you can also do it. Delete this login from Windows machine 'TOSHIBA\vtpcnk' or AD where this login is created and create a new one. Make sure you disable UAC. Creating new login is mostly when you have AD which controls logins if this login is in workgroup then disabling UAC is only what is required.
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 12:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics