xp_cmdshell reading a novell network drive 
Author Message
 xp_cmdshell reading a novell network drive

me again...
Ive decided to use the xp_cmdshell function in ISQL/W on
the client (Windows 3.11 but could use NT 4.0)
to kick off ISQL on the server (NT 3.51, SQL Server 6.0) so that I
can get a query to spool its results to a text file and everything works
except..
I would like ISQL to read a query from a Novell network drive and
write the results to a network drive but when I try and do something
simple like
xp_cmdshell 'dir o:\' (where o is the network drive) I get

'The specified user does not exist'

I am able to do anything to the c: drive but not to the network drive
although I know the server has access to the drive (and is mapped to it).
The only setting I can find is the 'xp_cmdshell impersonate client'
setting which I think should not be set (although Im not sure) but still
no luck.

If someone can tell me how to get this working (in language I
understand) I promise never to hassle this workgroup again (until the
next problem:-)

=========================================================================
Michael McSkeane



Mon, 26 Jun 2000 03:00:00 GMT
 xp_cmdshell reading a novell network drive

Michael,

 Go to control panel/services.  Highlight the MSSQLSERVER service and
choose startup.  Change it to run under a user account that has
privileges to the Novell share required.  You'll have to specify the
Novell drive as a UNC path rather than  as a drive letter.

 Neil Pike MVP/MCSE
 Protech Computing Ltd



Thu, 29 Jun 2000 03:00:00 GMT
 xp_cmdshell reading a novell network drive

Im sorry to bother you but you were kind enough to respond to my news
item so I thought it was worth a try to get this problem resolved

As you can probably tell the problem still exists and its getting a bit
infuriating. The first thing I don't understand is your reference to the
UNC path. I might sound a bit thick but all it asks on the MSSQLSERVER
startup option is if you want to use the sign in user or another.Ive
tried changing it to the specific NT/network user but it doesn't help.
Also, what is the relationship between the person that is logged into the
NT Server and the person using ISQL/W. Let me expand....
The user/password that logs into the NT server is the same
user/password that has network access. Does this also have to be the
same user/password that logs into ISQL/W?

As you can probably tell I am relatively new to both NT and
SQLServer and I don't wish to hassle you but any help will be
appreciated.

Thanks  
MMc


Quote:

>Michael,

> Go to control panel/services.  Highlight the MSSQLSERVER service and
>choose startup.  Change it to run under a user account that has
>privileges to the Novell share required.  You'll have to specify the
>Novell drive as a UNC path rather than  as a drive letter.

> Neil Pike MVP/MCSE
> Protech Computing Ltd

=========================================================================
Michael McSkeane



Mon, 03 Jul 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. xp_cmdshell not seeing newly created folder on network drive

2. Cannot DiskDump to a network drive on a Novell Server

3. SQL*net on HP-UX and client using Novell network Drive

4. Read only MDB on Novell network

5. DTS can't read from network drive?

6. Reading network drive with Reportsmith

7. How to read files which locate network drive ?

8. Error reading Network Drive

9. Indexing a network read only drive

10. Infamous: Network error reading drive..

11. SQL Server access on Novell network without Client for MS Networks

12. xp_cmdshell and Shared Drives


 
Powered by phpBB® Forum Software