Read & Write Permissions on SQL Server Agent Service startup account

Question

Post reply

Read & Write Permissions on SQL Server Agent Service startup account

ssmith 29602

SSC-Addicted

Points: 422
More actions
November 19, 2012 at 6:17 am

#393629

How do I add read permission and write permission to the Temp directory of the SQL Server Agent Service startup account.
Many Thanks
Stuart.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

ESAT ERKEC SSCertifiable Points: 5661 More actions · Answer 1

You can give persmion temp folder SQLServerSqlAgentUser$InstanceName

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

ESAT ERKEC (11/19/2012)
You can give persmion temp folder SQLServerSqlAgentUser$InstanceName

I can't find this folder.

What is the entore path?

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Welsh Corgi (3/12/2013)
ESAT ERKEC (11/19/2012)
You can give persmion temp folder SQLServerSqlAgentUser$InstanceName
I can't find this folder.
What is the entore path?
Thanks!

It appears to mean, grant permissions on the temp directory to the SQLServerSqlAgentUser$InstanceName account.

Just interpreting

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Thanks.

The folder was hidden granted permissions and I still get the error.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I get this error when I attempt to run the Package using the Domain Account, SQLServerAgent.

Message
Executed as user: MyDomain\SQLServerAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 01:29:42 PM Could not load package "\Dev\AS400\CYP_Staging_Load_Truncate_Nightly" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for user 'MuDomain\SQLServerAgent'.). The SQL statement that was issued has failed. Source: Started: 01:29:42 PM Finished: 01:29:42 PM Elapsed: 0.046 seconds. The package could not be loaded. The step failed.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Is the package stored in msdb or filesystem?

Oh, and it would be a good idea to start a new thread for this. This was an old thread and appears to be slightly different

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

It is stored in MSDB, thanks.

I will open a new thread.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

I opened a new thread:

http://www.sqlservercentral.com/Forums/Forum1550-1.aspx?Update=1">

http://www.sqlservercentral.com/Forums/Forum1550-1.aspx?Update=1

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/