Problems configuring Execution Log Reports

I receive the following error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'RSExecutionLog'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
My ReportServer DB is separate from my ReportServer IIS boxes, I'm trying to
use Windows NT Integrated Security to access the Execution Log. I'm a Local
Admin of both servers but still receive the error.
Am I dealing with a permissions hop issue? Any suggestions would help.
DavidYes. Use stored credentials in the shared data source for the reports
(another slightly more complex option would be to use Kerberos delegation)
--
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
"David Dubay" <DavidDubay@.discussions.microsoft.com> wrote in message
news:30C3BBF3-5DE7-4F4E-9008-349CA172D6EC@.microsoft.com...
>I receive the following error:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'RSExecutionLog'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> My ReportServer DB is separate from my ReportServer IIS boxes, I'm trying
> to
> use Windows NT Integrated Security to access the Execution Log. I'm a
> Local
> Admin of both servers but still receive the error.
> Am I dealing with a permissions hop issue? Any suggestions would help.
> David

Problem: sqlCom.ExecuteNonQuery()

What can be reason for this message?

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

There could be a lot of reasons for that message. You need to trap the error (either while debugging or with a custom error handling routine that displays errors) and look at it's inner message. This is thrown when there was some form of database error, i.e. a specified column doesn't exist, you tried to insert a duplicate primary key, etc.|||reading from sql database is working fine but when i try to save something it throws that exception|||

You still need to debug in order to narrow down the problem more effectively. Once you have the actual message (SqlException.Message), then we could give you direction. Or, you could post your code; the error message would be helpful, too, though.

|||

I solve the problem - mistakes in the database

thank you for your time

greetings.

Prole

|||

I solve the problem - mistakes in the database

thank you for your time

Prole

problem with visual studio.net5005 connectionstring passed to SQL Server 2000

hi!

i'am recieving this error :

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).

anybody can help me please

thanks

That is a general error thrown when there is a problem locating or connecting to a server. First place to look would be your connection string to make sure that the username/password is valid and has access to the server and the database.

BobP

Problem with UPDATE with Detailsview

i get

Incorrect syntax near 'nvarchar'.
Must declare the scalar variable "@.BookingID".

Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.
Must declare the scalar variable "@.BookingID".

Source Error:

An unhandled exception was generated during the execution of thecurrent web request. Information regarding the origin and location ofthe exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.
Must declare the scalar variable "@.BookingID".]
 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857354
 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734966
 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188

...

i am using the Edit feature of the detailsview, seems like the datatype is wrong? ID are int (in my DB, BookingID is int), and also its readonly it should not be updating in the first place right?

----------

Any way to debug whats in "new" values? ItemUpdating? how to do it?

Can you post your code?

|||

erm... its SqlDataSource controls + DetailsView, shouldn't it be automatic? i found out that some tables can work some cannot

anyway

UPDATE [Booking]SET [InventoryID] = @.InventoryID, [Username] = @.Username, [Status] = @.Status, [DateBooked] = @.DateBookedWHERE [BookingID] = @.BookingIDSELECT Booking.BookingID, Booking.InventoryID, Booking.Username, Booking.Status, Booking.DateBooked, InventoryPC.TitleAS [Inventory Title]FROM BookingINNERJOIN InventoryPCON Booking.InventoryID = InventoryPC.InventoryIDWHERE (Booking.BookingID = @.ID)

the code from data source the details view is getting from... looks like thats all relavent code? what else is needed,|||

It would be best if you post all your code (page and code behind).