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
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.