SQL Server Service dilemma

  • Two conflicting requirements.

    1. Using Outlook as mail client requires that my SQL Server Service account is a domain account.

    2. I need to mount an nfs share on a Linux box and write files to it, requiring that my SQL Server Service account runs under a local system account. It will not run mount under a domain account.

    I can get one or the other to work, but not both. Are there any solutions? The platforms are SQL 2000, Outlook 2000,  and W2K3. What can I do?

    Thanks...Nali

  • This was removed by the editor as SPAM

  • You just need outlook configured under the USER account that SQL Server is using...  This needn't be a domain account or involve MS Exchange.  So you can have a local user account, configure Outlook for it (if the local account happens to have the same user/pass as a domain user account then Outlook can still connect to Exchange) and then let SQL use it...

    Hmm - actually I just reread your post and you are talking about LOCALSYSTEM rather than a LOCAL USER...  Why can't you mount your NFS share when logged on as a domain user account?

  • Its a share to a 4690. Don't know why, but the only way to get SQL to mount the share, and to be able to write files to it, is if SQL Server is running the local system account. Perhaps because its a Unix, and required Unix drivers installed on the Windows box to be able to mount it...

  • So when you are logged on as a user to this box (ie, looking at a windows desktop) can you get access to the Unix share?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply