Mapped drives

Hi,
Why new SS2005 doesn't see mapped drives anymore?
I use SS2005, SP1
Thanks in advance
Nikola MilicNikola Milic wrote:
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>
>
Hi
I don't know if there're any difference in this compared to SS2000, but
the question is why do you want to see/use mapped drives? It's
recommenced to use UNC path rather than mapped drives.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||Steen Persson (DK) wrote:

> Nikola Milic wrote:
> Hi
> I don't know if there're any difference in this compared to SS2000, but
> the question is why do you want to see/use mapped drives? It's
> recommenced to use UNC path rather than mapped drives.
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator
If you mapp drives in SQL Server through xp_cmdshell using net use SQL
Server can see it.=20
Regards
Amish Shah|||Hi,
Take a look int below URL.
http://support.microsoft.com/defaul...kb;en-us;304261
Thanks
Hari
SQL Server MVP
"Nikola Milic" <hotmnikola@.hotmail.com> wrote in message
news:OXpZooK0GHA.3440@.TK2MSFTNGP06.phx.gbl...
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>|||Nikola Milic wrote:
> Hi,
> Why new SS2005 doesn't see mapped drives anymore?
> I use SS2005, SP1
> Thanks in advance
> Nikola Milic
>
The drive mappings must be created under within the profile of the user
that the SQL Server service is running under. In other words, if SQL is
running as "DOMAIN\SQLServiceUser", and you create the drive mappings
while logged in as "DOMAIN\MyPersonalUser", the mappings won't be usable
by SQL.
As Steen indicated, it is preferred and advised to use UNC path names,
and not drive mappings.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thank you all for help
And special thanks to Amish - that is what I wanted.
Nikola
"amish" <shahamishm@.gmail.com> wrote in message
news:1157450921.948672.98340@.h48g2000cwc.googlegroups.com...
If you mapp drives in SQL Server through xp_cmdshell using net use SQL
Server can see it.
Regards
Amish Shahsql