SQL Mail session.. MAPI login failure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

SQL Mail session.. MAPI login failure

Author

Topic

THNQdigital
Starting Member

15 Posts

Posted - 2004-03-15 : 09:47:06

HI ,

I am updating a sql server table ( 7.0) through an asp page ( using dsn). ( Table has one of the columns to store an emial id)
All these days eveyrthing was fine '
but suddenly i see
an error

"Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Mail session is not started."

I saw in MSSQL\LOG\ERROR file
MAPI login failure..
2004-03-15 19:43:22.19 ods Error: 17951, Severity: 18, State: 1
2004-03-15 19:43:22.19 ods Failed to start SQL Mail session..

Please let me know what is going wrong
Thanks
THNQdigital

raymondpeacock
Constraint Violating Yak Guru

367 Posts

Posted - 2004-03-15 : 10:11:12

Have you defined a valid SQL Mail Profile for the service to start under? If so, and it has been working in the past - has the password changed recently?

Raymond

THNQdigital
Starting Member

15 Posts

Posted - 2004-03-16 : 07:48:31

quote:
Originally posted by raymondpeacock

Have you defined a valid SQL Mail Profile for the service to start under? If so, and it has been working in the past - has the password changed recently?
Raymond

Hi RayMond, i am able to solve the problem, but still unable to exactly figure out how was it working earlier.. down is the explaination..

My settings when i was getting the error,

1) (EntprMGR)SQL Server Properties->Security tab
Authentication = SQL Server and Windows NT
Start up service account = system account

This account - My Nt Account and password ( server is also installe dusing the same accont)

2)SQL Server Agent -properties - General - System account
Mail profile = nothing
connection tab = USe sql server authetication ( valid uid and pswd specified)

What i changed to make it work

startup serice account tobe same as the account in which the server is installed ( this account = my NT account and pwd)
Now in Agent i specify the valid mail profile and say test then
"test is successfull"

Conclusion :
Recenlty the n/w on which server is installed is merged with another n/w ( to be abale to connect n/ws across regions)
i am just guessing may be " the setting were reset so started erroring out and prior to the n/w merge the settings were how i have set now..

Thanks
Best Regards
Bhat

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources