Hi all! Does anyone of you know what port number SQL Executive is using? Is it separate from the SQL Server's 1433?
I have a user who is behind a firewall. He can connect to sql server but he can not run a task manually. If the task is scheduled it is successful but
if he run manually , sql server display "The SQL Executive service is not currently running on <servername>. This prevents task .... from being run."
Eventhough the service is running and other jobs are successfully.
Would it be possible the port for SQL Server is open to that user but not the
sql executive.
i have both SQL Server 6.5 and 7.0 installed...for some reason i cannot start SQLExecutive while operating on 7.0...when i try to start the service it says 'Yu need SQL version 6.5 or later to start SQL Executive' has ayone come across such an error?
Having issue starting this service on SQL7 SP2. Returns "specific error 109" Any tips on resolution--no help on MS site search. what are ramifications of NOT starting this service if it is a single Server and the SQL application we use does not seem to be affected other than problem loading SP3 and is this related?
When trying to run SQL Executive from the SQL Enterprise manager it run in a dos window ( all scheduled tasks runs fine). PS: the machine in question had sql 6.5 installed , removed and then and then re-installed again. this is when the problem started.
I have registered a Sql server on my local machine.
I can adddelete jobs to the Task Scheduler, view job histories etc on that server however, when I try to execute a job on that server using the Task Scheduler, I get the following error message:
"The sqlexecutive servive is currently not running on server <server name>. This prevents the task from running".
I have checked the SqlExecutive service on the server and it is running. I have jobs that get executed each night via the Task Scheduler
Does anyone have any idea of what the problem could be ?
I have SQL Server 6.5 on Windows NT 4.0. Every night i was doing my backups with SqlExecutive. Some days ago I had to restart my server. First I stopped SQL Sevrver,then DTS service and when I tried to stop SQL Executive it begun to show me the stopping status. I waited for 20 min. and status didn't changed. In the Control panel, Services SQL Executive status is stopped. When I'm trying to start it from control panel the system tells me that this service is already running. And now I can't stop it or start it from service manager. What could be wrong ? Is it SQL Server problem or NT problem.
I registered a remote server on my machine that has SQL 6.5 Client installed. Using the SQL Enterprise manager I am trying to run the scheduled jobs in the remote site, and I get the following error message
"The SQLExecutive Service is not currently running on Server 'Server Name'. This prevents task 'task name' from being run"
I have verified that SQL executive is running in the remote server and I was able to run the same jobs on the same server from another machine. Can you please suggest me as what is wrong with my machine. I have tried to re-install SQL client on my machibe.
I would appreciate if anyone can reply this ASAP as I am stuck.
I'm running SQL Server 6.5 and have schedules a number of tasks to run overnight. This has generally been successful; even when the tasks have failed, it's been because of a lack of data in a feeder database system.
My problem is that when I try to run the tasks manually, I get a message saying that they can't be run because SQL Executive is not running on the server. Now, this ain't true. The little gizmos show green in the server manager, and if I right click on SQL Executive, 'Start' is disabled and 'Stop' is enabled.
Am I missing something here? Does anyone have any clues or suggestions?
1) SQL Executive stops running jobs 2) The only way I can get it to START running jobs is to reboot the server 3) When SQL Server and executive come back up, a number of the tasks have been DISABLED! (I have seen this happen over and over on my SQL 6.5 SP4 instances.)
If you have seen this situation, have you found a way to prevent it? (ie: procedure or bug fix, etc.)
Hi all Can someone tell me what are these Logs mean. If you right click on SQL executive in EM and select Error Log you'll get a list of errors,warnings...etc.
In my Case I get these Errors that are occuring every few seconds. 11/05/98 09:03:10 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:12 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:18 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:28 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:35 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:40 AM DBLIB ERROR HANDLER: LOGIN INCORRECT 11/05/98 09:03:46 AM DBLIB ERROR HANDLER: LOGIN INCORRECT
And Warnings:
11/05/98 09:03:10 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not Associated with a trusted SQL Server Connection. 11/05/98 09:03:12 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not Associated with a trusted SQL Server Connection. 11/05/98 09:03:16 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not Associated with a trusted SQL Server Connection. 11/05/98 09:03:22 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not Associated with a trusted SQL Server Connection. 11/05/98 09:03:28 AM DBLIB Message HANDLER: LOGIN FAILED - User: sa Reason: Not Associated with a trusted SQL Server Connection.
I have no clue which security i use on the server and on my workstation. How can one find out which security is being used.
I presently have Error Logging turned on for the SQL Executive, but I no longer want it. When I open up the "Configure SQL Executive" window under the Server menu, the "Error Log File" field is dimmed and there is no option to turn it off.
Hi, I want to see my sql executive error log but it grown like anything. How i have to trucate my error log. I cannot stop my server now. i am getting following message. and also suggest me what i have to do not to grow like this means 56.01 mb size. The sql executive error log is 56.01 mb in size and loading it will consume considerble memory and may take several minutes to complete. Now i want to see my executive error log , pls tell me what i have to do.
I just inherited a SQL Server that was set up by a non-DBA. It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t certified the product on SP4). I am trying to change the SQL Executive Service to use a non-system logon account. The account that I want to use is running SQL Executive on 9 other servers.
I went into Usrmgr and added the account to the administrators group. Made sure that it has rights to: log on as a service, log on as a batch job, increase quotas, act as part of the operating system, replace a process level token.
When I try to change to that id in services, I get the following error:
"cannot set the startup parameters for SQL Executive service. Error 1057 occurred. The account name is invalid or does not exist."
Looking in Technet, I found that if "log on as a service" isn`t set you could get this message but I`ve check/re-checked, had someone else check and it`s set.
We are running sql 6.5 with Serv. pack 4. All of our Prod. database are backedup weekly via scheduled tasks. On occasion the dump of a particular database will cause 1 of 2 things: 1. The db dump seems to work correctly but stops sql executive service. 2. The db dump seems to work correctly but sends an alert email msg to me indicating that it failed. The msg in the email is "NO Message".
Has anyone experienced either of these 2 problems or have any solutions?
