Hi. We are migrating databases from a server with
Standard edition (2000) to Enterprise Edition (2000).
Trying to find out if there is any difference in system
databases between these versions. For example, can we
move the master database from the Standard instance to
the Enterprise instance without any hangups. Thanks.You can move the system databases from one Edition of SQL Server to another
Edition.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts
Thursday, March 29, 2012
Sunday, March 25, 2012
Attach & Detach Multiple Databases
SQL Server 2000 Standard
I need to move multiple databases (about 20) from the C partition to the E
partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is OK
for a handful of databases but tedious with 10 or more databases. My manager
suggested "looping" or something like that. In other words he wants a method
to move these databases in an efficient script. I looked into using SSEUTIL
but that gives me a "mssql$sqlexpress is not installed" error message,
looking for SQL Server Express 2005. I'm sure what I'm asking isn't something
new.check out master.dbo.sysaltfiles for file paths. then you can dynamically
create the detach/attach scripts using sysdatabases and sysaltfiles.
think like this:
select 'sp_detach ... ' + name + '
go'
from sysdatabases
I use such constructs all the time to create scripts to execute.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"JosephV" <JosephV@.discussions.microsoft.com> wrote in message
news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
> SQL Server 2000 Standard
> I need to move multiple databases (about 20) from the C partition to the E
> partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is
> OK
> for a handful of databases but tedious with 10 or more databases. My
> manager
> suggested "looping" or something like that. In other words he wants a
> method
> to move these databases in an efficient script. I looked into using
> SSEUTIL
> but that gives me a "mssql$sqlexpress is not installed" error message,
> looking for SQL Server Express 2005. I'm sure what I'm asking isn't
> something
> new.|||Thanks. I'll research your suggestion.
"TheSQLGuru" wrote:
> check out master.dbo.sysaltfiles for file paths. then you can dynamically
> create the detach/attach scripts using sysdatabases and sysaltfiles.
> think like this:
> select 'sp_detach ... ' + name + '
> go'
> from sysdatabases
> I use such constructs all the time to create scripts to execute.
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "JosephV" <JosephV@.discussions.microsoft.com> wrote in message
> news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
> > SQL Server 2000 Standard
> >
> > I need to move multiple databases (about 20) from the C partition to the E
> > partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is
> > OK
> > for a handful of databases but tedious with 10 or more databases. My
> > manager
> > suggested "looping" or something like that. In other words he wants a
> > method
> > to move these databases in an efficient script. I looked into using
> > SSEUTIL
> > but that gives me a "mssql$sqlexpress is not installed" error message,
> > looking for SQL Server Express 2005. I'm sure what I'm asking isn't
> > something
> > new.
>
>|||Hi
http://dimantdatabasesolutions.blogspot.com/2007/03/detaching-and-attaching-database.html
"JosephV" <JosephV@.discussions.microsoft.com> wrote in message
news:A173C0D1-AB94-4BEA-AC8A-F81E88744A6F@.microsoft.com...
> Thanks. I'll research your suggestion.
> "TheSQLGuru" wrote:
>> check out master.dbo.sysaltfiles for file paths. then you can
>> dynamically
>> create the detach/attach scripts using sysdatabases and sysaltfiles.
>> think like this:
>> select 'sp_detach ... ' + name + '
>> go'
>> from sysdatabases
>> I use such constructs all the time to create scripts to execute.
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>> "JosephV" <JosephV@.discussions.microsoft.com> wrote in message
>> news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
>> > SQL Server 2000 Standard
>> >
>> > I need to move multiple databases (about 20) from the C partition to
>> > the E
>> > partition. I'm familiar with sp_detach_db and sp_attach_db scripts and
>> > is
>> > OK
>> > for a handful of databases but tedious with 10 or more databases. My
>> > manager
>> > suggested "looping" or something like that. In other words he wants a
>> > method
>> > to move these databases in an efficient script. I looked into using
>> > SSEUTIL
>> > but that gives me a "mssql$sqlexpress is not installed" error message,
>> > looking for SQL Server Express 2005. I'm sure what I'm asking isn't
>> > something
>> > new.
>>
I need to move multiple databases (about 20) from the C partition to the E
partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is OK
for a handful of databases but tedious with 10 or more databases. My manager
suggested "looping" or something like that. In other words he wants a method
to move these databases in an efficient script. I looked into using SSEUTIL
but that gives me a "mssql$sqlexpress is not installed" error message,
looking for SQL Server Express 2005. I'm sure what I'm asking isn't something
new.check out master.dbo.sysaltfiles for file paths. then you can dynamically
create the detach/attach scripts using sysdatabases and sysaltfiles.
think like this:
select 'sp_detach ... ' + name + '
go'
from sysdatabases
I use such constructs all the time to create scripts to execute.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"JosephV" <JosephV@.discussions.microsoft.com> wrote in message
news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
> SQL Server 2000 Standard
> I need to move multiple databases (about 20) from the C partition to the E
> partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is
> OK
> for a handful of databases but tedious with 10 or more databases. My
> manager
> suggested "looping" or something like that. In other words he wants a
> method
> to move these databases in an efficient script. I looked into using
> SSEUTIL
> but that gives me a "mssql$sqlexpress is not installed" error message,
> looking for SQL Server Express 2005. I'm sure what I'm asking isn't
> something
> new.|||Thanks. I'll research your suggestion.
"TheSQLGuru" wrote:
> check out master.dbo.sysaltfiles for file paths. then you can dynamically
> create the detach/attach scripts using sysdatabases and sysaltfiles.
> think like this:
> select 'sp_detach ... ' + name + '
> go'
> from sysdatabases
> I use such constructs all the time to create scripts to execute.
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "JosephV" <JosephV@.discussions.microsoft.com> wrote in message
> news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
> > SQL Server 2000 Standard
> >
> > I need to move multiple databases (about 20) from the C partition to the E
> > partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is
> > OK
> > for a handful of databases but tedious with 10 or more databases. My
> > manager
> > suggested "looping" or something like that. In other words he wants a
> > method
> > to move these databases in an efficient script. I looked into using
> > SSEUTIL
> > but that gives me a "mssql$sqlexpress is not installed" error message,
> > looking for SQL Server Express 2005. I'm sure what I'm asking isn't
> > something
> > new.
>
>|||Hi
http://dimantdatabasesolutions.blogspot.com/2007/03/detaching-and-attaching-database.html
"JosephV" <JosephV@.discussions.microsoft.com> wrote in message
news:A173C0D1-AB94-4BEA-AC8A-F81E88744A6F@.microsoft.com...
> Thanks. I'll research your suggestion.
> "TheSQLGuru" wrote:
>> check out master.dbo.sysaltfiles for file paths. then you can
>> dynamically
>> create the detach/attach scripts using sysdatabases and sysaltfiles.
>> think like this:
>> select 'sp_detach ... ' + name + '
>> go'
>> from sysdatabases
>> I use such constructs all the time to create scripts to execute.
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>> "JosephV" <JosephV@.discussions.microsoft.com> wrote in message
>> news:AEF01BE7-44DF-4DEC-90B1-285AEDA95069@.microsoft.com...
>> > SQL Server 2000 Standard
>> >
>> > I need to move multiple databases (about 20) from the C partition to
>> > the E
>> > partition. I'm familiar with sp_detach_db and sp_attach_db scripts and
>> > is
>> > OK
>> > for a handful of databases but tedious with 10 or more databases. My
>> > manager
>> > suggested "looping" or something like that. In other words he wants a
>> > method
>> > to move these databases in an efficient script. I looked into using
>> > SSEUTIL
>> > but that gives me a "mssql$sqlexpress is not installed" error message,
>> > looking for SQL Server Express 2005. I'm sure what I'm asking isn't
>> > something
>> > new.
>>
Saturday, February 25, 2012
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.
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
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.
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 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.
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.
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
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.
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 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.
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.
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
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.
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 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.
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.
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
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.
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 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.
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.
Thursday, February 9, 2012
ASP.NET 2.0 SQL Server 2005 Connect Problem
HI,
I have a standard 3 tier architecture which uses asp 2.0 and sql 2005. The SQL 2005 machine is remote and when trying connect to the db server from my logon page I get a page cannot be found once i click submit on the logon button.
I have carried out the following checks:
1 ) MAde sure that SQL Server has enabled the TCP/IP and network pipes from configuration manger.
2) I have checked that the remote connections is enabled from surface area configuration.
3) I have ensured that the network service account has privilages on the web server.
4) I am using forms authentication.
5) I have used the following connection string:
connectionString="Network Library=DBMSSOCN;Database=My_DB;data source=ServerName,1433;password=pasword;User ID=Myuser;Integrated Security=false;"
6) I have tested his connection string from a windows forms application and it s working fine.
Can someone please help me out here as I cant work out at is going wrong??
Thanks in advance
Garry
Hi,
Since you are able to connect through windows form using the same connection, I think you need to put a breakpoint at connection.Open() method and see what the actual error is. Let me know of this so that we can pinpoint what exactly is wrong.
-Vivek
|||Hi,
I resloved the problem. It was the fact that the WP process required db_owner rights on the SQL 2005 DB. As simple as that.
Cheers
Subscribe to:
Posts (Atom)