URGENT: Stored procedure throws Windows error 203

• panthagani

  SSC Veteran

  Points: 259

  More actions

  May 15, 2007 at 11:29 am

  #176654

  Posted - 05/15/2007 :  13:12:31

  I am trying to execute a stored procedure on Server1 which creates an excel report on a share of Server2: The following error message is thrown: Saving of scheduled report(s) to Excel file failed : 203 SaveReportToExcel() in TlRptToFile.RptExcel failed in sproc_SaveReportAsFile - TLRptXL::SaveReportToExcel - Connection to Database failed for Analytics DataBase Server : TKTALSQL3, Application Server: and DataBase : tlAnalytics : Windows Error - The system could not find the environment option that was entered. A DCOM component on Server1 runs the stored procedure that creates the excel report. The account under which DCOM component runs is a member of 'Administrators' group on both Server1 and Server2. Checked permissions on the shares. Account is a local Admin on both Server1 and Server2. Account under which SQLServer and ServerAgent runs is also an Admin on these shares (implicitly as part of 'Administrators' group). I am manually able to create an excel/text file on the Server2 share while accessing it from Server1, though. Both servers are running SQL Server 2000 and have an SQL Server version of 8.00.2151 (SP 4 + hotfix 903742). Appreciate any help with this. Thank you.

• philcart

  SSC-Forever

  Points: 47796

  More actions

  May 15, 2007 at 7:20 pm

  #706635

  Whatever process is trying to save the Excel file is not able to read a necessary environment variable. Maybe the environment variable is setup on a per-user basis and not system wide.

  I'd start by opening a command prompt on each server using the same account that the DCOM component uses. Then compare the output of the SET Command.

   

  --------------------
  Colt 45 - the original point and click interface