Need Help In Setting Up Sql Mail On Sql Server 2000
May 6, 2001
Iam not sure why Iam not able to successfully set up sql mail. here are the steps I follow:
1. I Created a user account and password to be used for sql server and sql agent as a service account.( Domain Namesqlservice )
2. Logged off window 2000 then log in with the same account I created in step one.
3. double clicked mail icon in control panel to set up a mail account by specifying the following:
pop :pop.erols.com
smtp: smtp.erols.com
I choose POP instead of IMAP to set up the mail account
4.tested the account by opening Outlook and was able to send and recieve mail via Outlook.
So far so good
I assume that I have already (a)created a service account to be used for sql server and sql agen mail account (b) created a mail account (c)tested the mail.
5. I opened sql server and clicked on the mail in the management console to test the sql mail by typing the same mail account in the text box, then clicking test.... I got an error message the MAPI is not set up and it is not connecting to any profile.
another error I got was Error :xp_mapi profile : failed with mail error 0x80040106
Here are some questions that I am not sure about.
Q1. Do I need to set up smtp service in service tab to use same account as sql server/ sql agent. It is using local system account now
Q2. the above steps are correct, I guess so, so what is the reason not being able to set up the mail profile to be used by sql server mail
Thanks for your help
Ali
View 2 Replies
ADVERTISEMENT
Sep 26, 2001
Hi, I have created a profile named sqlmail in exchange server. I tried to run the sql mail service from support service under sql mail to put the profile name, I got the following error: can any one assist me in setting up sql mail in an sql server 2000. .... thanks
Ali
Microsoft SQL - DMO(ODBC SQLState: 42000)
Error 18025:xp_test_mapi_profile: failed with mail error 0x80004005
View 1 Replies
View Related
May 2, 2000
Can someone point me in the direction of a good place to find out how to set this up properly please.
thanks
View 1 Replies
View Related
Dec 4, 1999
Hi
I am using Windows NT 4.0, SQL Server 6.5 and Exchange 5.0. I would like to setup SQL mail.
I tried to create mail login, NT expects for MS mail server name and login.
When i enter my exchange server/login name does not recoganise.
Any guide please.. Thanks in advance
Moorthy
View 2 Replies
View Related
Jul 20, 2005
How do you setup SQL Mail? I tried following the procedures on theonline manual but I do not understand what "On the instance of SQLServer, start the mail client using the newly created mail profile."means. What is the mail client? I have already setup the mail profilebut when I go to SQL Mail on Services and try setting it up, the profileI created is not showing on the pull down list.I appreciate any assistance.Thanks.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Jan 4, 2001
We are running SQL2000 on Windows2000 with Outlook2000.
The SQL Server machine is logged into as Administrator.
I've set up a mailbox called MyMailBox on the above server. I've also set up a profile called MyMailProfile on the server. They are the only Mailbox and profile on this machine and are setup correctly (by our network admin guy).
In services i've set the SQLServerAgent to login as Administrator.
Problems:-
(1) I then try to set the SQLMail profile name in SQL Server but MyMailProfile doesn't appear in the list (it's blank) ? I can type it in but when clicking the test button i get the following message - 'error 18025....failed with mapi error' any ideas ??
(2) If i try to set up an operator when i choose myself from the list and click test it says 'this will send a message to Paul etc'...which is fine but when i then click OK i get the message 'error 22022 SQLServerAgent error: The SQLSserverAgent mail session is not running, check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent properties dialog.' so OK i can do that...
(3) ...in the mail session of the SQLServerAgent properties i have entered MyMailProfile and the service startup account is Administrator. The problem in number (2) is the same ??
I have also checked the services - the MSSQLServer service is logged on using local system account whereas SQLServerAgent is logged on using Administrator - is that a problem ?
From here i'm stuck.
Why doesn't it work ? Is it something to do with NT permissioning ?
Does anyone know a good on-line source to help with setting up SQL Server Mail ?
thanks for any help.
View 1 Replies
View Related
Oct 17, 2006
I would need to use sql-mail for alerts etc on an SQL server installed on an Windows XP machine. IIS is installed. Is that possible and in that case how? Can I use POP-account for it?
Björn
View 1 Replies
View Related
Jan 5, 2001
Having problems setting up mail under SQL Server 2000. Here is scenario:
1. computer logged in under DOMAINCoolUser (member of Administrators group)
2. SQL Server and SQL Agent Service started under DOMAINCoolUser
3. Mail profile created called CoolUser and messages delivered to Mailbox - CoolUser
4. Successfully sending and receiving messages from Exchange Client
5. net use mailserverIPC$ is returning success
Problem A. I don't see the profile in the dropdown box
Problem B. If I specify the profile manually and test I get the following errro: Error 18025: xp_test_mapi_profile: failed with error 0x80040106
Can anybody help?
View 3 Replies
View Related
May 24, 2000
Any help on the following error which I am getting when I am trying to set up SQL Mail for Internet Mail with Outlook Express?
Error 22030: A Mapi error(error no 271)occured.Unable to get the default MAPI Message store due to mapi error 271:One or more of the receipients was not found in the address book.
Thanks!
View 3 Replies
View Related
Dec 19, 2007
Hello Friends
I want to send mail using Stored Procedure using SQL Server 2000 using windows smtp component. I don't want third party component.
can any body send Stored Procedure.
View 1 Replies
View Related
Jun 6, 2005
Probably a dumb question, but if one is using SQL Server 2000 instead of 'SQL Express' what has to change here, in order to set up caching? What changes in the paths?
http://beta.asp.net/guidedtour2/s22.aspx
View 26 Replies
View Related
Jul 19, 2002
We just got a new server. We are running Windows 2000 with Office 2000 and SQL Server 2000 (Standard Edition).
To set up the mail for SQL 2000 it says to use Outlook client in "corporate" mode. This mode doesn't have the IMAP option on internet Mail only POP3.
Did I miss an option while installing Outlook?
I've only been able to find a third party vendor that has a solution but our IS/IT people are not in favour of going this route.
Any thoughts on how to get around this?
Thanks for your time.
View 1 Replies
View Related
Feb 14, 2008
Hello
I want some ides rearding sending mail at specified time. I want to send mail at everyday 3:00AM from SQL Server. I have stored procedure to send mail.
Thanks in advance
Hem
View 3 Replies
View Related
Jul 6, 2006
Hi
I have a setup where I need to replicate the database which is actually subscribing from another database. The current setup is all in SQL Server 2000. I need to now setup a Distrbutor on a SQL server 2005 and publish the database using this distributor to another server on SQL server 2000.
Has anybody done this before. If yes what will I need to check. Can you please let me know :-
1) SQL Server 2000 which SP should be installed to support this enviroment.
2) SQL Server 2005 which SP should be installed to support this environment.
3) Any thing that I need to look out for.
Thanks for any inputs on this.
Regards
View 3 Replies
View Related
Nov 5, 2007
I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.
David Neahusan
View 1 Replies
View Related
Mar 13, 2004
Hello,
I am using a script to send mails from MSSQL 2000 server. The script is trying to use the ASPMail object is located within a SQL Job or DTS package in the SQL database. It is not being run through an ASP page. The ASPMail object works fine if running in an ASP page running on win2003 server. It DOES NOT work when trying to create the object within SQL ActiveX VB script running on mssql server. If I am using this script in a job and use Microsoft's Enterprise Manager it only tells me that the job failed. If I try to use this script in a DTS package I get the error: 'Can not create object ("SMTPsvg.Mailer"). If I use a third database manager I get the following error: 'Execute permission denied on object xp_ServiceControl database' Please let me know what is causing this and how to fix it. The script goes as below
'*************************************************
' Visual Basic ActiveX Script
'*************************************************
Dim Mailer
Set Mailer = CreateObject("SMTPsvg.Mailer")
Mailer.FromName = "Webmaster"
Mailer.FromAddress = "webmaster@domainname.com"
Mailer.RemoteHost = "mail.domainname.com"
Mailer.AddRecipient "user", "mailid@domainname.com"
Mailer.Subject = "Test ASP Mail"
Mailer.BodyText = "Test"
x = Mailer.SendMail
Set Mailer = Nothing
Any help is appreciated
Regards
View 3 Replies
View Related
Mar 3, 2008
can I send a mail by stored procedure?
View 5 Replies
View Related
Mar 20, 2001
Hi
I would like to know if it's possible to use pop3 server protocol instead of MAPI application to cause SQL Server 2000 sends email to an Administrator when anormal event comes ?
i.e, configure a pop profile to receive sql server 2000 error
Thanks for all repply
Michel
View 1 Replies
View Related
Mar 23, 2001
Hi
I would like to know if it's possible to use pop3 server protocol instead of MAPI application to cause SQL Server 2000 sends email to an Administrator when anormal event comes ?
i.e, configure a pop profile to receive sql server 2000 error
Thanks for all repply
Michel
View 1 Replies
View Related
Jan 30, 2008
I want to use a Microsoft SQL Server 2000 stored procedure to pull email information
from our Gordano mail server and append this data to our SQL database.
Information desired: From, To, Subject, Body
Preferably I don't want to use tools/resources outside the SQL procedure to gain access to
the Gordano information. Do you know if this is possible?
Can anyone offer any advice?
Thanks
View 4 Replies
View Related
Jul 7, 2003
Hello Everyone,
I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.
View 14 Replies
View Related
Feb 10, 2008
Hello,
The Database Mail feature is already enabled on the server, also I have a mail account on the other server.
The problem I faced is that I need to send mail from my SQL Server using a created email account on the other server. How should I configure my email to do that ?
Should I use a sysmail_add_account procedure to enable account, also set profile and profile account ? Does this way creates server mail account that is binded with other email account?
The mail should be sent from my SQL Server.
Thank You.
View 3 Replies
View Related
Feb 20, 2008
Hi all....
Our company use yahoo business mail server for our corporate mails. I know that I can configure database mail with SMTP. But when I try to configure database mail account with yahoo bizmail, I cannot do that. It gets configured but when I test it it doesn't send any mails. Do I need to have any special condiguration for this. SMTP address is smtp.bizmail.yahoo.com. Also I have specified the Authentication using my user name and password. Please help
Thanks
Rajesh
View 10 Replies
View Related
Dec 7, 2001
I am playing around with SQL Mail on my home network. I have SQL Server loaded on my server (Windows 2000 Advanced Server) and I have two XP Professional machines. I have the Outlook client installed on my XP machines. I do not have an Exchange Server. Can I configure SQL mail without an Exchange Server? If I can, How do I do it. I appreciate the feedback.
I really need details because I have been tying everything.
View 2 Replies
View Related
Apr 28, 2008
How to check , whether sql mail is configured or not using TSQL in sql server 2000?
------------------------
I think, therefore I am - Rene Descartes
View 4 Replies
View Related
Oct 10, 2000
I'm trying to set up Sql Mail using Outlook 2000 and the only way I can get a message sent is to have the Outlook client open at the time I start Sql Mail. Sql Mail will start regardless of the profile chosen even if it is blank, but if the Outlook client was not running at the time I started Sql Mail then while executing xp_sendmail I get "Server: Msg 17914, Level 18, State 1, Line 0 Unknown recipient: Parameter '@recipients', recipient 'jcorriveau@homeruns.com'"
Regardless of the Outlook client status or profile setup when performing a MAPI profile test, <SQL MAIL><Properties><Test>, I receive "SQL-DMO(ODBC SQLState: 42000) Error 22030: A MAPI error(error number 273) occurred.:Unable to get the default MAPI Message Store due to MAPI error 273:The information store could not be opened."
I've setup Sql Mail and Outlook 97/98 clients in the past and have not had to have the client open when starting Sql Mail. I've read most of the technet and knowledge base articles and the only ref I can find to this problem is a note in Q248431 "note that outlook 2000 or another configured MAPI client must be started before xp_startmail is executed." Was this the case in Outlook 97/98?
The Exchange server is in another domain. I think it's version 5.5. I'm using my domain account and profile to setup Sql Mail. I can send and receive mail fine using Outlook 2000. There is a Password dialog box that appears when starting the Outlook client prompting for User Name, Domain Name, and Password. I have not been able to create a profile that gets around this dialog box. Is this an Exchange server setting? If so, is it a server wide setting or can it be disabled per mail account?
Any help with this will be appreciated. Thanks, Jim
View 2 Replies
View Related
Jan 28, 2002
I can't find the start option and the check box which says auto start when sql agent starts in 2000.
In sql 7.0 it was pretty simple to configure the mail.
First configure the MAPI, then restore the same in sql agent test it then go to suport service then right click on sql mail and select the profile and click start button there before this test the profile i know we had options such as auto start sqlmail when sql agent starts as well as start and stop in support service..
My problem is i don't see either of these information nor can i find the same..i tried everywhere but they seem to be lost some where..Can some let me know what exactly is the process to start and stop sqlmail in 2000.
I appreciate your help.
Thanx,
Harry
View 1 Replies
View Related
Apr 12, 2007
I have an SQL 2000 default instance.
On windows server 2003 sp1 machine that is joined to a domain.
This windows is not the domain controller.
There is a domain account domainuser.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.
This domain account has a mail account at Exchange 2007 server.
Office 2007 (including outlook 2007) is installed on the same windows server machine that SQL resides in.
In Control Panel - Mail - Profiles: Outlook is the profile used.
In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"
Any help please?
Bishoy
View 4 Replies
View Related
Nov 3, 2006
I have a client server that has win2000 on it with sql 2000 enterprise edition. The box has 4 gig of memory on it. I noticed today that the sql server was set to use all 4 gig (even though I know sql can't really access that memory because sql can't really utilize the 2-4 gig range). Is there overhead or a downside to leaving it at this, or should I set it to 2 gig
View 3 Replies
View Related
Apr 3, 2007
How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?
View 1 Replies
View Related
Apr 17, 2007
Hello All,
I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.
There is a domain account domainuser.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.
Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.
Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.
In Control Panel - Mail - Profiles: Outlook is the profile used.
In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"
I looked at
http://support.microsoft.com/?id=263556
I could not figured it out
Any help please?
Thanks,
Ven
View 7 Replies
View Related
Apr 23, 2001
I have not yet set up SQL2K mail -> Notes, but I see in Q263556 a warning regarding extended MAPI and non-Exchange servers.
Just wondering if anyone is using a SQL2K - Notes MAPI profile -- and if any reliability issues have come up?
Thanks in advance
View 1 Replies
View Related
Mar 5, 2007
EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'.
The dbo user for the msdb has admin priviledges. I'm stumped on what to do or look for.
Any suggestions? Thanks!
View 8 Replies
View Related
