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.
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.
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
Hi, I'm using Exchange server for our mail communication. If wanted to config SQL Mail in SQL Server 2000 is Ok 1. Insall outlook in sql server 2. US Exchange mail server name in sql mail or any procedure I need to do? Thanks, Ravi
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
I recently had configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
I recently have configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
I have recently configured a Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
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
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
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.
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.
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
Hi, I got a website and everything works fine with SQL Server 2000, but now I modified the way of authentication using Forms and when I enter in a protected area I got this error: An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by thefact that under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server) The problem is that I don´t have SQL Server 2005 installed so I don´t know why my webapp is trying to contact it, where I can configure this settings so it will look for the Server that exists? Thanks.
We have an 8gb SQL server running Windows Server 2003 Enterprise Edition that simply will not get above 3gb of memory usage. We are using SQL 2000 Enterprise edition, version 2040 - SP4. My boot.ini has been configured with /3gb /PAE. System Properties does list Physical Address Extension as being enabled. AWE is enabled, and has been verified in the SQL server logs. Lock pages in memory access has been given to the account SQL is started under. Under task manager, the process sqlservr.exe does not grow above 2,762,428 ish. Does anyone know why this is occuring?
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
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
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
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.
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
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.
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
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.
