I've read that you can run a job on another server as long as you have a link server from the source to the destination server. I've search for hours online and read nearly everything in SQL Server Books Online pertaining to the sp_start_job function without success. I can't find one example on how to accomplish this.
I want to run a job called Job1 on Server1 from Server2 with a link server on Server2 to Server1 called ServerConn. The link server works fine grabbing data from Server1; so I know the link server works.
I am having problems on the server part of the sp_start_job function.
use msdb
exec sp_start_job @job_name = 'Job1', @server_name = 'ServerConn'
I end up with this error: The specified @job_name ('Job1) does not exist.
I don't understand why it is failing or how to fix it.
When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service. Are there any differences between these two methods? Does restarting the service inherit any changes made to the job's attributes?
We have SQL 2000 (SP2) , Our SQL server agent showing green light as started from EM , It is succussfully restarting from NT Services too . But When I open the properties of the jobs from EM its gives error message SQL DMO error " SQl Agent is starting , try later " . And in EM Next run Date & Time not available .
MDDB database is accessable & in Log file its recovered fully
- When I disable "allow remote connections to this server" from server properties>connection page, I can still remotely connect to the server from SSMS...so what is the impact of enable/disabling it?
- what is the impact of changing the remote query timeout (on the same page) from default value?
I've installed sql server 7.0 on winnt. Later i've changed my system name. Due to this SQL SERVER is not running and i'm getting the following error. "Your SQL Server installation is either corrupt or has been tampered with (unkown package id). Please rerun setup.". I've changed my system name back to the original one and sql server is running again.
Is there any way to change my system name and sql server running??
My SQL server is not sarting, Its giving me an error 2140 - An internal Windows NT error occured. I checked the Microsoft site found an article ran all the options to check if it works but invain.
I am stuck, its a production DB i have to get it up and running in the next hour
hi. i'm starting out with SQL server integration with visual studio.i used the data connection wizard on adding a new connection to my sql server. but i have no idea on how to open/access it like the usual way wherein i use:
SqlConnection myConnection = new SqlConnection(connectionstring); myConnection.Open();
/*queries*/
how do i go about doing these things with the new connection that i made via the connection wizard? thanks in advance
Since I installed MySQL on my Win Me, MS SQL SErver 7.3 doesnt seem to start. It keeps giving the message " A connection could not be established to Venus Comp -General Newtwork error. Check your network documentation ConnectionOpen (connect()) Please verify SQL Server is running and check your SQL Server registration properties (by right clicking on the Venus Comp node & try again"
But when i right click on the properties, it gives me the same error. I deleted the Venus Comp node. And re-created it by following step by step wizard. After that , when it tried to connect, it gave the same error.
I'm using just Win Me. Im using no network. It used to work well before i Installed mySQL on the my pc.
I do not wish to re-install the SQLServer with the fear of MySql not working.
Hi, we have a SQL server 7.0 on windows 2000 m/c,from yesterday onwards suddenly sqlserver agent is not starting,till then it was working fine. I tried to start SQL server agent manually and i got following message
"[241] Startup error: Unable to initialize error reporting system (reason: The specified module could not be found) "
Then i tried to start from services in controll panel,but i could't.
Then i checked event log ,found following error messages
Application log:
1) "The description for event ID(105) in soure(SQL Server Agent) can not be found. The Localcomputer may not havethe nessary registry information or message DLL files to display messagees from a remote computer.The following information is part of the event: The handle is invalid."
Event ID: 105 Source : SQLServerAgent Category: Disk
system log:
1)The Sql server agent service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
Hi Folks, Can anyone amongst u solve my problem..When i try to start the Sql Server Agent..i'm given the following error meassage.. Could not start Sql Server Agent.Error 2140.An Internal Windows NT error. Please help me if anybody can.
i get this error below my test box what does it mean ,and my server doesnt start and gives error when i restart services 00/12/08 13:31:37.83 kernel SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (1 CPU detected, SMPStat=0). 00/12/08 13:31:37.84 server LogLRU buffers: 0 00/12/08 13:31:37.84 kernel initdata: no memory for kernel locks
Does anyone use PeopleSoft and SQL? I am doing tape backups with Seagate. Seagate hangs sometimes. I am planning on writing a command to shut off SQL server then restart it. i am having trouble with writing the .BAT File so far: --start of bat NET STOP MSSQLServer NET STOP SQLExecutive <<call to backup software>> -- (my problem) net start server net start executive -- end of bat any help would be appreciated thanks marlene
Hi have you guys seen this error when trying to start the sql agent?
SQLServerAgent could not be started (reason: sqlserveragent must be able to connect to sqlserver as sysadmin, but '(unkown)' is not a member of the sysadmin rol.
What is this all about I can start the sql server service with the same account i'm trying to start the agent.
How can we start the SQL Server Agent without having physical acess to the server, I mean i have access to the EM which is installed on another server. How to start the SQL Server Agent , the login i use has sa rights ,
We just loaded SQL 2005 Standard Edition on a Windows 2000 Server. It will not let us start the Report Server through URL or through the SQL server Studio. The error in Studio is more descriptive so I have included the error text from attempting to start the Reporting Server through Studio using Object Explorer
TITLE: Connect to Server ------------------------------ Cannot connect to VZMET. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title>Configuration Error</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>Configuration Error</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. <br><br> <b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'M:InetPubwwwrootSAMMSSQL.2Reporting ServicesReportServer' because access is denied.<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> [No relevant source lines]</pre></code> </td> </tr> </table> <br> <b> Source File: </b> M:InetPubwwwrootSAMMSSQL.2Reporting ServicesReportServerweb.config<b> Line: </b> 0 <br><br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 </font> </body> </html> <!-- [HttpException]: Failed to start monitoring changes to 'M:InetPubwwwrootSAMMSSQL.2Reporting ServicesReportServer' because access is denied. at System.Web.FileChangesMonitor.FindDirectoryMonitor(String dir, Boolean addIfNotFound, Boolean throwOnError) at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback) at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback) at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname) at System.Configuration.BaseConfigurationRecord.InitConfigFromFile() [ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'M:InetPubwwwrootSAMMSSQL.2Reporting ServicesReportServer' because access is denied. (M:InetPubwwwrootSAMMSSQL.2Reporting ServicesReportServerweb.config) at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName) at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index) at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring() at System.Web.Configuration.HealthMonitoringSectionHelper..ctor() at System.Web.Management.HealthMonitoringManager..ctor() at System.Web.Management.HealthMonitoringManager.Manager() at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source) at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute) at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e) --> --. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------
I would like to access data from SQL database (SQL 2005 express) BEFORE Windows login (actually, the data I want to retrieve is the login name and password for Windows login). Is there a way that I can start the engine before I login?
I am having trouble just starting SQL Server 2005. When I try to use Management Studio, I do not see any server name. I just need to be able to start it up!
I have a pc running as an SQL Server 2005 express server. Last week, the RAID 1 array failed for some reason, both HD still work correctly and the raid utility simply mirrored everything back.
So after starting this pc the day after, SQL server stopped working. This is the error log:
Code Snippet 2008-02-19 17:37:20.50 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2) 2008-02-19 17:37:20.50 Server (c) 2005 Microsoft Corporation. 2008-02-19 17:37:20.50 Server All rights reserved. 2008-02-19 17:37:20.50 Server Server process ID is 2676. 2008-02-19 17:37:20.50 Server Logging SQL Server messages in file 'c:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2008-02-19 17:37:20.50 Server This instance of SQL Server last reported using a process ID of 2968 at 19/02/2008 17:26:54 (local) 19/02/2008 23:26:54 (UTC). This is an informational message only; no user action is required. 2008-02-19 17:37:20.50 Server Registry startup parameters: 2008-02-19 17:37:20.50 Server -d c:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2008-02-19 17:37:20.50 Server -e c:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2008-02-19 17:37:20.50 Server -l c:Archivos de programaMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2008-02-19 17:37:20.53 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2008-02-19 17:37:20.53 Server Detected 2 CPUs. This is an informational message; no user action is required. 2008-02-19 17:37:21.20 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2008-02-19 17:37:21.26 Server Database mirroring has been enabled on this instance of SQL Server. 2008-02-19 17:37:21.26 spid5s Starting up database 'master'. 2008-02-19 17:37:21.42 spid5s SQL Trace ID 1 was started by login "sa". 2008-02-19 17:37:21.46 spid5s Starting up database 'mssqlsystemresource'. 2008-02-19 17:37:21.51 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required. 2008-02-19 17:37:21.57 spid5s Error: 9004, Severity: 21, State: 1. 2008-02-19 17:37:21.57 spid5s An error occurred while processing the log for database 'mssqlsystemresource'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. 2008-02-19 17:37:21.57 spid5s Error: 945, Severity: 14, State: 2. 2008-02-19 17:37:21.57 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. 2008-02-19 17:37:21.57 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
I have been reading in this forum and other places, but I've had no luck fixing this. I already backed up all the mdf database files and logs just in case. The mssqlsystemresource database and logs are in the same location, and they have read/write access.
I want to start to use SQL Server 200 Express but have no idea where to enter the SQL queries and view the results.
I installed SQL Express and under Start > Programs > SQL Server 2005 I only have Configuration Tools which has Configuration Manager, Error and Usage Reporting and Surface Area Configuration.
SQL Server and SQL Server Browser Services are running but I have no clue of from to start creating my database, tables, etc etc.
I have a background of MySQL and used MySQL's command line tool and phpMyAdmin, so SQL is not a problem.
I upgraded my SQL 2005 Workgroup 2005 to SP2 and subsequently could not get the SQL Server service running. Turns out this was a problem because I had created separate folders for my data and log files. The distmdl.mdf and mssqlsystemresource.mdf files were in my data folder and distmdl.ldf and mssqlsystemresource.ldf were in my log folder. During SP2 upgrade a new distmdl.ldf and mssqlsystemresource.ldf were created in my data folder. I deleted the distmdl.ldf and mssqlsystemresource.ldf files in my log folder and then moved the newly created ones in my data folder into the log folder and all is well now.
Hi, Running SQL 7.0 on NT4. When server boots the SQL Server Agent appears to start normally. NT Service starts, Event Viewer shows service is started, Service Control Manager shows service started.
However when I try to view a job or create a lob I get the following error:
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Please try again later.
I am running windows 2003 and sql server 2005. i am following the directions in books online:
On the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
In SQL Server Configuration Manager, expand Services, and then click SQL Agent.
In the results pane, right-click any instance, and then click Start.
A green arrow on the icon next to the SQL Server Agent and on the toolbar indicates that SQL Server Agent started successfully.
Click OK.
the problem is i have nothing in Services. there is nothing to expand. is it installed wrong?? or is there another step before this that i have to do??
When I start the SQL SQL Server Management studio, I always the the a message box with the message , "Configuring the Environment for first time use, this may take a few minutes". This is only happening on one lap top. SQL express and Sql standard are installed on the box. I have uninstall and reinstalled the tools, but the problem persist.
I have hit a problem while trying to re-start the server in Single User Mode in order to restore the master database. I run the command sqlservr -m and it locks after the 'non-unicode character set' line each time.
Is there anyone who knows anything about this? Have I missed something or is it a bug? I have researched quite a few books and haven't found any reference to this problem.
Hello All... I am new to this forum (and new to SQL for that matter), so I hope this isn't a stupid question. I tried searching for the answer but couldn't find it here. I am trying to start & stop SQL server through the command line so I can start & stop it as a scheduled task. Are there any switches for sqlmangr.exe I can use? Maybe another way?