MuraliKrishnan1980 (7/9/2013)
I got the issue resolved by deleting the User from the Database and mapping the login to the DB after that..
for future reference there's no need to delete the user. Use either
USE [yourdb]
GO
exec sp_change_users_login 'UPDATE_ONE', 'dbusername', 'loginname'
Or
USE [yourdb]
GO
ALTER USER dbuserName WITH LOGIN = loginName
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉