User in t_metuser but not SQL server users

Amanda,

You need to delete any user groups associated then you can delete them from the user’s list in the security  module or in the table. I’ve done that a few times myself.  It isn’t advised if they have done any work in Tessitura, if they have it is better to just inactivate them and rebuild a different user account but if they have not done any work in Tessitura yet then you are ok to delete them very carefully.

Thank you have a good day!

Naomi Williams

Wondering if anyone's seen this before:

Yesterday created a new user. Got an error that the user couldn't be created. Cancelled out of the error window,but the user visibly existed in security. Checked t_metuser, user exists there. But the user can't log in, gets "invalid SQL server logon specified", and in SQL server, the user isn't listed under users and presumably doesn't exist.

Would it be safe to just delete the row from t_metuser and create the user again from scratch through security? Or am I in "open a ticket, look into it further" land?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Amanda,

You need to delete any user groups associated then you can delete them from the user’s list in the security  module or in the table. I’ve done that a few times myself.  It isn’t advised if they have done any work in Tessitura, if they have it is better to just inactivate them and rebuild a different user account but if they have not done any work in Tessitura yet then you are ok to delete them very carefully.

Thank you have a good day!

Naomi Williams

Wondering if anyone's seen this before:

Yesterday created a new user. Got an error that the user couldn't be created. Cancelled out of the error window,but the user visibly existed in security. Checked t_metuser, user exists there. But the user can't log in, gets "invalid SQL server logon specified", and in SQL server, the user isn't listed under users and presumably doesn't exist.

Would it be safe to just delete the row from t_metuser and create the user again from scratch through security? Or am I in "open a ticket, look into it further" land?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Amanda,

You need to delete any user groups associated then you can delete them from the user’s list in the security  module or in the table. I’ve done that a few times myself.  It isn’t advised if they have done any work in Tessitura, if they have it is better to just inactivate them and rebuild a different user account but if they have not done any work in Tessitura yet then you are ok to delete them very carefully.

Thank you have a good day!

Naomi Williams

Wondering if anyone's seen this before:

Yesterday created a new user. Got an error that the user couldn't be created. Cancelled out of the error window,but the user visibly existed in security. Checked t_metuser, user exists there. But the user can't log in, gets "invalid SQL server logon specified", and in SQL server, the user isn't listed under users and presumably doesn't exist.

Would it be safe to just delete the row from t_metuser and create the user again from scratch through security? Or am I in "open a ticket, look into it further" land?

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!