Map to Network Drive By SQL SP

Question

Is there any way to map to a network drive by using a stored procedure? I have tried:

xp_cmdshell 'net use Q: [shared_network_drive] [pwd] /user:[username]'

but I got an error saying something like

'System error 1312 has occurred.'
'A specified logon session does not exist. It may already have been terminated.'

However, when I run the same command in a cmd console in the same box as the SQL server machine, there is no problem at all. It looks like that SQL process does pass correct logon credential information. Any way to do it by SQL SP?

Answer 1

In an other forum someone posted a tip about how to solve the System error 1312 has occurred. problem by specifying the username including its domain like this:

net use Q: \\[host]\[folder] [pwd] /user:[host]\[username]

I tried it and it worked for me.

Answer 2

I spent one hour, but the problem solves: You must specify [HOST]\[username] If you write like this: u:/username - it doesn't work