December 14, 2005 at 11:13 am
Here is the scenerio:
1. asp.net web app needs to execute a DTS package.
2. asp.net subweb is set to "NT Athentication" -- Anonymous turned off.
3. ASP.Net package is located on webserver
4. DTS package located on SQLServer.
5. DTS package must visit Fileserver and get text file to load into SQL.
The problem?
Double-hop. The web server can take the logged on user credentials to do stuff to the application. But, it cannot forward the credentials to the SQL server.
The DTS needs a domain user account to execute because it must go to another server on the domain an retrieve a text file. SQL user authenication does not have domain permissions to retrieve the file.
So....What are our options? How can we resolve this?
December 19, 2005 at 8:00 am
This was removed by the editor as SPAM
December 20, 2005 at 4:33 am
I would.
Call the dts package from the web page by passing in a sql server username and password when calling the package. Like so:
Extract from web page: http://www.sqldts.com/?208,2
============================================================
' Load Package
oPKG.LoadFromSQLServer sServer, sUsername, sPassword, _
DTSSQLStgFlag_Default, , , , sPackageName
' Set Exec on Main Thread
For Each oStep In oPKG.Steps
oStep.ExecuteInMainThread = True
Next
' Execute
oPKG.Execute
============================================================
Why do you not then give the sql server account access to the file server and drive where the doucment resides.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply