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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-10 : 08:00:21
|
| Sazkin writes "PROBLEM DESCRIPTION:I have a SQL Server 2000 machine on which I created a package. This package has just 1 step which is a VB6 exe. This VB6 exe looks at some data on one of the SQL databases, creates a file and stores that file on another machine that is running FTP server so that a person can remotely grab that file. This exe has a config.ini file in which we specify the path to the FTP server on which to save the file.So, initially, the config.ini file had something like:J:\FTP\VTMCreatedFilesand the exe would save the files to this folder. J: is the mapped drive on the SQL Server machine to the machine running FTP server. When running the package through Enterprise Manager->Local Packages (Execute Package), it would run fine. However, if we scheduled a package to run, it would not execute the package (it would run it for 2 seconds and post no files to that folder).ARTICLES FOUND ON NET:I scoured the net and found this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;q269074I also found this article on your site:www.sqlteam.com/item.asp?ItemID=125SUGGESTIONS TRIED OUT AND RESULTS:The first article mentions using UNC instead of drive letters for mapped drives since SQLServer Agent is a Windows NT service and services do not recognize drive letters. I then changed the exe's config.ini file to contain \\Macaroni\FTP\VTMCreatedFiles\.(Macaroni is the FTP server machine). But this did not work either. The package would execute under DTS->Local packages in EM, but not when scheduled to run.SECURITY CONTEXTS:Now regarding security contexts, I am logged in to the SQL Server machine (this machine is named Eagle) as Administrator, the job, when scheduled, shows job owner as Eagle\Administrator. The FTP server machine (Macaroni) has given full permissions to Eagle\Administrator account. Under Server Roles->System Administrators, there is a BUILTIN\Administrator account listed, but there is no Eagle\Administrator account. There is a sa account listed too. I changed the job owner to sa, but that didn't help either.Any suggestions what more could be done? I have tried UNC and I have looked somewhat in to security contexts. I personally feel it is something to do with security contexts, but I have no clue how to resolve this. Please help.Kind regards." |
|
|
|
|
|
|
|
Scheduling DTS package issues