Error: Could not find stored procedure !!

Hi,

Error: Could not find stored procedure.

I Installed the SQL Server SP2 and the error still occurs when ever I call the stored procedure from my windows app!!

Any Help ?

what's the name of SP you want to call?|||

In design window its : GetMonthRecord;1

in code window its: GetMonthRecord_1

I tried to rename it to : GetMonthRecord

the same error occurs !!

|||

Would you mind running this query and posting the results so that we can get some more information related to the object:

select uid,
left ([name], 30) as [name]
from sysobjects
where [name] like 'GetMonthRecord%'

|||

I run this query:

select uid,

left ([name], 30) as [name]

from sysobjects

where [name] like 'ThisMonthRecords%'

the result is:

1 ThisMonthRecords

|||

Now try:

exec ThisMonthRecords

and post the results

|||

executed succecfully the result is integer:

2

//

I'm facing the problem only with VS2005, when I add the procedure as queryTableAdapter, no error in code, but the error uccours after calling the SP.

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: 3624 and event ID: 17055

We have a problem with our SQL Server.
the server is a windows 2K server SP3, running SQL Server
2K SP2. the problem we have is when we try to view JOBS
under Management. I get the following error.
Error: 3624
Location: rebcase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 54
Process ID: 1268
in the Event logs under application we get the following
Errors:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:09:44:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
---
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/12/2003
Time: 9:15:20:AM
User: MARCRIST\AdamB
Computer: ANIMAL
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
both these refere to the MSDB, the only change we have
made recently is to install the Veratis SQL Server Agent.
I would be grateful for any help or advice.| We have a problem with our SQL Server.
| the server is a windows 2K server SP3, running SQL Server
| 2K SP2. the problem we have is when we try to view JOBS
| under Management. I get the following error.
|
| Error: 3624
| Location: rebcase.cpp:1378
| Expression: m_offBeginVar < m_SizeRec
| SPID: 54
| Process ID: 1268
|
| in the Event logs under application we get the following
| Errors:
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:09:44:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
| ---
|
| Event Type: Error
| Event Source: MSSQLSERVER
| Event Category: (2)
| Event ID: 17055
| Date: 01/12/2003
| Time: 9:15:20:AM
| User: MARCRIST\AdamB
| Computer: ANIMAL
| Description:
| 17066 :
| SQL Server Assertion: File: <recbase.cpp>, line=1378
| Failed Assertion = 'm_offBeginVar < m_SizeRec'.
|
|
| both these refere to the MSDB, the only change we have
| made recently is to install the Veratis SQL Server Agent.
|
| I would be grateful for any help or advice.
--
Hi Adam,
This might help:
FIX: An INSERT May Fail with a 3624 Error Message After a Failed Attempt to
Add New Table Column
http://support.microsoft.com/?id=317852
--
Eric Cárdenas
SQL Server support

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.
Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.
|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:[vbcol=seagreen]
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
>
>
I get the same error. Please advise.
sql

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:[vbcol=seagreen]
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
>
>
>
>
I get the same error. Please advise.

error: 26 - error locating server/instance specified

My machine is WinXP with SP2. I installed SQL Server 2005 Developer
Edition on my machine last week, and I could bring up the Microsoft
SQL Server Management Studio fine, no error.
Today in Microsoft SQL Server Management Studio when I tried to
connect to machinename\SQL2005 (the SQL 2005 instance), I got the
error:
"An error has occured while establishing a connection to the server.
when connecting to sql server 2005, this failure may be caused by the
fact that under the default settings sql server does not allow remote
connections. (provider: sql network interfaces, error: 26 - error
locating server/instance specified)(microsoft sql server)"
But, I am not trying to connect to it remotely, the SQL Server 2005 is
on my machine.
In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
Configuration for Services and connections
"Local and remote connections" is not selected.
How can I fix this problem ?
Thank you.Never mind.
On the "Server name", i click on Browse more and select the instance
from there, I guess the machinename is different today than last week.
So, I selected that one and now it works.
THanks
On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> My machine is WinXP with SP2. I installed SQL Server 2005 Developer
> Edition on my machine last week, and I could bring up the Microsoft
> SQL Server Management Studio fine, no error.
> Today in Microsoft SQL Server Management Studio when I tried to
> connect to machinename\SQL2005 (the SQL 2005 instance), I got the
> error:
> "An error has occured while establishing a connection to the server.
> when connecting to sql server 2005, this failure may be caused by the
> fact that under the default settings sql server does not allow remote
> connections. (provider: sql network interfaces, error: 26 - error
> locating server/instance specified)(microsoft sql server)"
> But, I am not trying to connect to it remotely, the SQL Server 2005 is
> on my machine.
> In the Start >> Programs >> Microsoft SQL Server 2005 >> Configuration
> Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area
> Configuration for Services and connections
> "Local and remote connections" is not selected.
> How can I fix this problem ?
> Thank you.|||On Jun 10, 1:27 pm, fiefie.ni...@.gmail.com wrote:
> Never mind.
> On the "Server name", i click on Browse more and select the instance
> from there, I guess the machinename is different today than last week.
> So, I selected that one and now it works.
> THanks
> On Jun 10, 1:25 pm, fiefie.ni...@.gmail.com wrote:
> > My machine is WinXP with SP2. I installedSQLServer 2005 Developer
> > Edition on my machine last week, and I could bring up the Microsoft
> >SQLServer Management Studio fine, noerror.
> > Today in MicrosoftSQLServer Management Studio when I tried to
> > connect to machinename\SQL2005 (theSQL2005 instance), I got the
> >error:
> > "Anerrorhas occured while establishing a connection to the server.
> > when connecting tosqlserver 2005, this failure may be caused by the
> > fact that under the default settingssqlserver does not allow remote
> > connections. (provider:sqlnetwork interfaces,error:26-error
> > locating server/instance specified)(microsoftsqlserver)"
> > But, I am not trying to connect to it remotely, theSQLServer 2005 is
> > on my machine.
> > In the Start >> Programs >> MicrosoftSQLServer 2005 >> Configuration
> > Tools >>SQLServer 2005 Surface Area Configuration >> Surface Area
> > Configuration for Services and connections
> > "Local and remote connections" is not selected.
> > How can I fix this problem ?
> > Thank you.
I get the same error. Please advise.

Error: 18456, Severity: 14, State: 12.

I am running SQL Server 2005 x64 SP2 and have problem connecting to database with the SQL logins I created. I test the database login using Microsoft ODBC Administrator to connect the the database locally, only 'sa' can login. All other sql logins I created fails and returns this message:

Microsoft SQL Server Login

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'doteasylogin'.

OK

In the SQL Logs, it shows: Error: 18456, Severity: 14, State: 12.

The SQL Services is running as 'Local System'.

Can anyone help please?

Did you create the user at the server level and give him access to the server (and to the database) ? The state 12 indicates that there is an access problem which is normally dedicated to the fact that the user is either not allowed to login or does not have the appropiate permissions for the database.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I created the user 'testlogin' in SQL Server Login and grant the 'testlogin' user db_datareader & db_datawriter permission in Database Role Membership.

I'm using Windows Server 2003 x64 standard edition.

|||

Try executing the following two queries and check that each of them returns a row:

select name, principal_id from sys.server_principals where name = 'testlogin'

select permission_name, state_desc from sys.server_permissions where grantee_principal_id = suser_id('testlogin')

The first query should return the 'testlogin' login name and its associated id.

The second query should display a row with the CONNECT_SQL, GRANT value.

Thanks

Laurentiu

|||

Hello.

I have the same problem.

I am a beginner in SQL Server.I tried to install SQLServerExpress2005sp2

I've migrated a database from Access.

I tried to make a new user: for example 'testlogin' .

I've do all you sugest (server permissions, database permissions, ..)

I've run the queries from above and everything seems ok, but I cannot connect to database using the 'testlogin' account.

Error: 18456, Severity: 14, State: 12.

Login failed for user 'testlogin'. [CLIENT: xx.xx.xx.xxx]

IMPORTANT: if I grant sysadmin role to 'testlogin' I can connect.

thanks a lot in advance.

|||I started receiving this error after attempting to set up database mirroring. After running through the configuration including setting up endpoints (unsuccessfully) the mirror server has stopped accepting logins from SQL accounts (except SA). The principal server still accepts SQL logins without failure. I have stopped mirroring and deleted the database on both servers. Thank you for any help you can give. This was not an issue before I attempted database mirroring.

Okay after looking at it further it turned out that in my instance there was a new object for mirroring created. This object was accessible by going to the properties of the user account, choosing securables on the left side of the window. Then click on the add button and choose "all objects of the types" click OK; check Endpoints and click OK. In my case I saw the "Mirroring" option under Securables. That seems to be the culprit, after selecting Grant for the Connect permission I was able to connect fine. As a temporary solution I have chosen to follow the steps mentioned before using the "Public" server role, that way all accounts will have connect access. This is just temporary until I learn how to Drop the pesky Mirroring object from the server altogether.
|||

I am having the same issue, create a login using TSQL and granting access to a user database and it will not connect. I have tried the queries mentioned and from sys.server_permissions is saying CONNECT SQL with the GRANT option.

As soon as I added the user to the sysadmin server role, no problems connecting.

Thank you.

Error: 18456, Severity: 14, State: 12.

I am running SQL Server 2005 x64 SP2 and have problem connecting to database with the SQL logins I created. I test the database login using Microsoft ODBC Administrator to connect the the database locally, only 'sa' can login. All other sql logins I created fails and returns this message:

Microsoft SQL Server Login

Connection failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'doteasylogin'.

OK

In the SQL Logs, it shows: Error: 18456, Severity: 14, State: 12.

The SQL Services is running as 'Local System'.

Can anyone help please?

Did you create the user at the server level and give him access to the server (and to the database) ? The state 12 indicates that there is an access problem which is normally dedicated to the fact that the user is either not allowed to login or does not have the appropiate permissions for the database.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I created the user 'testlogin' in SQL Server Login and grant the 'testlogin' user db_datareader & db_datawriter permission in Database Role Membership.

I'm using Windows Server 2003 x64 standard edition.

|||

Try executing the following two queries and check that each of them returns a row:

select name, principal_id from sys.server_principals where name = 'testlogin'

select permission_name, state_desc from sys.server_permissions where grantee_principal_id = suser_id('testlogin')

The first query should return the 'testlogin' login name and its associated id.

The second query should display a row with the CONNECT_SQL, GRANT value.

Thanks

Laurentiu

|||

Hello.

I have the same problem.

I am a beginner in SQL Server.I tried to install SQLServerExpress2005sp2

I've migrated a database from Access.

I tried to make a new user: for example 'testlogin' .

I've do all you sugest (server permissions, database permissions, ..)

I've run the queries from above and everything seems ok, but I cannot connect to database using the 'testlogin' account.

Error: 18456, Severity: 14, State: 12.

Login failed for user 'testlogin'. [CLIENT: xx.xx.xx.xxx]

IMPORTANT: if I grant sysadmin role to 'testlogin' I can connect.

thanks a lot in advance.

|||I started receiving this error after attempting to set up database mirroring. After running through the configuration including setting up endpoints (unsuccessfully) the mirror server has stopped accepting logins from SQL accounts (except SA). The principal server still accepts SQL logins without failure. I have stopped mirroring and deleted the database on both servers. Thank you for any help you can give. This was not an issue before I attempted database mirroring.

Okay after looking at it further it turned out that in my instance there was a new object for mirroring created. This object was accessible by going to the properties of the user account, choosing securables on the left side of the window. Then click on the add button and choose "all objects of the types" click OK; check Endpoints and click OK. In my case I saw the "Mirroring" option under Securables. That seems to be the culprit, after selecting Grant for the Connect permission I was able to connect fine. As a temporary solution I have chosen to follow the steps mentioned before using the "Public" server role, that way all accounts will have connect access. This is just temporary until I learn how to Drop the pesky Mirroring object from the server altogether.
|||

I am having the same issue, create a login using TSQL and granting access to a user database and it will not connect. I have tried the queries mentioned and from sys.server_permissions is saying CONNECT SQL with the GRANT option.

As soon as I added the user to the sysadmin server role, no problems connecting.

Thank you.

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

Error: 18456, Severity: 14, State: 11

We have SQL Server 2005 Developer Edition with SP2 installed on Windows
Server 2003 Standard Edition SP1. When one of our programmers tries to
connect to the SQL instance he receives the 'Error: 18456, Severity: 14,
State: 11' error.
I found where this refers to a connect to server error and have checked, he
does have connect priviliges. I deleted both the server account and database
account and recreated them but he still receives the error. The only way he
can get access is to be a member of the sysadmin role. This was done for
testing but cannot be given as normal practice.
Does anyone have any ideas or solutions?
Thank You,
Bertbert
CREATE LOGIN test
WITH PASSWORD = 'balabalabala';USE AdventureWorks;
CREATE USER 'test' FOR LOGIN test;
GO Note , you can use ALTER LOGIN ... WITH default_database=..."-bert"
<bert@.discussions.microsoft.com> wrote in message
news:C9CDD261-B1AD-48BC-B821-9DCC80F64480@.microsoft.com...
> We have SQL Server 2005 Developer Edition with SP2 installed on Windows
> Server 2003 Standard Edition SP1. When one of our programmers tries to
> connect to the SQL instance he receives the 'Error: 18456, Severity: 14,
> State: 11' error.
> I found where this refers to a connect to server error and have checked,
> he
> does have connect priviliges. I deleted both the server account and
> database
> account and recreated them but he still receives the error. The only way
> he
> can get access is to be a member of the sysadmin role. This was done for
> testing but cannot be given as normal practice.
> Does anyone have any ideas or solutions?
> Thank You,
> Bert

Error writing binary data

Dear all,
we run a SQL Server 2000 SE 8.00.534 SP2 on a 2 CPU server.
We have three similar databases, which all contain a table to store binaries
as base64-Text.
From time to time we face a problem writing in one of this tables. The
requests get a timeout.
Its always the same table in the same database. The other tables never
caused any problem.
Reading access ist no problem, but writing doesn't work.
We can fix the problem by copying the data in a new table an rename them
that the new table replaces the old one. Sometimes the problem ist solved
when we add a new index (doesn't matter which column) and save the table.
You can't see any difference between the the table in the relevant database
and the other ones.
Even a restart of the whole machine doesn't solve the problem, so that locks
shouldn't be the cause.
Any tips?
Greeting from Germany
Matthias MerzHi
There are a significant number of changes between the version you are
running and the current version (2187) so you may want to review the KB
article to see if there is anything that may have fixed this
http://www.aspfaq.com/sql2000builds.asp
If you are getting any error messages in the SQL Server log or the Windows
Event log will help.
You don't say if dropping all indexes helps!!!
John
"Matthias Merz" wrote:
> Dear all,
> we run a SQL Server 2000 SE 8.00.534 SP2 on a 2 CPU server.
> We have three similar databases, which all contain a table to store binaries
> as base64-Text.
> From time to time we face a problem writing in one of this tables. The
> requests get a timeout.
> Its always the same table in the same database. The other tables never
> caused any problem.
> Reading access ist no problem, but writing doesn't work.
> We can fix the problem by copying the data in a new table an rename them
> that the new table replaces the old one. Sometimes the problem ist solved
> when we add a new index (doesn't matter which column) and save the table.
> You can't see any difference between the the table in the relevant database
> and the other ones.
> Even a restart of the whole machine doesn't solve the problem, so that locks
> shouldn't be the cause.
> Any tips?
> Greeting from Germany
> Matthias Merz
>
>

Error writing binary data

Dear all,
we run a SQL Server 2000 SE 8.00.534 SP2 on a 2 CPU server.
We have three similar databases, which all contain a table to store binaries
as base64-Text.
From time to time we face a problem writing in one of this tables. The
requests get a timeout.
Its always the same table in the same database. The other tables never
caused any problem.
Reading access ist no problem, but writing doesn't work.
We can fix the problem by copying the data in a new table an rename them
that the new table replaces the old one. Sometimes the problem ist solved
when we add a new index (doesn't matter which column) and save the table.
You can't see any difference between the the table in the relevant database
and the other ones.
Even a restart of the whole machine doesn't solve the problem, so that locks
shouldn't be the cause.
Any tips?
Greeting from Germany
Matthias MerzHi
There are a significant number of changes between the version you are
running and the current version (2187) so you may want to review the KB
article to see if there is anything that may have fixed this
http://www.aspfaq.com/sql2000builds.asp
If you are getting any error messages in the SQL Server log or the Windows
Event log will help.
You don't say if dropping all indexes helps!!!
John
"Matthias Merz" wrote:

> Dear all,
> we run a SQL Server 2000 SE 8.00.534 SP2 on a 2 CPU server.
> We have three similar databases, which all contain a table to store binari
es
> as base64-Text.
> From time to time we face a problem writing in one of this tables. The
> requests get a timeout.
> Its always the same table in the same database. The other tables never
> caused any problem.
> Reading access ist no problem, but writing doesn't work.
> We can fix the problem by copying the data in a new table an rename them
> that the new table replaces the old one. Sometimes the problem ist solved
> when we add a new index (doesn't matter which column) and save the table.
> You can't see any difference between the the table in the relevant databas
e
> and the other ones.
> Even a restart of the whole machine doesn't solve the problem, so that loc
ks
> shouldn't be the cause.
> Any tips?
> Greeting from Germany
> Matthias Merz
>
>

Error with SP

After installing SP2, when i try to run a report !
Thanks
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\RSReportHost.exe', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ReportingServicesLibrary.dll', nessun simbolo
caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Diagnostics.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\ReportingServicesLibrary.resources.dll',
nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_it_b77a5c561934e089\mscorlib.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Interfaces.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ReportingServicesNativeClient.dll' caricato,
caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione 'Just My
Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0DE06ACD\msvcm80.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Designer.dll',
nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ReportPreview.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ReportPreview.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ProcessingCore.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingObjectModel.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato
'C:\WINDOWS\assembly\GAC_MSIL\System.resources\2.0.0.0_it_b77a5c561934e089\System.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'kxxqa_gb', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.XmlRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.XmlRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.CsvRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.CsvRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ImageRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ImageRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.HtmlRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.HtmlRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ExcelRendering.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ExcelRendering.resources.dll', nessun simbolo caricato.
'RSReportHost.exe' (gestito): caricato
'expression_host_7e2a1ba8efe345ea9ede8dfc7bf53f89', nessun simbolo caricato.
'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.DataExtensions.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
'RSReportHost.exe' (gestito):
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll'
caricato, caricamento simboli ignorato. Il modulo è ottimizzato e l'opzione
'Just My Code' del debugger è attivata.
Il thread 0x378 è terminato con il codice 0 (0x0).
Il programma '[4884] RSReportHost.exe: Gestito' è terminato con il codice 0
(0x0).On Mar 2, 9:30 am, Paolo <P...@.discussions.microsoft.com> wrote:
> After installing SP2, when i try to run a report !
> Thanks
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.d=ll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\RSReportHost.exe', nessun simbolo caricat=o=2E
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e=089\System.Windows.Forms.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\Sy=stem.Drawing.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\ReportingServicesLibrary.dll', nessun sim=bolo
> caricato.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Diagnostics.d=ll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\ReportingServicesLibrary.resources.dll=',
> nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50=a3a\System.Configuration.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System=.Xml.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.W=eb.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_it_b77a5c561934e=089\mscorlib.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Interfaces.dl=l'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\ReportingServicesNativeClient.dll' carica=to,
> caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opzione 'Just= My
> Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x=-ww_0DE06ACD\msvcm80.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.Designer.dll',
> nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ReportPreview=.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCor=e=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ReportPrev=iew.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a=3a\System.Web.Services.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.Processing=Core.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.=Data.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingObj=ectModel.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato
> 'C:\WINDOWS\assembly\GAC_MSIL\System.resources\2.0.0.0_it_b77a5c561934e08=9\System.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'kxxqa_gb', nessun simbolo caricat=o=2E
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.XmlRendering.=dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.XmlRenderi=ng.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.CsvRendering.=dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.CsvRenderi=ng.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ImageRenderin=g=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ImageRende=ring.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.HtmlRendering=.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.HtmlRender=ing.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ExcelRenderin=g=2Edll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato 'C:\Programmi\Microsoft Visual Stu=dio
> 8\Common7\IDE\PrivateAssemblies\it\Microsoft.ReportingServices.ExcelRende=ring.resources.dll', nessun simbolo caricato.
> 'RSReportHost.exe' (gestito): caricato
> 'expression_host_7e2a1ba8efe345ea9ede8dfc7bf53f89', nessun simbolo carica=to.
> 'RSReportHost.exe' (gestito): 'C:\Programmi\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.DataExtension=s=2Edll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089=\System.Transactions.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11=d50a3a\System.EnterpriseServices.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c56193=4e089\System.Data.OracleClient.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> 'RSReportHost.exe' (gestito):
> 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d5=0a3a\Microsoft.VisualBasic.dll'
> caricato, caricamento simboli ignorato. Il modulo =E8 ottimizzato e l'opz=ione
> 'Just My Code' del debugger =E8 attivata.
> Il thread 0x378 =E8 terminato con il codice 0 (0x0).
> Il programma '[4884] RSReportHost.exe: Gestito' =E8 terminato con il codi=ce 0
> (0x0).
It seems like the service pack did not install completely, which
happens from time to time. Try to uninstall the service pack or search
online for the Microsoft service pack removal executable (don't quote
me on the name) and try to reinstall the SP. Also, make sure that you
have the correct SP2 installation file as well. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Error with SimplePageHeaders deviceinfo setting

I am using RS2000 SP2 and trying to implement SimplePageHeaders
deviceinfo to put the report header into the page header in Excel, but
cannot get this to work. I'm adding &rc:SimplePageHeaders=TRUE to my
URL but the Excel file does not appear to be generated.
If I add rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK.
If I use SimplePageHeaders, the dialog to download the xls file
displays no File Name or File Type and if I select Open, I get an
Internet Explorer error "Internet Explorer cannot download from
<servername>. Internet Explorer was not able to open this Internet
site. The requested site is either unavailable or cannot be found.
Please try again later".
I have tried running tcptrace on it - this shows a rendering error:
"Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was thrown. (rrRenderingError) ...... Object reference not set to an
instance of an object."
I've also tried adding the device info to the config file as
illustrated in MSDN online docs, but this appears to be completely
ignored.
Any assistance appreciated.I've had no response so far with the query below. Can anyone confirm
if using this deviceinfo setting should be feasible in RS2000 SP2 and
if there are any known issues with it?
AMasson wrote:
> I am using RS2000 SP2 and trying to implement SimplePageHeaders
> deviceinfo to put the report header into the page header in Excel, but
> cannot get this to work. I'm adding &rc:SimplePageHeaders=TRUE to my
> URL but the Excel file does not appear to be generated.
> If I add rc:RemoveSpace=0.5in, or rc:OmitFormulas=True, these work OK.
> If I use SimplePageHeaders, the dialog to download the xls file
> displays no File Name or File Type and if I select Open, I get an
> Internet Explorer error "Internet Explorer cannot download from
> <servername>. Internet Explorer was not able to open this Internet
> site. The requested site is either unavailable or cannot be found.
> Please try again later".
> I have tried running tcptrace on it - this shows a rendering error:
> "Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> was thrown. (rrRenderingError) ...... Object reference not set to an
> instance of an object."
> I've also tried adding the device info to the config file as
> illustrated in MSDN online docs, but this appears to be completely
> ignored.
> Any assistance appreciated.

Error while setting "Initialization" Configuration

Hi,

I have my pc setup with windows xp sp2.

I installed the sql reporting successfully .I setup the configuration also successfully.

But when i click on the tab "Initialization" it gives me this error.

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

I tried to install it on another pc also. But no success. When i run the http://localhost/ReportServer/ it gives me same error.

I have tried to install this on 4 pc. and same error on all the pc.

I tried to look on the forum for this error. Tried to implement almost all the solutions but no success.

This really frustrate me. I spend my 2 days for this. But still no success.

Please help. I need to solve this issue as soon as possible.

Here is the Error log i am getting.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>India Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServer__07_03_2006_17_17_31.log</Path>
<SystemName>VAIBHAV_PATEL</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2, v.2135</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!7/3/2006-17:17:31:: i INFO: Reporting Web Server started
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!7/3/2006-17:17:31:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!resourceutilities!1!7/3/2006-17:17:31:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!1!7/3/2006-17:17:31:: i INFO: Evaluation copy: 0 days left
aspnet_wp!runningjobs!1!7/3/2006-17:17:31:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!1!7/3/2006-17:17:31:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!7/3/2006-17:17:31:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!1!7/3/2006-17:17:31:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!1!07/03/2006-17:17:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!07/03/2006-17:17:33:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:18:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:19:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:19:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:19:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:19:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:20:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:20:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:20:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:20:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:21:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:21:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:21:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:21:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:22:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:22:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:22:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:22:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:23:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:23:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:23:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:23:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:24:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:24:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:24:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:24:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:25:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:25:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:25:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:25:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:26:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:26:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:26:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:26:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:27:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:27:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:27:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:27:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:27:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:27:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:27:31:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:28:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!runningjobs!7!7/3/2006-17:28:02:: e ERROR: Error in timer Database Cleanup (Web Service) : Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.CleanBatchRecords()
at Microsoft.ReportingServices.Library.DatabaseCleanupTimer.CleanBatch()
at Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:28:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:29:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:29:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:29:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:29:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:30:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:30:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:30:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:30:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:31:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:31:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:31:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:31:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:32:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:32:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:32:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:32:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:33:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:33:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:33:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:33:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:34:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:34:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:34:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:34:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!7!7/3/2006-17:35:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!7!7/3/2006-17:35:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!7!7/3/2006-17:35:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:35:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:36:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:36:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:36:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!6!7/3/2006-17:36:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:37:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!7/3/2006-17:37:02:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:37:02:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:37:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:37:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!7/3/2006-17:37:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
aspnet_wp!runningjobs!6!7/3/2006-17:37:31:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs()
at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:38:02:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!runningjobs!7!7/3/2006-17:38:02:: e ERROR: Error in timer Database Cleanup (Web Service) : Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.CleanBatchRecords()
at Microsoft.ReportingServices.Library.DatabaseCleanupTimer.CleanBatch()
at Microsoft.ReportingServices.Library.DatabaseCleanupTimer.DoTimerAction()
at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused)
aspnet_wp!library!7!7/3/2006-17:38:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Cannont get edition information from catalog server;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

Is the report server showing as initialized?|||

No It is not showing as initialized.

I can design the report fine in the studio but not able to deply it.

|||

Dear,

What version of IIS u had installed.In place of local host provide the reporting server name.

HTH

sufian

|||

Reporting Services can′t open a connection to the reporting services database, this can have many reasons:

You specified the wrong connectiong string / the wrong server / database combination and / or username / password in the configuration application.|||

hi,

Thanks for the reply.

I have IIS 5.1 installed on my pc.

One more thing to note is my pc name contains '_'.

I had reporting service installed successfully with studio 2003. and it works also fine. But now i have requirement to work on framework 2.0 So i installed the sql 2005 and sql reporting service for studio 2005.

That is installed successfully. But i am trying to setup this configuration for the sql 2000 on my local pc.

I am creating the default database default virtual directory and default windows service identity, web service identity. Everything setup fine. But only problem is with the Encryption keys and the initialization. When i click on initialization i get the above error. If i click on the Encryption key i have only option restore available.

you wrote "If you don′t have a valid backup of the key you will have to clear all the content from the reporting services database to start the database from scratch. If you have a backup of the key via the console."

I think this may cause the problem. Can you please let me know how to clear all the content from the reporting services database?

I also apply all the other solutions from the question asked by other users. But still no success.

Please reply me.

Thanks.

|||

Are you working on SQL2k now orSQL2k5 ? For SQL2k5 there is an option under ENrytion keys which reads "Delete" and will delete all active content in the reporting database. You can also use the rskeymgmt -Delete command from the DOS prompt for deleting data.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I am working on sql 2000. What i did is i reinstall the sql reporting service but still same error.

When i try to Delete the encryption or create the new encryption key it gives me same error.

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help|||

Vaibhav,

The problem is that the report server cannot connect to the SQL Server that is running on your machine. You should go to the database settings tab in the Report Server Configuration tool, connect to the desired SQL Server instance, then either choose an existing report server database or create a new one.

If you cannot connect to the SQL Server instance from this tool, the report server will not be able to connect either. You'll need to determine why - most commonly on my dev machine the SQL Server is simply not set to start by default and I need to start it. The error in the configuration tool about initialization is just symptomatic of the fact that you cannot connect to the SQL Server instance.

Hope that helps,

-Lukasz