| Author |
Topic |
|
itmaster
Starting Member
28 Posts |
 Posted - 2012-09-06 : 11:38:05
|
| Hi,I was on a job a while back and inorder get a file from or write data to afile on a share, the Admin had to give sql server permissions, he would tell me, to read and write to the share. He never told me what was involved with this; and I cannpot find it any where. If some one could shed some light on this I would really appreaciate it.Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2012-09-07 : 10:16:25
|
| Hi Thanks for getting back to me. I am sorry but this is going to be hard for me to explain as I am not a Admin; I am developer. However, what I can tell you is that it was when we would use any code (bulk insert or xp comand shell statements) to either import or export data. I remeber going to them and telling them that the code is not working, but it is the same code tha ti used in the past, and they would tell me that they have to give the SQL Server rights to read and write to the share. The after they did this my code would work fine. so I was woundering if you could tell me how they did this.Thank youITM |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2012-09-12 : 08:32:02
|
| Sorry I have not been able to get back to this sooner. However, I know he did the right thing in doing this, but I am looking for what he had to do. Where did he go what did he do. I cannot find anything on this.Thank youITM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2012-09-13 : 15:27:16
|
| Oh okay, I was thinking that he had to do something in sql server. ThanksITM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
How to set permissions for SQL Server