Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS SQL server service

Status
Not open for further replies.
lalitha1

lalitha1

Programmer
Oct 14, 2008
57
US
Can someone help me with this ---How can I make the service account for MS SQL server service to have write permissions on a folder. Thanks!
 
Sort by date Sort by votes
My folder sits at Z:/Apps/DTS. All DTS packages are saved in the DTS folder, how can I make the service account for MSSQLSERVER service to have write permissions on this folder.
Thanks!
 
Upvote 0 Downvote
right click the folder and choose security.
 
Upvote 0 Downvote
The trick isn't to give the service rights to the folder, but the Windows account which the SQL Server is running under needs rights to the folder.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL BI 2005 / SQL 2008 DBA / SQL 2008 DBD / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005/2008 / BI Dev (SQL 2005)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SSIS in SQL Server 2022
Replies
4
Views
281
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
239
Cpreston
Cpreston
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
473
mark williams
mark williams
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
267
marydn
marydn
how2trainyourdragon
  • Locked
  • Question
SSIS Web Service task SSL errors
Replies
1
Views
167
how2trainyourdragon
how2trainyourdragon

Part and Inventory Search

Sponsor

Back
Top