Re: Adding Network Devices !!??

Article View: bit.databases.mssql-l

Article #150

Back to bit.databases.mssql-l Previous Next

#150

From: Greg D. Moore
Date: Sun, 21 Jan 2001 03:39

40 lines
2609 bytes

Richard Gilbert wrote:
> 
> BP,
> 
> Ah, yes, I believe you hit the nail on the head.
> The Error Log Message contains the message "Operating System Error =
> 5(Access is denied.)"
> 
> However, SQL server has no trouble in, say, transforming data from files
> elsewhere on the network.
> 
> Are you saying SQL has read, but not write, access to the network?

That might be the issue.  Are you positive SQL server has no trouble
transferring data from files elsewhere on the network, or that Query
Analyzer or another such program doesn't have problems.

In any case, check under the service control panel.  Look for SQL Server
Agent.  Make sure it's not logging in as a System Account or
LocalSystem.  It should log in under a domain account (or at least a
local account that is both on the local system and on the remote system
with the same password.)

Set up this user, and start/stop the SQL Server Agent.  If it doesn't
start, then the account doesn't have the right permissions.  (Check
Books-on-line for details.)

Once it's running, you should be able to dump backups like this.

We backup to a SNAP server on a daily basis with little trouble this
way.

> 
> I am still learning obviously; where do I go to change this?
> 
> Thanks,
> Richard

Technical Details

Message-ID: <3A6A5AB9.79BF6C9B@greenms.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.skycache.com!Cidera!cyclone-0.nyroc.rr.com!cyclone-out.nyroc.rr.com!typhoon.nyroc.rr.com.POSTED!not-for-mail

References:

<zvpa6.2412$9D5.274782@newsread1.prod.itd.earthlink.net> <3a6a275a_2@news3.prserv.net> <6hqa6.2565$9D5.286058@newsread1.prod.itd.earthlink.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,1b9a449c07df7677
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,1b9a449c07df7677
X-Google-Attributes: gidf6611,public
X-Google-ArrivalTime: 2001-01-20 19:42:49 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.skycache.com!Cidera!cyclone-0.nyroc.rr.com!cyclone-out.nyroc.rr.com!typhoon.nyroc.rr.com.POSTED!not-for-mail
Message-ID: <3A6A5AB9.79BF6C9B@greenms.com>
From: "Greg D. Moore" <mooregr@greenms.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver
Subject: Re: Adding Network Devices !!??
References: <zvpa6.2412$9D5.274782@newsread1.prod.itd.earthlink.net> <3a6a275a_2@news3.prserv.net> <6hqa6.2565$9D5.286058@newsread1.prod.itd.earthlink.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 40
Date: Sun, 21 Jan 2001 03:39:11 GMT
NNTP-Posting-Host: 24.161.40.63
X-Complaints-To: abuse@nycap.rr.com
X-Trace: typhoon.nyroc.rr.com 980048351 24.161.40.63 (Sat, 20 Jan 2001 22:39:11 EST)
NNTP-Posting-Date: Sat, 20 Jan 2001 22:39:11 EST
Organization: Time Warner Road Runner - Albany NY

Reply to Parent Message