November 4, 2008 at 9:50 am
Dear all
I'm facing problem regarding database mail feature in SQL server 2005. I upgrade the SQL 2000 to SQL 2005 and under Management the Database Mail feature not installed. Can someone told me how to enable the database mail feature. I also tried the SQL Server Surface Area Configuration but there is no headings for database mail. Please help me in this regard...
November 4, 2008 at 1:28 pm
Datbase Mail is found under the Management tab. Is that where you are looking?
¤ §unshine ¤
November 4, 2008 at 2:06 pm
I checked but under the management there is no feature of Database mail. How I add this feature..???/
November 4, 2008 at 2:10 pm
See if this link might help.
http://www.sqlservercentral.com/articles/Administration/introtodatabasemailinsql2005/2197/
¤ §unshine ¤
November 4, 2008 at 2:23 pm
Thanks for you reply and i have already checked this artilce but there is no option in SAC and I tried the SQL server 2005 CD also. But nothing.....?
November 4, 2008 at 2:46 pm
I'm not sure if it might be a version issue. is it Enterprise, Standard? Are you trying as SA?
¤ §unshine ¤
November 5, 2008 at 11:27 am
looks like you have SQL Server Express Edition, which doesn't support Database Mail. Check this link it might help.
http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx
November 5, 2008 at 1:35 pm
Below are the all information about the installed server.
Microsoft SQL Server Management Studio9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)2000.085.1117.00 built by: (_sqlbld)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer6.0.2800.1106
Microsoft .NET Framework2.0.50727.42
Operating System5.0.2195
I take all necessary steps but still in vain...
November 5, 2008 at 1:39 pm
I get this procedure from a friend...
USE Master
GO
sp_configure 'show advanced options', 1
GO
reconfigure with override
GO
sp_configure 'Database Mail XPs', 1
GO
reconfigure
GO
sp_configure 'show advanced options', 0
GO
and after running this following error is occured..
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 79
The configuration option 'Database Mail XPs' does not exist, or it may be an advanced option.
Valid configuration options are:
Msg 5808, Level 16, State 1, Line 1
Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.
Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply