| Author |
Topic |
|
vgv8
Starting Member
6 Posts |
 Posted - 2004-12-02 : 10:55:48
|
| SQLMail through webmail?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 account tstvgv@hotpop.com (i.e. webmail with free support of POP3 cleints). It is also account name. I added user .\tstvgv@hotpop.com (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.\tstvgv@hotpop.com 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 .\tstvgv@hotpop.com, the connection fails with:"SQL Query AnalyzerUnable to connect to server SQLServerNameServer:Msg 18456, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '.\tstvgv@hotpop.com'"Why does login fail?Is it possible to use webmail's POP3 and SMTP access in SQL Mail? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-12-02 : 13:17:43
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;263556-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
vgv8
Starting Member
6 Posts |
Posted - 2004-12-02 : 13:39:01
|
| I already have read a lot including this, quiet obvious, reference.Previously I configured succesfully SQL Mailhaving mail server inisde domain.I described exactly - what I was doing (along that reference).I have encountered concrete problems and asked concrete questions.So, has anybody had experience in configuring SQL Mailusing POP3 client provided through webmail? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-02 : 13:58:46
|
| Then frankly, the answer should be pretty obvious, exact, and concrete to you. It is to me.And if this reply sounds rude, re-read your reply. |
|
|
|
vgv8
Starting Member
6 Posts |
Posted - 2004-12-02 : 14:47:56
|
| I could not understand. Can u rephrase it? |
|
|
|
cindylee
Yak Posting Veteran
55 Posts |
|
|
vgv8
Starting Member
6 Posts |
Posted - 2004-12-03 : 06:15:27
|
| Cindy,this is great. From my p.v. It is free-lancer job... I should ask my boss - he told to send Email from MS SQL Server2000.Earlier I succeded in using SQL Mail in MS SQL Server 2000 Developer's on Windows XP workstation belonging to workgroup (even not to domain as explained in all docs, including link from first reply) having POP3 mail server remotely on local network. But boss then wanted to avoid in client installations having mail server. But the idea, as I understood, is to give to client-organisation the simplest universal solution. Might be I should ask why to send Email from SQL Server (really it is service of .NET application). And I am not system engineer |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-12-03 : 14:12:31
|
| I have set up SQL mail using the article I posted many times. If it is not working I suspect you have missed a step or done something not included in the article. I would suggest starting from scratch, and go step by step through the article rather than just saying you already tried that.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
vgv8
Starting Member
6 Posts |
Posted - 2004-12-10 : 06:27:40
|
| Yes, I also used it before without problems.BVut this reference does not give 100% correct advises. For ex.,"On the Microsoft Exchange server, set up a mailbox for the user account that is to be used by the MSSQLServer service. This account must be a domain account. "Earlier I used workgroup account without problems.I deviated or was not sure, and asked if it is possible, in part of:"SQL Mail requires a mail connection, a mailbox, a mail profile, and the Windows NT account you used to start SQL Server. This Windows NT account needs to be a domain account if you are using an Exchange server as your mail server. It can be a local or domain NT account if you are using POP3/SMTP mail server."That is I tried to use free POP3 server available on Internet. Whether it is possible?Also I configured local network account (workgroup, to simplify) with the name of webmail account and password. I configured and tested its use from Outlook. I restarted with MSSQLServer, etc. But that profile is not seen when I tried to add it to SQL Mail.There is No much sense to insist in what I do not understand well and nobody does. Cetainly I tried many timesBut it might be interesting from didactical p.v. |
|
|
|
|
SQLMail through webmail?