job failed om the sql server

SQL Server Security

Index ‹ SQL Server

- Previous
  - 1
    - Mirroring on SQL 2000 Does mirroring exist on sql2000 Regards, Randy. Tag: job failed om the sql server
  - 2
    - Updating values in one row from values in another row Hi I have a table containing: ProductCat Product Qty NewQty TypeA ProductA -10 TypeA ProductB 5 TypeB ProductX 8 TypeB ProductY -5 I need to get rid of negative values in the same ProductCat by adding surplus values to the negative values in the same ProductCat ie. This is what I ant the table to look like. ProductCat Product Qty NewQty TypeA ProductA -10 -5 (Add ProductB to ProductA in the same ProductCat to reduce the deficit) TypeA ProductB 5 0 (Due to the fact that I added 5 to ProductA NewQty must be reduced by 5) TypeB ProductX 8 3 TypeB ProductY -5 0 (Deficit only has to be reduced to 0 where possible therefor the balance of 3 for ProductX) Note the values in Qty can stay as the same. I am interested in the New values. Could someone please help me with the correct method of doing this Thank you. Tag: job failed om the sql server
  - 3
    - Summarize data using single Query I recieve duplicate customer bill data which I want to consolidate using SQL query. How to summarize data using single query...both Qty and Price. If either one of price or qty is -ve then both should be -ve. Here is example data for one customer. 1 每 Only Qty is negative Product Qty Price Shirt 2 6.00 Shirt -1 6.00 ------------------------------------------------------------------------------------------------- Shirt 1 6.00 Result 2 - Only price is negative Product Qty Price Pant 2 6.00 Pant 1 -6.00 ------------------------------------------------------------------------------------------------- Pant 1 6.00 Result Thanks for help!! Pintoo Tag: job failed om the sql server
  - 4
    - Unable to Install SQL Server 2005 Standard I'm attempting to install SQL Server 2005 Standard, on my personal PC which isn't on a network, there are no user accounts besides myself, I'm signed-on as admin. The logs from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG, all appear successful, although there are many more logs. When I look under Control Panel/Administrative Tools/Services, I see no service at all for SQL Server. I attempted to use the SQL Server Surface Area Configuration Tool, which told me no instances of the data-base had been loaded. I must admit, the install went a bit too fast for me to believe it was correct. I was never even asked for the product-key. This particular copy, was bundled with Visual Studio 2005 Pro, which was given to me by someone who attended a Microsoft seminar/demo of some sort. I've never used SQL Server before, and know nothing about it, so I hope I'm posting in the right forum. Any help would be appreciated, and I can provide listings of any log-file if needed. Thanxxxxxxxxxx in advance for any replies. I'm studying for MCTS, and am trying to work through ADO.Net Step by Step. Tag: job failed om the sql server
  - 5
    - Installation Hangs when on a large network Hi All, I have to do a lot of SQL Server Express 2005 installations and I've noticed that when I'm doing an install on a machine that's on a large network that the installer will "hang" towards the end of the installation process. The installer will say something about Local Groups and sit there for a really long time. As soon as I take the machine off of the network though (via unplugging the network cable) the installer jumps back into action. Of course, I've not seen this on a stand alone machine either... It would seem to me that the installer is trying to communicate via the network or something and then when it loses its LAN access it just moves on. But I'm not entirely sure why it would need to do that. More importantly, is there a way that I can keep it from doing this I'm doing a silent install so maybe I can use a command line swith or property In reviewing the command line options I didn't see much that seemed to fit; but perhaps one of you folks know of a way to achieve this. Thank you for anything you can offer. Tag: job failed om the sql server
  - 6
    - getting access to the data in group 2 from group1 I have a table with two groups.. like this Table Header Group 1 Header Group 2 header Detail Group 2 footer Group 1 footer Table footer I have a field value in group 2, I need to sum that field value in group 1. Is there any way to do this I thought you could go inwards in scope but not outwards Tag: job failed om the sql server
  - 7
    - SQL2000 and SQL2005 named instances on same server Is it the best practise to run SQL2000EE and SQL2005EE named instances on the same server on Windows 2K3 EE Any comments Tag: job failed om the sql server
  - 8
    - Bulk Insert Error Simple test project. Created Flat File connection, database connection (both local), and Bulk Insert Task. When running the package I get the following error: [Bulk Insert Task] Error: An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.Bulk load: An unexpected end of file was encountered in the data file.". I've tried different settings for the Flat File config, and the database connection, but still get the error. Any suggestions would be helpful. Tks. Tag: job failed om the sql server
  - 9
    - Does file connection manager not work offline? Hi there I have a connectin manager for file( New File Connection..) along with some oledb connection managers. Now If a put SSIS work Offline as True (I need this for some reason). Connection manager for File gives error as something -- "Connection manager for File connection failed with error code-0xc0014019,Connections cannot acquire connections while work offline is true." But other connections of olddb work fine. so do we have to change some more settings with file connection or with file connection we can't work offline Thanks and Regards Rahul Kumar Tag: job failed om the sql server
  - 10
    - run MDX query in SQL Server Agent issue Hello, We have 'Create global cube' MDX query running fine in Management studio, but it can not run in job agent, error massage: [136] Job testcube reported: Microsoft.AnalysisServices.Xmla.XmlaException: CREATE GLOBAL CUBE statement. FILENAME|C:\dw\cube\monthly\mycube.cub|DDL|<Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine " xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance"><Create AllowOverwrite="true"><ObjectDefinition><Database><ID>mycube</ID> <Name>mycube</Name> <Cubes><Cube><ID>mycube</ID><Name>mycube</Name> <ScriptErrorHandlingMode>IgnoreAll</ScriptErrorHandlingMode> <MeasureGroups><MeasureGroup> <ID>Fact mycube</ID><Name>Fact mycube</Name> <Source xsi:type="MeasureGroupBinding"><DataSourceID>mycube</DataSourceID><CubeID>mycube</CubeID><MeasureGroupID>Fact mycube</MeasureGroupID><Persistence>All</Persistence></Source><IgnoreUnrelatedDimensions>true</IgnoreUnrelatedDimensions><Measures><Measure><ID>Count Orders</ID><Name>Count Orders</Name><Visible>true</Visible><AggregateFunction>Sum</Aggregat Anyone could help with any suggestions Thanks in advance. Tag: job failed om the sql server
  - 11
    - Connection path OK on device, not on desktop This code... string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase); // Create the connection fConnection = new SqlCeConnection("Data Source =\"" + Path + "\\TreeNotes.sdf\" ;Password =\"abcd1234\";"); fConnection.Open(); ...works on my device, but on my computer it gives SqlCeException with message: The database file cannot be found. Check the path to the database. [ File name = \Program Files\TreeNotes\TreeNotes.sdf ] I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into... C:\Program Files\TreeNotes\TreeNotes.sdf ...hoping that the computer will find it there. What am I missing Tag: job failed om the sql server
  - 12
    - Problems With OLE DB Command Transformer I am trying to use the OLE DB Command Transformation to update rows in my table. When I make the connections and select the connectionmanager I get the following error: Error at Data Flow Task [OLE DB Command [6624]]: An OLE DB error has occurred. Error code: 0x80040E0C. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E0C Description: "Command text was not set for the command object.". I cannot figure out what to do. The connection is valid. I have used it in many places in the data stream. I also see that there are no output columns available for mapping. I didn't see a place to select the table. Can anyone please help. Thanks, Lee Tag: job failed om the sql server
  - 13
    - Print each tables in new page Options Hi All, I have a report which has four tables in it. But I have only one Dataset. Since this dataset has more then 30 fields, I have divided this into four tables to be shown in a report. This will help the user to take print of the report and place each print out side by side for view. Showing each table in a new page is just fine. It works. But when we take print out some times rows of second table are printed in same page that shows rows of first table. With this user can not put each print out side by side for view. Is there any way to set option like print each table in new page I mean to say after printing first table, second table print should start at new page. Thanks in advance. Tag: job failed om the sql server
  - 14
    - All my money in dollars please?? I have a Windows 2003 server, with SQL 2005. How do i change the culture/regional options for the database as on my local test machine (which seems to be exactly the same in terms of windows regional settings and SQL server settings) the currenency fields show with a ㏒ signs as expected, however on my production box they are $. I know this should be simple but its the night before a deadline and my brain is screwed. Please help!! Tag: job failed om the sql server
  - 15
    - Using Xcopy to get the .mdf file of pubs database to the App_Data folder of a website of VWD Express project Hi all, I have a stand-alone Windows XP Pro PC that has SQL Server Express (SSE) and Visual Web Developer Express (VWDE) programs. The Microsoft "pubs" Database is installed in the SQL Server Management Studio Express (SSMSE). I created a website in my VWDE program. I need the .mdf file of the pubs Database in the App_Data folder of website of my VWDE project. I think that User Instance in my SSE is established. I have studied Xcopy Deployment (SQL Server Express) and User Instance for a quite a while and I still do not know where and how to use Xcopy to get the mdf file of the pubs database into the App_Data folder of the website of my VWDE project. Please help and give me the detailed key steps/instructions about where and how to get the .mdf file of the pubs database into the App_Data folder of the website of my VWDE project via Xcopy. Thanks in advance, Scott Chang Tag: job failed om the sql server
  - 16
    - error column Hi, There is an error output from one oledb destination which causes error to another which populated a table called tblFailedRows. I have mapped the errorcolumn to the errorcolumn in tblFailedRows. When looking at the errorcolumn in tblFailedRows I see just numbers not the column name. How do I get the column name that causes the error Thanks Tag: job failed om the sql server
- Next
  - 1
    - Cannot shut down VS after using report designer Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP Tag: job failed om the sql server
  - 2
    - Report Header woes I am creating a report which consists of data in two columns. I've set the Body section to have 2 columns in it. This works fine until I start working with the report header. I do not want a page header that shows up on every page, I only want a header on the first page, a report header. I first tried to hide the header by placing it in the Page Header section, then putting in the "page > 1" expression in the visibility property. This does what I want, except a large blank space is present at the top of my report (the header is about 1.2 "). This is unacceptable. So my next test was to put the header into the Body section so that it only shows up in the beginning of the report. Because of this, I will need to remove the columns from the Body and make it only 1 column now. I decided to put the multi-column section into a subreport that has 2 columns and add this to the body of my report. But, this failed; the data appears in one column only. I can change the width the ensure it fits and set all other sorts of properties, nothing works. I've researched both issues and found that these are both "bugs" in reporting services, although I cannot find thedocumented bugs. Is there any workaround to putting a header onto only the first page of a multi-column report Other reporting engines are able to handle this with ease, I'm suprised by Reporting Services lack of a "Report Header" section. I am an experienced .NET developer, so if there is a programmatic way through this, I am game. Thanks, Scott Steigerwald Tag: job failed om the sql server
  - 3
    - Dynamic SQL and sp_executesql Hi I have a SP where i search for values in a column and returns the results. Problem is, if i send in %word% OR body LIKE %word2% i get no results but if i just send in %word% then i get results (i know there are results since i ran a regular query (not SP one) and got the results. The SP looks like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[doSearch] -- Add the parameters for the stored procedure here @searchWord nvarchar(4000) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @sql nvarchar(4000); DECLARE @ParmDefinition nvarchar(500); DECLARE @searchTitle nvarchar(500); DECLARE @searchName nvarchar(500); DECLARE @searchPath nvarchar(500); DECLARE @searchBody nvarchar(4000); DECLARE @searchDate DateTime; -- Insert statements for procedure here SELECT @sql = 'SELECT @sTitle = f.title, @sName = f.name, @sPath = f.path, @sBody = c.designBody, @sDate = c.lastModify FROM files AS f INNER JOIN contents AS c ON c.fileId = f.id WHERE (f.status = 2) AND (c.designBody LIKE @sWord) ORDER BY c.lastmodify DESC'; SET @ParmDefinition = N'@sWord nvarchar(4000), @sTitle nvarchar(500) OUTPUT, @sName nvarchar(500) OUTPUT, @sPath nvarchar(500) OUTPUT, @sBody nvarchar(4000) OUTPUT, @sDate DateTime OUTPUT'; EXEC sp_executesql @sql, @ParmDefinition, @sWord = @searchWord, @sTitle = @searchTitle OUTPUT, @sName = @searchName OUTPUT, @sPath = @searchPath OUTPUT, @sBody = @searchBody OUTPUT, @sDate = @searchDate OUTPUT; SELECT @searchTitle AS title, @searchName AS name, @searchPath AS path, @searchBody AS body, @searchDate AS lastmodify; END I am pretty sure that i have messed up somewhere. Thanks for the help in advance! Tag: job failed om the sql server
  - 4
    - Service Broker "TO service could not be found" Message origin: "Transport" I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: "Transport". This is my activated stored procedure that is sending the message to the target service. I am using certificate security. Any help appreciated.... CREATE PROCEDURE [usp_ProcessMessage] AS BEGIN SET NOCOUNT ON ; DECLARE @conversation_handle uniqueidentifier DECLARE @message_body AS VARBINARY ( MAX ) WHILE ( 1 = 1 ) BEGIN BEGIN TRANSACTION ; WAITFOR ( RECEIVE TOP ( 1 ) @conversation_handle = conversation_handle , @message_body = message_body FROM [tcp://mydomain.com/INITIATE/MyQueue] ), TIMEOUT 1000 ; IF ( @@ROWCOUNT = 0 ) BEGIN COMMIT ; BREAK ; END END CONVERSATION @conversation_handle IF @message_body IS NOT NULL BEGIN BEGIN DIALOG CONVERSATION @conversation_handle FROM SERVICE [tcp://mydomain.com/INITIATE/MyService] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' ON CONTRACT [tcp://mydomain.com/INITIATE/MyMessage/v1.0] WITH ENCRYPTION = ON , LIFETIME = 600 ; SEND ON CONVERSATION @conversation_handle MESSAGE TYPE [tcp://mydomain.com/TARGET/VisitMessage] ( @message_body ); END COMMIT ; END END GO My endpoints are created like so: CREATE ENDPOINT MyEndpoint STATE = STARTED AS TCP ( LISTENER_PORT = 4022 ) FOR SERVICE_BROKER ( AUTHENTICATION = CERTIFICATE MasterCertificate ) GO GRANT CONNECT TO CertOwner GRANT CONNECT ON ENDPOINT :: MyEndpoint TO CertOwner GO And my routes like so: GRANT SEND ON SERVICE :: [tcp://mydomain.com/INITIATE/MyService] TO CertOwner GO CREATE REMOTE SERVICE BINDING [MyCertificateBinding] TO SERVICE '[tcp://mydomain.com/TARGET/MyService]' WITH USER = CertOwner , ANONYMOUS = OFF CREATE ROUTE [tcp://mydomain.com/INITIATE/MyRoute] WITH SERVICE_NAME = '[tcp://mydomain.com/TARGET/MyService]' , BROKER_INSTANCE = N 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' , ADDRESS = N 'TCP://xxx.xx.xx.xx:4022' GO Tag: job failed om the sql server
  - 5
    - Where clause in a SET Can you use a WHERE clause in a set statement I want to limit the set I am building to a certain subset of data. SET [Customers] as ORDER ( NONEMPTY ([Dim Customer].[Name].[Name]. members ,[Measures].[Coil Weight]), [Measures].[Coil Weight], BDESC ) MEMBER measures.[Ton Rank] AS RANK ([Dim Customer].[Name]. CurrentMember ,[Customers]) Somewhere I'd like to add "WHERE ([Dim SalesType].[SalesYype] = "Sales")..............or something. Can this be done Thanks. Tag: job failed om the sql server
  - 6
    - Can i set somehow the package to have the components automaticaly updated? Help ... i'm lost I have one custom dataflow component in assembly A with version 1.1.0.0 used in many packages. The component is now in assembly A with version 1.2.0.0 but not changed. There is aniway to have those packaged configured in order to automaticaly be upgrated to use the new version of the component I tried (in this order): - set the property "UpdateObjects" to true on package (while version 1.1.0.0 was available in GAC) and saved package. - unistalled the version 1.1.0.0 from GAC. - tried to reopen package with "Reload and Upgrade" option. NO SUCCESS I know that can be an brute way to do it, meaning replace as text in xml ... but i try to find a solution not this stupid "workaround" Many thanx for any suggestions! Catalin PS: Excuse my english. Tag: job failed om the sql server
  - 7
    - Table transfer errors Hello, I am trying to transfer a database from one server to another using the Import Export wizard in SSIS and I am consistantly getting this error on 2 different tables so far. - Execute the transfer with the TransferProvider. (Error) Messages * ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (79)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider) This error message is beyond cryptic and when I click on the link it sends me to a web page the just tells me that there is no information available for my current issue. I am transfering the tables to an empty database so I do not understand why I am receiving this error. I have to say that I am not impressed with SSIS at all. I know alot of developers think it's the best thing since sliced bread, however either I am doing something wrong or Microsoft needs to come out with a service pack that fixes these bugs... Any help would be appreciated... Thanks, David Tag: job failed om the sql server
  - 8
    - Query takes more time from user interface or in a network I execute a pretty big sql query which joins multiple tables and I reviewed indexes on all these tables. I am happy with the result when I run the query using SSMS in the server locally i.e., where my SQL Server database is installed. It takes 4 seconds to get around 17000 records. If I run the same query in a network or from my desktop using SSMS i.e., i connect to the above mentioned SQL Server using SSMS, it takes more than 60 seconds. Not sure how to solve this. If someone could help me, it will be of great help. Thanks. Tag: job failed om the sql server
  - 9
    - Packege success, despite task failure Hello, When I run my package, a task will fail, however, the package will claim that it was successful. Why is this, and how can I trigger a failed package when one task fails Thanks in advance. Tag: job failed om the sql server
  - 10
    - Can i host a SQL2005 EE DB on SQL2000 engine ? Hi, I'd like to host a small website created using VS2005 EE with a company that offers just SQL2000 DB support. My question, can i use the DB created by VS site manager as a DB to the site, if not, is there any alternatives. Thanks. Tag: job failed om the sql server
  - 11
    - Incorrect processing order for views I am using SQL 2005 merge replication with SP1 hotfix build 9.00.2227.00. This build is in use rather than SP2 because a fix I need is not yet available for SP2 Essentially the problem is as follows: 1) Initial state is that merge replication of table and views is working fine 2) I then alter one view which reference s a new view in the same publication 3) Synchronization processes the view scripts in the wrong order regardless of the processing order 4) An 'invalid object name' error results as the new view has not arrived at the subscriber when alteration of the first view is attempted The number suffixes on the script filenames in the snapshot folder do, however,appear to be numbered correctly so as to process in the correct order Note that I have tried using the default processing order and have also set the processing order explicitly using sp_changemergearticle - but the problem still occurs I have tried to recreate this problem on a small database with a minimum of articles, but attempts at repro have failed to date with a simple configuration - ie the processing order applied is correct Is there an known problem in this area Any suggestions would be much appreciated aero1 Tag: job failed om the sql server
  - 12
    - Unable to read local eventlog (the parameter is incorrect) In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date: 03.11.2005 Time: 17:14:47 User: N/A Computer: RESYSHADOW Description: Unable to read local eventlog (reason: The parameter is incorrect) Does anyone know what could be causing this. I have tried it on Windows XP SP2 with local Admin account and on Windows Server 2003 with Domain Administrator Account and the SQL2005 Server is RTM with the same results. Tag: job failed om the sql server
  - 13
    - Database Blobs & Performance Hi geniuses, I have a core database question in MS Access and SQL Server. Assume the following table in MS Access or SQL Server: Employees table: EmpID, Name, Hiredate, Photo; and the following query: "SELECT EmpID, Name, Hiredate FROM Employees;" The question is, "does the blob object ( Photo) affect the performance of the query even when not included in the select statement " I mean, will I gain some additional performance when separating the blob fields to another table Thanks for the answer. Tag: job failed om the sql server
  - 14
    - How to extract domain name from an email address?? Hi do you know incase a script which extracts domain names from an email address like foreg. we have xyz@dmc.com or abce@dmc-int.com should give dmc and dmc-int Tag: job failed om the sql server
  - 15
    - problem connecting Remote Analysis service 2005 from vb.net 2005 hi mates, following code works fine in the server machine where sql server exists. but this doen't run at client machine. it throws error as " A connection cannot be made. Ensure that the server is running. " help to solve this problem thanks Code Snippet Dim msSvr As New Server Dim db As New Database Try If Not msSvr Is System.DBNull.Value Then msSvr.Disconnect() End If 'both connections r not working msSvr.Connect( "Provider=MSOLAP.9; datasource=http://server/olap/msmdpump.dll;Initial Catalog=testolap;user id=sa;password=sa;" ) msSvr.Connect( "Provider=SQLNCLI.1;Data Source=esERVER;user id=sa;password=sa;" ) If Not db Is System.DBNull.Value Then db.Dispose() End If db = msSvr.Databases.Find( "testdb" ) db.Process(ProcessType.ProcessFull) db.Refresh( True ) Catch ex As Exception Console.WriteLine(ex.Message) Finally db.Dispose() msSvr.Disconnect( True ) End Try Tag: job failed om the sql server
  - 16
    - select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: job failed om the sql server

Steam5

Hi,

i have a problem when i schedule an agent on the sql server and i log off the sql server ,

the agent failed with this msg' in the event viewr :

Login failed for user 'sa'. [CLIENT: <local machine>].

the account that run the SQL AGENT is NT AUTHORITY\NETWORKSERVICE.

i guess the problem is there but i can't find how to resolve it

i'll be happy for any help.

10X.

Re: job failed om the sql server

Steam5

anyone plz...

Re: job failed om the sql server

Steam5

Hi everyone,

If more info is need i'll be happy to give...

Thanks.

Re: job failed om the sql server

ggciubuc

I think NT AUTHORITY\NetworkService account is appropriate for MSDTC service but for SQL AGENT you need a domain account if you schedule activities on a network , so change SQL Agent logon account.

Re: job failed om the sql server

Jens K. Suessmeyer

Which service account is the service account running with

Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---

Re: job failed om the sql server

Arnie Rowland

These resources may help you sort out the service account requirements for SQL Agent.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

Re: job failed om the sql server

Steam5

the service account running with NT AUTHORITY\NetworkService.

(sql server agent service).

Re: job failed om the sql server

Arnie Rowland

As previously indicated, that is NOT a good account for the SQL Agent service.

Refer to the sources I posted for guidelines in setting up a domain account for your SQL Agent Service.