Home > profile name > error 14607 sql

Error 14607 Sql

Contents

here for a quick overview of the site Help Center Detailed answers to any questions profile name is not valid sql server 2012 you might have Meta Discuss the workings and policies of this sql server profile name site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers

Msg 14607, Level 16, State 1, Procedure Sysmail_verify_profile_sp, Line 42 Profile Name Is Not Valid

or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community

Configuration Wizard Of Database Mail

of 4.7 million programmers, just like you, helping each other. Join 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 name is not sysmail_add_principalprofile_sp 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 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_

(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)  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

Msg 14607, Level 16, State 1, Procedure Sp_send_dbmail, Line 141 Profile Name Is Not Valid

that when it runs sends out an email in and HTML format with table records about principal name is not valid on hand inventory. the query works but when it come to emailing it fails with the above error. I have check in Management and system.data.sqlclient.sqlexception: profile name is not valid 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? http://stackoverflow.com/questions/3491053/profile-name-is-not-valid 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 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 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 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 0 Sign in to vote That was it. I copied the code from another server and edited it and forgot to set the profile to the new server's profile Thursday, June 25, 2015 9:03 PM Reply | Quote Microsoft is conducting an online survey to understand you

up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » 'profile name is not valid' error with... http://www.sqlservercentral.com/Forums/Topic698578-146-1.aspx 'profile name is not valid' error with sp_send_dbmail Rate Topic Display Mode Topic Options Author http://www.c-sharpcorner.com/uploadfile/c1f7d5/sql-database-mail-profile-name-is-not-valid-in-sql-server-2/ Message J-HobJ-Hob Posted Thursday, 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 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 profile name 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 = '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 name is not 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 it's all working now. Post #699331 cms4jcms4j Posted Thursday, October 6, 2016 5:37 AM Forum Newbie Group: General Forum Members Last Login: Friday, October 7, 2016 10:20 AM Points: 3, Visits: 135 Try the solution mentioned in this Blog Post:https://cms4j.wordpress.com/2013/12/17/msg-14607-level-16-state-1-profile-name-is-not-valid/ Post #1823952 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You

DOWNLOAD: C# Corner Android App Version 0.5.3 Released C# Corner Annual Conference 2017 Announced C# Corner Contribute An Article A Blog A News A Video A Link An Interview Question Ask a Question TECHNOLOGIES .NET Cloud iOS Oracle String in C# .NET Core Cognitive Services Java Outsourcing Swift ADO.NET Cryptography JavaScript PHP TypeScript AJAX Current Affairs JQuery Power BI Universal Windows Platform Android Databases & DBA JSON Products Visual Studio Angular 2 Design Patterns & Practices JSP Project Management VR and AR AngularJS Dynamics CRM Knockout Python WCF Architecture Entity Framework Learn C# Corner R Web Development ASP.NET Error Zone LINQ React Web Services ASP.NET Core Expression Studio Machine Learning Robotics & Hardware Windows 10 Azure Games Programming Microsoft Office Security Windows Controls Big Data GDI+ & Graphics Mobile Development Servers Windows Forms BizTalk Server Google Development Multithreading SharePoint Windows PowerShell Bot Framework HoloLens Node.js SignalR WPF C# How do I Office Development Smart Devices Xamarin C, C++, MFC HTML 5 OOP/OOD Software Testing XAML Career Advice Internet & Web Open Source SQL Language XML Chapters Internet of Things Operating Systems SQL Server Request a new Category| View All ANSWERS BLOGS VIDEOS INTERVIEWS BOOKS NEWS CHAPTERS CAREER Jobs CODE IDEAS Scroll To Top Reader Level: Article SQL Database Mail Profile Name is Not Valid in SQL Server 2012 By Shivom Agarwal on May 16, 2014 This article explains how to send emails using the msdb.dbo.sp_send_dbmail Stored Procedure as a non-sysadmin user in SQL Server 2012. 42.2k 0 1 facebook twitter linkedIn google Plus Reddit WhatsApp expand This problem occured whenI was trying to send emails using themsdb.dbo.sp_send_dbmailStored Procedure as a non-sysadminuser in SQL Server 2012.For Example: EXECmsdb.dbo.sp_send_dbmail @profile_name='MailProfile' ,@recipients='test@test.com' ,@subject='AutomatedTestResults(Successful)' ,@body='Thestoredprocedurefinishedsuccessfully.' The error was: Msg14607,Level16,State1,Proceduresp_send_dbmail,Line141 Profilenameisnotvalid You can see that the non-sysadminuserhas been added tothe DatabaseMailUserRolerole inthe database. Note:If the database mail profile is not set for public access then the user is not allowed to use the specified profile. Now set the profile to Public.Right-click on the Database Mail in the Management Studio and select the Configure Database Mail menu option. Click the "Next" button. Select "Manage profile security" then click the "Next" button. Now go toPublic Profiles, select your profile name and then set the profile to Public then click the "Next" button. Note: The

 

Related content

error 14607 sql server

Error Sql Server table id toc tbody tr td div id toctitle Contents div ul li a href Sql Server Profile Name a li li a href Configuration Wizard Of Database Mail a li li a href Microsoft Odbc Sql Server Driver Sql Server Profile Name Is Not Valid a li li a href System data sqlclient sqlexception Profile Name Is Not Valid a li ul td tr tbody table p May April December relatedl October September August p h id Sql Server Profile Name p July March November msg level state procedure sysmail verify profile sp line profile name

error 14607 profile name is not valid

Error Profile Name Is Not Valid table id toc tbody tr td div id toctitle Contents div ul li a href System data sqlclient sqlexception Profile Name Is Not Valid a li li a href Msg Level State Procedure Sp send dbmail Line Profile Name Is Not Valid a li li a href How To Check Profile Name In Sql Server a li ul td tr tbody table p July June May April December October September relatedl August July March procedure sysmail verify profile sp profile name is not valid November October September August July sql server profile name June

error 14607 sql server 2008

Error Sql Server table id toc tbody tr td div id toctitle Contents div ul li a href Sql Server Profile Name a li li a href Configuration Wizard Of Database Mail a li li a href Microsoft Odbc Sql Server Driver Sql Server Profile Name Is Not Valid a li li a href System data sqlclient sqlexception Profile Name Is Not Valid a li ul td tr tbody table p 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

profile name is not valid error 14607

Profile Name Is Not Valid Error table id toc tbody tr td div id toctitle Contents div ul li a href Procedure Sysmail verify profile sp Profile Name Is Not Valid a li li a href System data sqlclient sqlexception Profile Name Is Not Valid a li li a href Sysmail add principalprofile sp a li li a href Msg Level State Procedure Sp send dbmail Line Profile Name Is Not Valid a li ul td tr tbody table p Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center relatedl Server and Tools Blogs TechNet Blogs p

profile name is not valid sqlstate 42000 error 14607

Profile Name Is Not Valid Sqlstate Error table id toc tbody tr td div id toctitle Contents div ul li a href Sql Server Profile Name a li li a href System data sqlclient sqlexception Profile Name Is Not Valid a li li a href Configuration Wizard Of Database Mail a li li a href Msg Level State Procedure Sp send dbmail Line Profile Name Is Not Valid a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the relatedl workings and

profile name is not valid sqlstate 42000 error 50000

Profile Name Is Not Valid Sqlstate Error table id toc tbody tr td div id toctitle Contents div ul li a href System data sqlclient sqlexception Profile Name Is Not Valid a li li a href Sysmail add principalprofile sp a li ul td tr tbody table p HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related relatedl threads Remove From My Forums Answered by profile name is not valid microsoft sql server error sql server agent job fails SQL Server SQL Server procedure sysmail verify profile sp profile name is not valid Database Engine