Rank: Advanced Member
Groups: Member
Joined: 6/9/2008
Posts: 188
Points: 576
Location: California, USA
|
Null login name for a database userwe have a software application called blackboard software working with sql server 2005.
After restore database, I realized the login is not created, then I use script created those logins.
In a database I found one of our user called bb_jreport have null login name, and null default databasename by using sp_helpuser bb_Jreport.
I cannot mapped to the login bb_jreport, for the button is grayed out.
How can I add the login name to the database user and update its default database name to the right databasename.
I tired to delete the user, and recreate, but it failed : cannot drop user because it owns a schema.
How can do with this, thanks
|
Rank: Advanced Member
Groups: Member
Joined: 3/31/2008
Posts: 94
Points: 282
Location: London
|
Null login name for a database userrichard wrote:we have a software application called blackboard software working with sql server 2005.
After restore database, I realized the login is not created, then I use script created those logins.
In a database I found one of our user called bb_jreport have null login name, and null default databasename by using sp_helpuser bb_Jreport.
I cannot mapped to the login bb_jreport, for the button is grayed out.
How can I add the login name to the database user and update its default database name to the right databasename.
I tired to delete the user, and recreate, but it failed : cannot drop user because it owns a schema.
How can do with this, thanks Remap it with sp_change_users_login.
|
