Sean Sims
3/26/2007 2:11:00 PM
I was beginning to think that the Query Analyzer bypasses security
somehow. I'm using a SQL account for authentication. I've tried
adding every user/group that I can think of to the file system
permissions and the command still fails. I've tried, ASPNET, Local
Service, Network Service, IUSR_Machine, IWAM_Machine, ANONYMOUS LOGON,
SERVICE, SYSTEM, and even Everyone. I've also tried changing the
account that the MSSQL service uses and adding that account with Full
Control. I'd really like to get this working, but I don't know what
else to try.
-Sean
On Mar 20, 11:34 pm, "EMartinez" <emartinez....@gmail.com> wrote:
> I believe that OSQL sometimes bypasses SQL Server security/required
> permissions (at least, in SQL Server 2000). Are you sure that the user
> from the ASP application has sufficient privileges to restore the
> database and to access all parts of the physical file path?
> Traditionally, the ASP.NET user does not have adequate permissions due
> to possible Microsoft security risks. Sorry that I could not be of
> further assistance.
>
> Regards,
>
> Enrique Martinez
> Sr. SQL Server Developer