SQLMail - Configuring - totally stumped
wasnt sure which forum to put this in - intially had it in "getting started" but think it maye have been better of in here i have been trying to setup SQLMail in SQL2000 but have been having a few problems i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.
i also assigned the SQL Server Agent to use the same profile & tested this. also, checked "save in sent items" checkbox so i assumed that was all thats needed? through Query Analyzer i run a simple test EXEC xp_sendmail'Craig.Gamble@<mydomain>.com' 'The DB is full' i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent i also checked the SQL account permissions to make sure it could access the Exchange Server using the EXEC xp_cmdshell 'NET USE\\Enterprise\IPC$' and again this returned success so now im stumped! is there anything else i can check to see where or what its supposedly sending? any help greatly appreciated.
Cheers,
Craig
