• With your CREATE LOGIN statement a SQL account is created.

    If you can login as administrator but you can't login as 'sa' then it looks like the authentication mode of the instance is set to "Windows Authentication mode". This prevents the use of SQL accounts.

    If it is needed (according to your security policy) you can change this setting using SSMS. Navigate to the 'security' tab of the properties of the instance.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **