--- title: "Create database mail profile in sql server step by step." description: "In this article I would discuss about the Database Mail which is used to send the Email using SQL Server.  Database Mail Configuration To Create a D" author: "Anonymous User" published: 2016-03-07 updated: 2018-03-14 canonical: https://www.mindstick.com/blog/11028/create-database-mail-profile-in-sql-server-step-by-step category: "database" tags: ["database", "sql server"] reading_time: 2 minutes --- # Create database mail profile in sql server step by step. In this article I would discuss about the [Database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) Mail which is used to send the Email using [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server).\ ##### Database Mail Configuration ##### \ To Create a Database Mail profile - In Object [Explorer](https://www.mindstick.com/forum/34658/want-to-developed-windows-explorer-without-using-telerik), connect to the SQL Server [instance](https://www.mindstick.com/forum/1739/object-reference-is-not-set-to-an-instance-of-an-object-error-in-my-code) you want to ##### configure Database Mail on, and expand the server tree. - Expand the [Management](https://www.mindstick.com/articles/23490/tips-for-better-cash-flow-management) node - [Double click](https://www.mindstick.com/forum/155692/what-is-dfp-double-click-for-publisher) or (right click [configure](https://answers.mindstick.com/qa/51511/how-to-configure-client-and-repository-in-informatica-power-center) database mail ) Database Mail to open the Database Mail [Configuration](https://www.mindstick.com/articles/13112/setting-up-the-perfect-configuration-for-your-work-computer) Wizard. ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/8f2df878-80f5-441f-972f-790e71413245.png)\ - On the Select Configuration Task page, select Manage Database Mail accounts and profiles option and click Next. ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/e1a8074d-35b4-471b-a740-e46709a721d1.png)\ - On the Manage [Profiles](https://answers.mindstick.com/qa/34878/which-president-won-the-pulitzer-prize-for-profiles-in-courage) and [Accounts](https://answers.mindstick.com/qa/33250/what-are-accounts-in-salesforce) page, select Create a new profile option, and click Next. \ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/d8158599-4946-4a8a-a518-c8aacec13eb1.png)\ - On the New Profile page, specifiy the Profile name, Description and add accounts to be included in the profile, and click Add button . \ - create new email Account. ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/62180624-6e9c-4301-a2de-2292d5ec716a.png)\ \ - Click On New Account ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/785cc214-c914-4eaf-9fc7-4a8a252e378e.png)\ \ - On the New DataBase Mail Account page, specifiy the Account name, Description and add accounts to be included in the SMTP Details, and \ click OKbutton . \ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/896e0cf3-0a14-4503-83bd-696fbdbb8fc9.png)\ \ Click to next Button\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/080beb85-515b-4dc3-84c1-6beab701d02b.png)\ \ Click to next Button\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/1bb044de-78ce-45eb-8cab-b5245055976d.png)\ Click to next Button\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/4dd657d6-bcec-4d5e-9f14-6902ef61da62.png)\ \ Click To Finish Button![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/a032f052-8f16-4b06-a5da-a1c460a6919b.png)\ \ Click To Close Button\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/b1456b47-437e-4437-beb4-a824c09b7f03.png)\ \ Right Click to Database mail and send test E-mail.\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/6cd970eb-eba4-42af-8c96-15bfb67bf92a.png)\ \ Select your mail profile and include to email Id ,subject,body and Send Test E-Mail.\ ![Create database mail profile in sql server step by step.](https://www.mindstick.com/blogs/cbb1aead-2b0b-4fc7-ac9c-ece34fc6e9bc/images/5aed1fa6-8007-45dd-8320-b0c14b27e648.png)\ \ ##### I hope this article help full for you. --- Original Source: https://www.mindstick.com/blog/11028/create-database-mail-profile-in-sql-server-step-by-step Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.