Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to login in SQL Server when login failed?

Author  Topic 

alinazolii
Starting Member

4 Posts

Posted - 2014-09-03 : 06:37:13
Hi

Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)

I am facing this problem when connecting to local system db, but when i connect any server it connects.

Login failed for user 'domain\username'. (Microsoft SQL Server, Error: 18456)

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-09-03 : 06:42:11
Can you check sql server errorlog and post detailed message here. What do you mean by connecting to local system are you talking about local DB ?

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-09-03 : 06:57:39
Hi Alina

Here are simple steps by which you can eradicate this error

Create new user with Administrator privilege with same username and password as of SQL Server in operating system.

On SQL Server database create new user by expanding DatabaseNode >> Security >> Login >> Create New User and add this new user with Windows Authentication radio button selected. This user can be only added by selected Windows Authentication it is Operating system’s User Login. Once above. You should perform the above steps using windows authentication
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-09-08 : 01:11:54
Here is an article about SQL server error message: 18456.

https://www.katieandemil.com/microsoft-sql-server-error-18456-login-failed-for-user?tab=article
Go to Top of Page
   

- Advertisement -