SQL Executive NOT Visible...
Mar 23, 1999Hi,
When I register an SQL Server from elsewhere on the network, some of them are not displaying SQL Executive in the Enterprise manager.
Why is this?
ADVERTISEMENT
SQL Executive
Mar 15, 2001Hi 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.
Thanks in advance.
Zrxowm
SQL Executive Using 6.5 And 7.0
Oct 27, 2000i 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?
SQL Executive
Mar 28, 2002Having 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?
Thanks for any input
SQL Executive
Jan 17, 2000MSSQL Server, SP4, running under version 6.5.
Is there a way I could use T-SQL to find out if the SQL Executive is running or not ?
SQL Executive (SQL 6.5)
Jun 11, 1999When 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.
Any hint on this subject is appreciated.
Thank you.
Guss
SQL Executive Not Running SQL 6.5 Sp3
Mar 31, 2000MS SQL server error 18450 severity 14
Login failed for user ‘%ls’. Reason: Not defined as a valid user of a trusted SQL Server connection.
does anybody have a clue how to fix this
already cjanged user used for mssql service and sqlexec service
No scheduled tasks can run
Sql Executive Jobs
Mar 19, 2001Hello,
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 ?
Regards,
Hitesh
SQL Executive Problem !
Mar 31, 1999Hi !
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.
Thanks in advance !
Saule@nafta.lt
SQL Executive Error
Sep 23, 1998Hi,
If I execute any scheduled jobs on my SQL Server I am getting the following error message.
`Error 21003 : [SQL Server] Error executing xp_schedulersignal extended stored procedure`
`SQL Executive not running.`
If I check SQL Executive by right click, the drop down menu show start option is disabled.
Can any one help.
Thank you in Advance.
Murali Raparla
SQL Executive Problem
Jul 10, 2001I 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.
Thanks
Ganesh
SQL Executive And Scheduled Tasks
Jan 19, 1999I'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?
Thanks.
SQL Executive Tasks Disabled
Apr 15, 1999Has anyone seen the following situation?
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.)
Thanks for your help!
Problems In Error Log In SQL EXecutive????
Nov 6, 1998Hi 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.
THANK YOU IN ADVANCE.
How Can I Turn Off SQL Executive Error Logging?
Jun 29, 1998I 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.
How do I turn off logging for SQL Executive?
Executive Error Logs---very Urgent
Jul 21, 2000Hi,
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.
--rk
SQL Executive - Service Startup Account Error
Aug 5, 1998Hello all,
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.
Any help would be appreciated!
Dump Database Task Stops SQL Executive
Aug 18, 1998We 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?
Data Not Visible???
Jan 27, 2004I recently imported some Access tables into SQL Server. I can go into enterprise manager and return all rows and the data is there.
I build an ASP page to edit the data. After the connection the data for the record is displayed in a form. For some reason some fields are not coming through?
Is this a problem when converting to SQL Server. It just doesn't make sense that the table in Enterprise manager says the field is populated but when I do a pull via ASP the data doesn't come through.
Does anyone know anything about this?
Any help or pointing in the right direction would be greatly appreciated.
Thanks,
JW
SUM Only Visible Rows
Oct 1, 2007I am using an expression to hide values in a row based on a date field ( if date is bewtween this date and that date show value, otherwise hide it). My problem is now I need to sum all the values, even though some are not visible the sum is still adding them. Is there an expression to check for only "visible" rows??
View 6 Replies View RelatedKeep The First 2 Columns Visible
Jan 16, 2008I got a Report with a lot of columns and if the user scrolls, I would like to keep the first 2 columns visible. Excel offers a function like this is there something like this in Reporting?
Triggers Not Visible
Jun 18, 2007i created two new instances of SQL Server and created 2 triggers on each of these instances.
I go to object explorer under the triggers plus sign and there's no triggers there. But these instances recognize that the triggers are there because when i try to recreate them, i get a trigger already exist error message.
Is there a problem with my instances or is there something i need to change or configure?
I will really appreciate any help on this
SQL Server Not Visible
Feb 15, 2007I can't seem to make the SQL Server visible to anything other then SQL Server Tools. (management Studio, etc.)
Neither Visual Studio 2005, or Administrative Tools/Data Sources can view or connect with my SQL Server.
I need help, Thank you.
Drive Not Visible For Backups
Feb 21, 2008Hi all,
I have a 1 TB network drive on a Windows 2005 sql server that is visible at the OS level.I am trying to use this for my SQL backups but this drive is not visible from SQL server. All the other drives appear fine except this drive. The OS team already checked everything and as its visible at the OS level they point to SQL server as the one having problems.
Any suggestion would help..
-Thanks all.
System Tables Are Not Visible At All, Why?
Jun 16, 2006Dear all,
When you go to Sql Management Studio->Object Explorer and select Tables and then System you don€™t see any at all.
Why are not visible system tables for each user database as previously did Sql Server 2000 ? They are hidden or there is other stuff?
Any thought or view would be very appreciated.
SQL DTS Designer Components Not Visible
Aug 20, 2007Hi,
I installed SQL 2005 Enterprise Edition and SQL DTS Designer Components. However I cannot find the icon of the SQL Designer Components.
Thanks.
Lian.
Check If An Object Is Visible
May 1, 2008
Is there anyway to check if a textbox (or detail row, etc) is visible? I'm envisioning something like an 'isVisible' function. I'm trying to set a filter in the detail section based on a toggled visibility.
Thanks.
Brad
CLR Stored Procedure Not Visible
Dec 20, 2005I am trying to do some time series analysis on data that I have. I've read that the best way to do this is to use CLR to write the manipulation code in .Net and then load the assembly into SQL rather than extracting the data, manipulating it and putting it back again.
I'm using crystal reports with visual studio 2003 to do my reporting. The problem I am facing is that the CLR stored procedures I create using SQLExpress are not visible from my SQL explorer built into Visual Studio 2003. I can create stored procedures using standard transact sql and these are visible, but the CLR stored procedures are not.
I've noticed when I browse the stored procedures in my SQL Management Studio that the image of the stored procedure has a padlock shown in the icon, as if they are locked?
Do I have to explicitly enable a security attribute on CLR stored procedures to make them visible?
Any help would be greatly appreciated.
Home Properties Tab NOT Visible
Apr 1, 2008
When I type my 'http://ServerName/rmMyManager/Pages/Folder.aspx' I can see only Home and NOT Properties. I can see all the folders below that I have .
Just two days back I have changed permission to allow only me for deploying and have all those settings. Please guide me accordingly.
Dts Object Not Visible In My DataFlow ScriptComponent
Jan 30, 2007I am trying to set the TaskResult in my DataFlow ScriptComponent, but the Dts object is not visible.
Dts.TaskResult = Dts.Results.Failure
The above line works fine in my EventHandler script, but the Dts object seems to be out of scope when I try to use it from my Dataflow.
One thing I have noticed is that my DataFlow ScriptComponent inherits from 'UserComponent'
I have tried adding Microsoft.SqlServer.ScriptTask reference, but can not see it in the reference list - Strange?
Any help appreciated.
Regards,
Paul.
Stored Procedure Not Visible In SQL Express
Apr 7, 2006I have SQL express installed in my server and I created a stored procedure using SQL server management studio express, but when I refresh my stored procedures the one I created does not show. Please help.
Your valuable feedback is greatly appriciated.
Relationships Not Visible In The Query Designer
Jan 26, 2008Hello
I have created some tables and relationships between them by using MS SQL Server Management Studio Express.
The relationships are between a field named OId, which is not a part of the primary key but it is typed as an unique key. And a field named ParentTableOId.
When I open the two tables that have this relationship in the "Design Query in Editor" is not the relationship there.
Anybody who knows why?
Best Regards
/Erik
+/- For Toggling Visible And Invisible Groupings
Mar 17, 2007When defaulted to Visible or Invisible, +/- displays correctly. But when using the Expression, + is always showing as the default even when a group is expanded. Is this expected? TIA.