🚀 go-pugleaf

Richard,

SQL Server, to the operating system, is just another user ... nothing
"special" about SQL Server just because it is (a) a Microsoft product or (b)
it runs as a service. To the operating system, SQL Server has to have the
proper operating system rights in order to access any file on the network.

SQL Server, in other words, runs in a security context just like any other
application. You can see the security context that SQL Server runs it by
opening Enterprise Manager, right-clicking the server name and choosing
Properties. From here, choose the Security tab. The operating system account
used by your SQL Server should be shown. (BTW, this is for SQL Server 2000,
but the same, if not identical, process should also apply to SQL Server 7.0)

Does the account used to start the SQL Server service have the operating
system privileges you need?

----------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Richard Gilbert" <bixgomez@earthlink.net> wrote in message
news:6hqa6.2565$9D5.286058@newsread1.prod.itd.earthlink.net...
> 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?
>
> I am still learning obviously; where do I go to change this?
>
> Thanks,
> Richard
>
>