Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deepa
Starting Member
17 Posts |
 Posted - 2002-01-17 : 04:17:37
|
| Whenever a bulk insert is performed from a local administrator on a sql machine ,I will be able to access the stored procedures but I am unable to perform the bulk insert operation . It throws an Access denied error. But the same can be performed from another machine on the same domain as a network administrator.Can any one give any information on this, like Is there an option while installing SQL itself or any other help/link topics on this please..DeepaEdited by - deepa on 01/17/2002 04:20:56 |
|
|
mphelps
Starting Member
12 Posts |
Posted - 2002-01-17 : 05:12:57
|
If the source file is not on the local machine you need to use a domain account that has the required file permissions. the local admin account will only be able to access files on the local machine.Check that you have the SQLServer and SQLAgent services running with a domain account and not the local system accountMartin quote:
I don't suffer from insanity, I enjoy every second of it
|
 |
|
|
|
|
|
Bulk Insert as local administrator throws an error