RE: SQLServer can't backup remotely (on Workgroups) unless Administrator?

From: Jivko Dobrev [MS] (jivkod@online.microsoft.com)
Date: 07/06/02 

From: jivkod@online.microsoft.com (Jivko Dobrev [MS])
Date: Fri, 05 Jul 2002 23:37:11 GMT

Hello Robert,

As you know, when the machines are members of a workgroup, the security
database is distributted and each machine must contain its own list of
users with defined credentials, which have the right to access its local
resources over the network.

If you are trying to commit a backup over the network, SQL Server as a
service will try to use its service account's credentials (name and
password) to authenticate to the remote machine. If you want this process
to succeed, the account must exist on the remote machine, it must match the
same password, supplied by the SQL Server and it must possess the
permissions to write to the appropriate share/folder. Only in this case,
the remote backup will succeed.

However, it is not recommended to use a workgroup for more than 5-10
machines network or especially - when you have an application server, which
may require remote access and operations. It would be much easier for you
if you place a single domain controller and operate in a domain-regulated
environment. At least, this would imply a much stronger security.

Hope that this information will be useful for you.
Have a wonderful day!
Jivko Dobrev

This posting is provided "AS IS" with no warranties, and confers no rights.