Skip to main content

Posts

Showing posts with the label Configuration

BUILT IN Account : Network Service Account,Local System Account

Dear Friends ,  This is my all time confusion about Built In account of Sql Server Instance. Today i deeply examine about these.. So i would like to share.. When we right click on any instance of SQL Server from configuration manager, we will get below window... Local System : Completely trusted account, like the administrator account. There is nothing on a single box that this account cannot do and it has the right to access the network as the machine (this requires Active Directory and granting the machine account permissions to perform something) Network Service : Limited service account that is meant to run standard least-privileged services. This account is far more limited than Local System (or even Administrator) but still has the right to access the network as the machine Local Service : A limited service account that is very similar to Network Service and meant to run standard least-privileged services. However unlike Network Service it has no ability to ac

3 Easy Steps to Configure Database Mail

Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine.  I am going to use Database Mail to Configure Automation Failure Notification.. Create an e-mail profile, specify its SMTP accounts and  Specify profile security. Configure Operator. Assign Operator on Jobs/Schedulers. In First Step: Create an e-mail profile, specify its SMTP accounts. To Varify check TSQL   use msdb SELECT *   FROM [msdb] . [dbo] . [sysmail_profile] Now Enable Database Mail service. USE master Go EXEC sp_configure 'show advanced options' , 1 Go RECONFIGURE Go EXEC sp_configure 'Database Mail XPs' , 1 Go RECONFIGURE Go EXEC sp_configure 'show advanced options' , 0 Go RECONFIGURE Go In 2nd Step : Configure Operator. To Varify TSQL   use msdb SELECT *    FROM [msdb] . [dbo] . [sysoper