Mapped Drives not Showing Up

Scenario:
Just connected a 2000 server running SQL 2000 to an Iomega NAS via a
crossover. Set both machines to be in the same workgroup and both have the
same local admin user and password. Also set the SQL service and the agent
service to run as the local admin.
Setup the NAS box to share and mapped the drives within explorer and all is
well. When I copied the database to one of the shared drives on the NAS
box and then try to restore it within Enterprise Manager the drive doesn't
show up?!?!?!?!
Any help would be greatly appreciated!
Enterprise Manager will show the local drives but not mapped
drives. It's usually better to use UNC paths rather than
mapped drives.
Just an FYI...if you are planning on storing database files
on the NAS, database files on network storage devices are
not recommended (but are supported using trace flag 1807).
See the following:
INF: Support for Network Database Files
http://support.microsoft.com/?id=304261
-Sue
On Wed, 31 Mar 2004 11:21:43 -0800, "Bob Smith"
<spamfree@.spam.com> wrote:

>Scenario:
>Just connected a 2000 server running SQL 2000 to an Iomega NAS via a
>crossover. Set both machines to be in the same workgroup and both have the
>same local admin user and password. Also set the SQL service and the agent
>service to run as the local admin.
>Setup the NAS box to share and mapped the drives within explorer and all is
>well. When I copied the database to one of the shared drives on the NAS
>box and then try to restore it within Enterprise Manager the drive doesn't
>show up?!?!?!?!
>Any help would be greatly appreciated!
>

Mapped Drives not Showing Up

Scenario:
Just connected a 2000 server running SQL 2000 to an Iomega NAS via a
crossover. Set both machines to be in the same workgroup and both have the
same local admin user and password. Also set the SQL service and the agent
service to run as the local admin.
Setup the NAS box to share and mapped the drives within explorer and all is
well. When I copied the database to one of the shared drives on the NAS
box and then try to restore it within Enterprise Manager the drive doesn't
show up?!?!?!?!
Any help would be greatly appreciated!Enterprise Manager will show the local drives but not mapped
drives. It's usually better to use UNC paths rather than
mapped drives.
Just an FYI...if you are planning on storing database files
on the NAS, database files on network storage devices are
not recommended (but are supported using trace flag 1807).
See the following:
INF: Support for Network Database Files
http://support.microsoft.com/?id=304261
-Sue
On Wed, 31 Mar 2004 11:21:43 -0800, "Bob Smith"
<spamfree@.spam.com> wrote:

>Scenario:
>Just connected a 2000 server running SQL 2000 to an Iomega NAS via a
>crossover. Set both machines to be in the same workgroup and both have the
>same local admin user and password. Also set the SQL service and the agent
>service to run as the local admin.
>Setup the NAS box to share and mapped the drives within explorer and all is
>well. When I copied the database to one of the shared drives on the NAS
>box and then try to restore it within Enterprise Manager the drive doesn't
>show up?!?!?!?!
>Any help would be greatly appreciated!
>

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

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 Schlüter Persson
Databaseadministrator / Systemadministrator|||Steen Persson (DK) wrote:
> Nikola 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 Schl=FCter Persson
> Databaseadministrator / Systemadministrator
If you mapp drives in SQL Server through xp_cmdshell using net use SQL
Server can see it.
Regards
Amish Shah|||Hi,
Take a look int below URL.
http://support.microsoft.com/default.aspx?scid=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 Shah