I created a login name in SQL Server 2008 by
- right click on security then new->login
- specify a name , password and server map.
- Right-click on SQL Server instance at root of Object Explorer, click on Properties
- Select Security from the left pane.
- Select the SQL Server and Windows Authentication mode radio button, and click OK.
- Open up Services and restart the SQL Service (SQLEXPRESS) Windows service.
but it has following error:
login failed for user gggggggg (microsoft sqlserver error 18456)
what is the problem?