Unanswered: Cannot create new user in Sql Server Express
I've been trying to add a user account to my SQL Server 2008 Express DB that I can use for remote connections, but when I create a new account in Management Studio and give it serveradmin and sysadmin privileges, I can't even access it from the local machine. I put in the username and password at the Connect to Server prompt and it tells me "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". Does anyone have any ideas what I could be doing wrong. I really just want to have the my database stored on one computer, and connect to remotely from other computers for development purposes. Thanks.
Most common cause is that you have created a SQL Authenticated login, and the SQL Server is configured to only accept Windows Authenticated logins.
That is exactly what the issue was! I just found out 15 minutes ago by following a link in the error dialog to the Microsoft documentation. For anyone else with the same issue, you just have to right-click on the DB server in the Management Studio object explorer, go to security and then chose the authentication mode that allows both Windows and SQL Server authentication. Thanks for your help, MCrowley!