Profile Name Is Not Valid Error 14607
Contents |
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs
Procedure Sysmail_verify_profile_sp Profile Name Is Not Valid
TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscriptions sql server profile name TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security Virtualization principal name is not valid Downloads Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2016 System Center 2016 Windows 10 Enterprise SQL Server 2016 See all trials » Related
System.data.sqlclient.sqlexception: Profile Name Is Not Valid
Sites Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training Microsoft Official Courses On-Demand Certifications Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification
Sysmail_add_principalprofile_sp
(MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Troubleshooting Troubleshooting Concepts (Database Engine) Troubleshooting Database Mail Troubleshooting Database Mail Troubleshooting Database Mail: Profile not valid Troubleshooting Database Mail: Profile not valid Troubleshooting Database Mail: Profile not valid Troubleshooting Database Mail: General steps Troubleshooting Database Mail: Sending Test E-Mail Troubleshooting Database Mail: Could not find stored procedure 'sp_send_dbmail' Troubleshooting Database Mail: Profile not valid Troubleshooting Database Mail: Permission denied on sp_send_dbmail Tro
Communication LEARN: How to become a Microsoft MVP C# Corner Annual Conference 2017 Announced C# Corner configuration wizard of database mail Contribute An Article A Blog A News A Video A Link An Interview
Msg 14607, Level 16, State 1, Procedure Sp_send_dbmail, Line 141 Profile Name Is Not Valid
Question Ask a Question TECHNOLOGIES .NET Coding Best Practices Internet & Web Outsourcing String in C# .NET sp_send_dbmail profile name Core Cognitive Services Internet of Things Philosophy Swift ADO.NET COM Interop iOS PHP TypeScript AJAX Cryptography Java Power BI Universal Windows Platform Android Crystal Reports JavaScript Products Visual Studio Angular 2 https://technet.microsoft.com/en-us/library/ms175984(v=sql.105).aspx Current Affairs JQuery Project Management VR and AR AngularJS Databases & DBA JSON Python WCF Architecture Design Patterns & Practices Knockout R Web Development ASP.NET DevOps LINQ React Web Services ASP.NET Core Dynamics CRM Machine Learning Robotics & Hardware Windows 10 Azure Entity Framework Microsoft Office Security Windows Controls Big Data Error Zone Mobile Development Servers Windows Forms BizTalk Server Games Programming Multithreading http://www.c-sharpcorner.com/UploadFile/c1f7d5/sql-database-mail-profile-name-is-not-valid-in-sql-server-2/ SharePoint Windows PowerShell Bot Framework GDI+ & Graphics Node.js SignalR WPF C# Google Development OOP/OOD Smart Devices Xamarin C, C++, MFC HoloLens Open Source Software Testing XAML Career Advice How do I Operating Systems SQL Language XML Chapters HTML 5 Oracle 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. 43.4k 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
gave my user (let's call it User1) the permissions to send mail as described here. I then called it from some C# code and got the following message. profile name is not valid Here are the steps I used to figure http://justgeeks.blogspot.com/2012/10/troubleshooting-profile-name-is-not.html out what my problem was. Double check that the name of the profile is correct and is being passed correctly to the stored proc using the @profile_name parameter. The next step is to figure out if it is my code or SQL server side. The easiest way to do that is to open SQL Management Studio and connect to your database server using the exact user/login you were using when you got the error. Then try profile name to send the mail message using the following (tweak as necessary): msdb.dbo.sp_send_dbmail @profile_name = 'Profile1', @recipients = 'someone@somewhere.com', @subject = 'Test subject', @body = '
Test Body
', @body_format = 'HTML' If you still get the error, it is something to do with SQL Server, otherwise, it is somewhere in your code that is called the stored proc. If it is in your code, you are on your own. If it is on the name is not server (still getting the error) then proceed to the next step. In SQL Management Studio, open another connection, but this time connect as a user that has more rights (probably yourself). Now execute the following stored proc. msdb.dbo.sysmail_help_principalprofile_sp @principal_name = 'User1', @profile_name = 'Profile1' If you get no results back then that means you have a permission problem. This likely means that your profile is NOT public or the user (User1) don't have access to it. You an change the permission by going to the Database Mail Configuration Wizard | Manage profile security radio button | Next button. Here you can click the profile to make it public. You can alternatively go to the Private Profiles tab and select the user and then the profile. Either way should work. If you run the stored procedure again, it should show that you now have access to the profile now. You can also re-run the sp_send_dbmail and it should work this time. Posted by Brent V at 6:21 PM Labels: Database, MS SQL Server No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Page Views Follow by Email Subscribe To Posts Atom Posts Comments Atom Comments Labels .Net ADO.NET Entity Framework Agile AI AJAX Architecture ASP.NET Batch Files BI Big Data Branching C# Castle Windsor Code Coverage Continuous Delivery Continuous Integration