Urgent - SQL Mail Problem 
Author Message
 Urgent - SQL Mail Problem
The SQL server runs under services account
The machine runs under administrator
Ae exchange(outlook98) profile has been set up under the name SQLSERVER
This profile works as regards mail both when logged in to the PC as services
and as administrator.

Hwveer when I try to tell SQLMAIL the profile if gives an error which is
more or less

error 22030 error no 273 mapiLogonEx Mapi Logon failed

Any help would be appreciated



Tue, 29 Oct 2002 03:00:00 GMT
 Urgent - SQL Mail Problem

Mike,

This is rather simple matter, first of all which version of SQL Server we
are talking about 6.5 or 7.0

If 7.0 make sure that you have domain user account with Exchange mail box
assigned.
1. Configure Exchange profile in Outlook 98 properties for this domain
account
Please perform the test by logging to the SQL Server computer with this
account by sending E-mail, this test will confirm that Exchange profile
configured properly.
2. Make this account a member of Sysadmin group on SQL Server
3. Configure SQLServer and SQLAgent properties to start with this domain
account.
4. Restart both services and test SQLMail

Feel free to contact me if you encounter any problems.

                                Alex Glauberzon /MCSE,MCT,MCDBA/


Quote:
> The SQL server runs under services account
> The machine runs under administrator
> Ae exchange(outlook98) profile has been set up under the name SQLSERVER
> This profile works as regards mail both when logged in to the PC as
services
> and as administrator.

> Hwveer when I try to tell SQLMAIL the profile if gives an error which is
> more or less

> error 22030 error no 273 mapiLogonEx Mapi Logon failed

> Any help would be appreciated



Fri, 01 Nov 2002 03:00:00 GMT
 Urgent - SQL Mail Problem
Mike sorry for typing error please read Sysadmin role instead of sysadmin
group.

Alex

Quote:
> The SQL server runs under services account
> The machine runs under administrator
> Ae exchange(outlook98) profile has been set up under the name SQLSERVER
> This profile works as regards mail both when logged in to the PC as
services
> and as administrator.

> Hwveer when I try to tell SQLMAIL the profile if gives an error which is
> more or less

> error 22030 error no 273 mapiLogonEx Mapi Logon failed

> Any help would be appreciated



Fri, 01 Nov 2002 03:00:00 GMT
 Urgent - SQL Mail Problem
I solved this problem - it was to do with the user account that the server
had been set up with.

Basically I silved by creating a new user and altering the settings in SQL
Server and redoing the process.

However another question as regards mail.

Does anyone know whether it is possible to use sendmail to send messages in
a different language (ie: character set) to english in this case swedish.

The problem is that there are several characters not in the standard ascii
set such as "p? f?ljande s?tt".

The characters show up fine in SQLserver but when sendmail processes them
the extended characters drop out leaving the base text.

I tried persuading sendmail to send unicode but it had a wobbly and said it
would only accept varchar

Anyone any ideas

Quote:
> The SQL server runs under services account
> The machine runs under administrator
> Ae exchange(outlook98) profile has been set up under the name SQLSERVER
> This profile works as regards mail both when logged in to the PC as
services
> and as administrator.

> Hwveer when I try to tell SQLMAIL the profile if gives an error which is
> more or less

> error 22030 error no 273 mapiLogonEx Mapi Logon failed

> Any help would be appreciated



Sat, 02 Nov 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Problem in Setting SQL Mail / SQL Agent Mail

2. SQL mail Win2k with SQL 2k :: URGENT PLEASE

3. MAPI Spooler problem using mail using SQL Mail

4. Problem getting mail with SQL Mail

5. Problem wtih DTS Task for Send Mail and SQL Mail

6. Problem Using DDE : URGENT URGENT URGENT

7. SQL Server 2000 Mail URGENT

8. SQL MAIL WITH A SMTP SERVER - URGENT

9. SQL Mail Error, Urgent Please

10. SQL Mail - Urgent please

11. Using SQL Mail....VERY URGENT

12. sql problem SA problem urgent


 
Powered by phpBB® Forum Software