Mapi Error 285 Sql Server
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Configuring SQL Mail Configuring SQL Mail Rate Topic Display Mode Topic Options Author Message Tim Lewis-224882Tim Lewis-224882 Posted Thursday, November 17, 2005 8:25 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, January 13, 2009 10:17 AM Points: 1, Visits: 4 Does anyone have experience configuring sqlmail or sqlserveragent mailwhen your Exchange server is in a seperate (non-trusted) domain from your SQL server (2000)?I've logged on to the SQL Serveras the domain account that my SQLServer Agent is configured to logon as. This account is a member of the Local Admins group on the SQL Server. I can create a profile using control panel - mail, and logon using outlook. But when I configure the SQL Server agent to use this profile, andhit TEST, I get an "Error 22022: SQLServerAgent Error: Unable to get the default MAPI Message Store due to MAPI error 285: The Microsoft Exchange Server computer is not available. Either there are network problems or the Microsoft Exchange Server computer is down for maintenance." Neither of these two assumptions are correct. I can pull up outlook using the same profile and login and it works fine.My thinking is that, because of the un-trusted domain element, when the SQL Server Agent tries to initiate a MAPI session, it's being prompted for a password (albeit you cannot see this).Anyone with a similar configuration out there?Regards - Tim Post #237845 Scott BecksteadScott Beckstead Posted Friday, November 18, 2005 10:13 AM SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, December 7, 2010 5:44 PM Points: 148, Visits: 24 Can't help with what you are doing but this article worked for me. Doesn't use SQLMail but smtp.http://www.sqlservercentral.com/scripts/contributions/510.asp Kindest Regards,Scott Beckstead"We cannot defend freedom abroad by abandoning it here at home!"Edward R. Murrowscottbeckstead.com Post #238178 David KorbDavid Korb Posted Friday, November 18, 2005 2:23 PM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, April 25, 2016 9:09 AM Points: 145, Visits: 311 Open the MSSQLSERVER service on your desktop and change t
Discussion in 'General DBA Questions' started by quailj1973, Oct 27, 2006. quailj1973 New Member I am trying to configure SQL Mail on one of our windows 2000 servers. The server has SQL 2000 SP4 and Outlook 2003 installed, but when I try to test the SQL Mail Session it comes up with the message below: Error 22022: SQL Server Agent Error: Unable to get the default MAPI Message Store due to MAPI Error 285: The Microsoft http://www.sqlservercentral.com/Forums/Topic237845-5-1.aspx Exchange Server computer is not available. Either there are network problems or the Microsoft Exchange Server computer is down for maintenance I have spoken to our infrastructure team and they said everything is fine on the exchange side of things, plus I am able to send emails directly from outlook on the server. Has anyone come across this before? If http://www.sql-server-performance.com/forum/threads/sql-server-mail.8591/ yes, how did you managed to recolve it? Jason quailj1973, Oct 27, 2006 #2 ramkumar.mu New Member May be this link should give you some help... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=237845 Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..." ramkumar.mu, Oct 27, 2006 #2 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 and 2000 Forum Topics > General DBA Questions > Forums Forums Quick Links Search Forums What's New? Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Newer Than: Advanced search...
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close https://www.experts-exchange.com/questions/20073331/Help-needed-using-SQLMail.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store http://www.verycomputer.com/156_8223b84576ee33a7_1.htm Headlines Experts Exchange > Questions > Help needed using SQLMail Want to Advertise Here? Solved Help needed using SQLMail Posted on 2001-02-06 MS SQL Server 1 Verified Solution 6 Comments 1,025 Views Last Modified: 2012-06-27 I'm trying to configure SQLMail on SQLServer 7.0. When I try to test the mail service I get the error message :- Error 22030. A mapi error MAPI error (error number 285) occurred. Unable to get the default MAPI message store due to MAPI error 285. You do not have permission to log on. Can anyone help ? 0 Question by:ggale Facebook Twitter LinkedIn Google LVL 3 Best Solution byjsaxon2 Here's a link to the Microsoft Knowledge Base on setting up SQLMail in SQL 7.0 http://support.microsoft.com/support/SQL/Content/HowTos/SQL7Mail.asp?LN=EN-US&SD=gn&FR=0&qry=SQLMail&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL Go to Solution 6 Comments LVL 5 Overall: Level 5 MS SQL Server 5 Message Expert mapi error 285 Comment by:xnmb2001-02-06 make sure the MAPI profile used by SQL Mail is configured for your MSSQLServer service log on account 0 Message Expert Comment by:gng2001-02-06 Thanks - I've checked this and it is but I still get the error. 0 LVL 5 Overall: Level 5 MS SQL Server 5 Message Expert Comment by:xnmb2001-02-07 hehe...now check if the logon account YOU are using is THE SAME as the the logon account used by MSSQLServer service to start. in other words, the logon account used by MSSQLServer service to start, the logon account you are using, and the domain account your MAPI profile is configured for MUST be ONE and THE SAME! great, aint it?! good luck. 0 Message Expert Comment by:gng2001-02-07 Looks good ! So, to summarise am I right in saying :- "the NT account that owns the Exchange mailbox must equal the NT account that runs the MSSQLServer service must equal the NT account that runs the MSSQLAgent service ?" OR just "the NT account that owns the Exchange mailbox must equal the NT account that runs the MSSQLAgent service ? (i.e. it doesn't matter which NT account runs the MSSQLServer service)" 0 LVL 5 Overall: Level 5 MS SQL Server 5 Message Expert Comment by:xnmb2001-02-09 NT account that owns the Exchange mailbox,NT account that runs the MSSQLServer service,NT acc
to send out emails from sql server!?!? SQL 2k sp2 NT 4.0 sp6 Thanks in advance. Top MAPI ERROR 285 HELP PLEASE!!!!! by Vishal Anand[M » Sun, 24 Feb 2002 07:34:15 Can you attach the Sql Agent.out file and also check if the .pst file is in use by some other application Hope this helps Regards Vishal Anand Microsoft SQL Server Support Of course, this posting wouldn't be complete without a nice, juicy disclaimer from our lawyers: This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. ? 2001 Microsoft Corporation. All rights reserved. Top 1. MAPI ERROR 285 HELP PLEASE!!!!! Hi John, Check this Under Internet Explorer Properties / Programs check what is your default E-Mail client make sure it is Microsoft Outlook and not anything else and see if you still get the error Also go through http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263556&SD=MSKB& Hope this helps Regards Vishal Anand Microsoft SQL Server Support Of course, this posting wouldn't be complete without a nice, juicy disclaimer from our lawyers: This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. ? 2001 Microsoft Corporation. All rights reserved. 2. xp_senmail error from Access when saving table 3. Codepage 285 4. Problem with utl_file 5. Error 22030 / 22022 A MAPI error HELP 6. ADO Interface database programming samples needed 7. MAPI HELP PLEASE 8. ::Oracle Programmer Analyst::Portland, OREGON:: dr01543 9. MAPI Help, please 10. MS SQL Server + MAPI = Help me, please! 11. MAPI problem, please help 12. Please help with email using MAPI 13. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP! 2 post • Page:1 of 1 All times are UTC Board index Spam Report