Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

passing SQL JOb agent proxy to access Sharepoint file path Expand / Collapse
Posted Friday, August 23, 2013 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 18, 2015 8:14 PM
Points: 3, Visits: 96

Task is to access the sharepoint file using the service account of SQL Agent.

My setup is
1> SQL agent service is running under domain/user1
2> A Proxy is created which has domain/user1 in its principal
3> This proxy is used to as 'RUN AS' to execute a SSIS package.
4> This package will access the shrepoint file.
5> domain/user1 has full access to this sharepoint file.

Can you please help what do I pass the request.credentials so it picks the domain/user1 account

below is the code snippet.

Dim request As HttpWebRequest
Dim response As HttpWebResponse = Nothing
Dim url As String
url = "https://*******/GoStSe/Business%20Intelligence/Test/test.txt"
request = CType(WebRequest.Create(url), HttpWebRequest)
request.Credentials = System.Net.CredentialCache.DefaultCredentials
response = CType(request.GetResponse, HttpWebResponse)
Post #1487702
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse