Login Error 18456 in sql server 2008

Question

I have successfully installed Sql Server but but not created Account during installation.Now when i used windows authentication then no problem but when used server authentication it show error messege Login failed.I am also tried login name=sa & passward=sql server.

Pankaj Pandey · Answer

hello login with authentication mode go to security-->login-->sa and double click set your passwrod and go to status tab and set it to enabled. mark as answered if helpfull

Jignesh Trivedi · Answer

hi Login with Windows Authentication run following Query CREATE LOGIN WITH PASSWORD = ' '; Please refer. http://msdn.microsoft.com/en-us/library/aa337562(v=sql.105).aspx hope this will help you.