Configuring SQLServerAgent 2000 Mail Session

Apr 3, 2007

How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

View 1 Replies


ADVERTISEMENT

Configuring SQL Mail - Help Please

Jun 18, 2001

Hi all,
I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).

Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated.
thanks in advance.
regards..

View 5 Replies View Related

Configuring SQL MAIL

Aug 4, 2005

Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V

View 1 Replies View Related

SQL Mail - Configuring

Sep 27, 2006

wasnt sure which forum to put this in - so i'll attempt 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.

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 \EnterpriseIPC$' 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

View 1 Replies View Related

Sql Server Mail Session

Jan 18, 2002

when i start mail session
there is a message poping up as
"Error 17952:Faild to Start SQl Mail Session"

When i test From Sql Mail Configuration
i get a message "succesfully Started(and stopped)a MAPI session with this profile"

& still i cannot start the sql mail service"
i still get a error

what could case for this error

View 1 Replies View Related

Test For SQL Mail Session Started

Feb 27, 2001

I call a stored proc from an ASP page that eventually makes a call to xp_sendmail to email a confirmation back to our visitor. It all works fine as long as the Exchange Server hasn't crashed and therefore, rendered the SQL Mail session dead. Unfortunately, when this happens (which has been all too often recently), the web visitor gets the following message:

Number: -2147217900

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Mail session is not started.

SQLState: 37000

Native Error: 17966

Is there a way I can check for this in the stored proc that calls xp_sendmail so I could still return to the ASP page and prevent the web visitor from seeing this error.

I've searched high and low to no avail.

Thanks,
Laura Stamps

View 1 Replies View Related

Sql Mail Session Startup Account

Mar 31, 2003

Hi,

Is there any way to use different email accounts for sql mail dynamically on sql server 2000?

Here is the problem:

My sql server is configured to start mail session under account 'xxnotifyxx'.

There are many jobs scheduled to run queries and send out emails to different user groups within the company as well as outside the company from 'xxnotifyxx' as a sender.

However, one of the usergroup within the company is asking for sending out their emails ( from scheduled tasks that uses xp_sendmail ) using 'publishergroup' as a sender.

As far as I know, this is not possible (sql server 2000, exchange 2000 client win2000 ) until I change the mail session configuration to start under 'publishergroup' in stead of 'xxnotifyxx'. If I do this, 9 other groups have problems with this.

Is there a work around for this kind of situation?

Thanks,
Shaili

:rolleyes:

View 1 Replies View Related

Failed To Start SQL MAil Session

Aug 18, 1999

Hello!
I created SQLServer account which suppose to launch MSSQLServer and
SQL mail serveces.
But when I try to stop and then run SQL Server through Command promt
I see error message:
" Starting SQL Mail session....
Error: 17903, Severity:18, state:1
MAPI login failure
Error: 17951, Severity:18, state:1
Failed to start SQL MAil session"
Please save my life. If you have any idea what I have to do to fix up
problem let me know.

Thank you.
Alona

View 1 Replies View Related

Configuring Database Mail In SQL Server 2005

Aug 20, 2007



Hi

I have created profiles in my database as mentioned below. now i want to delete the profile created in database.
can some one tell me how to proceed furthur.

i need to delete them permenantly.
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'MyMailAccount',
@description = 'Mail account for Database Mail',
@email_address = 'makclaire@optonline.net',
@display_name = 'MyAccount',
@username='makclaire@optonline.net',
@password='abc123',
@mailserver_name = 'mail.optonline.net'
-----------------------------------------------------
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'MyMailProfile',
@description = 'Profile used for database mail'
--------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'MyMailProfile',
@account_name = 'MyMailAccount',
@sequence_number = 1

-------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'MyMailProfile',
@principal_name = 'public',
@is_default = 1 ; Regardskrishna

View 4 Replies View Related

Failed To Start SQL Mail Session In Enterprise Manager

Jun 5, 2001

I cannot understand why I cannot get my sql mail to work properly. It was working fine a couple of days ago. My mail profile is setup using Outlook. The only problem is that when I go to services and check the Mssqlserver & sqlserveragent, they are now logging in as the system account, but when I attempt to change them to the administrator account it says error 1057 occured: the account name is invalid or does not exist, yet it does. Anyone have any idea how to rectify this? this is what is on the error log:Error: 17919, Severity: 18, State: 1
2001-06-05 14:09:16.33 ods Invalid session..
2001-06-05 14:09:16.34 ods Error: 17951, Severity: 18, State: 1
2001-06-05 14:09:16.34 ods Failed to start SQL Mail session..

Thanks,
Jerry

View 1 Replies View Related

SQL Server Agent &> General Tab &> Mail Session Is Greyed Out ??

Feb 22, 2004

Hi All,

Great forum y'all have going here.

Just wondering if anyone else has experienced this?

Enterprise Manager:
I have setup and 'sucessfully tested a MAPI session' with a mail profile via support services > sql mail. That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.

scenario is:
Windows Server 2003 SBS edition
SQL Server 2000 SP3
Exchange Server 2003 is also running on the server, with Outlook 2003 client (so i suspect side chaining issue).

Any help appreciated! did not have any luck googling or using microsoft KB.

View 12 Replies View Related

Configuring Mail For SQL Server Agent - Problem With Exchange And Outlook On Same Machine?

Jul 23, 2005

I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana

View 1 Replies View Related

Sql Mail Failed., Need Help To Set Up Sql Mail In Sql Server 2000

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

Store Session State In Sql 2000?

Apr 17, 2007

I'm currently storing session state in a sql 2000 server for my vs.net 2002 projects. I'm currently developing a new project using vs.net 2005 and was wondering if I could store the session state in the same sql server. Does anyone know if this is possible? If so can someone point me in to an article or code example. All of the examples I have come across are for sqlExpress.
Thanks in advanceJason

View 1 Replies View Related

Configuring Merge Replication For Side-by-side SQL Server 2000 And 2005

Feb 6, 2007

I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing.

So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running both SQL Server CE 2.0 and SQL Server 2005 CE to sync with either back-end server.

Can someone provide me with guidance as what is possible to set up here? I know that SQL Server 2000 and 2005 can be installed side-by-side on the same server. It also appears that you can set up SQL Server 2000 so that EITHER SQL Server CE 2.0 OR SQL Server 2005 CE can sync with SQL Server 2000 (see www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx), but I don't know if it's possible for BOTH SQL Server CE 2.0 AND SQL Server 2005 CE to sync to the same SQL Server 2000. As for SQL Server 2005 ... it appears to be possible to set up SQL Server 2005 so that BOTH SQL Server CE 2.0 devices AND SQL Server 2005 CE devices can sync to the same SQL Server 2005 (see web page cited above). However, I don't know if it's possible to set up a SQL Server 2005 server installation in this manner while at the same time having a side-by-side SQL Server 2000 installation supporting any level of mobile merge replication.

HELP!!!!

View 7 Replies View Related

SQL Server Session State - Using A 1.1 Database Schema For 2.0 Session State Storage

Aug 3, 2006

The 2.0 version of ASPSTATE is slightly different than the 1.1 version in that one table has one additional column and another table uses a different data type and size for the key. The 2.0 version also has a couple additional stored procedures.

We'd like to manage just one session state database if possible so we're trying to figure out if Microsoft supports using the new schema for 1.1 session state access (it seems to work, but our testing has been very light).

Is there any official support line on this? If not, can anyone comment on whether or not you'd expect it to work and why?

Thanks.

View 1 Replies View Related

SQL Mail For 2000

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

SQL Mail In SQL 2000

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

Sql Mail And Outlook 2000

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

SQL Server 2000 Mail

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

Sql Mail In 2000 Urgent

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

SQL Mail Problem At SQL 2000

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

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 View Related

Sending Mail Using SQL Server 2000

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

How To Configure IMAP Mail Server And SQL 2000 ?

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

How To Send Mail Everyday At 3:00 AM In SQL Server 2000

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

SQL Mail Problem At SQL 2000 And Lotus Notes 6.5

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

SQL 2000 MAPI Mail Interface To Lotus Notes

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

Using ASP Mail To Send Mails From MSSQL 2000 Server

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

Permission Denied W/ E-mail Subscription W/ SSRS 2000

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

SQL Server 2000 - Send A Mail By Stored Procedure

Mar 3, 2008

can I send a mail by stored procedure?

View 5 Replies View Related

Database Name With Point In It (mail.archive.mdf) Not Recognised In Query Analyser Of SQL 2000

Jun 21, 2006

Apparently the query analyser of sql server does not recognise adatabase with a point in it, likemail.archive.mdfI receive the following error when I use it:Server: Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'mail'. No entryfound with that name. Make sure that the name is entered correctly.Please help, thanksPrem

View 2 Replies View Related

SQLServerAgent

Mar 30, 2000

What would cause this message to display or what does this mean??
"Could not start the SQLServerAgent Service, error 2186, the service is
not responding to the control function"

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved