Drive Mapped in SQL Not Showing Up

When I map a drive using the xp_cmdshell net use command it executes successfully.   However the drive is not available in my computer.  If I run the net use statement from the command prompt it maps successfully.  However my issue is that if I run it from the command prompt the mapped drive still is not available in SQL Management Studio.  Has anyone come across this issue before?  Please advise.
Gary HarperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ephraim WangoyaConnect With a Mentor Commented:
Just to be precise

\\server\c$\folder1\.....

or share name

\\server\foldershare\....
0
 
Ephraim WangoyaCommented:
Mapped drives are not visible to SQL server.
Use the long path \\xxxx
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
and make sure that the 'sql server service account has enough permissions to access that share
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.