I have SQL Serer 2012 up and running. I created a new login (SQL Server authentication with password expiration, requires change, etc. turned off).
I can start SQL Server Management Studio as the user. But when I try to connect in code I get the error 'could not find a login matching the name provided'. I know the code works because it can connect to another instance on the same machine.
But the name is there, and I'm actually logged in as that user.
Note, I cannot use integrated security either, just the same error message.
What's wrong? Many thanks.