Advertisements

Archive

Archive for June 25, 2015

SQL Error – SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’

June 25, 2015 Leave a comment

 
Error Message:

Executed as user: DOMAIN\Account. SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for ‘Database Mail XPs’ in SQL Server Books Online. [SQLSTATE 42000] (Error 50000). The step failed.
 

–> Resolution:

-- show advanced options
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO

-- enable Database Mail XPs
EXEC sp_configure 'Database Mail XPs', 1
GO
RECONFIGURE
GO

-- check if it has been changed
EXEC sp_configure 'Database Mail XPs'
GO

-- hide advanced options
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO

Advertisements
Categories: SQL Errors Tags:

new CTP 2.1 update for SQL Server 2016 available for download

June 25, 2015 Leave a comment

Today Microsoft announced an update of the recently released Community Technology Preview (CTP) 2 version of SQL Server 2016, the CTP 2.1.
 

[Register and Download the CTP 2.1 Evaluation version (180 days) here]

 

Direct download link:
SQLServer2016CTP2.1-x64-ENU.box
SQLServer2016CTP2.1-x64-ENU.exe
 

As per the Microsoft [SQL Server Blog], now people do not have to wait for several months for the release of next CTP versions. Now customers can experience the Rapid Preview models and bits for their dev & test purpose.
 

–> This rapid release includes some improvements and fixes to the new features added in SQL Server 2016 release, and as follows:

1. Stretch DatabaseDemo video

2. Query Store

3. Temporal Data, added support for computed columns and Period columns with HIDDEN flag – Demo video.

4. Columnstore Index, improved seek/scan performance – Demo video.
 

Check the [SQL Server blog] for all these updates in detail.
 


 

Check & Like my FB Page