Did you try the following option

EXEC sp_addlogin 'Siva', 'Kumar', 'corporate'

This creates a login  to user Siva, with a password of kumar in the Database

'Corporate'. I hope this might be of...