[Samba] Domain Administrator cannot map Samba Share from Windows 7

[Mark Foley]

I changed our Samba file server to be a member of the Active Directory domain. This way, domain
users on Windows 7 workstations can map Samba shares with domain credentials automatically. That
bit works fine.

Problem #1: 

I use the Domain Administrator account (Administrator) as the main login account for the SQL
Server host (also Windows 7).  I can still log into that host with the Administrator
credentials, but I can no longer map Samba shares even though I enter the correct domain
credentials.  I now get "Access is denied".  I can map the Samba shares on that host using the
credentials of other domain users (actual users). 

I probably shouldn't have used that account in the first place, but I did. Is there a way
around this or do I have create a new domain account for this purpose? 

Problem #2:

In one of the SQL Server scripts, I have:

SET @NetworkPath = '\\OHPRSstorage\Backups\SQLServerBackup\'

which used to work before I changed OHPRSstorage (the Samba file server) to be a domain member
and do AD authentication. This script is run as SQL Server user 'sa', which likely has no
authorization to access the NetworkPath. I'm not even sure what userID it uses to try the
access.

Is there a way around this?

Thanks, Mark