Login Error 18456 in sql server 2008
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 PandeyPosted Jun 10, 2013, 2:59 AM
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 TrivediPosted Jun 10, 2013, 12:33 AM
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.