Error running report: job

Showing posts with label job. Show all posts

Thursday, March 29, 2012

Error when trying to execute a job from windows service.

Hi,
I'm trying to execute a DTS package from a .NET service. The service is
running under a domain account that owns the job which it executes using
'sp_start_job'. The call to the sp succeeds however checking the Job history
gives: -
"The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
job <JobName> has server access (reason: Could not obtain information about
Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Error 8198
))."
SQL Server 2000 SP4
Both SQLServer + SQLAgent run under a domain account (different to the
service)
ServiceUser has login to sql server not an admin, however I've tried using
the SQL Agent Proxy account still no success.
Any ideas?
thanks Paul> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
the SQL Agent service account must be a member of the local Administrators
group in order to "Create CmdExec and ActiveScript jobs belonging to someone
other than a SQL Server administrator".
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm trying to execute a DTS package from a .NET service. The service is
> running under a domain account that owns the job which it executes using
> 'sp_start_job'. The call to the sp succeeds however checking the Job
> history gives: -
> "The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
> job <JobName> has server access (reason: Could not obtain information
> about Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Er
ror
> 8198))."
> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
> Any ideas?
> thanks Paul
>|||Hi Dan,
Thanks that's sorted it. Also got it working using the proxy account
again this needed local admin rights.
Cheers Paul
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
> The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
> the SQL Agent service account must be a member of the local Administrators
> group in order to "Create CmdExec and ActiveScript jobs belonging to
> someone other than a SQL Server administrator".
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul Coulson" <nospam@.nospam.net> wrote in message
> news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
>|||I'm glad you were able to get it working. However, I'd be leery about
granting admin rights the proxy account since that allows non-sysadmins to
run processes with admin rights. Now that you got the service accounts
sorted out, I would expect your DTS package to run fine as long as the proxy
account has permissions on data and files accessed by the package.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:eCdaOR4OGHA.812@.TK2MSFTNGP10.phx.gbl...
> Hi Dan,
> Thanks that's sorted it. Also got it working using the proxy account
> again this needed local admin rights.
> Cheers Paul
>
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
>

Tuesday, March 27, 2012

Error when schedule a job in SQL 2005

Hi,

I have a SSIS package that contains an Execute DTS 2000 process. This DTS 2000 is calling a legacy package, which resides on the same server. The legacy package is just to import a flat file into the database. When i right click and execute this package, it runs perfectly without any errors. However, if i try to schedule this package as a job, it keeps failing.

I checked the flat file source for the permission, it does have the account of the executor of the package. In the view history, i didn't see any more information about why it is failing. It keeps saying "The job failed. The Job was invoked by Schedule 10...."

Does anyone have any ideas?

Did you try to turn on logging so you could get better error details?|||

Thanks, I turned on the log and it wrote to the application log events saying. Is there another log event in SQL 2005? I only saw it said "View History" in the scheduled job.

Status: Failed - Invoked on: 2006-11-06 13:56:00 - Message: The job failed. The Job was invoked by Schedule 24 (Test Schedule). The last step to run was step 1 (RUN ImportData)

|||See this KB about turning on logging and general troubleshooting of SSIS packages under Agent:
http://support.microsoft.com/kb/918760

error when running SSIS package as a job

I am running into an error when running a package using a scheduled job under SQL Server Agent account. I am getting following error:

Date 6/12/2007 4:19:15 PM
Log Job History (VistaODSFeed)

Step ID 0
Server 006-DEVSQL2005
Job Name VistaODSFeed
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. Unable to determine if the owner (ACI\snasir) of job VistaODSFeed has server access (reason: Could not obtain information about Windows NT group/user 'ACI\snasir', error code 0x6ba. [SQLSTATE 42000] (Error 15404)).

ACI\snasir is not the account under which SQL Server Agent service runs. However ACI\snasir has sa priveleges. not sure why am I getting ACI\snasir in the error and not the account under which sql server agent runs.

ideas?

Hi Shahab,

Is ACI\snasir hard-coded as the username in any of the connection managers?

Andy

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows;
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:

>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as f
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql

Error when running SQL Job

I get an Event ID: 40961 when running a job in SQL the error message is as follows
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.

Error when running RedGate SQL Backup Job in SQL Server 2005

I have 4 SQL Server 2005 production servers that I installed RedGate SQL Bac
k
up on. All but one run fine. The one that doesn't I get the below error.
Executed as user : AD-DomainName\UserName. SQL Backup job failed with
exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step f
ailed.
The back up is backing up to the AD server which is different than the
server the job runs on. It is a shared folder on the AD and the permissions
grant the owner of the job Full Access.
I do not know what else to do with this issue. It mirrors the other 3 that
work fine.
Any and all help is appreciated.
-ChrisChris,
SQL Server caches login information from active directory. The one
troublesome machine has apparently cached out of date AD information. In
David Grey's BLOG he discusses a similar problem (not with Red Gate) that
may help you resolve.
http://www.codefounders.com/communi...entication.aspx
RLF
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:2B7A5543-C258-4BA2-8CF4-BF2A7F4F1434@.microsoft.com...
>I have 4 SQL Server 2005 production servers that I installed RedGate SQL
>Back
> up on. All but one run fine. The one that doesn't I get the below error.
> Executed as user : AD-DomainName\UserName. SQL Backup job failed with
> exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step
> failed.
> The back up is backing up to the AD server which is different than the
> server the job runs on. It is a shared folder on the AD and the
> permissions
> grant the owner of the job Full Access.
> I do not know what else to do with this issue. It mirrors the other 3 that
> work fine.
> Any and all help is appreciated.
> -Chris
>

Monday, March 26, 2012

Error when running optimizer maintenance plan

Hi
I have 140GB data base with maintenance plan schedule
every sunday. when it run Optimizer plan
I get the error and the job failed if I rerun the job
some time it will completed but 1 out of 4 time it will
failed on
middle of reindex with the error [Microsoft SQL-DMO (ODBC
SQLState: 01000)] Error 0: This server has been
disconnected.
Have any one known what caused this problem?
Thank in advanceThe message indicates that SQL Server became unavailable to the client
connection. Check your SQL error log for any exceptions of access
violations. Also check to see if someone manually shutdown SQL Server.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Error when running DTS package as job

I have a DTS package which deletes some rows in a table and then inserts new ones from a Dbase file.

When I execute the package it works perfectly, but when I shedule it as a job it gives this error message:

Executed as user: LOMMELDOM\Administrator. ...DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: Copy Data from GRES to [ZNA].[dbo].[GRES] Step DTSRun OnError: Copy Data from GRES to [ZNA].[dbo].[GRES] Step, Error = -2147221164 (80040154) Error string: Class not registered Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700 Error Detail Records: Error: -2147221164 (80040154); Provider Error: 0 (0) Error string: Class not registered Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700 Error: -2147221164 (80040154); Provider Error: 0 (0) Error string: Class not registered Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4700 Error: -2147221164 (... Process Exit Code 5. The step failed.

The deleting of the rows works but the import from the Dbase doens't, I thought it was a security issue. So I made sure the JobAgent has all the rights it needs to access the directory of the Dbase file.

Any clues?

You are using a custom class / transform / task that is not registered on the server. You will need to register it through the GAC....|||But how come it works perfectly on the same server when I just execute the package? And on the same server it fails if job agent does it?|||

You are executing it on YOUR machine, even if it is hosted on the server.

Edit: Unless if you are running it from the job by right clicking and hitting execute job starting at step...

|||

Hi Eric,

Thanks for the reply.

Euh, my machine = server so there is no other machine around.

It fails when sheduled but it also fails when I right click the job and say execute. It only works if I right click the package and execute that! Further there are no other steps in the job and the job was created by right clicking on the package and sheduling it.

|||Looking a bit more closely at your error messages, are you running SSIS (SQL 2005)? It kind of looks like you are still using SQL 2000 and DTS...|||Yes I'm using SQL2000 with DTS, that's why I also mentionned this in the title of my question. I didn't find a DTS specific newsgroup.|||Try this one: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Error when running DTS package as job

I have a DTS package which deletes some rows in a table and then inserts new ones from a Dbase file.

When I execute the package it works perfectly, but when I shedule it as a job it gives this error message:

Any clues?

You are executing it on YOUR machine, even if it is hosted on the server.

Edit: Unless if you are running it from the job by right clicking and hitting execute job starting at step...

|||

Hi Eric,

Thanks for the reply.

Euh, my machine = server so there is no other machine around.

Error when running a back up job created n a SQL cluster

but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default...b;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/defaul...kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database withou
t
> making it a schedule job I get a good backup, when I create it as a job an
d
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [
;SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for data
base
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Er
ror
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
4035). The step failed.
Can anyone help me out on a solution?may be anything :)
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:
> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

Friday, March 23, 2012

error when importing text file - saving in notepad first works

I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message

Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067

However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.

The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.

The column has datatype DT_STR with a width of 500.

I use Locale Swedish and when I save in Notepad it is saved in ANSI,

I use Windows XP Swedish version.

Try DT_WSTR instead as its unicode.

There could be a control character in that field that gets thrown away when you save in Notepad.|||

Had the same error importing a text file. Error was resolved by changing the dataype as you advised. Thanks!

error when importing text file - saving in notepad first works

I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message

The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067

The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.

The column has datatype DT_STR with a width of 500.

I use Locale Swedish and when I save in Notepad it is saved in ANSI,

I use Windows XP Swedish version.

Try DT_WSTR instead as its unicode.

There could be a control character in that field that gets thrown away when you save in Notepad.|||

Had the same error importing a text file. Error was resolved by changing the dataype as you advised. Thanks!

Monday, March 19, 2012

Error when creating a backup job

Hello, I'm trying to do a backup of a database by creating a job for it....
I'm entering the command but when I do a Parse to ensure that the syntax is
correct, I'm getting the following error:
"TITLE: Parse Command Text
--
The following errors were detected in the command text.
--
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The identifier that starts with 'EXEC sp_addumpdecive 'disk',
'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
backup database WSS_Content to back' is too long. Maximum length is 128.
(Microsoft SQL Server, Error: 103)"
Is that because of the location(
'\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the backup
to?
Please help.....
ThanksShelly
Run in the job's step
BACKUP DATABASE dbname TO DISK = N'\\Server\folder\dbname.BAK'
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> Hello, I'm trying to do a backup of a database by creating a job for
> it....
> I'm entering the command but when I do a Parse to ensure that the syntax
> is
> correct, I'm getting the following error:
> "TITLE: Parse Command Text
> --
> The following errors were detected in the command text.
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> backup database WSS_Content to back' is too long. Maximum length is 128.
> (Microsoft SQL Server, Error: 103)"
> Is that because of the location(
> '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> backup
> to?
> Please help.....
> Thanks
>|||HI, ,thank you so much it worked.....
But I would like to know, what is the purose of the "N"?
Also, If i want to overwrite the backup, what do I need to include in the
command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's steps
> BACKUP DATABASE dbname TO DISK => N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > Hello, I'm trying to do a backup of a database by creating a job for
> > it....
> >
> > I'm entering the command but when I do a Parse to ensure that the syntax
> > is
> > correct, I'm getting the following error:
> >
> > "TITLE: Parse Command Text
> > --
> >
> > The following errors were detected in the command text.
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > backup database WSS_Content to back' is too long. Maximum length is 128.
> > (Microsoft SQL Server, Error: 103)"
> >
> > Is that because of the location(
> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > backup
> > to?
> >
> > Please help.....
> >
> > Thanks
> >
>
>|||Hi, thank you it worked.
However I would like to know what is the purpose of the "N"?
Also, If i want to overwrite the backup, what exactly do I need to include
in the command?
"Uri Dimant" wrote:
> Shelly
> Run in the job's step
> BACKUP DATABASE dbname TO DISK => N'\\Server\folder\dbname.BAK'
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > Hello, I'm trying to do a backup of a database by creating a job for
> > it....
> >
> > I'm entering the command but when I do a Parse to ensure that the syntax
> > is
> > correct, I'm getting the following error:
> >
> > "TITLE: Parse Command Text
> > --
> >
> > The following errors were detected in the command text.
> >
> > --
> > ADDITIONAL INFORMATION:
> >
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> >
> > --
> >
> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > backup database WSS_Content to back' is too long. Maximum length is 128.
> > (Microsoft SQL Server, Error: 103)"
> >
> > Is that because of the location(
> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > backup
> > to?
> >
> > Please help.....
> >
> > Thanks
> >
>
>|||Shelley
1) You do not have to use N.
http://support.microsoft.com/kb/239530
2) Use WITH INIT option of the BACKUP DATABASE command
"Shelley" <Shelley@.discussions.microsoft.com> wrote in message
news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...
> HI, ,thank you so much it worked.....
> But I would like to know, what is the purose of the "N"?
> Also, If i want to overwrite the backup, what do I need to include in the
> command?
> "Uri Dimant" wrote:
>> Shelly
>> Run in the job's steps
>> BACKUP DATABASE dbname TO DISK =>> N'\\Server\folder\dbname.BAK'
>>
>> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
>> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
>> > Hello, I'm trying to do a backup of a database by creating a job for
>> > it....
>> >
>> > I'm entering the command but when I do a Parse to ensure that the
>> > syntax
>> > is
>> > correct, I'm getting the following error:
>> >
>> > "TITLE: Parse Command Text
>> > --
>> >
>> > The following errors were detected in the command text.
>> >
>> > --
>> > ADDITIONAL INFORMATION:
>> >
>> > An exception occurred while executing a Transact-SQL statement or
>> > batch.
>> > (Microsoft.SqlServer.ConnectionInfo)
>> >
>> > --
>> >
>> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
>> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
>> > backup database WSS_Content to back' is too long. Maximum length is
>> > 128.
>> > (Microsoft SQL Server, Error: 103)"
>> >
>> > Is that because of the location(
>> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
>> > backup
>> > to?
>> >
>> > Please help.....
>> >
>> > Thanks
>> >
>>|||Hi, thanks alot..... it worked.
"Uri Dimant" wrote:
> Shelley
> 1) You do not have to use N.
> http://support.microsoft.com/kb/239530
> 2) Use WITH INIT option of the BACKUP DATABASE command
>
> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> news:6E0ED4AC-38AA-41C6-916A-E752D62185EF@.microsoft.com...
> > HI, ,thank you so much it worked.....
> > But I would like to know, what is the purose of the "N"?
> > Also, If i want to overwrite the backup, what do I need to include in the
> > command?
> >
> > "Uri Dimant" wrote:
> >
> >> Shelly
> >> Run in the job's steps
> >> BACKUP DATABASE dbname TO DISK => >> N'\\Server\folder\dbname.BAK'
> >>
> >>
> >> "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> >> news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> >> > Hello, I'm trying to do a backup of a database by creating a job for
> >> > it....
> >> >
> >> > I'm entering the command but when I do a Parse to ensure that the
> >> > syntax
> >> > is
> >> > correct, I'm getting the following error:
> >> >
> >> > "TITLE: Parse Command Text
> >> > --
> >> >
> >> > The following errors were detected in the command text.
> >> >
> >> > --
> >> > ADDITIONAL INFORMATION:
> >> >
> >> > An exception occurred while executing a Transact-SQL statement or
> >> > batch.
> >> > (Microsoft.SqlServer.ConnectionInfo)
> >> >
> >> > --
> >> >
> >> > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> >> > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> >> > backup database WSS_Content to back' is too long. Maximum length is
> >> > 128.
> >> > (Microsoft SQL Server, Error: 103)"
> >> >
> >> > Is that because of the location(
> >> > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> >> > backup
> >> > to?
> >> >
> >> > Please help.....
> >> >
> >> > Thanks
> >> >
> >>
> >>
> >>
>
>|||N makes the string Unicode.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Shelley" wrote:
> Hi, thank you it worked.
> However I would like to know what is the purpose of the "N"?
> Also, If i want to overwrite the backup, what exactly do I need to include
> in the command?
> "Uri Dimant" wrote:
> > Shelly
> > Run in the job's step
> > BACKUP DATABASE dbname TO DISK => > N'\\Server\folder\dbname.BAK'
> >
> >
> > "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> > news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > > Hello, I'm trying to do a backup of a database by creating a job for
> > > it....
> > >
> > > I'm entering the command but when I do a Parse to ensure that the syntax
> > > is
> > > correct, I'm getting the following error:
> > >
> > > "TITLE: Parse Command Text
> > > --
> > >
> > > The following errors were detected in the command text.
> > >
> > > --
> > > ADDITIONAL INFORMATION:
> > >
> > > An exception occurred while executing a Transact-SQL statement or batch.
> > > (Microsoft.SqlServer.ConnectionInfo)
> > >
> > > --
> > >
> > > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > > backup database WSS_Content to back' is too long. Maximum length is 128.
> > > (Microsoft SQL Server, Error: 103)"
> > >
> > > Is that because of the location(
> > > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > > backup
> > > to?
> > >
> > > Please help.....
> > >
> > > Thanks
> > >
> >
> >
> >|||Thank you
"Mohit K. Gupta" wrote:
> N makes the string Unicode.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Shelley" wrote:
> > Hi, thank you it worked.
> > However I would like to know what is the purpose of the "N"?
> > Also, If i want to overwrite the backup, what exactly do I need to include
> > in the command?
> >
> > "Uri Dimant" wrote:
> >
> > > Shelly
> > > Run in the job's step
> > > BACKUP DATABASE dbname TO DISK => > > N'\\Server\folder\dbname.BAK'
> > >
> > >
> > > "Shelley" <Shelley@.discussions.microsoft.com> wrote in message
> > > news:17373ED1-5AF5-48BD-9161-0D39F4207BCB@.microsoft.com...
> > > > Hello, I'm trying to do a backup of a database by creating a job for
> > > > it....
> > > >
> > > > I'm entering the command but when I do a Parse to ensure that the syntax
> > > > is
> > > > correct, I'm getting the following error:
> > > >
> > > > "TITLE: Parse Command Text
> > > > --
> > > >
> > > > The following errors were detected in the command text.
> > > >
> > > > --
> > > > ADDITIONAL INFORMATION:
> > > >
> > > > An exception occurred while executing a Transact-SQL statement or batch.
> > > > (Microsoft.SqlServer.ConnectionInfo)
> > > >
> > > > --
> > > >
> > > > The identifier that starts with 'EXEC sp_addumpdecive 'disk',
> > > > 'backup_file1', '\\tcl-fileserver3\backups\moss-weekly\weekly'
> > > > backup database WSS_Content to back' is too long. Maximum length is 128.
> > > > (Microsoft SQL Server, Error: 103)"
> > > >
> > > > Is that because of the location(
> > > > '\\tcl-fileserver3\backups\moss-weekly\weekly') I am trying to do the
> > > > backup
> > > > to?
> > > >
> > > > Please help.....
> > > >
> > > > Thanks
> > > >
> > >
> > >
> > >

Error when creating a backup job

Monday, March 12, 2012

Error when changing job owner

When I change one of my job owners on a job that does a simple select, from
sa to a domain account, the job fails giving me the following error:
Could not obtain information about Windows NT group/user 'MyDomain\ADUser'
Error 8198.
I verified this login was a part of the Pre-Windows 2000 Compatible Access
Group (kb 241643). Next I tried using xp_logininfo with this login, and I
got the same error. Then I took out the select from the xp and ran it
separately (select distinct domain+N'\'+name, sid, sidtype from
OpenRowset(NetUserGetGroups, 'mydomain\aduser') and got the same error.
When I ran the above select statement with unknow domain\login, I got the
same error.
Any help would be appreciated.
Paul
You might want to have a look at
How to troubleshoot a SQL Server 8198 error
http://support.microsoft.com/default...b;en-us;834124
and
FIX: You Receive an Error Message When the xp_logininfo Extended Stored
Procedure Runs
http://support.microsoft.com/default.aspx?kbid=830596
Also make sure you are on the latest windows service pack
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul Bergstedt" <Paul@.nospam.com> wrote in message
news:uLmmgm4XEHA.3664@.TK2MSFTNGP12.phx.gbl...
> When I change one of my job owners on a job that does a simple select,
from
> sa to a domain account, the job fails giving me the following error:
> Could not obtain information about Windows NT group/user 'MyDomain\ADUser'
> Error 8198.
> I verified this login was a part of the Pre-Windows 2000 Compatible Access
> Group (kb 241643). Next I tried using xp_logininfo with this login, and I
> got the same error. Then I took out the select from the xp and ran it
> separately (select distinct domain+N'\'+name, sid, sidtype from
> OpenRowset(NetUserGetGroups, 'mydomain\aduser') and got the same error.
> When I ran the above select statement with unknow domain\login, I got the
> same error.
> Any help would be appreciated.
> Paul
>
|||After trying everying under the sun, I tried putting the server name into
the Pre-Windows 2000 Access Group, and that fixed the problem. I got this
idea after noticing that the service account that the SQL Server services
ran under was the local System Account. I would imagine if I were running
the services under a domain account that it too would need to be added. I
have a case open with Microsoft on this, so I will ask them to suggest
putting this info into the KB article listed below.
Paul
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eybsju6XEHA.1764@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> You might want to have a look at
> How to troubleshoot a SQL Server 8198 error
> http://support.microsoft.com/default...b;en-us;834124
> and
> FIX: You Receive an Error Message When the xp_logininfo Extended Stored
> Procedure Runs
> http://support.microsoft.com/default.aspx?kbid=830596
> Also make sure you are on the latest windows service pack
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Paul Bergstedt" <Paul@.nospam.com> wrote in message
> news:uLmmgm4XEHA.3664@.TK2MSFTNGP12.phx.gbl...
> from
'MyDomain\ADUser'[vbcol=seagreen]
Access[vbcol=seagreen]
I[vbcol=seagreen]
the
>

Error when changing job owner

When I change one of my job owners on a job that does a simple select, from
sa to a domain account, the job fails giving me the following error:
Could not obtain information about Windows NT group/user 'MyDomain\ADUser'
Error 8198.
I verified this login was a part of the Pre-Windows 2000 Compatible Access
Group (kb 241643). Next I tried using xp_logininfo with this login, and I
got the same error. Then I took out the select from the xp and ran it
separately (select distinct domain+N'\'+name, sid, sidtype from
OpenRowset(NetUserGetGroups, 'mydomain\aduser') and got the same error.
When I ran the above select statement with unknow domain\login, I got the
same error.
Any help would be appreciated.
PaulYou might want to have a look at
How to troubleshoot a SQL Server 8198 error
http://support.microsoft.com/default.aspx?scid=kb;en-us;834124
and
FIX: You Receive an Error Message When the xp_logininfo Extended Stored
Procedure Runs
http://support.microsoft.com/default.aspx?kbid=830596
Also make sure you are on the latest windows service pack
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul Bergstedt" <Paul@.nospam.com> wrote in message
news:uLmmgm4XEHA.3664@.TK2MSFTNGP12.phx.gbl...
> When I change one of my job owners on a job that does a simple select,
from
> sa to a domain account, the job fails giving me the following error:
> Could not obtain information about Windows NT group/user 'MyDomain\ADUser'
> Error 8198.
> I verified this login was a part of the Pre-Windows 2000 Compatible Access
> Group (kb 241643). Next I tried using xp_logininfo with this login, and I
> got the same error. Then I took out the select from the xp and ran it
> separately (select distinct domain+N'\'+name, sid, sidtype from
> OpenRowset(NetUserGetGroups, 'mydomain\aduser') and got the same error.
> When I ran the above select statement with unknow domain\login, I got the
> same error.
> Any help would be appreciated.
> Paul
>|||After trying everying under the sun, I tried putting the server name into
the Pre-Windows 2000 Access Group, and that fixed the problem. I got this
idea after noticing that the service account that the SQL Server services
ran under was the local System Account. I would imagine if I were running
the services under a domain account that it too would need to be added. I
have a case open with Microsoft on this, so I will ask them to suggest
putting this info into the KB article listed below.
Paul
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eybsju6XEHA.1764@.TK2MSFTNGP10.phx.gbl...
> You might want to have a look at
> How to troubleshoot a SQL Server 8198 error
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834124
> and
> FIX: You Receive an Error Message When the xp_logininfo Extended Stored
> Procedure Runs
> http://support.microsoft.com/default.aspx?kbid=830596
> Also make sure you are on the latest windows service pack
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Paul Bergstedt" <Paul@.nospam.com> wrote in message
> news:uLmmgm4XEHA.3664@.TK2MSFTNGP12.phx.gbl...
> > When I change one of my job owners on a job that does a simple select,
> from
> > sa to a domain account, the job fails giving me the following error:
> >
> > Could not obtain information about Windows NT group/user
'MyDomain\ADUser'
> > Error 8198.
> >
> > I verified this login was a part of the Pre-Windows 2000 Compatible
Access
> > Group (kb 241643). Next I tried using xp_logininfo with this login, and
I
> > got the same error. Then I took out the select from the xp and ran it
> > separately (select distinct domain+N'\'+name, sid, sidtype from
> > OpenRowset(NetUserGetGroups, 'mydomain\aduser') and got the same error.
> > When I ran the above select statement with unknow domain\login, I got
the
> > same error.
> >
> > Any help would be appreciated.
> >
> > Paul
> >
> >
>

Thursday, March 29, 2012

Error when trying to execute a job from windows service.

Tuesday, March 27, 2012

Error when schedule a job in SQL 2005

error when running SSIS package as a job

Error when running SQL Job

Error when running SQL Job

Error when running SQL Job

Error when running RedGate SQL Backup Job in SQL Server 2005

Monday, March 26, 2012

Error when running optimizer maintenance plan

Error when running DTS package as job

Error when running DTS package as job

Error when running a back up job created n a SQL cluster

Error when running a back up job created n a SQL cluster

Error when running a back up job created n a SQL cluster

Friday, March 23, 2012

error when importing text file - saving in notepad first works

error when importing text file - saving in notepad first works

Monday, March 19, 2012

Error when creating a backup job

Error when creating a backup job

Error when creating a backup job

Monday, March 12, 2012

Error when changing job owner

Error when changing job owner

Error running report

Blog Archive

About Me