I am developer and not db admin.
My boss wants that his clients would have possibility to use SQL Mail without installing MS Exchange or any mail server.
I.e. using webmail.
I configured and tested POP3 client (MS Outlook) to use
(i.e. webmail with free support of POP3 cleints)
. It is also account name. I added user .\firstname.lastname@example.org (belonging to administrator ) as start-on account of MSSQLServer (Developer Edition) and SQL Server Agent on my Windows XP Pro (workstation) with MS SQL Server 2000 (Developer Ed., SP3a) through services.msc.
Unfortunately, MAPI Profile added through Control Panel âMail (or MS, what is the same, through MS Outlook) doesn't appear in SQL Mail configuration and writing its title there gives an error.
I also gave access to user
in MS SQL Server 2000 but when I am trying to connect in MS SQL Server Query Analyzer using SQL Server authentication option with login name .\email@example.com, the connection fails with:
SQL Query Analyzer
Unable to connect to server SQLServerName
Server:Msg 18456, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '.\firstname.lastname@example.org'
Why does login fail?
Is it possible to use webmail POP3/SMTP access in SQL Mail?