• AWESOME! Thanks!

    I had not been using xp_cmdshell to execute the net use command. I knew I was getting hung up in permissions but just didn't know where. Well, now I guess I will just really hope that a log shipping restore session won't break and all goes smoothly (save the time of re-doing log shipping). Have been testing on testing server and it's looking clean.

    EXEC sp_configure 'xp_cmdshell', 1

    GO

    RECONFIGURE

    GO

    exec master.dbo.xp_cmdshell 'NET USE.......