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.
| Author |
Topic |
|
noxipoo
Starting Member
3 Posts |
 Posted - 2005-05-04 : 04:35:23
|
| Hi, I'm a SQL admin newbie because our last one left and I was given it. Now, I have a few concerns and questions before I begin making changes to the server.Windows 2000 serverMS SQL server 2000We have an Active Directory network and using exchange for e-mail. I wanted to setup MSSQLMail and SQLAgentMail so I can have people e-mailed when problems arise. Our server is setup to login as an local administrator account and then using a domain account to connect to the network. From the MS documentation, it looks like I will need to have it login to the domain, setup an outlook profile and then SQL server can send out e-mail. My question would be, any way to set up the profile using the local admin account and still have it work from SQL server? I'm not sure why it is running on local admin account and I didn't want to change anything until I know what I'm doing.Second question is, I read various people saying running the MAPI enabled software on SQL server is dangerous. What security concerns are there on the server that would make it a concern?Thanks for any info. Greatly appreciated. |
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-05-04 : 11:35:13
|
| You can try to use XPSMTP. It does not require any software to be installed, just a SMTP email server.Detail see the following link.http://www.sqldev.net/xp/xpsmtp.htmWendy |
 |
|
|
|
|
|
MS SQL server 2000 setting up SQL mail issues.