All of these instructions should be done as a database admin, with the restored database selected. First, make sure that this is the problem. This will lists the orphaned users: EXEC sp_change_users_login ‘Report’ If you already have a login id and password for this user,…
Month: August 2015
Enable the Database Mail XPs: USE master GO sp_configure ‘show advanced options’,1 GO RECONFIGURE WITH OVERRIDE GO sp_configure ‘Database Mail XPs’,1 GO RECONFIGURE GO Create a new mail profile: USE msdb GO EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘admin’, @description = ‘Profile for sending Automated DBA Notifications’…