SQL Server permissions problem
From: Manoj Gadhia (anonymous_at_discussions.microsoft.com)
Date: 08/06/04
- Next message: Tom Moreau: "Re: Grant select permission on all Tables to a DB role"
- Previous message: Manoj Gadhia: "Permission to view only jobs"
- In reply to: Mihaela M.: "SQL Server permissions problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 6 Aug 2004 09:41:00 -0700
You must be running this in your query analyzer. So its
your nt account should have permission to access the
folder & when you run as a job the server2 sqlagent
account should have permission to access the same.
>-----Original Message-----
>
>Hello.
>
>Here is my problem.
>I have a CSV file on a server, let's say "server1".
>I have also a stored procedure, into a SQL Server
database, which is located
>on another server, let's say "server2".
>These 2 servers are in the same network.
>
>I need to connect from the stored procedure to the CSV
file, using
>OPENDATASOURCE, like this:
>OPENDATASOURCE(''Microsoft.Jet.OLEDB.4.0'',''Data
>Source=\\Idd1\test_files_import\1_files;Extended
>Properties="text;HDR=Yes;FMT=Delimited"'')...CLASSES#CSV
>It gives the following error:
>
>Microsoft OLE DB Provider for SQL Server error '80040e14'
>
>[OLE/DB provider returned message: '\\Idd1
\test_files_import\1_files' is not
>a valid path. Make sure that the path name is spelled
correctly and that you
>are connected to the server on which the file resides.]
>
>The path is valid, I'm sure about it. Maybe it is a
users permissions
>problem.
>Shouldn't I set permissions for SQL Server user for this
folder?
>But what user SQL Server uses?
>
>Thanks for any help!
>
>
>.
>
- Next message: Tom Moreau: "Re: Grant select permission on all Tables to a DB role"
- Previous message: Manoj Gadhia: "Permission to view only jobs"
- In reply to: Mihaela M.: "SQL Server permissions problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
