Issue Mapping letter drive in sql server 2008

• gunning423

  SSC Veteran

  Points: 245

  More actions

  July 25, 2012 at 1:29 pm

  #392830

  Hey Guys I was hoping someone might be able to enlighten me on a sql issue I'm seeing when mapping a network drive through sql. the original creator has since left the company, so any help on this would be greatly appreciated.

  Here is what I'm seeing:

  I run the following:

  EXEC master..xp_cmdshell ‘net use M: \\10.0.0.11\Master /user:administrator password’

  This worked fine as long as our IP was 10.0.0.11, that IP has now changed to 10.0.0.12 and running

  EXEC master..xp_cmdshell ‘net use M: \\10.0.0.12\Master /user:administrator password’

  results in the following:

  output

  row1) M: has a remembered connection to \\10.0.0.11\Master.....

  row2) Want to overwrite the remembered connection? (Y/N...

  row3) No valid response was provided

  row4) Null

  So based on the returned results I am assuming that a Y or something needs to be added to the above statement to say go ahead and overwrite the remembered IP, but nothing I've tried so far has worked. If anyone has any idea's on it let me know!

  Thanks!

  Bill

• Jared

  SSC Guru

  Points: 61793

  More actions

  July 25, 2012 at 2:59 pm

  #1517640

  Go to the command line on that machine and type "net use M: \\10.0.0.12\Master /user:administrator password"

  When prompted, press Y

  Jared
  CE - Microsoft