Asp.net / sql help: installed

Showing posts with label installed. Show all posts

Tuesday, March 27, 2012

Attach database over the network.

Hello,
I have Sql Express installed in one computer and I want to attach a database
that is stored in another computer.
How can I do that?
ThanksSQL Server doesn't support having database files over the network. Copy the
files locally then
attach to the files. Or have an SQL Server on the other machine and connect
to that SQL Server from
your client apps.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Joao Novo" <jotanovo@.gmail.com> wrote in message news:uQPr1M$gHHA.4064@.TK2MSFTNGP02.phx.gbl
..
> Hello,
> I have Sql Express installed in one computer and I want to attach a databa
se that is stored in
> another computer.
> How can I do that?
> Thanks
>sql

Attach database over the network.

Hello,
I have Sql Express installed in one computer and I want to attach a database
that is stored in another computer.
How can I do that?
ThanksSQL Server doesn't support having database files over the network. Copy the files locally then
attach to the files. Or have an SQL Server on the other machine and connect to that SQL Server from
your client apps.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Joao Novo" <jotanovo@.gmail.com> wrote in message news:uQPr1M$gHHA.4064@.TK2MSFTNGP02.phx.gbl...
> Hello,
> I have Sql Express installed in one computer and I want to attach a database that is stored in
> another computer.
> How can I do that?
> Thanks
>

Wednesday, March 7, 2012

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
>

Friday, February 24, 2012

ASPNETDB.MDF is readonly

I have downloaded and installed ASP.NET Ajax Sample applications from

http://ajax.asp.net/default.aspx?tabid=47&subtabid=471

I am trying to run the AJAX TaskList example under C:\Program\Microsoft ASP.NET\ASP.NET AJAX Sample Applications\v1.0.61025\TaskList

First I moved the content of the TaskList folder to a virtual IIS directory, making it possible to debug the website on my local IIS server.

When I run the example I get prompted to Login or register as a new user. When I submit the registration form I receive the following error message:

Failed to update database "C:\INETPUB\WWWROOT\TASKLIST\APP_DATA\ASPNETDB.MDF" because the database is read-only.

How can I modify the permissions forASPNETDB.MDF in order to run the TaskList example.

Thanks

Additional information:

I have installed SQL Server Management Studio Express as I figured this tool might help me to change the permissions. It did not help. I also tried to delete ASPNETDB.mdf, and recreate it by going Website -> Asp.net configuration by adding a new user. I still receive the same error message.

When I point the connection string to a remote SQL database of mine it is possible to register users in ASPNETDB.mdf. But I havn't figured out how to add users using a local version of ASPNETDB.mdf.

I am running Visual Studio on Windows XP. In windows XP you can't just modify permissions for folders as far as I know. I have recently installed SQL Server Management Studio Express as I said before.

I read somewhere that the read/write property for ASPNETDB.mdf may be enabled by checking a box somewhere.

But in SQL Server Management Studio Express tried the following:

*Right click on databases and click attach

*Click Add and select the database ASPNETDB.mdf

*Click OK

*Right Click on the path for ASPNETDB.mdf and click properties

When I click 'Options' under select a page Database Read-Only is already set to false.

If there is not way to use a local version of ASPNETDB.mdf (App_Data folder) I simply have to put up with my remote MS SQL 2005 database. But the subscription fee for this database is outrageous, and therefore I hope that someone might help me and everyone else by providing the appropriate steps to use ASPNETDB.mdf located to the App_Data folder, both on the local IIS server and server side.

Thanks
Svenbro

|||This can be a permission ?issue. Open Management Studio Express->connect to SQL Express instance->go to Security->Logins->make?sure the 'NT AUTHORITY\NETWORK SERVICE' account is there.|||

The 'NT AUTHORITY\NETWORK SERVICE' account is not in the list, but there is a similar item: NT INSTANS\SYSTEM

Should I add 'NT AUTHORITY\NETWORK SERVICE' as a new account with the Windows authentication property checked?

Thanks,

|||NETWORK SERVICE?is?hidden, just type it and click check name in the browse text, you should get it.

aspnetdb connection could not establish but database correctly created.

I installed netframework 2.0 Visual Web developer and MSSQL 2005 express edition with SQL Server management express.

I have got this configuration: 2*256 mb ram Intel Pentium 3.2Ghz Windows XP HUN SP2 latest version.

server name: localhost\SQLEXPRESS
Authentication: Windows Authentication

I run aspnet_regsql.exe and the setup wizard created aspnetdb see here, Microsoft sql server management studio can see the database:
MSSQL server management express & aspnetdb

But! When I run to the asp.net web application administration tool in Provider Configuration and choose
AspNetSqlProvider only 1
then I clickSelect a single provider for all site management data link -> then test

The Tool write this:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web SiteAdministration tool, use the aspnet_regsql command-line utility tocreate and configure the database, and then return to this tool to setthe provider.

Hi,

You application does not "know" where your database is. It is trying to find it in App_Data folder of your application. If it is not there you can specify its locaton by using connection string in web.config like this:

|||

<!--
 Note: As an alternative to hand editing this file you can use the
 web admin tool to configure settings for your application. Use
 the Website->Asp.Net Configuration option in Visual Studio.
 A full list of settings and comments can be found in
 machine.config.comments usually located in
 \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
 <connectionStrings>
 <clear/>
 <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.web>
<!--
 Set compilation debug="true" to insert debugging
 symbols into the compiled page. Because this
 affects performance, set this value to true only
 during development. Visual Basic options:
 Set strict="true" to disallow all data type conversions
 where data loss can occur.
 Set explicit="true" to force declaration of all variables.
 -->
<compilation debug="true" strict="false" explicit="true"/>
<pages>
<namespaces>
<clear/>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
</pages>
<!--
 The <authentication> section enables configuration
 of the security authentication mode used by
 ASP.NET to identify an incoming user.
 -->
<authentication mode="Windows"/>
<!--
 The <customErrors> section enables configuration
 of what to do if/when an unhandled error occurs
 during the execution of a request. Specifically,
 it enables developers to configure html error pages
 to be displayed in place of a error stack trace.
 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
 <error statusCode="403" redirect="NoAccess.htm" />
 <error statusCode="404" redirect="FileNotFound.htm" />
 </customErrors>
 -->
</system.web>
</configuration>

I paste But doesn't work. Sad modify the text or not? When I run the page createuserwizard

Kiszolgálóhiba t?rtént az alkalmazásban: ?/Website".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.Leírás: Nem kezelt kivétel k?vetkezett be az aktuális webes kérelem végrehajtása során. A hibára és az azt okozó kódrészletre vonatkozó adatok az alábbi veremkivonatban találhatók.Hiba t?rtént az SQLExpress adatbázisfájl automatikus létrehozásakor:A kapcsolódási karakterlánc az alkalmazás App_Data k?nyvtárában található adatbázishelyet használó helyi SQL Server Express példányt ad meg. A szolgáltató megkísérelte automatikusan létrehozni az alkalmazás szolgáltatási adatbázisát, mert a szolgáltató megállapította, hogy az adatbázis nem létezik. A k?vetkez? konfigurálási k?vetelmények megléte szükséges ahhoz, hogy az alkalmazás szolgáltatási adatbázisának létezése sikeresen ellen?rizhet? legyen, és hogy az alkalmazás szolgáltatási adatbázisa automatikusan létrehozható legyen: 1. Ha még nem létezik az alkalmazás App_Data k?nyvtára, a webkiszolgálói fióknak olvasási és írási hozzáféréssel kell rendelkeznie az alkalmazás k?nyvtárához. Ez azért szükséges, mert a webkiszolgálói fiók automatikusan létre fogja hozni az App_Data k?nyvtárat, ha az még nem létezik. 2. Ha már létezik az alkalmazás App_Data k?nyvtára, a webkiszolgálói fióknak csak az alkalmazás App_Data k?nyvtárához van szüksége olvasási és írási hozzáférésre. Ez azért szükséges, mert a webkiszolgálói fiók megkísérli ellen?rizni, hogy az alkalmazás App_Data k?nyvtárában már létezik-e az SQL Server Express adatbázis. Ha visszavonja a webkiszolgálói fióktól az olvasási engedélyt az App_Data k?nyvtárhoz, a szolgáltató nem fogja tudni helyesen megállapítani, hogy már létezik-e az SQL Server Express adatbázis. Ez hibát okoz, amikor a szolgáltató megpróbálja még egyszer létrehozni a már létez? adatbázis másodpéldányát. Az írási hozzáférés azért szükséges, mert az új adatbázis létrehozásához a webkiszolgálói fiók hitelesít? adatait kell használni. 3. A számítógépen telepítve kell lennie az SQL Server Express programnak. 4. A webkiszolgálói fiók folyamatidentitásának helyi felhasználói profillal kell rendelkeznie. A mind a számítógéphez, mind a tartományi fiókokhoz készített helyi felhasználói profil létrehozásáról az információs fájl tartalmaz további tudnivalókat.Forráshiba:Az aktuális webes kérelem végrehajtása nem kezelt kivételt okozott. A kivétel okára és helyére vonatkozó adatok az alábbi veremkivonatban találhatók.Veremkivonat:[SqlException (0x80131904): 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.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735027 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +67[HttpException (0x80004005): Nem lehet csatlakozni az SQL Server adatbázishoz.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +122 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +89 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +26 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +388Verzióinformáció: Microsoft .NET-keretrendszer verziója:2.0.50727.42; ASP.NET verziója:2.0.50727.42

|||

I don't understand I try to make an other database in app_data new_item anotherdatabase.mdf and I have got this message:
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.
I reinstall Confused everything maybe next time work normal.

|||

Where is located aspnetdb.mdf?

|||

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\here

But I try to put them into the App_Data and doesn't work.
I install Windows Longhorn Beta (server 2008) and sites runingI try the same in my notebook windows XP HUN and workso I don't know what is the problem ,but NOW run everything Smile and I don't care.

Thursday, February 16, 2012

ASP.net version

I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
and now I am unable to access the report server. I noticed that I now have
asp.net version 2 instead of version 1. I think this may be the problem.
In VS 2005 I do not use the web part of the program at all so I think I may
be able to delete version 2 from IIS and install version 1 again and that
this may solve my problem. But before I do I just thought I should ask here
if someone else sees a problem. I guess the worst that could happen is that
it would continue not to work.
Anyone?Both the ReportServer and Reports virtuals roots need to be mapped to
ASP.Net 1.1.4322. You can verify this in the properties for each virtual
root on the ASP.Net tab.
What error message do you get when you access report server? Installing a
new version of the framework will reset the password on the ASPNet account,
removing all encryption keys from the account. You may simply need to run
rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1
> and now I am unable to access the report server. I noticed that I now
have
> asp.net version 2 instead of version 1. I think this may be the problem.
> In VS 2005 I do not use the web part of the program at all so I think I
may
> be able to delete version 2 from IIS and install version 1 again and that
> this may solve my problem. But before I do I just thought I should ask
here
> if someone else sees a problem. I guess the worst that could happen is
that
> it would continue not to work.
> Anyone?
>|||To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility found
in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||Using the aspnet_regiis utility will definitely cause you to lose the
encryption keys because it resets the ASPNet account password. You are
better off using the IIS virtual root properties page.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:utbIkAXgEHA.2544@.TK2MSFTNGP10.phx.gbl...
> To remap the vroots back to 1.1.4322 use the aspnet_regiis.exe utility
found
> in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> > Both the ReportServer and Reports virtuals roots need to be mapped to
> > ASP.Net 1.1.4322. You can verify this in the properties for each
virtual
> > root on the ASP.Net tab.
> >
> >
> > What error message do you get when you access report server? Installing
a
> > new version of the framework will reset the password on the ASPNet
> account,
> > removing all encryption keys from the account. You may simply need to
run
> > rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Woody Splawn" <nospam@.splawns.com> wrote in message
> > news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have been running SSRS in VB 2003 but recently I installed VS 2005
> beta1
> > > and now I am unable to access the report server. I noticed that I now
> > have
> > > asp.net version 2 instead of version 1. I think this may be the
> problem.
> > >
> > > In VS 2005 I do not use the web part of the program at all so I think
I
> > may
> > > be able to delete version 2 from IIS and install version 1 again and
> that
> > > this may solve my problem. But before I do I just thought I should
ask
> > here
> > > if someone else sees a problem. I guess the worst that could happen
is
> > that
> > > it would continue not to work.
> > >
> > > Anyone?
> > >
> > >
> >
> >
>|||> What error message do you get when you access report server?
I am getting the following message:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled)
>You may simply need to run rsactivate -r -c <config file>
If I do, what is the exact syntax?
If I understand correctly I move to my MS SQL Server\80\tools\binn directory
to run rsactivate. What is the name of the config file? I have a file
called cnfgsvr.ini, if that helps. What exactly do I do?
In the help on line I got the following:
"A system administrator on the computer running the Report server service
can use a backup copy of the public key to get the report server running
again. Use the rskeymgmt utility to apply the backup key set. If you do not
have backup of the key, you must run rskeymgmt utility to delete all of the
encrypted content, run rsconfig utility to respecify the encrypted
connection values used to connect to the report server database, restart the
service, and retype stored credentials for all reports that use stored
credentials. For more information this utility, search Books Online."
However, I do not understand exactly what they're saying.
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:OmNAryWgEHA.3728@.TK2MSFTNGP10.phx.gbl...
> Both the ReportServer and Reports virtuals roots need to be mapped to
> ASP.Net 1.1.4322. You can verify this in the properties for each virtual
> root on the ASP.Net tab.
>
> What error message do you get when you access report server? Installing a
> new version of the framework will reset the password on the ASPNet
account,
> removing all encryption keys from the account. You may simply need to run
> rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Woody Splawn" <nospam@.splawns.com> wrote in message
> news:Os60WfWgEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have been running SSRS in VB 2003 but recently I installed VS 2005
beta1
> > and now I am unable to access the report server. I noticed that I now
> have
> > asp.net version 2 instead of version 1. I think this may be the
problem.
> >
> > In VS 2005 I do not use the web part of the program at all so I think I
> may
> > be able to delete version 2 from IIS and install version 1 again and
that
> > this may solve my problem. But before I do I just thought I should ask
> here
> > if someone else sees a problem. I guess the worst that could happen is
> that
> > it would continue not to work.
> >
> > Anyone?
> >
> >
>|||P.S.
I do keep a backup of my entire system. I'm sure I have a backup that
preceeds the install of VS 2005 beta1. If it is just a matter of copying a
certain file back into a certain directory I can easily do that, but what
file and what directory?|||Woody,
Check this thread and see if it will help.
http://tinyurl.com/6fyb7
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>|||Your ASPNet account password was reset. The database is intact, and that
backup won't help you. As a side note, you may want to check out the topics
relating to backing up your report server in books online. You certainly
want to back up the encryption key.
The data that is missing was in the ASPNet user profile. Running
"rsactivate -r -c <config file>" will fix the problem. The config file you
are looking for is called rsreportserver.config. You should specify the
full path to the file.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Woody Splawn" <nospam@.splawns.com> wrote in message
news:OSyDmjXgEHA.3348@.TK2MSFTNGP12.phx.gbl...
> P.S.
> I do keep a backup of my entire system. I'm sure I have a backup that
> preceeds the install of VS 2005 beta1. If it is just a matter of copying
a
> certain file back into a certain directory I can easily do that, but what
> file and what directory?
>
>

Monday, February 13, 2012

ASP.NET Problem installing SQL Server 2000 Reporting Services

I am trying to install SQL Server 2000 Reporting Services on a machine with Windows Server 2003. It keeps telling me ASP.NET is not installed or not configured with the web server. I have registered it with IIS using "C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.ex
e -i" and I have installed all necessary updates and restarted the server. I've even set ASP.NET version 1.1.4322 as the default version on the Default Web Site. It is still claiming that it's not installed or not configured.

I checked the help and it says:

Report Manager is an ASP.NET application. If you are installing Report Manager, you must have ASP.NET installed and configured. Setup requires that version 1.1.4322 of ASP.NET be registered with IIS. If you are installing Reporting Services on Windows Server 2003, ASP.NET must be running as Network Service. For information about installing and configuring ASP.NET, see the setup documentation

As far as I can tell, ASP.NET 1.1.4322 is installed and configured and running as the user Network Service. Am I missing anything?

If you have not done actual Asp.net development in this box you are missing a lot because Win2003 comes with IIS not installed and when you install it IIS comes to just render HTML which means all components needed to run Asp.net are disabled. Now to how you fix it first remove IIS if it is installed, then you go to add it in add/remove Windows component add IIS then click on details in that box you will see all the sub components needed to run Asp.net that are disabled. When you have finished that, go into IIS and remove all the security restrictions that makes IIS to run only HTML.

Now to what you need to get SQL Server to install Reporting services 2000 make sure you are running SQL Server 2000 and have at least service pack 3a or 4 and please don't answer questions Windows ask you during the installation only answer questions relevant to you. Post again if you still need help but follow my instructions and you will get through I just helped two people with similar problems.

|||I tried that and didn't quite get there. I uninstalled the .net framework 2.0 as that was the default version on IIS and I don't think anything was using it. I also ran aspnet_ regiis.exe -i -enable.

It would have installed this morning but for the fact that SQL Server needed SP4 installing and everyone got in to work before I could get stuff installed!

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

The connection string specifies a local SQL Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The .......

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

This I fixed by editing the Machine.Config file and changing the Connection String for the Database Access. (Can't remember just which one, but if you do a search for SQLExpress in teh machine.config you will find it.)

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

1) Create a database in SQL Server (2000 or 2005) and make sure that you give the ASPNET account permissions to this database.
2) Run the aspnet_regsql.exe file in your System%Root\Microsoft.NET\Framework\v2.0.xyz directory. This will open an ASP.NET SQL Server Setup Wizard which will create the objects necessary for ASP.NET security.
3) Point to the database you just created.
4) In your web.config file, locate the <connectionStrings> element and add the following:

<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=localhost;initial catalog=<your database name>;integrated security=true" providerName="System.Data.SqlClient">

This overrides the default SQL Express and points to the new database you just created - be it in the same machine or a different machine. You can also change the configuration in the machine.config file although this will affect every web application sitting on top of your machine.|||WOW! it did solve my problem. thanks so much|||

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...|||

Hi bass_player,

I think I was a bit late in getting this error, but when I got it in 2007 your post of 2005 saved my day.

Thanks a lot

RaghavS

|||hi
the first three steps done greatly
the fourth is not
i did not find any<connectionStrings> in my web.config

i'm just a beginer
thank u
|||

Place the <connectionstrings>...</connectionstrings> section right before the <system.web> seciton

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...|||

Hi bass_player,

I think I was a bit late in getting this error, but when I got it in 2007 your post of 2005 saved my day.

Thanks a lot

RaghavS

|||hi
the first three steps done greatly
the fourth is not
i did not find any <connectionStrings> in my web.config

i'm just a beginer
thank u
|||

Place the <connectionstrings>...</connectionstrings> section right before the <system.web> seciton

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...|||

Hi bass_player,

I think I was a bit late in getting this error, but when I got it in 2007 your post of 2005 saved my day.

Thanks a lot

RaghavS

|||hi
the first three steps done greatly
the fourth is not
i did not find any <connectionStrings> in my web.config

i'm just a beginer
thank u
|||

Place the <connectionstrings>...</connectionstrings> section right before the <system.web> seciton

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...

Asp.Net not finding the SQLServer for setting up Security problem

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to SQLServer (express) as being the issue.

I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with VS.

Both created datasases and eveyting looked good inside the db's.

However when I click the "Securtiy tab" I get a message "Unable to connect to SQL Server Database."

When I go to The Provider Tab, there is nothing to configure, just a test Hlink that generates the following when clicked.

SQLExpress database file auto-creation error:

I have run SQL Trace (profiler) against both instances of SQL when aps is trying to connect, but neither show anything.

I keep feeling like I must have missed something.. Anyu clues are welcome.

Rob

The issue was the Machine.Config file and the fact that when I named my new instance of SQL2005, I installed it using a NonDefault name.

HTH

Rob
Smile |||Here is another approach in using a full blown SQL Server as the repository of your credentials for ASP.NET 2.0 if you do not want to use the default SQL Express.

Worked !

Thanks a lot.

(I can now start growing my hair back )

Bill

|||

I have the same problem :S

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

i still get error

Error 4 XML document cannot contain multiple root level elements.

:S:S

|||

<add name ="LocalSqlServer" connectionString="Data Source=localhost;initial catalog = memberDB;

integrated security=true " providerName="System.Data.SqlClient">

</connectionStrings>

I think your error might be pointing to the Add tag as it is missing the Close Tag. However you seem to have an XML issue, not the issue that started the thread..

Rob

E.G. (highlighted in red)

|||Is it mandatory to have SQL Server for accessing the security features like creating users and roles in ASP.Net Configuration tool? If not please tell me the way to avoid the same problem...

Sunday, February 12, 2012

ASP.NET connection string problems with SQL Server 2000

My aspx page is trying to connect to a remote server with SQL Server 2000 installed on it, the ip of the server is 172.16.3.111 and the same is the instance of SQL Server, sql server is running in SQL Server Authentication mode, user id is "test" and password is "test123", name of database is myDB,the connection string which I am providing is as follows:

data source=172.16.3.111\172.16.3.111;user id=test;password=test123;initial catalog=myDB;"

But I am getting the following exception:

SQL Server does not exist or access denied.

even if I try the following connection string:
"data source=172.16.3.111;user id=test;password=test123;initial catalog=myDB;"

than also I get the same exception

even if provide the following connection strings:

"SERVER=172.16.3.111;UID=test;PWD=test123;DATABASE =myDB;"

"SERVER=172.16.3.111\172.16.3.111;UID=test;PWD=test123;DATABASE =myDB;"

than also I get the same exceptions

Can u please tell whats the problem,is the connection string correct,the DBA has also registered me "test" as a user on the SQL server.One thing which I want to mention is that through enterprise manager I can connect and use sql server without any problems,also please note that in VS.NET when I try connecting using server explorer and test the connection than I connect successfully, than why is problem occuring in connecting throug aspx page.

Try change the param "Server" like this:

\\ server name or server ip \ instance name

Tuesday, March 27, 2012

Attach database over the network.

Attach database over the network.

Wednesday, March 7, 2012

Assertion failed on subscription email send

Friday, February 24, 2012

ASPNETDB.MDF is readonly

aspnetdb connection could not establish but database correctly created.

Thursday, February 16, 2012

ASP.net version

Monday, February 13, 2012

ASP.NET Problem installing SQL Server 2000 Reporting Services

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Asp.Net not finding the SQLServer for setting up Security problem

Sunday, February 12, 2012

ASP.NET connection string problems with SQL Server 2000

Asp.net / sql help

Blog Archive

About Me