Last post Aug 28, 2019 09:38 AM by Yang Shen
Aug 28, 2019 08:16 AM|Lucifer_deep|LINK
My company created a user with domain today on my machine and I am not able to log into my SQL server 2012 SSMS. I am the only user on the machine. Can I go with creating a new user with username and password or setup windows authentication now on my machine.
Right now, the error is:
"Login failed for user '<domain_name>\<firstname>.<lastname>'. (Microsoft SQL server error: 18456)"
Right now, I need access for my SQL server so that I can create Database and start working on it. Can anyone help me with this.
Aug 28, 2019 09:38 AM|Yang Shen|LINK
Hi Luc ,
Here's a video that can solve exact the same error you met in your SQL, Error 18456.
Hope it can help, if any issue still after the video, please feel free to tell.