Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Thursday, March 29, 2012

Attach e Detach database

Maybe this a stupid question, but is there any differences beetwen detach
and attach a database from Enterprise Manager (All Tasks-Detach/Attach) or
with the system stored procedures ?
e.g.
if I look at KB 224071
http://support.microsoft.com/support/kb/articles/q224/0/71.asp (Moving SQL
Server Databases to a New Location with Detach/Attach) the articole said to
detach the database as follows :
use master
go
sp_detach_db 'mydb'
go
and to re-attach the database as follows :
use master
go
sp_attach_db 'mydb','...','...'
go
I think it's more simple to detach and attach the database from Enterprise
Manager than to write the stored procedure ...
Thanks,
Michele L.EA justs acts as a nice GUI. In the backgroud it actually
runs the sp_detach_db, sp_attach_db.
So your answer is - no not really ;)
J
>--Original Message--
>Maybe this a stupid question, but is there any
differences beetwen detach
>and attach a database from Enterprise Manager (All Tasks-
Detach/Attach) or
>with the system stored procedures ?
>e.g.
>if I look at KB 224071
>http://support.microsoft.com/support/kb/articles/q224/0/71
.asp (Moving SQL
>Server Databases to a New Location with Detach/Attach)
the articole said to
>detach the database as follows :
>use master
>go
>sp_detach_db 'mydb'
>go
>and to re-attach the database as follows :
>use master
>go
>sp_attach_db 'mydb','...','...'
>go
>I think it's more simple to detach and attach the
database from Enterprise
>Manager than to write the stored procedure ...
>Thanks,
>Michele L.
>
>
>
>
>.
>

attach db MS SQL 2000 .BAK with enterprise manager

hello everyone
i am the worst newbie that exists,,.. and on top my english is terrible !
i hope someone can help me :)
I need to attach .BAK db MS SQL 2000 with enterprise manager
I have a file de db sqlserver 2000 called hello_db_20060410man.bak
my last host has transfered to me .i am not hosted anymore and trying to attach my sqldb to use on IIS on my computer
but..... enterprise manager asks me for files in
.mdf and .log
How can I transform this .bak ?
when i try to restore it enterprise i CANNOT include it
message is that this ,bak is not a sql file !!!
Thanks in advance for your help

Quote:

Originally Posted by julia777

hello everyone
i am the worst newbie that exists,,.. and on top my english is terrible !
i hope someone can help me :)
I need to attach .BAK db MS SQL 2000 with enterprise manager
I have a file de db sqlserver 2000 called hello_db_20060410man.bak
my last host has transfered to me .i am not hosted anymore and trying to attach my sqldb to use on IIS on my computer
but..... enterprise manager asks me for files in
.mdf and .log
How can I transform this .bak ?
when i try to restore it enterprise i CANNOT include it
message is that this ,bak is not a sql file !!!
Thanks in advance for your help


Hi

Where you get this "hello_db_20060410man.bak" this file seems s BACKUP file ,you have restore this file then you will get the .mdf and .log files

RESTORE DATABASE <DESIRE DATABASE NAME>
FROM DISK = '<PATH OF WHERE hello_db_20060410man.bak RESIDES>'
WITH MOVE '<DAT FILENAME>' TO '<PATH WHERE YOU WANT .MDF FILE>',
MOVE 'LOGFILE NAME' TO '<PATH WHERE YOU WANT .LDF FILE>'

EXAMPLE:

RESTORE DATABASE TESTDB1 FROM DISK = 'C:\TEST\TESTDB.BAK'
WITH MOVE 'TESTDB_DAT' TO 'C:\TEST\TESTDB.MDF',
MOVE 'TESTDB_LOG' TO 'C:\TEST\TESTDB.LDF'|||THANKS a lot sponguru_dba :))
it seems to work i have ot my 2 files..
however.. seems i am having a problem to log into yhe site on my IIS :((
i will try again and let you know if you dont mind :)
Thanks again
Julia

Tuesday, March 27, 2012

attach db

How can I attach a remote db via Enterprise Manager or Query Analyzer?
Am I wrong if I launch a "sp_attach" sql file (from my local machine) to the remote server?
Do I really have to detach local db before?
Please can someone just tell me how he did?

SaoriHi saori,
1. Did you try to post your question in the DBA section of these forums:

http://www.sqlteam.com/Forums/


http://www.sql-server-performance.com/forum/default.asp

2. Hope some DBA will help you.|||Thanks for the answer.
I'll (quickly) give it a try.

(I posted a msg there 'cause it is above all a question of method about sql server tools)

Saori|||Honestly, I attach remote db's by creating a new registration. Unless you mean something else like fiberchanneling or something, but as for having your SQL Enterprise Manager utilize a Remote SQL Server, just create a new registration.

For T-SQL based methods, you're not necessarily attaching. I'd say it's more Linked Server, or Using Remote Servers. check books online for those two in the Index tab.

SP_LinkedServers and the other method would be actually using the enterprise manager to create the registration.|||Saori,

You didn't clearly define your question about what you want to 'attach', but I think I have understood what you were saying. I would redefine your question with several possible solutions.

Assume, you have a local SQL server in your machine, and there is another SQL server in a remote machine. There is a database called pubs1 existing in the remote SQL server. You want it APPEARS ('attach') in your SQL server.

1. Logical APPEAR:
As KraGiE suggested you could make a new Server Registration in your local SQL Enterprise Manager to LINK to that remote SQL server. In this way, you would bring the whole SQL server including the pubs1 into your local SQL Enterprise Manager.

However, to do so, you need to have the access to the database, say: machine name, login name and password. It is possible that you could only access one database in that server, say, pubs1. But that is enough for you. By the way, if the remote server is not within your LAN, and need to be linked through HTTP, you should have the server IP address and also the access to possible firewall.

I called this kind of 'attach' as logical APPEARS, because the database is not physically in your machine, but still at the remote server. You can only access the database through your Enterprise Manager. The database pubs1 appearing in your Enterprise Manager is just a pointer linked to the remote server.

2. Physical APPEAR:
In short, get a physical copy from the remote server and 'attach' it to your local server.

Step 1:
Copy the database file and the log file into your local machine. In this case, pubs1 files are located by default at:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1_log.LDF
You need shut down the remote database for copy/past, otherwise, it wouldn't work.

Step 2:
from Enterprise Manager, right click the Databases object in your local SQL instance, choose all tasks --> attach database ... . From the Attach Database window, choose your database file, pubs1, and then OK.

3. If you didn't have SQL 2000, instead of SQL 7.0, then the Step 2 would not avaiable in Enterprise Manager. You would have to use the command 'sp_attach_db' to do the job. Something like:


EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log1.ldf'

4. Finally, if you even didn't have SQL server 7.0, you couldn't do the trick of 'attach'. But, you could do the job with SQL server 6.5 Enterprise Manager 'Database/Object transfer' tool given you have access to the remote database, where there is equivalent tools in both SQL 7.0/2000, called Import Data/Export Data, but not as easy used as the ATTACH method.

Hope this helps.|||Thanks Phuoc, KraGiE and ghan.
This really helped me understand essential issues.

Great analysis , ghan (copied in my notepad)!
Just one little thing:
When I attach db via Enterprise Manager, do I automatically transfer log file as well?|||saori,

I am really happy to hear that. You know what, when I made some analyses to other people, I just summarize what I have done and clear my understanding about this issue myself.

When I attach db via Enterprise Manager, do I automatically transfer log file as well?

You see the example:


EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log1.ldf'

There are two files, one is *.mdf, the data file, another is *.ldf, the log file.

When you use enterprise manager to do the job, you will see, (at STEP 2) you only need browse the *.mdf file in, while the *.ldf file will be brought in automatically, assuming you have copied the two files into the same directory (Step 1).

Good luck.|||I have a project lets say project1. I have a copy of it running on my development server and a copy of it on my production server. I have detached db from development server and attached it to my production server. I can work in db using Enterprise manager but when I try to run my applications it doesnt work. I know why it doesnt work its because its looking for user developmentserver and now its on productionserver. Is there a way to set permissions for user productionserver without having to do every table and stored procedure one at a time? I would like to do it quickly and efficiently and doing all by hand one at a time is neither.
Please help.|||There is a security issue. You must use Windows Authentification, instead of SQL Server Authentification. You might change your connection string to use SQL Server authentification. If you want to keep to use windows authentification, you need to setup your security in your production server to make your application assistent with your SQL server.

attach database option disabled

Hi,
I am trying to attach a database via enterprise manager
but the option to this is disabled. Is there anyway I can
enable this option?
Thanks in advance
JenCIs the server you're connected to using SQL Server 7? If so, then no, you
cannot enable it. However, you can do the attach via Query Analyzer using
sp_attach_db (look up syntax in BOL).
"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
> Hi,
> I am trying to attach a database via enterprise manager
> but the option to this is disabled. Is there anyway I can
> enable this option?
> Thanks in advance
> JenC|||Hi,
I am using SQL 2000 and I have tried using sp_attach_db
but with no joy.
Thanks.
>--Original Message--
>Is the server you're connected to using SQL Server 7? If
so, then no, you
>cannot enable it. However, you can do the attach via
Query Analyzer using
>sp_attach_db (look up syntax in BOL).
>
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
>> Hi,
>> I am trying to attach a database via enterprise manager
>> but the option to this is disabled. Is there anyway I
can
>> enable this option?
>> Thanks in advance
>> JenC
>
>.
>|||"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
> I am using SQL 2000 and I have tried using sp_attach_db
> but with no joy.
Do you want to post your error and some more information about the
problem? How was the database detached?|||Hi,
I have sorted it out now (touch wood). Basically we have a
setup program that as part of the install installs MSDE
2000, unfortunately on some PC's (mainly Win XP PCs) it
installs the earlier version of MSDE and this is what
caused the confusion. I have now successfully installed
MSDE 2000 and I can now attach databases to my hearts
content.
Thanks for your help.
Jen
>--Original Message--
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
>> I am using SQL 2000 and I have tried using sp_attach_db
>> but with no joy.
> Do you want to post your error and some more
information about the
>problem? How was the database detached?
>
>.
>

Sunday, March 25, 2012

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
inThe attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into th
e
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:

> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
[vbcol=seagreen]
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into
the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
>|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as the
y
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
[vbcol=seagreen]
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:
>

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
inThe attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into the
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:
> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
> > in the Enterprise Manager when one goes to attach a database it lets
> > you choose an MDF / LDF file. It then verifies the validity of the
> > database before attaching. (I also assume that it detects if the
> > database was spanning multiple files). I am wondering if there is a
> > sproc/sprocs that can be called to do this or is this done via
> > proprietary knowledge of the format that the mdf/ldf files are stored
> > in
> >|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as they
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:
> > The attaching or the check on spanning multiple files?
> >
> > Attaching: sp_attach_db or sp_attach_single_file_db
> >
> > Check for files: this is included in the header of the .mdf, primary data
> > file. When the database comes online, this information is populated into the
> > virtual sysfiles.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > "johndoe@.driver.net" wrote:
> >
> > > in the Enterprise Manager when one goes to attach a database it lets
> > > you choose an MDF / LDF file. It then verifies the validity of the
> > > database before attaching. (I also assume that it detects if the
> > > database was spanning multiple files). I am wondering if there is a
> > > sproc/sprocs that can be called to do this or is this done via
> > > proprietary knowledge of the format that the mdf/ldf files are stored
> > > in
> > >

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
in
The attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into the
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:

> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>
|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
[vbcol=seagreen]
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as they
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
[vbcol=seagreen]
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:

Thursday, March 8, 2012

assigning a data source

Is there any other way to a assign a data source to a report other than
through the Report Manager. The reason I ask is because when I try to
browse for data sources in Report Manager, I get "Object reference not set
to an instance of an object". Microsoft tech support seems unable to help
with this error message so I'm wondering if assigning a data source can be
done outside of the Manager.
--Will you send the Report Manager log file that contains the object reference
exception? The file name should be ReportServerWebApp_<current date>.log
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:%23lOzEIpmEHA.2096@.TK2MSFTNGP15.phx.gbl...
> Is there any other way to a assign a data source to a report other than
> through the Report Manager. The reason I ask is because when I try to
> browse for data sources in Report Manager, I get "Object reference not set
> to an instance of an object". Microsoft tech support seems unable to help
> with this error message so I'm wondering if assigning a data source can be
> done outside of the Manager.
> --
>
>|||I received the strack trace from the PSS engineer you were working with. I
believe you have view state disabled on your machine. In the web.config
file in the Report Manager directory, add the attribute
enableViewState="true" to the system.web/pages tag:
<system.web>
<pages enableViewState="true" />
</system.web>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:%23lOzEIpmEHA.2096@.TK2MSFTNGP15.phx.gbl...
> Is there any other way to a assign a data source to a report other than
> through the Report Manager. The reason I ask is because when I try to
> browse for data sources in Report Manager, I get "Object reference not set
> to an instance of an object". Microsoft tech support seems unable to help
> with this error message so I'm wondering if assigning a data source can be
> done outside of the Manager.
> --
>
>

Saturday, February 25, 2012

ASSERT: Assertion failed!

Dear ALL,
I have this problem during view report in Report Manager (I m using CTP Sept
Cut for my SQL 2005 now). And, i can't find out what is this error about.
w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
stack
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32 cellIndex)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
processingContext, TextBox textbox, TextBoxInstance textboxInstance,
TextBoxInstanceInfo textboxInstanceInfo, Object value)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
textBox, ProcessingContext processingContext, Int32 index, IScope
containingScope)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection parameters, Boolean noRows)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component processing;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
Please help
NickyThis is a known issue in CTP September. Your report has a table with another
table inside that has table detail rows. The detail rows of that inner table
are causing the issue. The fix is available in SQL Server 2005 RTM.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nicky" <Nicky@.discussions.microsoft.com> wrote in message
news:5A957A04-9D69-4C9D-9D5F-CB95FA802D2C@.microsoft.com...
> Dear ALL,
> I have this problem during view report in Report Manager (I m using CTP
> Sept
> Cut for my SQL 2005 now). And, i can't find out what is this error about.
> w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
> stack:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32
> cellIndex)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
> processingContext, TextBox textbox, TextBoxInstance textboxInstance,
> TextBoxInstanceInfo textboxInstanceInfo, Object value)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
> textBox, ProcessingContext processingContext, Int32 index, IScope
> containingScope)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
> processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
> rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection
> parameters, Boolean noRows)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection
> parameters, Boolean mergeTran)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, ProcessingContext context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
> processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
> errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
> ProcessingContext& context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
> renderer, DateTime executionTimeStamp, GetReportChunk
> getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
> CreateReportChunk cacheDataCallback, Boolean& dataCached)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
> Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
> operation)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext
> context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., un-named assertion fired for component processing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> Please help
> Nicky
>

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>


Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.


Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>


Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||I also have d same problem..can anybody tell me how to fix it?????

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>


Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.

Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

Assembly ReportingServicesWebServer problem

I did a fresh install of Reporting Services (Standard Edition Final).
From the service manager the report service is running, but i get the following error on http://localhost/ReportServer/

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.

Source Error:

Line 27: <assemblies>
Line 28: <clear />
Line 29: <add assembly="ReportingServicesWebServer" />
Line 30: </assemblies>
Line 31: </compilation>


Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 29

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

=== Pre-bind state information ===
LOG: User = Unknown
LOG: DisplayName = ReportingServicesWebServer
(Partial)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/
LOG: Initial PrivatePath = C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
Calling assembly : (Unknown).
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/Temporary ASP.NET Files/reportserver/b7e1529c/70d36ced/ReportingServicesWebServer/ReportingServicesWebServer.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportServer/bin/ReportingServicesWebServer.DLL.
LOG: Using application configuration file: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config
LOG: Using host configuration file: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ERR: Failed to complete setup of assembly (hr = 0x80070005). Probing terminated.


Hi!

I'm having the same problem, can someone help me?

Thank you!

|||I have the same problem ,can someone help me..|||

xian_ve

xian_ve,

Can you verify the version SQL reporting services is .NET version 2.0, and that your application pool for reporting service is using "Network" logon?

Ham

|||

That is so on my computer.

What is the solution?

|||

I had a similar error, and it was some problems in c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\rssrvpolicy.config, so check that that one looks correct.

Sunday, February 12, 2012

asp.net enterprise manager

Hi

has anyone used this tool to upload sql databases to a web host

i'm struggling

cheers!!!

Adrian

Hi

Use the Copy Database Wizard

|||This post shows detailed steps to move database to?shared host:
HOW-TO: Database from VWD to Shared Host