Attach Access Database to SQLServer

Attach Access Database to SQLServer?

It seems it is necessary if I want to put it on the internet through IIS.

I tried add data source through tools and tried most combinations, but nothing led in that direction.

I also did a search.

If not, the alternative is importing the data into sqlserver 2005. What worries me about this is incrementally importing new tables, views, etc., and new rows. Is this later possible?

dennist685

> It seems it is necessary if I want to put it on the internet through IIS.

No. My guess is that you might security issues. The account of which runs your statement (IIS account or ASP account, I guess) to have the rights to read your mdb file. Should be mentioned in numerous threads.

> If not, the alternative is importing the data into sqlserver 2005. What worries me about this is incrementally importing new tables, views, etc., and new rows. Is this later possible?

This would be my soulution. I would use SQL Server (maybe Express) to serve data.

You can access Access tables from within SQL Server queries. I would keep away from doing this for normal processing. For import of data, it is OK, I guess.

-- Sample to SELECT against object in access db:

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'Ad Hoc Distributed Queries', 1

GO

RECONFIGURE

GO

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'x:\dir\mymdb.mdb';'admin';'',objectname)

GO

The sp_configure statments are neccessary because distributed queries are turned off by default for security reasons

Hope this helps

sql

Assertion failed on subscription email send

Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003
Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
emails via subscriptions. Cannot decipher the error. Log file is below:
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
<SystemName>XXX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
public key
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
NotificationPolling polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
chunks, 0 running jobs
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
based subscription notification for subscription:
d680d144-e89e-4dd2-8be7-3f365310eb4f
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
7:04:09 PM.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
RenderFirst( '/Ahl Reports/QualityOfImages' )
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
it was not specified in Server system properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SnapshotCompression to 'SQL' as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionAccessTimeout to default value of '600' seconds because
it was not specified in Server system properties.
ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('QualityOfImages_style', 1), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('Main', 0), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
sending email.
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
at
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
Failure sending mail: An unexpected error occurred in Report Processing.,
DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
NotificationPolling finished processing item
af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
chunks, 0 running jobs
ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
chunks, 0 running jobs
ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobsI had it installed on D:\. I uninstalled, reinstalled on C:\ and now it
works. Must have been some permission thing.
"Bhavin" wrote:
> Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003
> Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
> emails via subscriptions. Cannot decipher the error. Log file is below:
> --
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
> <SystemName>XXX</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Reporting Services starting SKU: Standard
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
> Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
> for temporary files.
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
> ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
> based subscription notification for subscription:
> d680d144-e89e-4dd2-8be7-3f365310eb4f
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
> 7:04:09 PM.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
> NotificationPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
> NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
> RenderFirst( '/Ahl Reports/QualityOfImages' )
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionTimeout to '600' second(s) as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
> it was not specified in Server system properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SnapshotCompression to 'SQL' as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionAccessTimeout to default value of '600' seconds because
> it was not specified in Server system properties.
> ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
> LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
> Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('QualityOfImages_style', 1), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('Main', 0), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
> Assertion failed! Call stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
> sending email.
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> at
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
> af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
> Failure sending mail: An unexpected error occurred in Report Processing.,
> DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
> NotificationPolling finished processing item
> af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
> chunks, 0 running jobs
> ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
> chunks, 0 running jobs
> ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>

Aspx with IIS6 with SQL 2000

Hi All,
I am trying to run aspx website on IIS version 6. It works locally with WEb Matrix but when I put the site into the IIS server, it cannot connect to the database. THe IIS is sonfigured and all users have full permissions but the error that is returned is:
Login failed for user '(null)'. Reason: Not associated with a treusted SQL Server connection.
SQL Server 2000 is installed and a connection is open to the database in question.
Would be very greatfull for ANY help on this, being tryin to get this workin for days!!
Collette.
Hi,
I have explained the cause and resolution for this error in the following articles.
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for.html
http://harishmvp.blogspot.com/2005/05/you-may-receive-error-login-failed-for_25.html
One of the above should help you.
Write back if this doesnt help.
Thanks.|||

Hi!

Still having problems with the this! Done everything in the two documents and still no joy!

Error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Please help!!

Collette.

|||

Hi,

Can you let me know your scenario?

Thanks.

ASPNETDB.MDF is read-only....

Hello everyone.

I am to create a sample site using the club site example. I had a problem with the IIS but now it is solved.

Now i copyied the site to the IIS and it is running. But i cannot access ASPNETDB.MDF. It keep saying that the database is read only... It is not read only!!!

Can any one help me??

System.Data.SqlClient.SqlException: Failed to update database "C:\INETPUB\WWWROOT\NEO\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Thank you in advance.

Iasonas

Try granting the NETWORK SERVICE account R/W access to the contents of your app_data folder (mdf's and ldf's)and the folder itself.

If that doesn't work, please take a look at this post:

http://forums.asp.net/thread/906040.aspx

Why not using search feature in this formus:) Maybe you issue is a common one, then you can find some possible solution by searching the formus rather than just waiting:)

'aspnet_regiis' impact on classic ASP?

Hi,
We want to install RS on a Windows 2003 / IIS 6 server.
Does it hurt our 'classic' (pre .net) ASP aps if we run aspnet_regiis -i
on this machine?
tanx,
Derk JanWe have classic ASP and ASP.NET running on the same server just fine. Since
ASP.NET uses different file extensions (aspx), it shouldn't hurt.
Nevertheless, a system backup -- or trying it first on a dev server -- is
always a good idea.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Derk Jan" <DerkJan@.discussions.microsoft.com> wrote in message
news:6BDE0622-F903-48D8-B419-4D6BD497FD0F@.microsoft.com...
> Hi,
> We want to install RS on a Windows 2003 / IIS 6 server.
> Does it hurt our 'classic' (pre .net) ASP aps if we run aspnet_regiis -i
> on this machine?
> tanx,
> Derk Jan
>

ASPNET worker process account can't login to Database

Hi,
I'm using .Net Remoting and IIS (5.1) to pull data from a (local for now)
SQL Server 2005 database. My application is failing at the point at which a
connection to the database is being opened.
Using cn as New SqlConnection(ConnectString)
cn.Open()
Causes an SQLException to be thrown. The message is...
Cannot open database "AppData" requested by the login. The login failed.
"Login failed for user '<MachineName>\ASPNET'
This is the ASP.Net worker process user. I have had some problems with this
User Id on this machine - it was originally absent from the machine. I got
it back by re-installing ASP.Net (ver 2.0). Now all my remoting stuff is
working, but I cannot get to the data.
So my question is, what configuration items / permissions in SQL Server
should I set up to give the ASPNet worker process access to my data?.
For now the application, SQL Server Instance, and IIS are all on the same
machine. Everything seems to work except for the login call to the Database
.
Thanks for your help.
BBMHello BBM,
You could add the <Machine Name>\ASPNET user in the SQL Login. After that,
you could grant the proper permission for the account to access the sql
database.
Here is an article you could refer:
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn2.microsoft.com/en-us/library/aa302387.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
Thanks for your help. I knew this had to be covered someplace.
BTW, Searching Help in SQL Server, or in Visual Studio on this topic, the
ASP "worker process" account, returns nothing remotely useful.
Thanks again.
BBM
"Wei Lu [MSFT]" wrote:

> Hello BBM,
> You could add the <Machine Name>\ASPNET user in the SQL Login. After that,
> you could grant the proper permission for the account to access the sql
> database.
> Here is an article you could refer:
> Building Secure ASP.NET Applications: Authentication, Authorization, and
> Secure Communication
> http://msdn2.microsoft.com/en-us/library/aa302387.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> [url]http://msdn.microsoft.com/subscriptions/support/default.aspx." target="_blank">http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==========
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello BBM,
You could use the MSDN search in the web directly. And you could search for
ASPNET and SQL Server as the key words.
Thanks!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

aspnet user can not access sql server

We have an ASP.net application that currently sits on a server that runs IIS and sql server. We are spliting IIS and SQL server into 2 seperate machines. I believe I have the connection string okay as I can see the entries in the security log on the sql server machine however it keeps saying aspnet user invalid user or invalid password. What gives with this. We put .net on the sql server however this just added the aspnet user to the machine. Do I need to create an aspnet user inside the sql server and give it control of the dbases as well? I am running this using the personal web server not IIS on a server. I have a project on my desktop and am using the "local" IIS or personal web server that comes with visual studio out of the box. What kills me is that when I put the project on a real IIS server that has sql server on the same machine I have no issues. However when I split the dbase and the IIS apart onto 2 servers I get this aspnet invalid user or invalid password.
HELPtry giving database permission to the aspnet user on the other machine (IIS). ex. IISMachine\ASPNET
cheers
Shane Sukul
|Bsc|Mcsd.Net|Mcsd|Mcad|
|||

In SQL Server you can use Windows Authentication or SQL Server Authentication. If in connection string you don't spec. which user and password to use it tries to use Windows Authentication and the user which ASP.NET process runs should have permissions in the SQL Machine.
I normally use SQL Server authentication, put in my web.config (with only permission to the ASP.NET process) the ConnectionString with user and password.
HH
NeuralC

|||

neuralc wrote:

In SQL Server you can use Windows Authentication or SQL Server Authentication. If in connection string you don't spec. which user and password to use it tries to use Windows Authentication and the user which ASP.NET process runs should have permissions in the SQL Machine.
I normally use SQL Server authentication, put in my web.config (with only permission to the ASP.NET process) the ConnectionString with user and password.
HH
NeuralC

Of course you wouldn't actually put that in clear text!
|||

None of this works. The application currently sits on my desktop which is running xp professional. The web server is local to my machine whatever ships with visual studio. The dbase is on a server that has the .net environment running on it. Why can I not see the dbase information when I have the correct connection string.

If I take the same application on my machine and go and hit a server that has IIS adn sql server installed on the same machine it works fine
What gives

|||Also have a look at your firewall settings on the server that hosts your database.

ASPNET Acct in SQL Server 2000

I have windows Server 2003 w/ IIS 6.0 running an asp.net
web application. The web application needs to connect to
another server, with SQL Server 2000 installed. We also
have Active Directory.
My question is how do I get the ASPNET account to show up
in the list of users on SQL Server? Do I need to add it
to Active directory? Do I need to create another user as
ASPNET on SQL Server?
Thanks for the help.
Steve M.815154 HOW TO: Configure SQL Server Security for .NET Applications
http://support.microsoft.com/?id=815154
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

ASPNET & NETWORK SERVICE accounts hitting SQL Server from IIS

Hello All,
Running IIS 6 and ASP.NET, the only way an application can access SQL Server
seems to be as "NT AUTHORITY / NETWORK SERVICE" (or an alias specified in
the <identity> element within "web.config"). This is analagous to the
"ASPNET" user for IIS 5 and ASP.NET.
In a secure (SSL) web running in IIS 6 with authentication, we're interested
in getting from ASP.NET the behavior we get from ASP 3.0. When the ASP
application logs onto the SQL Server database, it does so under the logon of
the actual user. There does not appear to me to be a way to make this
happen. And, as a result, we feel as though we have lost a layer of
security--the security of the database!
Any ideas or suggestions are welcome.
Thanks a lot!
JimInside
<system.web>
I added
<identity impersonate="true" />
It worked like a charm!
Jim
"Jim Moon" <jmoon()at()uab.edu> wrote in message
news:ec4zWdtXEHA.3596@.tk2msftngp13.phx.gbl...
> Hello All,
> Running IIS 6 and ASP.NET, the only way an application can access SQL
Server
> seems to be as "NT AUTHORITY / NETWORK SERVICE" (or an alias specified in
> the <identity> element within "web.config"). This is analagous to the
> "ASPNET" user for IIS 5 and ASP.NET.
> In a secure (SSL) web running in IIS 6 with authentication, we're
interested
> in getting from ASP.NET the behavior we get from ASP 3.0. When the ASP
> application logs onto the SQL Server database, it does so under the logon
of
> the actual user. There does not appear to me to be a way to make this
> happen. And, as a result, we feel as though we have lost a layer of
> security--the security of the database!
> Any ideas or suggestions are welcome.
> Thanks a lot!
> Jim
>

ASPNET & NETWORK SERVICE accounts hitting SQL Server

Hello.
Running IIS 6 and ASP.NET, the only way an application can access SQL Server
seems to be as "NT AUTHORITY / NETWORK SERVICE" (or an alias specified in
the <identity> element within "web.config"). This is analagous to the
"ASPNET" user for IIS 5 and ASP.NET.
In a secure (SSL) web running in IIS 6 with authentication, we're interested
in getting from ASP.NET the behavior we get from ASP 3.0. When the ASP
application logs onto the SQL Server database, it does so under the logon of
the actual user. There does not appear to me to be a way to make this
happen. And, as a result, we feel as though we have lost a layer of
security--the security of the database!
Any ideas or suggestions are welcome.
Thanks,
JimHi Jim,
In order to make this work you'll need to be in a 2000 or 2003 domain
with Security Delegation Enabled.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

ASP-Application

Hi,
i have my application running with two servers ( iis - sql
server ).
What is securest way to access from the first workstation
(iis) on the second ( sql server ) ?
With an DSN or a Connection String ?
I am running a ASP-application !
Greetings,
Daniel RakojevicYou could run your application on the IIS server under the context of an acc
ount (domain or local to the SQL server), grant this account access to the d
atabase, and then set the DSN on the IIS box to use trusted_connection=YES.
if you need to secure the data in transit, you could also enable SSL encrypt
ion on the SQL Server:
http://support.microsoft.com/defaul...kb;en-us;316898
--Roberto
-- Daniel Rakojevic wrote: --
Hi,
i have my application running with two servers ( iis - sql
server ).
What is securest way to access from the first workstation
(iis) on the second ( sql server ) ?
With an DSN or a Connection String ?
I am running a ASP-application !
Greetings,
Daniel Rakojevic

ASP.NET/IIS/SQL help !

Hi.

Let me tell you my domain environment. It's NT 4.0 domain with a
Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one
box, and it worked fine. Recently, we bought a new box with Windows 2003
standard version and trying to move ASP.NET and IIS to this box. However;
we're getting "Login failed for user 'NT Authority\Anonymous Logon'" error
when we access the ASP.NET page. I believe it has something to do with
moving the asp.net/iis to a different box and leave SQL in the old box. I've
done some research and there're some possibilities that have caused this:

1. It would require Active Directory domain environment when you move
asp.net/iis to a different box and authenticates with the SQL
server on the old box?

2. ASPNET account locally on both boxes need to be matched?

3. reconfigure the Machine.config and Web.config in the asp.net?

Can anyone help me on this with the details?

ThanksHi Charlie

Not exactly sure why you are getting this error but it sounds it's more
a problem of the IIS configuration than SQL Server. You might want to
repost in an IIS group.

If you place a very simple index.aspx (a blank webform) in the root of
your website on the Windows 2003 box and try calling it like
http://localhost/myapp/index.aspx - Do you get the same error? In this
case it's a pure IIS problem. Check the properties of your web
application root and make sure that anonymous logon is enabled.

Also check that you have the right settings in web.config.

<!-- AUTHENTICATION
This section sets the authentication policies of the application.
Possible modes are "Windows", "Forms", "Passport" and "None"

"None" No authentication is performed.
"Windows" IIS performs authentication (Basic, Digest, or Integrated
Windows) according to its settings for the application. Anonymous
access must be disabled in IIS.
"Forms" You provide a custom form (Web page) for users to enter their
credentials, and then you authenticate them in your application. A user
credential token is stored in a cookie.
"Passport" Authentication is performed via a centralized
authentication service provided
by Microsoft that offers a single logon and core profile services for
member sites.
--
Let me know the result.

M

ASP.NET/IIS/SQL help

Hi.
Let me tell you my domain environment. It's NT 4.0 domain with a
Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one
box, and it worked fine. Recently, we bought a new box with Windows 2003
standard version and trying to move ASP.NET and IIS to this box. However;
we're getting "Login failed for user 'NT Authority\Anonymous Logon'" error
when we access the ASP.NET page. I believe it has something to do with
moving the asp.net/iis to a different box and leave SQL in the old box. I've
done some research and there're some possibilities that have caused this:
1. It would require Active Directory domain environment when you move
asp.net/iis to a different box and authenticates with the SQL
server on the old box?
2. ASPNET account locally on both boxes need to be matched?
3. reconfigure the Machine.config and Web.config in the asp.net?
Can anyone help me on this with the details?
Thanks
"Charlie Ting" <cting74@.hotmail.com> wrote in
news:O6ednQldj8dcG4vfRVn-sw@.golden.net:

> we're getting "Login failed for user 'NT
> Authority\Anonymous Logon'" error when we access the ASP.NET page. I
> believe it has something to do with moving the asp.net/iis to a
> different box and leave SQL in the old box.
My knowledge is limited. but I'll hazard a good guess...
As IIS is on a new server the IUSER_newservername is being used to access
the virtual directory, which in turn is not an authenticated user as far as
sql server is concerned.
Hope it helps?

ASP.NET/IIS/SQL help

Hi.
Let me tell you my domain environment. It's NT 4.0 domain with a
Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one
box, and it worked fine. Recently, we bought a new box with Windows 2003
standard version and trying to move ASP.NET and IIS to this box. However;
we're getting "Login failed for user 'NT Authority\Anonymous Logon'" error
when we access the ASP.NET page. I believe it has something to do with
moving the asp.net/iis to a different box and leave SQL in the old box. I've
done some research and there're some possibilities that have caused this:
1. It would require Active Directory domain environment when you move
asp.net/iis to a different box and authenticates with the SQL
server on the old box?
2. ASPNET account locally on both boxes need to be matched?
3. reconfigure the Machine.config and Web.config in the asp.net?
Can anyone help me on this with the details?
Thanks"Charlie Ting" <cting74@.hotmail.com> wrote in
news:O6ednQldj8dcG4vfRVn-sw@.golden.net:

> we're getting "Login failed for user 'NT
> Authority\Anonymous Logon'" error when we access the ASP.NET page. I
> believe it has something to do with moving the asp.net/iis to a
> different box and leave SQL in the old box.
My knowledge is limited. but I'll hazard a good guess...
As IIS is on a new server the IUSER_newservername is being used to access
the virtual directory, which in turn is not an authenticated user as far as
sql server is concerned.
Hope it helps'

ASP.NET/IIS/SQL help

Hi.
Let me tell you my domain environment. It's NT 4.0 domain with a
Windows 2000 member server running as ASP.NET/IIS/MS SQL 2000, all in one
box, and it worked fine. Recently, we bought a new box with Windows 2003
standard version and trying to move ASP.NET and IIS to this box. However;
we're getting "Login failed for user 'NT Authority\Anonymous Logon'" error
when we access the ASP.NET page. I believe it has something to do with
moving the asp.net/iis to a different box and leave SQL in the old box. I've
done some research and there're some possibilities that have caused this:
1. It would require Active Directory domain environment when you move
asp.net/iis to a different box and authenticates with the SQL
server on the old box?
2. ASPNET account locally on both boxes need to be matched?
3. reconfigure the Machine.config and Web.config in the asp.net?
Can anyone help me on this with the details?
Thanks"Charlie Ting" <cting74@.hotmail.com> wrote in
news:O6ednQldj8dcG4vfRVn-sw@.golden.net:
> we're getting "Login failed for user 'NT
> Authority\Anonymous Logon'" error when we access the ASP.NET page. I
> believe it has something to do with moving the asp.net/iis to a
> different box and leave SQL in the old box.
My knowledge is limited. but I'll hazard a good guess...
As IIS is on a new server the IUSER_newservername is being used to access
the virtual directory, which in turn is not an authenticated user as far as
sql server is concerned.
Hope it helps'

ASP.Net service account gray out

I am installing RS2005 on Windows server 2000 with IIS 5.0. Everything is fine in configuration tool except service account. It is empty. I have added ASPNET account in reportservice user group and tried to add <machinename>\ASPNET to <WebServiceAccount>. It is still empty. Any idea?

Thanks.

Hello,

I believe this is pulled from the Identity of your application pool. Go to IIS and set the identity there and it should be reflected in the RS Configuration Manager.

Hope this helps.

Jarret

|||

Hi,

It seems that application pool is only for IIS6.0. I am using IIS5.0. How can I set the identity in this case

thanks

Ken

|||Therer's no direct way (from RS tools at least) to set IIS5 app pool identities. In fact, there's no way in IIS to set IIS5 app pool identities. I've heard that you can modify a .config file and change the IIS5 app pool identity, but I've not tried this myself.|||Yes, I have changed <WebServiceAccount> tag in RSReportServer.config but it doesn't work. I think Jarret is right. The identity is from somewhere in IIS setting.

I also installed report service in XP pro. I don't need to set anything to let it work. I am not sure if there is something special in Windows 2000 Server.
|||

Has anyone installed Report service 2005 on Windows 2000 server successfully? Please give comment. I appreciate it.

Ken

|||Did anybody solve this issue?

ASP.NET Report Viewer Version 9.0 problem.

I recently migrated my development server from Windows Server 2003 \ IIS 6 \
.NET Framework 2 and SQL 2005 to Windows Server 2008 \ IIS 7 \ .NET Framework
3.5 and SQL 2005 SP2. SQL install also includes Reporting Services. On my dev
workstation I have upgraded to from vs2005 to vs2008 and installed the
correct AjaxToolKit 3.5 dll.
I have a web project that uses SQL reporting services and Report Viewer 8.0
which used to work ok before the migration. I have replaced the Report Viewer
8.0 control within my web project to the new vs2008 Report Viewer 9.0 and
replaced all references (web.config etc) from 8.0 to 9.0. I have also
installed the Report Viewer 9.0 download on my development server &
workstation and rebooted.
When I now run my project the report viewer control does not render my
report (or even display the default icons for the report control such as
print icon etc).
I get a client side javascript error in IE7 stating â'Error: this.Controller
is null or not an objectâ'. If I try the site on FireFox the report displays
â'404 File or Directory not foundâ' within the report viewer.
Im running the report within a user control. Please find code for the uc
containing the report viewer and associated data objects below...
<%@. Control Language="C#" AutoEventWireup="true"
CodeFile="Reporting_MainSite.ascx.cs" Inherits="NPApplets_Reporting_MainSite"
%>
<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,
Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" Height="325px" Width="100%" BackColor="#95B7F3">
<LocalReport ReportPath="Report_SiteTraffic.rdlc"
EnableExternalImages="True">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
Name="DataSet1_Report_LastMonth" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource2"
Name="DataSet2_Report_Last12Months" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource3"
Name="DataSet3_Report_Last12MonthsUBS" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource4"
Name="DataSet4_Report_SinceLaunch" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource4" runat="server"
SelectMethod="GetData"
TypeName="DataSet4TableAdapters.Report_SinceLaunchTableAdapter"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource3" runat="server"
SelectMethod="GetData"
TypeName="DataSet3TableAdapters.Report_Last12MonthsUBSTableAdapter"
OldValuesParameterFormatString="original_{0}">
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
SelectMethod="GetData"
TypeName="DataSet2TableAdapters.Report_Last12MonthsTableAdapter"
OldValuesParameterFormatString="original_{0}" >
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
SelectMethod="GetData"
TypeName="DataSet1TableAdapters.Report_LastMonthTableAdapter"
OldValuesParameterFormatString="original_{0}" >
<SelectParameters>
<asp:ControlParameter ControlID="lbWondersiteToReportOn"
Name="Wondersite_FullName"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:Label ID="lbWondersiteToReportOn" runat="server"
Visible="False"></asp:Label>
Within VS2008 designer the Report Viewer control shows the controls icons
correctly (print icon etc).
I have 4 data objects that my report uses. If I try and modify the data
source objects via the Smart Tag > Configure Data Source I get the following
error...
"The type 'DataSet4TableAdapters.Report_SinceLaunchTableAdapter' could not
be loaded. If the type is located in the App_Code folder, please check that
it compiles. If the type is located in a compiled assembly, pleaee check that
the assembly is referenced by the project.
The type "DataSet4TableAdapetrs.Report_SinceLaunchTableAdapter' could not be
foundâ'"
I have checked my DataSet.xsd files located in my App_Code directory and
everything compiles ok.
Im now stumped as what to try next. Any help, advice or pointers would be
very much appreciated.
Thanks in advance,
Paul.Managed to track down a fix...
Open Internet Information Services (IIS) Manager and select your Web
application.
Under IIS area, double-click on Handler Mappings icon.
At the Action pane on your right, click on Add Managed Handler.
At the Add Managed Handler dialog, enter the following:
Request path: Reserved.ReportViewerWebControl.axd
Type: Microsoft.Reporting.WebForms.HttpHandler
Name: Reserved-ReportViewerWebControl-axd
Click OK.
http://otkfounder.blogspot.com/2007/11/solving-reportviewer-rendering-issue-on.html
Paul.
"Paul Hale" wrote:
> I recently migrated my development server from Windows Server 2003 \ IIS 6 \
> .NET Framework 2 and SQL 2005 to Windows Server 2008 \ IIS 7 \ .NET Framework
> 3.5 and SQL 2005 SP2. SQL install also includes Reporting Services. On my dev
> workstation I have upgraded to from vs2005 to vs2008 and installed the
> correct AjaxToolKit 3.5 dll.
> I have a web project that uses SQL reporting services and Report Viewer 8.0
> which used to work ok before the migration. I have replaced the Report Viewer
> 8.0 control within my web project to the new vs2008 Report Viewer 9.0 and
> replaced all references (web.config etc) from 8.0 to 9.0. I have also
> installed the Report Viewer 9.0 download on my development server &
> workstation and rebooted.
> When I now run my project the report viewer control does not render my
> report (or even display the default icons for the report control such as
> print icon etc).
> I get a client side javascript error in IE7 stating â'Error: this.Controller
> is null or not an objectâ'. If I try the site on FireFox the report displays
> â'404 File or Directory not foundâ' within the report viewer.
> Im running the report within a user control. Please find code for the uc
> containing the report viewer and associated data objects below...
> <%@. Control Language="C#" AutoEventWireup="true"
> CodeFile="Reporting_MainSite.ascx.cs" Inherits="NPApplets_Reporting_MainSite"
> %>
> <%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0,
> Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"
> Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
> <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
> Font-Size="8pt" Height="325px" Width="100%" BackColor="#95B7F3">
> <LocalReport ReportPath="Report_SiteTraffic.rdlc"
> EnableExternalImages="True">
> <DataSources>
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource1"
> Name="DataSet1_Report_LastMonth" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource2"
> Name="DataSet2_Report_Last12Months" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource3"
> Name="DataSet3_Report_Last12MonthsUBS" />
> <rsweb:ReportDataSource DataSourceId="ObjectDataSource4"
> Name="DataSet4_Report_SinceLaunch" />
> </DataSources>
> </LocalReport>
> </rsweb:ReportViewer>
> <asp:ObjectDataSource ID="ObjectDataSource4" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet4TableAdapters.Report_SinceLaunchTableAdapter"
> OldValuesParameterFormatString="original_{0}">
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource3" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet3TableAdapters.Report_Last12MonthsUBSTableAdapter"
> OldValuesParameterFormatString="original_{0}">
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet2TableAdapters.Report_Last12MonthsTableAdapter"
> OldValuesParameterFormatString="original_{0}" >
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
> SelectMethod="GetData"
> TypeName="DataSet1TableAdapters.Report_LastMonthTableAdapter"
> OldValuesParameterFormatString="original_{0}" >
> <SelectParameters>
> <asp:ControlParameter ControlID="lbWondersiteToReportOn"
> Name="Wondersite_FullName"
> PropertyName="Text" Type="String" />
> </SelectParameters>
> </asp:ObjectDataSource>
> <asp:Label ID="lbWondersiteToReportOn" runat="server"
> Visible="False"></asp:Label>
> Within VS2008 designer the Report Viewer control shows the controls icons
> correctly (print icon etc).
> I have 4 data objects that my report uses. If I try and modify the data
> source objects via the Smart Tag > Configure Data Source I get the following
> error...
> "The type 'DataSet4TableAdapters.Report_SinceLaunchTableAdapter' could not
> be loaded. If the type is located in the App_Code folder, please check that
> it compiles. If the type is located in a compiled assembly, pleaee check that
> the assembly is referenced by the project.
> The type "DataSet4TableAdapetrs.Report_SinceLaunchTableAdapter' could not be
> foundâ'"
> I have checked my DataSet.xsd files located in my App_Code directory and
> everything compiles ok.
> Im now stumped as what to try next. Any help, advice or pointers would be
> very much appreciated.
> Thanks in advance,
> Paul.
>

ASP.NET Cannot use msde2000 in the win2003 server

In the office I am Setup win server 2003 and setup iis for webserver and download msde2000 for create database.
In the first I create web application for connect the database and use DataGrid Control for show it.
And then I create database in the Server Explorer in the Vc#.net. Now I compile program complete. Not error
But the IE show text for me is
......
(Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.)
Description: An unhandled exception occurred during the execution of the current web request.Please review the stack trace for more information about the error where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Source Error:
LINE 31: sqlDataAdapter1.Fill(DataSet11); -- But the source is not error in my home computer (my home computer use winxp + msde2000 + vc#)
How I fix this problem.
Thank a lot
That is the aspnet_wp.exe process model account you're seeing the
login failure message for. You configure in your machine.config file
whether to use machine or system (system is less secure) for the
processModel setting. When you connect through asp.net, you're not
connecting as yourself unless you've configured impersonation, but as
the aspnet process. The aspnet process Windows account doesn't have a
SQLS login and requisite database permissions enabled for it. A good
resource on working with asp.net security is the "best practices"
whitepaper, which i recommend you download from:
http://www.microsoft.com/downloads/r...eleaseID=44047
--Mary
On Sun, 18 Apr 2004 04:41:03 -0700, Aurora
<anonymous@.discussions.microsoft.com> wrote:

>In the office I am Setup win server 2003 and setup iis for webserver and download msde2000 for create database.
>In the first I create web application for connect the database and use DataGrid Control for show it.
>And then I create database in the Server Explorer in the Vc#.net. Now I compile program complete. Not error
>But the IE show text for me is
>......
>(Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.)
>Description: An unhandled exception occurred during the execution of the current web request.Please review the stack trace for more information about the error where it originated in the code.
>Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
>Source Error:
>LINE 31: sqlDataAdapter1.Fill(DataSet11); -- But the source is not error in my home computer (my home computer use winxp + msde2000 + vc#)
>How I fix this problem.
>Thank a lot

ASP.NET and SQL Server Express 2005 User Account problem

I have IIS installed on a Windows XP Pro machine and am using MS Visual Web Developer Express (VWDEx) and SQL Server Express (SQLSEx) to try and create a website.

I used menu item: Website > ASP.NET Configuration to enable roles and create a role called 'Administrators'. I then created a user called 'webmaster' of type 'Administrators' role.

On one of the web pages I have used the inbuilt VWDEx Login control from the toolbox and updated web.config as:

<location path="CatalogAdmin.aspx">

<system.web>

<authorization>

<allow roles="Administrators"/>

<deny users="*"/>

</authorization>

</system.web>

</location>

<system.web>

<authorization>

<allow roles="Administrators" />

</authorization>

When I run the website to test it (within VWDEx) and try to login, it gives me the following error:

Cannot open user default database. Login failed.
Login failed for user 'GLKD2396800\ASPNET'.

…

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MyMachineName\ASPNET'.

…

Stack Trace:

[SqlException (0x80131904): Cannot open user default database. Login failed.

Login failed for user 'GLKD2396800\ASPNET'.]

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734867

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning… etc… etc… etc…

Any ideas on how to solve this problem ?

Thanks

That means the 'GLKD2396800\ASPNET' windows user is not a valid login or does not have the appropriate permissions within it's default database on the SQL Server. You'll have to first ensure this user is a valid server login...to do that, see the following command's information in Books Online:

CREATE LOGIN...

Once it's a valid login, you'll have to give it the appropriate permission(s) in the appropriate database(s) on the server to allow it to login to those db's...for more information on this, see the following command's information in Books Online:

CREATE USER....

HTH,