Error 14607 Profile Name Is Not Valid
Contents |
(1) July 2014 (1) June 2014 (2) May 2014 (2) April 2014 (2) December 2013 (2) October 2013 (4) September 2013 (5) August 2013 (3) July 2013 (2) March 2013 procedure sysmail_verify_profile_sp profile name is not valid (8) November 2011 (3) October 2011 (3) September 2011 (2) August 2011 (2) July sql server profile name 2011 (2) June 2011 (5) May 2011 (3) February 2011 (2) November 2010 (1) October 2010 (3) September 2010 (2) configuration wizard of database mail August 2010 (1) May 2010 (2) November 2009 (2) August 2009 (2) June 2009 (2) May 2009 (4) March 2009 (5) January 2009 (4) December 2008 (5) November 2008 (3) September 2008 (4) August
System.data.sqlclient.sqlexception: Profile Name Is Not Valid
2008 (2) July 2008 (2) June 2008 (1) May 2008 (4) April 2008 (1) March 2008 (5) February 2008 (2) January 2008 (7) Image Galleries Info .NET Development Enterprise Integration BizTalk Gurus Entertainment - Games Java Development Mobile/PDA Development Professional Affiliations Association of Professionals in Business Management Computer Professionals for Social Responsibility Data Management Association Institue of Electronics and Electronic Engineers Metropolitan Design and Development Modern Language Association Syndication: sysmail_add_principalprofile_sp RSS ATOM News Copyright © 2008-2016 Paula DiTallo Tag Cloud Microsoft more tags... << SQL Server: How do I start an agent job on a remote server? | Home | SQL: Locate stored procs, views, etc. by text >> I get this message: profile name is not valid [SQLSTATE 42000] (Error 14607) using sp_send_dbmail. Why? The most likely reason is that your profile has not been configured, or you are using an incorrect name under the @profile_name parameter. To determine your profile settings, use this query:SELECT [profile_id] ,[name] ,[description] ,[last_mod_datetime] ,[last_mod_user] FROM [msdb].[dbo].[sysmail_profile] If after you have checked the results of this query and you are using the correct profile name, check how you are passing the parameter values.Don't do this:exec msdb.dbo.sp_send_dbmail @subject, @body, @profile_name, @recipients ... it will still fail because you need to explicitly define the parameter values ...For example,@subject = 'Some topic or another'So you would either have to do this:exec msdb.dbo.sp_send_dbmail @subject = 'Some topic or another', @body = 'read this!' ...etc.,ordeclare @subj varchar(100)set @subj 'Some topic or another'exec msdb.dbo.sp_send_dbmail @subject=@subj ... etc.,... Share This Post:Short Url: http://wblo.gs/hSU Thursday, September 24, 2015 6:56 PM Feedback No comments posted yet. Post A Comment Title: Please enter a title Name: Please enter your nam
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL principal name is not valid Server 2005 » Administering » 'profile name is not valid' error with... 'profile
Msg 14607, Level 16, State 1, Procedure Sp_send_dbmail, Line 141 Profile Name Is Not Valid
name is not valid' error with sp_send_dbmail Rate Topic Display Mode Topic Options Author Message J-HobJ-Hob Posted Thursday,
How To Check Profile Name In Sql Server
April 16, 2009 9:19 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, September 22, 2009 2:29 AM Points: 9, Visits: 41 I am currently migrating our sql2000 instance to http://geekswithblogs.net/AskPaula/archive/2015/09/24/167058.aspx sql2k5 on a new server. As part of this migration we are moving away from SQL mail and replacing it with Database Mail.I am getting close to getting this implemented but have what I think is a final hurdle to get over until I get this working.If I run the following under an account with the sysadmin server role it works:EXEC msdb.dbo.sp_send_dbmail @profile_name http://www.sqlservercentral.com/Forums/Topic698578-146-1.aspx = 'Student Service Team', @recipients = 'jh@somewhere.com', @subject = 'Test', @body = 'Message', @body_format = 'HTML';If I run it against an account with more restricted permissions it fails with the following error message:Msg 14607, Level 16, State 1, Procedure sp_send_dbmail, Line 119 profile name is not validI have tried assigning the DatabaseMailUserRole and/or db_owner role on msdb. It seems that the only way I get this to work is to assign the sysadmin role which obviously is not sensible for a production environment.I think the error message is a red herring as I know the profile name is valid. Googling hasn't yielding any useful leads. Does anyone have an idea on why this is failing and how I can get it to work? Post #698578 J-HobJ-Hob Posted Friday, April 17, 2009 6:33 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, September 22, 2009 2:29 AM Points: 9, Visits: 41 I managed to resolved this. Needed to make the profiles public by using:EXECUTE msdb.dbo.sysmail_add_principalprofile_sp @principal_name = 'public', @profile_name = 'Student Service Team', @is_default = 1 ;Did this for each of the profiles and i
4.06/51 2 3 4 5 i 05:29:00 pm, by tom.green 31612 views Categories: Errors, Server Configuration Problem When trying to send emails http://blog.sql-assistance.com/index.php/profile-name-is-not-valid from SQL Server using usingthe sp_send_dbmail stored procedure the following error can appear (on SQL Server 2005 or 2008): EXECUTE msdb.dbo.sp_send_dbmail @profile_name = 'PROFILE_NAME', -- Change This @recipients https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5dff0e82-a738-409f-aab4-f7fa4146e16e/profile-name-is-not-valid-sqlstate-42000-error-14607?forum=sqlgetstarted = 'recipient@domain.com', -- Change This @Subject = 'Test Message generated from SQL Server DatabaseMail', @Body = 'This is a test message from SQL Server DatabaseMail' Msg 14607, profile name Level 16, State 1, Procedure sp_send_dbmail, Line 141 profile name is not valid The Database Mail feature is installed and configured (the Database Mail feature is enabled and the necessary account and profile is created). As sysadmin the emails are send successfully using sp_send_dbmail stored procedure. The problem appear when trying to call the sp_send_dbmail stored name is not procedure as a non-sysadmin login. Also the executing non-syadmin login has been added to DatabaseMailUserRole role in msdb database. Cause This happens because the database mail profile is not set with public access and the login is not allowed to use the specified profile. ... Solution: 1. Set the profile used as Public Right click on theDatabase Mailin Management Studio and select theConfigure Database Mailmenu option. ChooseManage profile security Go toPublic Profiles, select your profile name and then set the profile as Public. OR 2. Go to Private Profiles and grant rights to use the specified profile to the login that executes the sp_send_dbmail stored procedure. Tags: profile name is not valid, sp_send_dbmail Currently 4.06/51 2 3 4 5 i Permalink 14 comments Comment from: Yodhava [Visitor] thanks for your notes on this... helped our team fix this problem we were facing. 11/21/12 @ 17:27 Comment from: Sergey Kosik [Visitor] Thanks, that helped me to resolve the issue. 03/12/13
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Profile name is not valid [SQLSTATE 42000] (Error 14607) SQL Server > Getting started with SQL Server Question 0 Sign in to vote I have a job that when it runs sends out an email in and HTML format with table records about on hand inventory. the query works but when it come to emailing it fails with the above error. I have check in Management and Database mail is enabled and a test email works perfectly In SQL Server Agent the Test button is Greyed out FailSafe Operator is enabled and sent via email checked. I must be missing a step. Anyone have and suggestions? Thursday, June 25, 2015 5:23 PM Reply | Quote Answers 0 Sign in to vote How do you send the email? Does your code use sp_send_dbmail? I think so (since it is HTML encoded), so go and check your code and make sure that you specify the profle name as one of the parameters. Aso verify that this profile actually exists and is a public profile.Tibor Karaszi, SQL Server MVP | web | blog Marked as answer by Ruthless Roth Thursday, June 25, 2015 9:01 PM Thursday, June 25, 2015 7:46 PM Reply | Quote All replies 0 Sign in to vote Hello, By the error message you are using the wrong database profile name to send the emailOlaf Helper [ Blog] [ Xing] [ MVP]
Thursday, June 25, 2015 5:39 PM Reply | Quote Moderator 0 Sign in to vote I would agree but I only have one profile so I do not understand how that could be. Is there someplace to specify the profile for a database? SQL 2012 Thursday, June 25, 2015 7:08 PM Reply | Quote 0 Sign in to vote How do you send the email? Does your code use sp_send_dbmail? I think so (since it is HTML encoded), so go and check your code and make sure that you specify the profle name as one of the parameters. Aso verify that this profile actually exists and is a public profil