Failed to schedule DTS in SQL 2005

Hello,

I am trying to to schedule DTS Package but this message appear .

Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (1). and this

Message
Executed as user: Computer name\SYSTEM. The package execution failed. The step failed

so how I can schedule DTS Package in sql 2005 .

Do you have logging enabled for this package? if enabled check the log file it should have more detailed information on the error.

The error you have posted is a very generic error from the job agent, and it does not give any information.

Thanks

|||

Sounds like you might have some issues with the account settings. See the following thread for tips on setting up proxies / credentials / jobs etc.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

|||

Thanks, all

But still the same problem even I did all thing to solve but still can't schedule DTS, but when I see th proparites of the

SQL Server Agent-->Connection and found the sql server connection grayed out and can't select or change it . so may be this is the problem but how to run the agent under sa account .

|||

Assuming you are talking about the connection infromation on the left hand side of the job properties screen, that connection information is how you are currently connected to the sql server. You would need to look at the steps tab and click edit on the step associated with the package you are trying to run. At the top of this screen there will be a place for the step name (i.e. run package x), the type (sql server integration services package) and the run as. You would select the correct proxy name from the run as drop down that ties to your sa account...

|||

Thanks very much for you reply but I still can't schedule the DTS even though when I execute the dts it's work fine and I did all thing what said here http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp

|||

I am trying to schedule working DTS in sql server 2005 sp 2 . but I it failed and got this message . I searched at Internet and found this

http://support.microsoft.com/kb/904796

but I can’t understand how to solve it, any one can help please .

Message

Executed as user: ComputrName\Administrator. ...00.3042.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.Started:10:16:11 ?Error: 2007-08-17 22:16:12.95Code: 0x00000000Source: Copy Data from ROOM toDBNamedboER_ROOMTaskDescription: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.at DTS.PackageClass.Execute()at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()End ErrorError: 2007-08-17 22:16:14.75Code: 0x00000000Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.at DTS.PackageClass.Execute()at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()End ErrorError: 2007-08-17 22:16:15.14Code: 0x00000000The package execution fa...The step failed.

|||

how to Reinstall the SQL Server 2000 tools? where to find it .

Still no solution can solve this issue .

sql

Failed to reserve contiguous memory

Hello people

I have a problem with my Sql,i Run SQL Server 2000 SP4 with Windows 2003 Server and i got the Hyper Threading Technology.

My log is here some one can help?

2007-02-27 07:31:12.30 spid59 WARNING: Failed to reserve contiguous memory of Size= 65536.
2007-02-27 07:31:12.31 spid59 Buffer Distribution: Stolen=609 Free=911 Procedures=523
Inram=0 Dirty=63344 Kept=0
I/O=0, Latched=32, Other=47333

2007-02-27 07:31:12.31 spid59 Buffer Counts: Commited=112752 Target=113711 Hashed=110709
InternalReservation=122 ExternalReservation=2216 Min Free=128 Visible= 113711

2007-02-27 07:31:12.31 spid59 Procedure Cache: TotalProcs=251 TotalPages=523 InUsePages=291

2007-02-27 07:31:12.31 spid59 Dynamic Memory Manager: Stolen=1132 OS Reserved=960
OS Committed=938
OS In Use=924
Query Plan=681 Optimizer=0
General=1169
Utilities=10 Connection=89

2007-02-27 07:31:12.31 spid59 Global Memory Objects: Resource=960 Locks=86
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 07:31:12.31 spid59 Query Memory Manager: Grants=1 Waiting=0 Maximum=84834 Available=82618

2007-02-27 07:38:01.30 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 07:38:01.30 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to d:\sql_sdb\MSSQL\log\SQLDump0058.txt

2007-02-27 07:38:01.30 spid57 Error: 0, Severity: 19, State: 0

2007-02-27 07:38:01.30 spid57 SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 02/27/07 07:38:01 spid 57
*
* Exception Address = 1047100B
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000010
* Input Buffer 46 bytes -
* exec dbo.sp_good_prodP2
*
*
* MODULE BASE END SIZE
*
* Edi: 00000001:
* Esi: 000000A0:
* Eax: 00000000:
* Ebx: 00000000:
* Ecx: 19D417F8: 00000001 000000A0 00000002 00000064 00000000 18720048
* Edx: 1715A1C0: 08DB1538 0057005C 004E0049 004F0044 00530057 0073005C
* Eip: 1047100B: 8B104B8B F7D233C6 D28557F1 748B1E74 10681824 8D104730
* Ebp: 08B3E618: 18963218 060589B0 19D417F8 19E57580 18720048 000000A0
* SegCs: 0000001B:
* EFlags: 00010246: 005C003A 00720050 0067006F 00610072 0020006D 00690046
* Esp: 08B3E5E0: 16591DC8 08B3E618 19E57580 0605FA1D 00000000 19E57580
* SegSs: 00000023:
* *******************************************************************************
* -
* Short Stack Dump
* 1047100B Module(UNKNOWN+00000000)
* 060589B0 Module(UNKNOWN+00000000)
* -
2007-02-27 07:38:01.33 spid57 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 07:38:04.69 spid57 Stack Signature for the dump is 0x268BA9A6

2007-02-27 07:38:04.70 spid57 Error: 0, Severity: 19, State: 0

2007-02-27 07:38:04.70 spid57 language_exec: Process 57 generated an access violation. SQL Server is terminating this process..

2007-02-27 07:58:59.03 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536.

2007-02-27 07:58:59.05 spid57 Buffer Distribution: Stolen=438 Free=189 Procedures=524
Inram=0 Dirty=63086 Kept=0
I/O=0, Latched=36, Other=47606

2007-02-27 07:58:59.05 spid57 Buffer Counts: Commited=111879 Target=112935 Hashed=110728
InternalReservation=154 ExternalReservation=0 Min Free=128 Visible= 112935

2007-02-27 07:58:59.05 spid57 Procedure Cache: TotalProcs=252 TotalPages=524 InUsePages=291

2007-02-27 07:58:59.05 spid57 Dynamic Memory Manager: Stolen=962 OS Reserved=920
OS Committed=898
OS In Use=894
Query Plan=488 Optimizer=0
General=1165
Utilities=10 Connection=86

2007-02-27 07:58:59.05 spid57 Global Memory Objects: Resource=960 Locks=77
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 07:58:59.05 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=84256 Available=84256

2007-02-27 08:09:50.45 spid57 WARNING: Failed to reserve contiguous memory of Size= 65536.

2007-02-27 08:09:50.45 spid57 Buffer Distribution: Stolen=436 Free=187 Procedures=526
Inram=0 Dirty=63089 Kept=0
I/O=0, Latched=36, Other=47605

2007-02-27 08:09:50.45 spid57 Buffer Counts: Commited=111879 Target=112927 Hashed=110730
InternalReservation=158 ExternalReservation=0 Min Free=128 Visible= 112927

2007-02-27 08:09:50.45 spid57 Procedure Cache: TotalProcs=253 TotalPages=526 InUsePages=291

2007-02-27 08:09:50.45 spid57 Dynamic Memory Manager: Stolen=962 OS Reserved=920
OS Committed=898
OS In Use=894
Query Plan=488 Optimizer=0
General=1165
Utilities=10 Connection=86

2007-02-27 08:09:50.45 spid57 Global Memory Objects: Resource=960 Locks=77
SQLCache=43 Replication=2
LockBytes=2 ServerGlobal=25
Xact=52

2007-02-27 08:09:50.45 spid57 Query Memory Manager: Grants=0 Waiting=0 Maximum=84250 Available=84250

2007-02-27 08:18:00.67 spid60 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

2007-02-27 08:18:00.68 spid60 CImageHelper::Init () Failed load of dbghelp.dll - Not enough storage is available to process this command.

***Symbol load failed - Proceed to dump without any symbols
*Stack Dump being sent to d:\sql_sdb\MSSQL\log\SQLDump0059.txt

2007-02-27 08:18:00.68 spid60 Error: 0, Severity: 19, State: 0

2007-02-27 08:18:00.68 spid60 SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************

Sounds like you ran out of memory. Add more memory and then check the configuration settings in Books Online for Server Memory. It will guide you through what you need to do.sql

Failed to open a rowset Warning/Error

Hi there

I am working in CR 9.0 and have included subreports in the main report.

Whenever I run the main report and have to give the Login ID & password for the " HiT ODBC / 400 Driver" (DataSource - AS400) I get the following warning/error.

"Failed to open a rowset.
Details: HY000:{HiT][HiT ODBC/400][SQL/400][ODBS Error][SQL0128] Use of NULL is not valid"

If I click the OK button the report is generated.

If I run the same report the second/third time - where I do not have to specify the Login ID & password the error/warning does not occur.

How do I get rid of this warning/error msg.

rkpYou need to pass them in the Front End coding

Failed to notify 'DBA' via email

We have some SQL jobs those run on a schedule basis. These jobs are setup to
notify us via email in case of job fails. However, Some time we get this
error "Failed to notify 'DBA' via email." Initially I thought it may be b/c
of mail server was not available but our exchnage server admin has looked at
exchange logs and not found any thing at that time. I also looked at the SQL
server logs and did not find any issues. My question is: is there any thing
can go wrong in the SQL server that can cause this probelm?
Help is appreciated.
Thanks,
MohMoh,
FWIW - SQL Server MAPI will only wait a certain amount of time to deliver a
message. If it cannot get out, then the mail will 'fail' even though
Exchange is up and running and healthy. It might be Exchange, networking,
domain issues, etc. that cause the problem.
If you Google on "sql mail Failed to notify" you will see a few comments on
this, without any real help that I could find.
(Unless xp_smtp_sendmail would work for you.)
RLF
"Moh Abb" <mabbas@.aligntech.com> wrote in message
news:eiv3swh3EHA.3376@.TK2MSFTNGP12.phx.gbl...
> We have some SQL jobs those run on a schedule basis. These jobs are setup
to
> notify us via email in case of job fails. However, Some time we get this
> error "Failed to notify 'DBA' via email." Initially I thought it may be
b/c
> of mail server was not available but our exchnage server admin has looked
at
> exchange logs and not found any thing at that time. I also looked at the
SQL
> server logs and did not find any issues. My question is: is there any
thing
> can go wrong in the SQL server that can cause this probelm?
> Help is appreciated.
> Thanks,
> Moh
>|||"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:ePA64pj3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Moh,
> FWIW - SQL Server MAPI will only wait a certain amount of time to deliver
a
> message. If it cannot get out, then the mail will 'fail' even though
> Exchange is up and running and healthy. It might be Exchange, networking,
> domain issues, etc. that cause the problem.
> If you Google on "sql mail Failed to notify" you will see a few comments
on
> this, without any real help that I could find.
Generally I find if you don't absolutely need to use Exchange, setup a local
SMTP server right on teh SQL box and send email through that directly.
Eliminates timeouts, etc.
> (Unless xp_smtp_sendmail would work for you.)
> RLF
> "Moh Abb" <mabbas@.aligntech.com> wrote in message
> news:eiv3swh3EHA.3376@.TK2MSFTNGP12.phx.gbl...
> > We have some SQL jobs those run on a schedule basis. These jobs are
setup
> to
> > notify us via email in case of job fails. However, Some time we get this
> > error "Failed to notify 'DBA' via email." Initially I thought it may be
> b/c
> > of mail server was not available but our exchnage server admin has
looked
> at
> > exchange logs and not found any thing at that time. I also looked at the
> SQL
> > server logs and did not find any issues. My question is: is there any
> thing
> > can go wrong in the SQL server that can cause this probelm?
> >
> > Help is appreciated.
> >
> > Thanks,
> > Moh
> >
> >
>
>

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
--
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
--
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
RonenRonen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00
">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00
">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Lin
e
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
>|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>sql

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
Ronen
Ronen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>
|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...[vbcol=seagreen]
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>

Failed to generate a user instance of SQL Server??

I use VS2005 & sql2005express to create a website, but it cannot to display data.

When I run it, I got such errors:

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

My web.config file:

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>

When I change the User Instance=True to False, it works, but MSDN says it is not safe.

I searched the past threads, which writes "delete the folder C:\Documents and Settings\yy\Local Settings\Application Data\Microsoft\Sqlserver Data, it will work".

I try, but failed. What should I do??

have u resolved this error, I'm getting the same?

Failed to decrypt XML node "DTS:Password"

Hi!
I made an SSIS package and it runs fine on my workstation, but it fails when I run it on the SQL Server.
I'm using an ODBC connection and when I run the package, I get the error message:
"Login failed. Check for valid user ID, server name or password".
I tried to load the project in Visual Studio on the Server and got the error message above:
Failed to decrypt XML node "DTS:Password"
How can I set up the permissions for decrypting the password?

Thanks for any help!

The problem is that you have the ProtectionLevel set to "EncryptSensitiveWithUserKey". This means the package can be executed only by the user that created the package and on the machine that it was created. (unless you use a domain account and use machines in the same domain)

If you import the package on your server I recomend to change the ProtectionLevel to "EncryptSensitiveWithPassword" - will ecnrypt sensitive information like passwords - or if you store the package on SqlServer you can use "Rely on server storageand rolse for access control" - this means that the package will be stored unencrypted on the SQL Server.

The package can be stored unencrypted ONLY in the SQL Server.

HTH.
Ovidiu Burlacu

|||Thanks for the explanation!
I tried to use the last option"Rely on server storageand rolse for access control", however it causes a lot of error messages in the Business Intelligence Studio and I can not create a build with a deployment manifest. The help sais, this option is not accessible from Visual Studio, but I can not figure out, how to use it.
Can you tell me, how I can use it?
|||

Are you saving the package on a SQL Server or to a file? You can use ServerStorage ONLY if you save the package on SQL Server

To save a package from BIDS directly to SQL Server use File-> "Save Copy of <package_name>.dtsx As..." and in the dialogs that appears you can specify a SQL Server

If you want to create a deployment manifest encrypt with a passord and when you run the Deployment wizard and specify the destination to be a SQL Server the you can choose the "Rely on server storage and role for access control".

HTH,
Ovidiu

|||Thanks alot!

failed to create crystal query engine

Hi,
when trying to run crystal reports from within application the error:
'Crystal.CRPE.Application' Failed to create the Crystal Query Engine. appears.
The full install has been done and is version 8.5
any help appreciatedOpen the report and do verify database
or try it here
http://support.businessobjects.com/

failed to connect to the server

When I have a subscription built for a report it runs at the time expected, but the report send via e-mail fails. I can run the report from a client workstation just fine. I can also run it from the admin tool fine too, it just will not run as part of a subscription. The full context of the error message is as follows:

Failure sending mail: The transport failed to connect to the server

This is not my first Reporting services report, but I am trying to replace all Crystal reports with Reporting services reports and this functionality is greatly needed.

Thanks! - Eric-

The error is telling you the RS server cannot connect to the Mail server. Make sure that the unattended execution account is setup and is a user that has access to the mail server.

Here is a link to help you.

http://msdn2.microsoft.com/en-us/library/ms155851.aspx

Failed Maintenance Plan

Please advice.
I run a SQL2k SP4 on WIN2K SP4.
I have a maintenance plan to backup the databases at 01:30AM. This has alway
s been succesfull.
Strangely it did the backup at 02:25PM with no entry in SQL Error Log and ca
using subsequent backups to fail as the files created had the 02:25 badge he
nce could not be deleted.
Please help as to what caused the maintenance plan to backup at 02:25 and wh
at to do to avoid it.
Thanks for your kind response.I posted a reply to this yesterday. Here's that text:
My guess is that it wasn't Main Plan that did the backup, someone else did i
t (or explicitly started the main
plan job, or scheduled the main plan job at that hour). If it was executed a
s a job, you can view the job
history under EM, Management, Jobs. In any event, each backup is written to
the eventlog and the errorlog
file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Timi" <anonymous@.discussions.microsoft.com> wrote in message
news:EA0A7329-EAA1-49B3-9DDB-1736B6F35A4C@.microsoft.com...
> Please advice.
> I run a SQL2k SP4 on WIN2K SP4.
> I have a maintenance plan to backup the databases at 01:30AM. This has alw
ays been succesfull.
> Strangely it did the backup at 02:25PM with no entry in SQL Error Log and causing
subsequent backups to fail
as the files created had the 02:25 badge hence could not be deleted.
> Please help as to what caused the maintenance plan to backup at 02:25 and
what to do to avoid it.
> Thanks for your kind response.
>|||Thanks for your response.
The maint plan was ran at 02:25AM as opposed to 01:30AM the scheduled time.|||can you check with your server guys if there was a problem
with the server which resulted in it being restarted on or
arounf 2:25 ?, but the best way of finding out is to check
the error log.
J

>--Original Message--
>Thanks for your response.
>The maint plan was ran at 02:25AM as opposed to 01:30AM
the scheduled time.
>.
>|||Agent does no run a job if it was down at the time it should have executed.
I doubt that this is the reason,
based on that. I bet a beer that someone started the job at that time.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message news:13fdd01c41357$84085e80$
a301280a@.phx.gbl...
> can you check with your server guys if there was a problem
> with the server which resulted in it being restarted on or
> arounf 2:25 ?, but the best way of finding out is to check
> the error log.
> J
>
> the scheduled time.|||Bet a beer against you and your SQL Server knowledge, never ;)
Anyway your right but my sneaky plan was to get Timm to check the server, as
we both agree thats where the problem is, and who actually started it.|||:-)
<<as we both agree thats where the problem is, and who actually started it.>
>
Yep.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:D6CB3367-9F9F-4633-B7FE-3FBEBFFA8B74@.microsoft.com...
> Bet a beer against you and your SQL Server knowledge, never ;)
> Anyway your right but my sneaky plan was to get Timm to check the server, as we bo
th agree thats where the
problem is, and who actually started it.

Failed Maintenance Plan

Please advice.
I run a SQL2k SP4 on WIN2K SP4.
I have a maintenance plan to backup the databases at 01:30AM. This has alway
s been successfull.
Strangely it did the backup at 02:25PM with no entry in SQL Error Log and ca
using subsequent backups to fail as the files created had the 02:25 badge he
nce could not be deleted.
Please help as to what caused the maintenece plan to backup at 02:25 and wha
t to do to avoid it.
Thanks for your kind response.My guess is that it wasn't Main Plan that did the backup, someone else did i
t (or explicitly started the main
plan job, or scheduled the main plan job at that hour). If it was executed a
s a job, you can view the job
history under EM, Management, Jobs. In any event, each backup is written to
the eventlog and the errorlog
file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Timi" <anonymous@.discussions.microsoft.com> wrote in message
news:CDA33615-5054-47D3-8D06-0A52B8FB7544@.microsoft.com...
> Please advice.
> I run a SQL2k SP4 on WIN2K SP4.
> I have a maintenance plan to backup the databases at 01:30AM. This has alw
ays been successfull.
> Strangely it did the backup at 02:25PM with no entry in SQL Error Log and causing
subsequent backups to fail
as the files created had the 02:25 badge hence could not be deleted.
> Please help as to what caused the maintenece plan to backup at 02:25 and w
hat to do to avoid it.
> Thanks for your kind response.
>

Failed Login for a WorkGroup when attempting to run a query

Hi all,
I have an application which works with SQL Server. When the applicationattempts to load a page it needs to run certain queries. When itattempts to run a particular query it fails but I catch the exceptionand then log it. The following is logged:
System.Data.Ole.Db.OleDbException: Login failed for user 'CWAMB01DWH01\ASPENT'.
Now what I don't understand is that this is the work group that ASPNETis run under, and I am running other queries to the database via SQLServer authentication. Why am I getting a failed login for thisworkgroup? Do I need to create a new Login for the Server in SQLServer, and then create a new user for the database with the sameusername as the Workgroup name? If so, then how does the password workfor the SQL Server as the workgroup (CWAMB01DWH01\ASPENT) obviouslydoesn't have a password.
Thanks, and I hope I have explain my problem clear enough.
Tryst
There are two permissions in SQL Server database permissions in the database and server permissions you create under security in Enterprise Manager. Hope this helps.

Failed Job Message

This is a post
I am in desparate need of some help with SQL Server 2000. I recently created several jobs to run at night to update several tables in my SQL Server. I then realized that I could schedule one job with various steps, so I tried to delete the original jobs
with the stored proc. but could not seem to get it to work. While examining the sysjob table in the msdn database I deleted one of the old jobs. This is where the problem started. I have since deleted the job steps out of the sysjobsteps and the sysjo
bschedule as well as systaskids for that same job. I am still getting the error notification each morning that the job failed Unable to retrieve steps for the certain job. Where is this notification coming from? Because there is no jobs or job steps in
any of the tables. Any help would greatly be appreciated.
There is a bit more that goes on in deleting a job than just
deleting rows from these tables. Jobs can be stored in the
job cache so there are also procedures that check the job
cache and update it if necessary - I think it's through
sp_agent_notify if I remember correctly. There could also be
some other references to the jobs in some of the other job
tables. That's why modifying these tables directly isn't
recommended. You could try restarting SQL Agent if you
didn't do so after modifying the tables but I'd guess you
could still have some other dangling references to the job
which may or may not affect things.
You may want to consider restoring your msdb database from
prior to your modifying the job tables and then delete the
jobs using sp_delete_job which is the supported method of
dropping a job. Using sp_delete_job will handle all the
details, update the job cache if necessary, etc.
-Sue
On Tue, 20 Apr 2004 10:51:04 -0700, "Cartman"
<anonymous@.discussions.microsoft.com> wrote:

>This is a post
>I am in desparate need of some help with SQL Server 2000. I recently created several jobs to run at night to update several tables in my SQL Server. I then realized that I could schedule one job with various steps, so I tried to delete the original job
s with the stored proc. but could not seem to get it to work. While examining the sysjob table in the msdn database I deleted one of the old jobs. This is where the problem started. I have since deleted the job steps out of the sysjobsteps and the sysj
obschedule as well as systaskids for that same job. I am still getting the error notification each morning that the job failed Unable to retrieve steps for the certain job. Where is this notification coming from? Because there is no jobs or job steps i
n any of the tables. Any help would greatly be appreciated.

Failed Job Message

This is a post
I am in desparate need of some help with SQL Server 2000. I recently created several jobs to run at night to update several tables in my SQL Server. I then realized that I could schedule one job with various steps, so I tried to delete the original jobs with the stored proc. but could not seem to get it to work. While examining the sysjob table in the msdn database I deleted one of the old jobs. This is where the problem started. I have since deleted the job steps out of the sysjobsteps and the sysjobschedule as well as systaskids for that same job. I am still getting the error notification each morning that the job failed Unable to retrieve steps for the certain job. Where is this notification coming from? Because there is no jobs or job steps in any of the tables. Any help would greatly be appreciatedThere is a bit more that goes on in deleting a job than just
deleting rows from these tables. Jobs can be stored in the
job cache so there are also procedures that check the job
cache and update it if necessary - I think it's through
sp_agent_notify if I remember correctly. There could also be
some other references to the jobs in some of the other job
tables. That's why modifying these tables directly isn't
recommended. You could try restarting SQL Agent if you
didn't do so after modifying the tables but I'd guess you
could still have some other dangling references to the job
which may or may not affect things.
You may want to consider restoring your msdb database from
prior to your modifying the job tables and then delete the
jobs using sp_delete_job which is the supported method of
dropping a job. Using sp_delete_job will handle all the
details, update the job cache if necessary, etc.
-Sue
On Tue, 20 Apr 2004 10:51:04 -0700, "Cartman"
<anonymous@.discussions.microsoft.com> wrote:
>This is a post
>I am in desparate need of some help with SQL Server 2000. I recently created several jobs to run at night to update several tables in my SQL Server. I then realized that I could schedule one job with various steps, so I tried to delete the original jobs with the stored proc. but could not seem to get it to work. While examining the sysjob table in the msdn database I deleted one of the old jobs. This is where the problem started. I have since deleted the job steps out of the sysjobsteps and the sysjobschedule as well as systaskids for that same job. I am still getting the error notification each morning that the job failed Unable to retrieve steps for the certain job. Where is this notification coming from? Because there is no jobs or job steps in any of the tables. Any help would greatly be appreciated.

Failed Job Message

This is a post
I am in desparate need of some help with SQL Server 2000. I recently create
d several jobs to run at night to update several tables in my SQL Server. I
then realized that I could schedule one job with various steps, so I tried
to delete the original jobs
with the stored proc. but could not seem to get it to work. While examining
the sysjob table in the msdn database I deleted one of the old jobs. This
is where the problem started. I have since deleted the job steps out of the
sysjobsteps and the sysjo
bschedule as well as systaskids for that same job. I am still getting the e
rror notification each morning that the job failed Unable to retrieve steps
for the certain job. Where is this notification coming from? Because there
is no jobs or job steps in
any of the tables. Any help would greatly be appreciated.There is a bit more that goes on in deleting a job than just
deleting rows from these tables. Jobs can be stored in the
job cache so there are also procedures that check the job
cache and update it if necessary - I think it's through
sp_agent_notify if I remember correctly. There could also be
some other references to the jobs in some of the other job
tables. That's why modifying these tables directly isn't
recommended. You could try restarting SQL Agent if you
didn't do so after modifying the tables but I'd guess you
could still have some other dangling references to the job
which may or may not affect things.
You may want to consider restoring your msdb database from
prior to your modifying the job tables and then delete the
jobs using sp_delete_job which is the supported method of
dropping a job. Using sp_delete_job will handle all the
details, update the job cache if necessary, etc.
-Sue
On Tue, 20 Apr 2004 10:51:04 -0700, "Cartman"
<anonymous@.discussions.microsoft.com> wrote:

>This is a post
>I am in desparate need of some help with SQL Server 2000. I recently created sever
al jobs to run at night to update several tables in my SQL Server. I then realized
that I could schedule one job with various steps, so I tried to delete the original
job
s with the stored proc. but could not seem to get it to work. While examini
ng the sysjob table in the msdn database I deleted one of the old jobs. Thi
s is where the problem started. I have since deleted the job steps out of t
he sysjobsteps and the sysj
obschedule as well as systaskids for that same job. I am still getting the
error notification each morning that the job failed Unable to retrieve steps
for the certain job. Where is this notification coming from? Because ther
e is no jobs or job steps i
n any of the tables. Any help would greatly be appreciated.

Fail to run report made with report builder

Hi,

I am completely new to Report Builder. I created and deployed a report model and opened the Report Builder, and created a very simple report by dragging a table into the report. When running the report i get this error:

Keyword not supported: 'provider'.
-
Cannot create a connection to data source 'dataSource1'.
-
An error has occurred during report processing.
The data source name that I used in the report model was not called dataSource1.

Approximately the same error is displayed if I deploy (save) the report to the report server:

An error has occurred during report processing.
Cannot create a connection to data source 'dataSource1'.
Keyword not supported: 'provider'.
The report server itself seems to work fine, because I can deploy reports that are created the old way (ie from within BI Development Studio)

I am using the September CTP.

BR
KaDid you create model using Model Designer?

Fail to run as job but success execute in VS2005

hi all,

please help,

i using Execute DTS 2000 Package Task to create a package.dtsx, and execute successful in VS2005

but when i created it as a job and it fail to run.

the package.dtsx is calling a package2000.dts, which having 2 steps to run.

i execute the job by step, and the i found that the 1st job is running successful but the 2nd job was fail.

may i know where can i found the error log? or any where to debug it?

please help......

thanks 1st.....

Hi Khin,

* Note that configuring log for SSIS will not provide the log for Individual steps run in the Execute DTS 2000 Package task.

* Configure a Separate log for the DTS file enclosed by opening it in DTS designer, right click -> Properties ->Logging -> <Give a file Path to Store this log file >.

Thanks

Subhash Subramanyam

Fail to Invoke Job from ASP .NET

Hi,

I have an ASP .NET page which invoke a SQL Agent Job. It works fine in debugging but when I run the web application in deplyment environnment it does not work. The Web Application is configured in Basic Authentication. The error message is not very detailed: "Invoke failed to job XXX".

I tried to add credentials information in my code using:

myServer.ConnectionContext.LoginSecure = false;
myServer.ConnectionContext.Login = "DOMAIN\Login";
myServer.ConnectionContext.Password = "pwd";

or

myServer.ConnectionContext.LoginSecure = false;
myServer.ConnectionContext.ConnectAsUserName = "DOMAIN\Login";
myServer.ConnectionContext.ConnectAsUserPassword = "pwd";

but it does not change anything.

Any help will be appreciated.

When you specify LoginSecure=false you're telling the server to use a SQL login, then you're supplying a domain login. You need to establish a SQL Login with the necessary credentials on the server in this circumstance.|||Hi,

if you want to impersonate the curretn thread with another security token than the actual it is running on (as you told the basic authentication) you will have to create an impersonation context, if you want to use the current security context your can just set the LoginSecure = true.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Fail to attach to MDF file

I tried to use sp_attach_single_file_db to attach to a MDF file which is probably corrupted in a power failure. But, whenever I run this stored procedure, I get some error message like
Change language setting to us_english
Server: msg 945, Level 14, State 2, line 1
Database 'AlbumSQL' can not be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AlbumSQL'. CREATE DATABASE is aborted.
There is also a Ldf file in the same folder, but when I tried to use sp_attach_db, I get the other message
Server: Msg 5172, Level 16, State 15, Line 1
The header for file 'd:\data\albumsql_log.ldf' is not a valid database file header. The PageAudit property is incorrect.
Can you help me some hint to solve this problem? Thanks.
-Alex HuangIS it possible that there is more than one data file.. Attach single file db
only works when there is only one data file... (Based on the error message,
that kind of sounds like it might be happening.)
Otherwise it is probably time to open a call to PSS>
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alex Huang" <alexh@.ulead.com> wrote in message
news:3DBA8115-8DCC-4853-8ED5-F53B15619452@.microsoft.com...
> I tried to use sp_attach_single_file_db to attach to a MDF file which is
probably corrupted in a power failure. But, whenever I run this stored
procedure, I get some error message like
> Change language setting to us_english
> Server: msg 945, Level 14, State 2, line 1
> Database 'AlbumSQL' can not be opened because some of the files could not
be activated.
> Server: Msg 1813, Level 16, State 2, Line 1
> Could not open new database 'AlbumSQL'. CREATE DATABASE is aborted.
> There is also a Ldf file in the same folder, but when I tried to use
sp_attach_db, I get the other message
> Server: Msg 5172, Level 16, State 15, Line 1
> The header for file 'd:\data\albumsql_log.ldf' is not a valid database
file header. The PageAudit property is incorrect.
> Can you help me some hint to solve this problem? Thanks.
> -Alex Huang