?
Solved

Drive Mapped in SQL Not Showing Up

Posted on 2013-05-31
3
Medium Priority
?
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

770 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