Wednesday, March 21, 2012

Problems Connect a Network Drive with SQL Server Agent

Hello
I have MS SQL 7.00.1094 on NT 4.0
When I connect a Network Drive (net use.../User:local User
on Remote System) with SQL Server Agent I cannot access
this.
If I take the same command on the desktop (Command Shell)
the access is o.K.
The SQL Server Agent is started with the same Account as I
logged on locally.
Even I connect a network drive z.B. U: local, I can not
access this from SQL Server Agent though is the same
global user.
But this Problem exist only 7 days ago.
Thanks
MartinDid someone add a proxy account to the SQL agent? Go to Enterprise Manger
and check the properties for SQL server agent | Job System tab. You should
verify then that you can map the drive with the proxy account.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Martin" <anonymous@.discussions.microsoft.com> wrote in message
news:106b801c3f46d$5ee8bef0$a301280a@.phx
.gbl...
> Hello
> I have MS SQL 7.00.1094 on NT 4.0
> When I connect a Network Drive (net use.../User:local User
> on Remote System) with SQL Server Agent I cannot access
> this.
> If I take the same command on the desktop (Command Shell)
> the access is o.K.
> The SQL Server Agent is started with the same Account as I
> logged on locally.
> Even I connect a network drive z.B. U: local, I can not
> access this from SQL Server Agent though is the same
> global user.
> But this Problem exist only 7 days ago.
> Thanks
> Martin|||A service, such as SQL Server Agent, is not supposed to be able to see
mapped drives. You should use a URL from a service.
180362 INFO: Services and Redirected Drives
http://support.microsoft.com/?id=180362
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment