I've got a SQL server that I'm reviewing that uses mixed mode authentication. I have an entry in the syslogins table that lists a user with a NULL password, this user is an NTUser that does have ...

Click the option labeled "With SQL Server authentication." This option uses the separate SQL server username and password instead of logging you in with the Windows 7 account information.

Instead of using SQL Server Management Studio to bridge the gap, as used in Azure SQL Database, Microsoft's free SQL Server Data Tools (which can be downloaded here) will be used instead. The improved ...