INF: Using SQLMail with a NetWare Post Office (126726)

SUMMARY

When you run Microsoft SQL Server on Windows NT, you need to run the SQL Server service under the system account (sometimes called the LocalSystem account) in order to have SQLMail functionality.

A service running under the system account has no user account information to use when accessing remote resources. Therefore, the SQL Server service cannot directly access certain server software, including Novell NetWare.

However, it is still possible to set up SQLMail to work when the mail post office is on a Novell NetWare file server. This can be done by going through the Gateway Services for NetWare, which ship with Microsoft Windows NT version 3.5.

MORE INFORMATION

You can follow the steps below to set up SQLMail to work with a NetWare post office:

Set up a gateway share on the Windows NT Server to point to the post office share on the NetWare computer. This step will require supplying a valid NetWare user account and password for an account that has RWCD access to the post office share. For more information on how to set this up, see the Windows NT documentation on the Gateway Services for NetWare.
Set up the Win32 Mail client (MSMAIL32.EXE) to connect to the NetWare post office using the drive letter specified for the gateway connection.
Verify that the user setting up SQLMail can successfully start a mail session, then send mail using the Win32 mail client.
In the SQL Setup program, go to Set Server Options, Mail Login and select the check box for Copy SQLMail Configuration From Current User Account. This will copy the mail client configuration information from the current user account into the following location in the Windows NT registry:
```
      \\HKEY_USERS\.DEFAULT\Software\Microsoft\Mail\MicrosoftMail

						
```

Once you successfully complete the above steps, you can set up SQLMail to start automatically when SQL Server starts, or it can be started manually using the xp_startmail extended stored procedure with a valid mail username and password.