I need to enable the SQL Mail in our SQL Server 2000 server. However, we do not MS Outlook installed in the server where the SQL sits and we have a policy in our company not to install outlook in servers. Is there any way to enable SQL Mail without Outlook installed?
try The Bat
OR call the mail api from vb
Talk to your admins and explain the process so that they will allow you to add the outlook client to your server.
most reasonable people will change the group policy or allow you to block inheritance on the policy.(just for your servers)
I am in a situation that I cannot see a solution for. I need to set up SQL Mail on our servers without installing IIS or Outlook. We are using SQL Server 2000 on Windows 2000 Advanced Server. Our current mail client is Lotus Notes.
I have taken a look at the Bat link you provided, but I cannot see how that will help me here.
the trick in your situation is not the iis
web server is not neccessary in this situation
what you need is a mail server that is exposed externally and a client
i have set up sql mail on lotus notes with outlook 98 and 2000 and it works very well.
the previous article that indicates the ms kb article is an excellent situation.
your mission if you accept it is to choose either a third party client or create the programmatic solution from the kb article.
one last question,,,, what mail client is being currently used?
I never thought so... but KBAs are always reliable and useful, which is most suggested way to resolve the issues rather than using third party tools which has crumbling behaviour and dependant on enterprise to enterprise network setup.
And its my general tendency to refer a knowledgebase article issues by MS and discourage to enroute the solution.
Originally posted by Ruprect
you thiink you're so smart huh??!
that's a great kb article. i wish i would've found it first
all i had was my lame alternative email client...and some vb code..
i'm gonna have to use this solution in some of my more difficult consults.