HELP! sp_send_dbmail error
i'm having trouble sending email through dbmail. i'm logged in a sql login user named "serviceuser". have added user msdb database , rolemember "databasemailuserrole"
use [msdb]
go
create user [serviceuser] for login [serviceuser] with default_schema=[guest]
go
use [msdb]
go
exec sp_addrolemember n'databasemailuserrole', n'serviceuser'
go
when try send email:
exec msdb.dbo.sp_send_dbmail
@profile_name=@databasemailprofiletouse,
@recipients=@emailaddress,
@subject=@subject,
@body=@messagebody,
@mailitem_id=@mymailitem_id output
i following error:
msg 15404, level 16, state 10, procedure xp_logininfo, line 62
could not obtain information windows nt group/user 'serviceuser', error code 0xffff0002.
i executed following on msdb , didn't help:
exec sp_changedbowner 'sa'
xp_logininfo returns error:
exec xp_logininfo 'serviceuser'
what wrong??????? help!
SQL Server > SQL Server Tools
Comments
Post a Comment