Where are the error messages for the MS-SQL Connect Agent? Or, can someone help me with this message? ANSQL119E -- Failed to connect to SQL server. This comes from a .CMD job that runs fine if starte
Barry, Make sure the ADSM Scheduler Service is running as a user that has the correct permissions to access the SQL Server. You can check this by looking at the "Log On As:" parameter in the NT "Serv
Del, Thanks! It seems that running the command file from a prompt with "/sqlsecure" worked fine, but when the command file is run from a schedule, I had to specify the user and password. Thanks again