Yes, you should be able to login using any local users on that computer. The only one who will have access to edit and admin mode is users in the Administrator role though.
So if it says login failed, it means the username or password was wrong.
Thanks for your reply. It looks like it doesn't work to authenticate with a Microsoft Account. You should create a Local Account (PC Settings - Accounts - Other accounts - Add an account. Remember to make it an Administrator) and log in to the Alloy Sample Site with this user. This worked perfectly for me.
I've installed the Alloy Demo Site on my Surface Pro running Windows 8.1, IIS 8.5 and SQL Server 2012. I'm trying to access the Alloy site with my administrator credentials on this computer.
I've followed the Installation Instructions and step number ten says that I can "log in with a Windows user that is part of the administrators group on the machine". I've tried this - no luck. I'm getting "Login failed". Is these any way that I can create a user using T-SQL? Is this a bug related to the installation?