I recently installed SQL Server 2014 in my machine. I configured my user and provided high level access for the same. While connecting through SSMS 2014; if I choose 'Windows Authentication', I can able to connect to database engine successfully. However if I choose to connect through 'SQL Server Authentication' and provide my username/password; I'm getting Error: 18456.
The purpose of me trying this option is - I wanted to try out subscriptions for my SSRS report. Since I opted for 'Windows Authentication' in my report settings I couldn't able to do subscriptions for my reports.
Any suggestions will be very useful. Thanks.