May 31, 2012 at 11:43 am
I have an ssis package that runs as a proxy (sql login) ==coldfusionuser
This account is used in coldfusion to give access to sql server.
The step of the package is using a proxy (coldfusionuser) and login to the server (windows authentication).It uses a folder on the coldfusion server. If the coldfusion server is down. the package fails (local host server is not running, then it terminates the mssqlserver service unexpectedy.
then it fails to restart the mssqlserver server access is denied
If the coldfusion server is up and package fails nothing goes wrong.
Help please
May 31, 2012 at 12:44 pm
Do you see any kind of error message? If you have the exact error message, post it here and someone should be able to help you.
May 31, 2012 at 1:23 pm
05/30/2012 23:46:49,,Information,[098] SQLServerAgent terminated (normally)
05/30/2012 23:46:48,,Error,[359] The local host server is not running
05/30/2012 23:46:47,,Error,[359] The local host server is not running
05/30/2012 23:46:46,,Warning,[360] SQLServerAgent initiating shutdown following MSSQLSERVER shutdown
05/30/2012 23:46:46,,Error,[140] AutoRestart: The MSSQLSERVER service could not be restarted after 3 attempts
05/30/2012 23:46:46,,Error,[368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
05/30/2012 23:46:45,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #3)...
05/30/2012 23:46:40,,Error,[368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
05/30/2012 23:46:40,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #2)...
05/30/2012 23:46:35,,Error,[368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: Access is denied)
05/30/2012 23:46:35,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...
05/30/2012 23:46:35,,Error,[012] The MSSQLSERVER service terminated unexpectedly
05/30/2012 23:46:32,,Error,[359] The local host server is not running
05/30/2012 23:46:32,,Error,[359] The local host server is not running
05/30/2012 23:46:32,,Error,[359] The local host server is not running
05/30/2012 23:46:32,,Error,[359] The local host server is not running
05/30/2012 23:46:32,,Error,[359] The local host server is not running
05/14/2012 11:58:29,,Warning,[000] Request to run job StartPackage_Moodle_Import_Assessments_Populate (from User ColdfusionUser) refused because the job is already running from a request by User ColdfusionUser
05/13/2012 13:15:32,,Warning,[000] Request to run job StartPackage_Moodle_Import_Assessments (from User ColdfusionUser) refused because the job is already running from a request by User ColdfusionUser
05/11/2012 13:57:46,,Warning,[000] Request to run job StartPackage_Moodle_Import_Assessments (from User ColdfusionUser) refused because the job is already running from a request by User ColdfusionUser
05/10/2012 14:31:24,,Warning,[000] Request to run job StartPackage_fremont_AssignInstruct (from User ColdfusionUser) refused because the job is already running from a request by User ColdfusionUser
05/10/2012 14:31:23,,Warning,[000] Request to run job StartPackage_fremont_AssignInstruct (from User ColdfusionUser) refused because the job is already running from a request by User ColdfusionUser
03/18/2012 17:26:09,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
03/18/2012 17:26:09,,Warning,[260] Unable to start mail session (reason: No mail profile defined)
03/18/2012 17:26:08,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
03/18/2012 17:26:08,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
03/18/2012 17:26:07,,Information,[432] There are 12 subsystems in the subsystems cache
03/18/2012 17:26:06,,Information,[339] Local computer is COLO-SQL-SEAPOR running Windows NT 6.1 (7600)
03/18/2012 17:26:06,,Information,[310] 4 processor(s) and 6144 MB RAM detected
03/18/2012 17:26:06,,Information,[103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
03/18/2012 17:26:06,,Information,[102] SQL Server ODBC driver version 10.00.1600
03/18/2012 17:26:06,,Information,[101] SQL Server COLO-SQL-SEAPOR version 10.00.1600 (0 connection limit)
03/18/2012 17:26:06,,Information,[100] Microsoft SQLServerAgent version 10.0.1600.22 ((Unknown) unicode retail build) : Process ID 2444
03/18/2012 17:25:56,,Information,[393] Waiting for SQL Server to recover databases...
Thanks
May 31, 2012 at 1:57 pm
Thats strange. Can you look at the windows event log and see whats going on there at the same time? There should be HUP signal from some other process for SS to stop.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply