[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

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.
0
Gary Harper
Asked:
Gary Harper
  • 2
1 Solution
 
Ephraim WangoyaCommented:
Mapped drives are not visible to SQL server.
Use the long path \\xxxx
0
 
Ephraim WangoyaCommented:
Just to be precise

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

or share name

\\server\foldershare\....
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
and make sure that the 'sql server service account has enough permissions to access that share
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now