2005 64 bit SQL Question

Question

2005 64 bit SQL Question

Scott Ohar

Hall of Fame

Points: 3607
More actions
September 15, 2008 at 3:54 pm

#127408

Current setup:
Windows 2008 64 bit
SQL Server 2005 64 bit
Apparently SQL Mail isn't available with 64 bit SQL 2005, I've only found a few Articles on this: http://support.microsoft.com/kb/908360
Has anyone else ran into this problem? if so any solution besides setting up Outlook Express?

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

You can use Database Mail to send, unless you need to receive mail too.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 2

Actually, we can't. I went under Surface Area Connections and went to turn on Database Mail and SQL mail and it flagged an error. I researched the error which leaded me to post on here.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

DB Mail definitely works on SQL 2005 64 bit, I use it all the time. You may need to have SP1 to use it for SQL Agent alerting though.

If you are getting an error, then there must be something else wrong.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

sunil kak SSC-Addicted Points: 470 More actions · Answer 4

can you let us know what errors are you getting when you turn the database mail on?

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 5

Ok, sorry for not responding that quickly. Had a Family Emgy.

Turns out it's a known issue. My only option is to reinstall SP2 64 bit for 2005 SQL

Here is the Error

Date9/17/2008 2:01:58 PM

LogDatabase Mail (Database Mail Log)

Log ID1

Last Modified###

Last Modified By###

Message

Activation failure.

I did some research on the Error for 64 bit 2005 and on the msdn there is a known problem with Service pack 2 64 bit install completeling and not logging that it actually failed.

Manie Bloem SSC Enthusiast Points: 193 More actions · Answer 6

Do still have the problem or did you reinstall because, i am using SQL2005 SP2 Database Mail on a 64 bit Dell server and it works fine.

I have a script that i use to setup my Databse email, never had problems with it in SQL2005 SP2 or SQL2008. If you want it I will post it.

Manie

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 7

If you could please post the script when you can. I reinstalled sp2 and still no luck..

CrazyMan SSChampion Points: 12560 More actions · Answer 8

Hi Scott

DBMail Defenitly works on SP2, i am working with it, please check the configuration, else if possible to post the conf, i can have a look on it

cheers

🙂

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 9

I've Verified Surface Area Connection that DB Mail is enabled, I have the Account Configured exactly the same way we have in our current Prod Environment.

Any where else im forgetting to look?

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 10

We've used DB Mail on SQL 2005 - 64bit for several months now. It definitely works. Our OS is Windows 2003.

We enable it with these two scripts:

1.

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

2. Edit before running: ServerName and 'your_email_account_here'

-- Create a Database Mail account

EXECUTE msdb.dbo.sysmail_add_account_sp

@account_name = 'ServerName Server Account',

@description = 'Mail account for ServerName',

@email_address = 'your_email_account_here',

@replyto_address = 'your_email_account_here',

@display_name = 'ServerName Automated Mailer',

@mailserver_name = 'your_mail_server_here';

-- Create a Database Mail profile

EXECUTE msdb.dbo.sysmail_add_profile_sp

@profile_name = 'ServerName Profile',

@description = 'Profile used by ServerName' ;

-- Add the account to the profile

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp

@profile_name = 'ServerName Profile',

@account_name = 'ServerName Server Account',

@sequence_number =1 ;

-- Grant access to the profile to all users in the msdb database

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

@profile_name = 'ServerName Profile',

@principal_name = 'public',

@is_default = 1 ;

3. Then create an Operator. Give it any Name and an E-mail name using the email account as edited above for 'your_email_account_here'.

4. Open Properties for your SQL Server Agent and on the Alert System screen enable the mail profile. We also enable the Fail-safe operator using the Operator created in step 3 on this same screen.

5. Restart SQL Server Agent

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 11

Service Pack 2 Failed

Product : Database Services (MSSQLSERVER)

Product Version (Previous): 3042

Product Version (Final) :

Status : Failure

Log File :

Error Number : 11009

Error Description : No passive nodes were successfully patched

Jeffrey Williams SSC Guru Points: 90298 More actions · Answer 12

Scott Ohar (9/18/2008)
Service Pack 2 Failed
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched

You will probably need to failover SQL Server to the passive node and run the service pack upgrade on that node.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 13

I want to thank everyone for help with this problem.

Here is how it was fixed. (Sort of a Cluster Resource Error)

Due to our setup we are running out of drive letters, so we are using Mount points which was added as a SQL resouce, last week I was having a problem getting db restores working, our network gave the mount point luns Drive letters which was the same time I did the SP2 install, well I didnt notice that the SP was failing after network removed the mapped letters, turns out I had to change a regedit setting to point to the mount point then reinstall SP2.

You are all correct DBMail does indeed work Great with 64 bit =). Now I get to enjoy this beast of a sql box

2008 Server EE 64 w/2005 64

Quad/Quad

128gb ram

Scott Ohar Hall of Fame Points: 3607 More actions · Answer 14

If anyone ever has this problem here are some great links on other issues that might cause SP2 to fail

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2929900&SiteID=1

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1515506&SiteID=17

http://support.microsoft.com/kb/929151