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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-07-14 : 11:59:56
|
| hi everyone,This is 2005.I'm using sqlcmd to output a report to a folder that resides on another server.The agent job is able to create the report in \\Server2\E$\FolderAbut the same job is NOT creating the report when the target path is ... \\Server2\E$\FolderA\FolderBThe permissions to both folders look to be the same to me.2 questions:Is this kind of problem *always* related to folder permissions?The permissions of the job owner are used, is that correct?Thanks, John |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-07-14 : 13:55:24
|
| Thanks Tara.Oddly, when it does not generate the report, there is no error in the job history or in any SQL Server logs.The domain account that the Agent and MSSQL services run under has Full permissions to both folders.John |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2010-07-14 : 15:05:46
|
| Well, silly me.I had violated my # 1 rule by having a space in the folder name Failed LoginsChanged the folder name to FailedLogins and the SP to ref that name and now it writes the report. UghThanks for looking into it though.John |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Job Does Not Write Report to *SOME* Folders
Tara Kizer