xp_create_subdir() returned error 161, 'The specified path is invalid'

• BallaKet

  Mr or Mrs. 500

  Points: 593

  More actions

  July 5, 2015 at 5:00 pm

  #305543

  Hello!

  I created a new job that keeps on failing with the following message:

  "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly..."

  Any help is greatly appreciated.

  Thanks,

  BallaKet

• sgmunson

  SSC Guru

  Points: 110639

  More actions

  July 6, 2015 at 2:11 pm

  #1810572

  BallaKet (7/5/2015)

  ---

  Hello!

  I created a new job that keeps on failing with the following message:

  "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly..."

  Any help is greatly appreciated.

  Thanks,

  BallaKet

  The more obvious possible causes:

  1.) Folder specified as the base folder to create a subfolder within does not exist.

  2.) The SQL Agent service ID does not have permission to the folder in question (or possibly to the network share involved).

  Remember than an Agent job impersonates the service ID for everything a job needs to do from a permissions perspective.

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)

• Alvin Ramard

  SSC-Forever

  Points: 41190

  More actions

  July 6, 2015 at 2:35 pm

  #1810576

  BallaKet (7/5/2015)

  ---

  Hello!

  I created a new job that keeps on failing with the following message:

  "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly..."

  Any help is greatly appreciated.

  Thanks,

  BallaKet

  It might help if we could see the actual command as you tried to run it.

  ---

  
  Alvin Ramard
  Memphis PASS Chapter[/url]

  All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

  For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]