INF: Using SQLMail with a NetWare Post Office

• Microsoft SQL Server, versions 4.21 and 4.21a

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:

1. 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.

2. Set up the Win32 Mail client (MSMAIL32.EXE) to connect to the NetWare post office using the drive letter specified for the gateway connection.

3. Verify that the user setting up SQLMail can successfully start a mail session, then send mail using the Win32 mail client.

4. 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
   

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q118501
   TITLE     : INF: Troubleshooting SQLMail Problems