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.
| Author |
Topic |
|
alinazolii
Starting Member
4 Posts |
 Posted - 2014-09-03 : 06:37:13
|
| HiLogin 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 helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2014-09-03 : 06:57:39
|
| Hi AlinaHere are simple steps by which you can eradicate this errorCreate 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 |
|
|
|
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 |
|
|
|
|
|
|
How to login in SQL Server when login failed?