If you have created sql authentication user and not able to login due to this error please make sure :
Go to sql server configuration manager
Now, go to SQL Server Network configuration and select protocol for [your sql server], make sure that :
1. make sure Shared Memory Protocol is enabled
2. make sure Named Piped protocol is enabled
3. make sure TCP/IP protocol is enabled.