?
Solved

Mapping a local folder to a drive letter in Server 2008

Posted on 2011-09-06
16
Medium Priority
?
239 Views
Last Modified: 2012-08-13
I would like to know if it is possible to take a local folder such as e:\development (local on server 2008) and assign a drive letter to it, so all clients see the e:\development folder as g:?

For example:
orginal path -> e:\development

Clients (scripts) that connect to the server see the above path as g: locally.  

I am asking since we have an in-house app that will only recognize a hard coded drive letter not a UNC path or share.  I know, I know.. not the best practice however I am not the developer, I just need to know if this is possible and if so, how to do it.

subst g: e:\development will not work in this case since it is user based and we do not want to keep a user logged into the server at all times.

Please shoot me any ideas you may have.  Thanks!
0
Comment
Question by:TCLiven
[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
  • 8
  • 3
  • 3
  • +1
16 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36489808
You say "All Clients"(Scripts)  Where are these running? On the server as services?
Cause you also say Clients (Scripts) That "Connect" to the server?

Some more info please.
0
 
LVL 5

Expert Comment

by:MAdS
ID: 36489828
Use SUBST on the server. Command SUBST associates a drive letter to a local path.
Example: SUBST G: E:\DEVELOPMENT.
0
 

Author Comment

by:TCLiven
ID: 36489954
Good catch..
The developer states locally run scripts as well linked server activities.  I asked for more detail but have not heard back as of now.  Didn't know if this was enough to put you in the right direction.
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

by:TCLiven
ID: 36489959
@MAds:  Please see my comment above...

subst g: e:\development will not work in this case since it is user based and we do not want to keep a user logged into the server at all times.

0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36490048
Yeah you said Subst wouldnt work in your question.

IF you talking about local on the server running as a service then I am not sure how you can do it.
Is the software developed IN-House?
0
 

Author Comment

by:TCLiven
ID: 36490059
Yes, the app is a home grown one. :(
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36490201
Then tell your developer to Write code that works in a real world :D
0
 

Author Comment

by:TCLiven
ID: 36494947
:o)  He actually is stating that the obstacle is getting SSAS for the storagelocation setting to accept it in SSMS and BIDS.  I guess it expects a drive letter...  Anyone got any insight in that?  I will continue to research...
0
 
LVL 17

Expert Comment

by:OriNetworks
ID: 36495001
I don't understand, why can't you have a startup script with the subst command to map the folder to a drive letter? That way it will map for each user that logs onto the machine.
0
 

Author Comment

by:TCLiven
ID: 36495056
Hi OriNetworks -
Users are not specifically logging into the machine.  Scripts are being run via SSAS and BIDS per a SQL job.  Is there a way for a script to kick off with the SQL job that will perform the subst command w/o an actual login?  
0
 
LVL 5

Expert Comment

by:MAdS
ID: 36497480
What you are trying to accomplish, literally, doesn't make sense:
"Clients (scripts) that connect to the server see the path e:\development as g: locally."

Local folder OR drives in Windows servers are perceived remotelly through shares. Drives has default administrative SHARES as  C$, D$, etc. In order to map a server drive, you have to map that SHARE as "\\servername\driveletter$".

If there is a client that expects to use server drive G as a "local" drive G, it must map that administrative SHARE as a "local" drive letter as in "NET USE G: \\servername\G$". After that, further references to server data is done through client drive letter G:.

So, if you have a script that has that NET USE command, just change that command to "NET USE G: \\servername\DEVELOPMENT", where DEVELOPMENT is a share to server folder E:\DEVELOPMENT. After that, further references to server data is done through client drive letter G: as it was before.

Please clarify why that is not a solution.
0
 

Author Comment

by:TCLiven
ID: 36498076
Unfortunately I cannot explain why this is not a solution.  I have to rely on the developer stating if it will work or not and I am told that it does not work.  We have decided to rebuild the server (thank goodness, it is not production) to what will work with the developers/SSAS coding... Thanks anyways.
0
 
LVL 17

Accepted Solution

by:
OriNetworks earned 1000 total points
ID: 36499078
The experts have proposed several solutions but you are unable to communicate why this does not work which doesn't seem fair. I recommend getting your developer to better communicate the issues with these solutions and I am especially worried for you because I can't seem to figure out how a rebuild of the server will help your situation.

If you wanted to redistribute drive space to create a new partition there are utilities to help you do this without such a drastic change, even built into windows.

Another possible option would be to mount an iso image as read/write.

Yet another, albeit costly, the possibility of adding a physical drive, or using iscsi technology to mount space from a different server or the same server as its own drive letter.

I'm sorry your choice was to rebuild the server with my final advice being, don't accept "it just won't work" as an answer.
0
 
LVL 5

Expert Comment

by:MAdS
ID: 36505956
Maybe the script can not work directly with a share as "\\server\share\somefile", but once a share is mapped to a drive, the file will be seen as "X:\somefile", and applications will not be aware that a share was involved. There is no way for a client to access a server drive/folder that is not through a share and rebuilding the server will not change that.
0
 

Assisted Solution

by:TCLiven
TCLiven earned 0 total points
ID: 36560747
All - thank you for your advice and help however I do not have time or the convenience to second guess my programmers abilities to get something to work within his code.  Yes, I know this was something that should have been an easy fix with shares and yes, I too do not understand why it will not work...

I push as far as I can and then a decision must be made with the talents available.  I did not have to rebuild but I did add additional larger drives to accomodate the task at hand, which then I was able to parition the new drives and give them the drive letter the developer needed for his code to work.  It was not the quick fix I was looking for with my initial question, but the end goal is accomplished.  I understood the 'work arounds' that everyone gave and I appreciate them however they would not work with what the developer was trying to accomplish per the developer.    
0
 

Author Closing Comment

by:TCLiven
ID: 36591675
Please see comments above.  Even though I added the add'l drives prior to OriNetworks suggestion, it was the same thing we came up with.  So I gave him the points.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

765 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