Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Drive Mapped in SQL Not Showing Up

Posted on 2013-05-31
3
Medium Priority
?
354 Views
Last Modified: 2013-06-03
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
Comment
Question by:Gary Harper
  • 2
3 Comments
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 39211556
Mapped drives are not visible to SQL server.
Use the long path \\xxxx
0
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 2000 total points
ID: 39211567
Just to be precise

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

or share name

\\server\foldershare\....
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39211772
and make sure that the 'sql server service account has enough permissions to access that share
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question