Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thinknight
Starting Member
3 Posts |
 Posted - 2010-04-08 : 05:20:56
|
| Hi all,I want to take my backups to a shared folder on a different location, But i could not.First i added my sql server machine local system account as COMP1$ to the sharing securities and also to the permissions. Because in my SQL Server Computer (COMP2), SQL Services start with this account.But, While i am taking backup, i get ACCESS DENIED error.Second Case, When I restart My SQL Server Services on COMP2 with a domain account and give permissions to the this domain account on SHARED LOCATION(on COMP1). It succeeded.Where am i doing error?Is syntax wrong while adding COMP1 Computer Local System Account as COMP1$ ?Now, Adding COMP2's Local system Account is preferred. What do i have to do?Waiting your responsesRegards, |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-08 : 06:05:24
|
| This problem is the reason why SQL Server should be setup to run under a domain account. The setup process will grant the account the necessary permissions to run SQL Server.There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
|
|
|
Local System Account on a share on different machi