Tuesday, July 7, 2015

MS SQL Server Error 18456

in this Article we are learn how to remove error 18456  comes up when we connect  ms sql server with  sql authentication.
these are several step to make user authentication .
1- Connect to Server
 server name =.\SQLEXPRESS
 authentication= Windows Authentication
connect successfully.
2-go to Security and then enter Logins right click on Logins popup bring click on new Login
open new Login screen Popup form Enter Suitable Name for login username select radio button  SQL Server authentication put your password and Confirm password should be same then select default database : XYZ i.e
3- Select  Server Roles check public.
4- Select User Mapping Check Users mapped to this login XYZ.
5- Check on  below Database role membership for XYZ check
db_owner.
6- press ok button
then Disconnect to Server and reconnect to server select sql authentication
fill with login username and password connect the server.
if username and password are not  connect with sql server error 18456 raise.
connect server with windows authentication and right click on  .\SQLEXPRESS go to his property
Server Properties popup  form open  select page Security check radio button  SQL Server and Windows Authentications mode then press OK button. System need to be update take few seconds,
Now right click on .\SQLEXPRESS click on restart button. popup windows form comes up Message written on "Are you sure you want to restart the MSSQL$SQLEXPRESS service on Server name"
Yes or No Press Yes. Loading start after loading ending Disconnect to server and reconnect and select and put login detail and connect successfully.

thanks


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.