Mateen
asked on
Bulk Insert and Permissions
SQL2K
I am trying
bulk insert security_sql.dbo.share_rat e_intermed iate
from '\\mateen\pbapps\security_ sql\180520 06.txt'
with ( FielDTERMINATOR = ',' )
The error message is
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert because file '\\mateen\pbapps\security_ sql\180520 06.txt' could not be opened. Operating system error code 5(Access is denied.).
I also tried
bulk insert security_sql.dbo.share_rat e_intermed iate
from 'd:\pbapps\security_sql\18 052006.txt '
with ( FielDTERMINATOR = ',' )
the error message is
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert because file 'd:\pbapps\security_sql\18 052006.txt ' could not be opened. Operating system error code 3(The system cannot find the path specified.).
O/s Window 2000
Computer Name: mateen ( my own machine)
login name : mateen
The file lies in 'd:\pbapps\security_sql\18 052006.txt '
I have shared the folder
D:\pbapps with full control to myself (mateen)
From the Windows Start menu When I run the command
\\mateen\pbapps\security_s ql\1805200 6.txt
the file is opened in notepad.
THEN WHERE IS THE PROBLEM.
I am trying
bulk insert security_sql.dbo.share_rat
from '\\mateen\pbapps\security_
with ( FielDTERMINATOR = ',' )
The error message is
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert because file '\\mateen\pbapps\security_
I also tried
bulk insert security_sql.dbo.share_rat
from 'd:\pbapps\security_sql\18
with ( FielDTERMINATOR = ',' )
the error message is
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert because file 'd:\pbapps\security_sql\18
O/s Window 2000
Computer Name: mateen ( my own machine)
login name : mateen
The file lies in 'd:\pbapps\security_sql\18
I have shared the folder
D:\pbapps with full control to myself (mateen)
From the Windows Start menu When I run the command
\\mateen\pbapps\security_s
the file is opened in notepad.
THEN WHERE IS THE PROBLEM.
Sorry, I didn't read the complete post
ASKER
Hi aneeshattingal
If I give readonly permission to everyone then the above query works.
I DON'T WANT THAT ANYBODY COULD SEE MY FOLDER.
If I give readonly permission to everyone then the above query works.
I DON'T WANT THAT ANYBODY COULD SEE MY FOLDER.
If you are logged in as 'sa', the operating system security context for BULK INSERT is that of the SQL Server service account. That account needs permissions to the network resource. Note that the 'local system' account can't access network resources.
If you change the account, do so from Enterprise Manager (server properties) rather than the services mmc. Also, rather than mapping a drive, use a UNC path ('\\mateen\pbapps\security _sql').
If you change the account, do so from Enterprise Manager (server properties) rather than the services mmc. Also, rather than mapping a drive, use a UNC path ('\\mateen\pbapps\security
ASKER
Hi aneeshattingal
I have got SQL Box installed in my machine. I have administrator rights.
I am running the query from the server [sdmsrv].
<<If you change the account, do so from Enterprise Manager (server properties) rather than the services mmc>>
In Enterprise Manager where is server properties
I have got SQL Box installed in my machine. I have administrator rights.
I am running the query from the server [sdmsrv].
<<If you change the account, do so from Enterprise Manager (server properties) rather than the services mmc>>
In Enterprise Manager where is server properties
ASKER
and in the server properties what will be the tab name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try Start->Run -> \\mateen\pbapps\security_s