Re: Backup to NAS storage

You can run the SQL service under a domain user account that has local admin
rights. If you don't want to do this, there is a KB article that shows what
rights need configured for a domain user in order for SQL Server to function
properly. Once you do this, you can set the security on the NAS to allow
this domain user account permission to write to it.



"Cyber-Guy" <cyber-guy@xxxxxxxxxxxxxx> wrote in message
news:eH0amgxiGHA.4044@xxxxxxxxxxxxxxxxxxxxxxx

Greetings,

I've got a small/big problem, which is the following.

Got a server running Windows 2003 server with SQL 2000 and would like to
backup my database to a NAS. I was able to configure the NAS to allow the
domain Administrator user to access it with the write and read
permissions.



My problem due the authentication that SQL uses is not the Windows user
I'm not able to do a backup to the NAS storage.



My idea and question. If I change the SQL service to run using the
administrator user will there be some conflicts with the SQL or database?

Or am I just not seeing the whole picture?



Any ideas?



Thanx in advance.




.

Relevant Pages

  • Re: SMS Backup Task
    ... > domain user, it is more supposed to be more secure. ... > testing here that SMS does not support SQL running as a domain user ... >> Is your SQL Server service account a local administrator on the server? ...
    (microsoft.public.sms.admin)
  • Re: SMS Backup Task
    ... domain user, it is more supposed to be more secure. ... testing here that SMS does not support SQL running as a domain user account ... > Is your SQL Server service account a local administrator on the server? ...
    (microsoft.public.sms.admin)
  • Re: ASP .NET 2 Remoting User identity
    ... I'm writing a custom sink to get around the ... application connects to MS SQL with a trusted connection. ... custom APP Pool, map it to a domain user, and map that domain user via ... Are you sure this is not a SQL server user account authentication problem? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Domain or Local User Account for Laptop SQL 2008 Services
    ... In my former test, I simply added my domain user account as a sysadmin in both SQL Server 2005 and 2008 instance, and they all worked fine when they were disconnected from the domain. ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.setup)
  • SQL Server using BlueArc NAS
    ... FiberChannel storage connected as NAS. ... They have many customers using SQL ... Server with their Titan setup, but I am still skeptical of using NAS vs SAN ...
    (microsoft.public.sqlserver.setup)