Error 14607 Sql Server 2008
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about
Sql Server Profile Name
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask msg 14607, level 16, state 1, procedure sysmail_verify_profile_sp, line 42 profile name is not valid Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join
Configuration Wizard Of Database Mail
them; it only takes a minute: Sign up profile name is not valid up vote 18 down vote favorite 6 I have a windows account with users group and trying to exec the sp_send_dbmail but getting an error: profile sysmail_add_principalprofile_sp name is not valid. However, when I logged in as administrator and execute the sp_send_dbmail, it managed to send the email so obviously the profile name does exist on the server.. can anyone pleas help? sql-server sql-server-2008 share|improve this question edited Aug 16 '10 at 13:45 marc_s 452k938641029 asked Aug 16 '10 at 6:30 user384080 1,51294280 add a comment| 2 Answers 2 active oldest votes up vote 28 down vote You need to grant the user or group msg 14607, level 16, state 1, procedure sp_send_dbmail, line 141 profile name is not valid rights to use the profile. They need to be added to the msdb database and then you will see them available in the mail wizard when you are maintaining security for mail. Read up the security here: http://msdn.microsoft.com/en-us/library/ms175887.aspx See a listing of mail procedures here: http://msdn.microsoft.com/en-us/library/ms177580.aspx Example script for 'TestUser' to use the profile named 'General Admin Mail'. USE [msdb] GO CREATE USER [TestUser] FOR LOGIN [testuser] GO USE [msdb] GO EXEC sp_addrolemember N'DatabaseMailUserRole', N'TestUser' GO EXECUTE msdb.dbo.sysmail_add_principalprofile_sp @profile_name = 'General Admin Mail', @principal_name = 'TestUser', @is_default = 1 ; share|improve this answer edited Aug 18 '10 at 23:18 answered Aug 17 '10 at 0:21 Sam 5,99742853 can you please give me the sample scripts how to assign user to the right group? –user384080 Aug 17 '10 at 0:38 5 Since I am such a nice person ;) I have supplied this script for you. –Sam Aug 18 '10 at 23:18 2 This error can also happen if you've specified the WRONG profile name via some types of code... i.e., sp_send_dbmail @profile_name = N'Some Profile That does Not Exist', etc... will throw this error as well. –Michael K. Campbell Dec 29 '14 at 21:36 As a heads-up, this same error can ALSO be caused if/when you've simply forgotten to let the SQL Server Agent have access to the SQL Server's Database Mail interfaces - as per this link
360 games PC games
Microsoft Odbc Sql Server Driver Sql Server Profile Name Is Not Valid
Windows games Windows phone games Entertainment All Entertainment how to check profile name in sql server Movies & TV Music Business & Education Business Students & educators
System.data.sqlclient.sqlexception: Profile Name Is Not Valid
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/3491053/profile-name-is-not-valid Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/934226 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
by cms4j Database mail does not work? Profile not valid? Check this out. We use Database Mail very intensive, though faced a problem today with a new server login that we added to our instance. Every https://cms4j.wordpress.com/2013/12/17/msg-14607-level-16-state-1-profile-name-is-not-valid/ time we tried to send an email like this: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'My profile name', @recipients = 'cms4j@wordpress.com', @subject = 'Test', @body = 'Message', @body_format = 'HTML'; We got the error message: Msg 14607, Level 16, State 1, Procedure sp_send_dbmail, Line 119 profile name is not valid When i added our user with whom we connected to the SQL Server Instance to the Server Role "sysadmin" then the email was sent right away. profile name But that had nothing do do with security if we added our dedicated user to the sysadmin-group. So there had to be another solution. I googled a bit and found the following post on sqlservercentral: http://www.sqlservercentral.com/Forums/Topic698578-146-1.aspx There was mentioned a solution like this: EXECUTE msdb.dbo.sysmail_add_principalprofile_sp @principal_name = 'public', @profile_name = 'My profile name', @is_default = 1 ; I executed it, but it did not work. Might be the different SQL Server version, in profile name is the post it was mentioned sql2k5, but we run sql2k8 on our machine. So i opened Database Mail Configuration Wizard from within the SSMS: chose "Manage Profile Security" and found that all my mail profiles were public: But wait, there is another tab "Private Profiles" that shows more options: So i selected our SQL Server Login from the drop down list and granted access to all existing mail profiles. Clicking next and finishing i tried to send an email once again, and it WORKED🙂 Thank you for reading, i hope it solved your problem too. Like this:Like Loading... Related This entry was posted in SQL Server and tagged database mail, mssql. Bookmark the permalink. ← Connection Error 18456 Last "Touch" on each Database perInstance → One Response to Msg 14607, Level 16, State 1 - profile name is notvalid jeff says: December 11, 2015 at 8:03 pm Worked like a champ. Thanks for making this available. Reply Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogO