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 |
|
nzProgger
Starting Member
2 Posts |
 Posted - 2005-09-07 : 05:37:47
|
| Hey Im having troble getting SQL Mail setup.My current config is...A windows server 2003 with dns,dhcp,Ad, SQL Enterprise 2000, also acting as an exchange 2003 server.The clients run windows 2003 server, with an office xp install (Outlook included).The Domain Users accounts have been setup with mailboxs( as far as i can see) and i can send and recieve mail to and from client-server.The problem is setting SQL service mail profile.The drop down box is empty, even though the profiles are being used for the emailing.Is this happening because Im using Outlook XP? Would Outlook 2000 solve this...what about SQL service packs?Any help would be great!!!Steve. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-07 : 05:41:51
|
| you need to login to the server as the user that SQL Server runs under. If SQL Server is configured as LOCALSYSTEM, then you need to change that to to a real domain user that has a mailbox.ONce you login as that user, you need to configure the mapi mail profile. This is the same step you would go through when setting up outlook for your own use. After setting up the profile you should be able to see the profile name in the dropdown for sqlmail.This procedure is detailed in the microsoft KB articles on setting up sqlmail btw. -ec |
 |
|
|
nzProgger
Starting Member
2 Posts |
Posted - 2005-09-07 : 16:15:35
|
| Ok,So my server connects to the domain NWTraders, and i log in as Administrator. (NWTraders\Administrator)So for the service startup account i put NWTraders\Administrator and its asks to stop and restart sql service, i choose ok and it hangs until i kill the process.?Is NWTraders\Administrator not valid?Also my clients have SQL server on each of their machines called Lima, santiago, perth, etc...They connect to the domain using NWTraders\SQLAdminX where X is there computer number.What would i specify for their service accounts? |
|
|
|
|
|
|
|
|
SQL Mail