Error when using rskeymgmt to backup encryption key

When I run the rskeymgmt program to backup the encryption key, I get the
following error:
The Report Server Windows service is not responding to RPC requests. The
service may not be running.
I have checked, and the service is running. We are using SQL Server 2005
sp2. The command I am using is:
rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
Any ideas why this is failing. I was able to run the program some time ago.
Thanks.On May 2, 11:50 am, "Tim Kelley" <tkel...@.company.com> wrote:
> When I run the rskeymgmt program to backup the encryption key, I get the
> following error:
> The Report Server Windows service is not responding to RPC requests. The
> service may not be running.
> I have checked, and the service is running. We are using SQL Server 2005
> sp2. The command I am using is:
> rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
> Any ideas why this is failing. I was able to run the program some time ago.
> Thanks.
This link might be helpful:
http://www.technologyone.org/new-6210113-3731.html
Regards,
Enrique Martinez
Sr. Software Consultant

Error when trying to run database engine tuning advisor

Hi,

I am getting "R6031- Attempt

to initialize the CRT more than once. This indicates a bug in your

application." when I am trying to database engine tuning advisor. I already followed the workaround from http://support.microsoft.com/default.aspx/kb/913395 but it did not help as I did not have any explorer.exe or any file in that registry folder.

I am using windows XP Sp2, using SQL server developer edition. I am wondering if anyone else has experienced this issue and can help me.

Thanks.

Have you tried attempted to invoke using the DTA on another machine?

I believe this could be the issue with Client tools, try to reinstall the Developer edition on this machine.

|||I will give it a try. I did try to reinstall on this machine but it did not help.

Error when trying to deploy a report using Oracle data source

We use SQL Server Reporting Services, My SQL box is on Win2k3. The developer
is able to run the report on his Windows XP box but when he deploys the
reports to the SQL Server where Reporting Services is running, he gets the
following error:
"An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'WMS'. (rsErrorOpeningConnection)
Get Online Help
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater
He develped this report on his XP box using Visual Studio .NET and is trying
to deploy it to our SQL server production box where Reporting Services is
installed. I have installed Oracle 9.2 client on the SQL Server box and can
make successful connections to our Oracle Database (where the report is
pulling data from). What else am I missing?
Thanks!
Bea Isabelle, Database AdministratorI used the google groups search.
Look at this link:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
Basically reboot after installing. Link has other things to try.
Here is the search I used:
http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isabelle" <isabelle@.discussions.microsoft.com> wrote in message
news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> developer
> is able to run the report on his Windows XP box but when he deploys the
> reports to the SQL Server where Reporting Services is running, he gets the
> following error:
> "An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'WMS'.
> (rsErrorOpeningConnection)
> Get Online Help
> System.Data.OracleClient requires Oracle client software version 8.1.7 or
> greater
> He develped this report on his XP box using Visual Studio .NET and is
> trying
> to deploy it to our SQL server production box where Reporting Services is
> installed. I have installed Oracle 9.2 client on the SQL Server box and
> can
> make successful connections to our Oracle Database (where the report is
> pulling data from). What else am I missing?
> Thanks!
> Bea Isabelle, Database Administrator
>|||Unfortunately, my server access won't allow me to go to those links here from
work. The only
that we haven't tried is rebooting the IIS services as the documentation
noted. I've also installed the ODP .Net
driver on the FFSQL box and he still gets the error. We will try a reboot
later today and see if that clears up the error.
Thanks!
"Bruce L-C [MVP]" wrote:
> I used the google groups search.
> Look at this link:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8eb65eca58e11586/05b5299775c955b9?q=oracle+8.1.7+group:microsoft.public.sqlserver.reportingsvcs&rnum=1&hl=en#05b5299775c955b9
> Basically reboot after installing. Link has other things to try.
> Here is the search I used:
> http://groups-beta.google.com/groups?hl=en&lr=&safe=off&num=10&q=oracle+8.1.7+group%3Amicrosoft.public.sqlserver.reportingsvcs&safe=off&qt_s=Search
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isabelle" <isabelle@.discussions.microsoft.com> wrote in message
> news:66AE92CA-13A2-4FB2-96B4-9CE0464D141E@.microsoft.com...
> > We use SQL Server Reporting Services, My SQL box is on Win2k3. The
> > developer
> > is able to run the report on his Windows XP box but when he deploys the
> > reports to the SQL Server where Reporting Services is running, he gets the
> > following error:
> >
> > "An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'WMS'.
> > (rsErrorOpeningConnection)
> > Get Online Help
> > System.Data.OracleClient requires Oracle client software version 8.1.7 or
> > greater
> >
> > He develped this report on his XP box using Visual Studio .NET and is
> > trying
> > to deploy it to our SQL server production box where Reporting Services is
> > installed. I have installed Oracle 9.2 client on the SQL Server box and
> > can
> > make successful connections to our Oracle Database (where the report is
> > pulling data from). What else am I missing?
> >
> > Thanks!
> >
> > Bea Isabelle, Database Administrator
> >
>
>

error when running the DTSRUN command

Hi
We're using SqlServer 2000.

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:

[ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.

Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.

Has anyone got any idea what the problem is and ghow to solve it.

Thanks !

David GreenbergDavid Greenberg (davidgr@.iba.org.il) writes:

Quote:

Originally Posted by

I want to run a DTS using the DTSRUN command.
The commmand is inside a ".bat" file which my application is running
from an SQL client.
No matter how I run it from the client it fails giving me the message:
>
[ConnectionOpen (Connect()).]SQL Server does not exist or access denied
>
I've tried to run it from the client from the application, from the
command prompt and it fails.
I went into enterprise on the client and tried to run the DTS from
there. The run failed already on the 1st step which is a call to a
stored procedure, also giving me the same message. This really stuck me
as wierd because in enterprise I'm accessing the server successfully so
why the above messgae. It identifies the server and I am accessing it.
>
Because it failed on the 1st step which is a call to a stored procedure
I tried running the sp from within query analyzer and it succeeded.
>
Has anyone got any idea what the problem is and ghow to solve it.

You can't accuse me to know too much about DTS, but I see that a
DTS package has connection properties. I would assume that you can
have a package on server A, and run it against server B.

So I would check the connection properties of the package (or the step,
as different task surely must be able to connect to different servers).

The error message simply means that you are trying to connect to a
server that is not available. (Not running, misspelled, a firewall
in the way etc.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

error when running reports

Hi all
Has anyone seen the following error - cannot run any reports - start then
crashes
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
----
Microsoft Reporting Services
PeterThere seems to be a corruption with your temp DB. First check to see if
there is a ReportServerTempDB database. If so then check for the
ExecutionCache table, if it exist make sure the owner is dbo. If the DB
does not exist you can run the CatalogTempDB.sql script to create it. Make
sure to first create the DB as ReportServerTempDB and then create a Role
called RSExecRole, then you can run the script. You will also need to make
sure all the users that are in the RSExecRole in the ReportServer Database
are in the ReportServerTempDB's RSExecRole.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi all
> Has anyone seen the following error - cannot run any reports - start
> then crashes
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
> ----
> Microsoft Reporting Services
>
> Peter
>|||Daniel
Thank you for your suggestions - I will try them out and post back
Pete
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
> There seems to be a corruption with your temp DB. First check to see if
> there is a ReportServerTempDB database. If so then check for the
> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
> does not exist you can run the CatalogTempDB.sql script to create it.
> Make sure to first create the DB as ReportServerTempDB and then create a
> Role called RSExecRole, then you can run the script. You will also need
> to make sure all the users that are in the RSExecRole in the ReportServer
> Database are in the ReportServerTempDB's RSExecRole.
>
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>|||Daniel
Tried your suggestions - DB was missing - created , added user , added
role , ran script - all seemed to run ok - thought I was home
However I now get this and can't seem to find where to fix it
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Cannot resolve collation conflict for equal to operation.
----
Microsoft Reporting Services
Also , there appears o be multiple scripts for Service packs etc where the
create script is - any idea what order to run them if necessary - I had
installed SSRS SP2 initially
Thank you
Pete
"Pete" <p0911@.hotmail.com> wrote in message
news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
> Daniel
> Thank you for your suggestions - I will try them out and post back
> Pete
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the ReportServer
>> Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>|||Where do you see this error? When running a report or in the log files?
You only need to run the catalogtemp.sql script, non of the upgrade scripts.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
> Daniel
> Tried your suggestions - DB was missing - created , added user , added
> role , ran script - all seemed to run ok - thought I was home
> However I now get this and can't seem to find where to fix it
> Reporting Services Error
> ----
> a.. An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> a.. Cannot resolve collation conflict for equal to operation.
> ----
> Microsoft Reporting Services
>
> Also , there appears o be multiple scripts for Service packs etc where the
> create script is - any idea what order to run them if necessary - I had
> installed SSRS SP2 initially
> Thank you
> Pete
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see if
>> there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the DB
>> does not exist you can run the CatalogTempDB.sql script to create it.
>> Make sure to first create the DB as ReportServerTempDB and then create a
>> Role called RSExecRole, then you can run the script. You will also need
>> to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports - start
>> then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>|||Daniel
It happens when I run a report from Report Manager (or from within
RM3.0) - it starts off ok (view report) and then come up with this error -
If I create a new report in Visual Studio and run preview from there
everything is fine !!! - if I then import this into ReportManager and try to
run it comes up with this error - along with all the other reports currently
in ReportManager
Everything was working fine until the other day and as far as I know I've
done nothing to the server (don't even touch it) although we did have a
power outage when I wasn't here and the UPS expired - don't even know how
the TempDb went missing ( ps I'm the only one who uses the system - it is
my dev network etc )
I thought the collating seq may have been wrong so I checked with a VPC that
works and changed it to the same as the Report Server
Latin1_General_CI_Ai_KS_WS but made no difference
This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
plus Visual Studio 2003
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
> Where do you see this error? When running a report or in the log files?
> You only need to run the catalogtemp.sql script, non of the upgrade
> scripts.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary - I
>> had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You will
>> also need to make sure all the users that are in the RSExecRole in the
>> ReportServer Database are in the ReportServerTempDB's RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>|||Do the log files have more of a call stack? Perhaps that will lead us to
where the problem is occurring.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <p0911@.hotmail.com> wrote in message
news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
> Daniel
> It happens when I run a report from Report Manager (or from within
> M3.0) - it starts off ok (view report) and then come up with this
> error - If I create a new report in Visual Studio and run preview from
> there everything is fine !!! - if I then import this into ReportManager
> and try to run it comes up with this error - along with all the other
> reports currently in ReportManager
> Everything was working fine until the other day and as far as I know I've
> done nothing to the server (don't even touch it) although we did have a
> power outage when I wasn't here and the UPS expired - don't even know
> how the TempDb went missing ( ps I'm the only one who uses the system -
> it is my dev network etc )
> I thought the collating seq may have been wrong so I checked with a VPC
> that works and changed it to the same as the Report Server
> Latin1_General_CI_Ai_KS_WS but made no difference
> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus SP2
> plus Visual Studio 2003
> Peter
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user , added
>> role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hi all
>> Has anyone seen the following error - cannot run any reports -
>> start then crashes
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>> ----
>> Microsoft Reporting Services
>>
>> Peter
>>
>>
>>
>>
>|||Daniel
I'm going to delete the tempDB again and recreate it and make sure it has
exactly the same collating sequence and see what happens and let you know -
Peter Yang (MSFT)suggested checking that on the private newsgroup ( i
wasn't subscribed there before but I am now
ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
Latin1_General_CI_AI_KS_WS -
I obviously made a mistake when I recreatedthe TempDB
Thank yuo for you help and assistance
Peter
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
> Do the log files have more of a call stack? Perhaps that will lead us to
> where the problem is occurring.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Pete" <p0911@.hotmail.com> wrote in message
> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> 3.0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know I've
>> done nothing to the server (don't even touch it) although we did have a
>> power outage when I wasn't here and the UPS expired - don't even know
>> how the TempDb went missing ( ps I'm the only one who uses the system -
>> it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error log
>> for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>> There seems to be a corruption with your temp DB. First check to see
>> if there is a ReportServerTempDB database. If so then check for the
>> ExecutionCache table, if it exist make sure the owner is dbo. If the
>> DB does not exist you can run the CatalogTempDB.sql script to create
>> it. Make sure to first create the DB as ReportServerTempDB and then
>> create a Role called RSExecRole, then you can run the script. You
>> will also need to make sure all the users that are in the RSExecRole
>> in the ReportServer Database are in the ReportServerTempDB's
>> RSExecRole.
>>
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>
>>
>>
>>
>>
>|||Daniel
Have managed to fix problem by recreating ReportServerTempDB with the
correct collating sequence this time
Thank you for you assistance - maybe well talk again in the future
Peter Hale
"Pete" <p0911@.hotmail.com> wrote in message
news:%23IIJp1tBGHA.4012@.TK2MSFTNGP10.phx.gbl...
> Daniel
> I'm going to delete the tempDB again and recreate it and make sure it has
> exactly the same collating sequence and see what happens and let you
> now - Peter Yang (MSFT)suggested checking that on the private newsgroup
> ( i wasn't subscribed there before but I am now
> ReportServer is Latin1_General CI_AS_KS_WS and the TempDB
> Latin1_General_CI_AI_KS_WS -
> I obviously made a mistake when I recreatedthe TempDB
> Thank yuo for you help and assistance
> Peter
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:OniKgWaAGHA.3436@.TK2MSFTNGP10.phx.gbl...
>> Do the log files have more of a call stack? Perhaps that will lead us to
>> where the problem is occurring.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:O$HJsEF$FHA.3800@.TK2MSFTNGP10.phx.gbl...
>> Daniel
>> It happens when I run a report from Report Manager (or from within
>> .0) - it starts off ok (view report) and then come up with this
>> error - If I create a new report in Visual Studio and run preview from
>> there everything is fine !!! - if I then import this into ReportManager
>> and try to run it comes up with this error - along with all the other
>> reports currently in ReportManager
>> Everything was working fine until the other day and as far as I know
>> I've done nothing to the server (don't even touch it) although we did
>> have a power outage when I wasn't here and the UPS expired - don't
>> even know how the TempDb went missing ( ps I'm the only one who uses
>> the system - it is my dev network etc )
>> I thought the collating seq may have been wrong so I checked with a VPC
>> that works and changed it to the same as the Report Server
>> Latin1_General_CI_Ai_KS_WS but made no difference
>> This box is SBS 2003 with SQL 2000 plus MS CRM 3.0 plus SSRS 2000 plus
>> SP2 plus Visual Studio 2003
>> Peter
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:uS%23qQdE$FHA.984@.tk2msftngp13.phx.gbl...
>> Where do you see this error? When running a report or in the log
>> files?
>> You only need to run the catalogtemp.sql script, non of the upgrade
>> scripts.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:%23BJiSYE$FHA.2420@.TK2MSFTNGP12.phx.gbl...
>> Daniel
>> Tried your suggestions - DB was missing - created , added user ,
>> added role , ran script - all seemed to run ok - thought I was home
>> However I now get this and can't seem to find where to fix it
>> Reporting Services Error
>> ----
>> a.. An internal error occurred on the report server. See the error
>> log for more details. (rsInternalError) Get Online Help
>> a.. Cannot resolve collation conflict for equal to operation.
>> ----
>> Microsoft Reporting Services
>>
>> Also , there appears o be multiple scripts for Service packs etc where
>> the create script is - any idea what order to run them if necessary -
>> I had installed SSRS SP2 initially
>> Thank you
>> Pete
>>
>> "Pete" <p0911@.hotmail.com> wrote in message
>> news:utAoZyD$FHA.912@.TK2MSFTNGP11.phx.gbl...
>> Daniel
>> Thank you for your suggestions - I will try them out and post back
>> Pete
>>
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:e9lgNFC$FHA.3992@.TK2MSFTNGP15.phx.gbl...
>>> There seems to be a corruption with your temp DB. First check to
>>> see if there is a ReportServerTempDB database. If so then check for
>>> the ExecutionCache table, if it exist make sure the owner is dbo.
>>> If the DB does not exist you can run the CatalogTempDB.sql script to
>>> create it. Make sure to first create the DB as ReportServerTempDB
>>> and then create a Role called RSExecRole, then you can run the
>>> script. You will also need to make sure all the users that are in
>>> the RSExecRole in the ReportServer Database are in the
>>> ReportServerTempDB's RSExecRole.
>>>
>>>
>>> I hope that helps.
>>>
>>> --
>>> -Daniel
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>>
>>> "Pete" <p0911@.hotmail.com> wrote in message
>>> news:%23TjeE%236%23FHA.532@.TK2MSFTNGP15.phx.gbl...
>>> Hi all
>>>
>>> Has anyone seen the following error - cannot run any reports -
>>> start then crashes
>>>
>>> Reporting Services Error
>>> ----
>>>
>>> a.. An internal error occurred on the report server. See the error
>>> log for more details. (rsInternalError) Get Online Help
>>> a.. Invalid object name 'ReportServerTempDB.dbo.ExecutionCache'.
>>>
>>> ----
>>> Microsoft Reporting Services
>>>
>>>
>>> Peter
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Error when running RedGate SQL Backup Job in SQL Server 2005

I have 4 SQL Server 2005 production servers that I installed RedGate SQL Bac
k
up on. All but one run fine. The one that doesn't I get the below error.
Executed as user : AD-DomainName\UserName. SQL Backup job failed with
exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step f
ailed.
The back up is backing up to the AD server which is different than the
server the job runs on. It is a shared folder on the AD and the permissions
grant the owner of the job Full Access.
I do not know what else to do with this issue. It mirrors the other 3 that
work fine.
Any and all help is appreciated.
-ChrisChris,
SQL Server caches login information from active directory. The one
troublesome machine has apparently cached out of date AD information. In
David Grey's BLOG he discusses a similar problem (not with Red Gate) that
may help you resolve.
http://www.codefounders.com/communi...entication.aspx
RLF
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:2B7A5543-C258-4BA2-8CF4-BF2A7F4F1434@.microsoft.com...
>I have 4 SQL Server 2005 production servers that I installed RedGate SQL
>Back
> up on. All but one run fine. The one that doesn't I get the below error.
> Executed as user : AD-DomainName\UserName. SQL Backup job failed with
> exitcode 0 SQL Error code 18456[SQLState 42000] (Error 50000) The step
> failed.
> The back up is backing up to the AD server which is different than the
> server the job runs on. It is a shared folder on the AD and the
> permissions
> grant the owner of the job Full Access.
> I do not know what else to do with this issue. It mirrors the other 3 that
> work fine.
> Any and all help is appreciated.
> -Chris
>

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql

Error when running optimizer maintenance plan

Hi
I have 140GB data base with maintenance plan schedule
every sunday. when it run Optimizer plan
I get the error and the job failed if I rerun the job
some time it will completed but 1 out of 4 time it will
failed on
middle of reindex with the error [Microsoft SQL-DMO (ODBC
SQLState: 01000)] Error 0: This server has been
disconnected.
Have any one known what caused this problem?
Thank in advanceThe message indicates that SQL Server became unavailable to the client
connection. Check your SQL error log for any exceptions of access
violations. Also check to see if someone manually shutdown SQL Server.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Error when running Agent in Merge Replication!

Hi All:
I am trying to setup a Merge Replication over Internet. Snapshot runs
successfully, but when it tries to run sycronize the data for ther first
time, it gives the following error in the end:
The Subscription to Publication 'xxxx' is invalid
'xxxx' is the Database Name
The connectivity to the remote DB is working.
One of the reasons for this swich I found was the the remote server's name
was changed after SQL server was installed. Therefore the old name was
dropeed b y using these:
sp_dropserver <server name>
go
sp_addserver <new server name> , LOCAL
go
After doing this, we still get the same message "The Subscription to
Publication 'xxxx' is invalid"
Please suggest the remedy for this.
Thanks,
Anukul
anukul,
Just for grins, check that the publisher is aware of the new server name. If not you can either drop the subscription in both places and re-create or alter the subscription in both places to utilize the new machine name.
Give it a shot. Worst case it doesn't work...|||If you changed the server name after configuring the Subscriber, the
Publisher doesn't know about the new server name. You need to drop and
recreate the subscription at the Subscriber and re-register the Subscriber
with the Publisher, using the following stored procedures:
? sp_dropmergepullsubscription at the Subscriber (only if the Merge Agent
runs at the Subscriber, a pull subscription).
? sp_dropmergesubscription at the Publisher.
? sp_dropsubscriber at the Publisher.
You should also be able to do this from Enterprise Manager.
Then you must re-register the Subscriber using sp_addsubscriber or (from
Enterprise Manager) and recreate the subscription using either Enterprise
Manager or executing sp_addmergesubscription at the Publisher and
sp_addmergepullsubscription (only if the Merge Agent runs at the Subscriber,
a pull subscription).
Best wishes,
Glenn Gailey
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anukul" wrote:

> Hi All:
> I am trying to setup a Merge Replication over Internet. Snapshot runs
> successfully, but when it tries to run sycronize the data for ther first
> time, it gives the following error in the end:
> The Subscription to Publication 'xxxx' is invalid
> 'xxxx' is the Database Name
> The connectivity to the remote DB is working.
> One of the reasons for this swich I found was the the remote server's name
> was changed after SQL server was installed. Therefore the old name was
> dropeed b y using these:
> sp_dropserver <server name>
> go
> sp_addserver <new server name> , LOCAL
> go
> After doing this, we still get the same message "The Subscription to
> Publication 'xxxx' is invalid"
> Please suggest the remedy for this.
> Thanks,
> Anukul
>
>

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
4035). The step failed.
Can anyone help me out on a solution?
may be anything
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default...b;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQ
LSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for databa
se
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Erro
r
4035). The step failed.
Can anyone help me out on a solution?may be anything
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/defaul...kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database withou
t
> making it a schedule job I get a good backup, when I create it as a job an
d
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [
;SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for data
base
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Er
ror
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
4035). The step failed.
Can anyone help me out on a solution?may be anything :)
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:
> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when replication to PDA

Dear all,
I am a new comer in replication with Pocket PC.
When I run with sample NorthwindCe application and replication with my SQL server. The following error have been occur:
Error Code :80072F76
Message : Header information is either corrupted or missing.
[,,,Header name,,]
Minor Err.: 28035
Source Microsft SQL Server 2000 Windows CE Edition
Would any one plese tell me that what's wrong has been happen in my application or setting?
Thank a lot!
Headless
What happens when you browse to your Web Server SQLCe directory?
Ie http://PublisherName/SQLCE/SSCESA10.dll or http://PublisherName/SQLCE/SSCESA20.dll
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Headless" wrote:

> Dear all,
> I am a new comer in replication with Pocket PC.
> When I run with sample NorthwindCe application and replication with my SQL server. The following error have been occur:
> Error Code :80072F76
> Message : Header information is either corrupted or missing.
> [,,,Header name,,]
> Minor Err.: 28035
> Source Microsft SQL Server 2000 Windows CE Edition
> Would any one plese tell me that what's wrong has been happen in my application or setting?
> Thank a lot!
> Headless
|||msg has been appear :
SQL Server CE Server Agent
Headless
"Hilary Cotter" wrote:
[vbcol=seagreen]
> What happens when you browse to your Web Server SQLCe directory?
> Ie http://PublisherName/SQLCE/SSCESA10.dll or http://PublisherName/SQLCE/SSCESA20.dll
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Headless" wrote:

Error when open Report Manager

RS is installed on the same server with the WebServer. I run this from a
domain network PC:
http://WebServerName/Reports/Pages/Folder.aspx
and I receive this error:
The request failed with HTTP status 401: Unauthorized.
What I checked:
1.On the WebServer go in IIS , then Default Web Site, then Reports, then
Proprieties, then Security and ONLY Integrated Windows Authentication is
checked
2. The save as above for ReportService under Default Web Site
3. Open Windows Explorer on the Web Server and go to C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
ReportService.asmx file is located. In the same folder have a look in
web.config file and:
<authentication mode="Windows" />
<identity impersonate="false" />
4 IIS is version 6
5. Web Server is Windows 2003
6. Went in Logs for RS and this is what I found:
w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
status 401: Unauthorized.
w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
--Details--
7. Changed in IIS to use Anonymous access and then Report Manager opens
without error but there is no report there (only Home directory and that's
all).After working on this problem for a week, I found posting from Jonny W.
and it worked for me.
If anyone else is having the same problem this KB article applies:
http://support.microsoft.com/default.aspx/kb/896861/en-us
Eddy wrote:
> RS is installed on the same server with the WebServer. I run this from a
> domain network PC:
> http://WebServerName/Reports/Pages/Folder.aspx
> and I receive this error:
> The request failed with HTTP status 401: Unauthorized.
> What I checked:
> 1.On the WebServer go in IIS , then Default Web Site, then Reports, then
> Proprieties, then Security and ONLY Integrated Windows Authentication is
> checked
> 2. The save as above for ReportService under Default Web Site
> 3. Open Windows Explorer on the Web Server and go to C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer where
> ReportService.asmx file is located. In the same folder have a look in
> web.config file and:
> <authentication mode="Windows" />
> <identity impersonate="false" />
> 4 IIS is version 6
> 5. Web Server is Windows 2003
> 6. Went in Logs for RS and this is what I found:
> w3wp!ui!1860!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:44:: e ERROR: The request failed with HTTP
> status 401: Unauthorized.
> w3wp!ui!1acc!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 401:
> Unauthorized.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!1860!17/02/2006-13:20:45:: e ERROR: HTTP status code --> 500
> --Details--
> 7. Changed in IIS to use Anonymous access and then Report Manager opens
> without error but there is no report there (only Home directory and that's
> all).

error when I run script

Hi All,

I can't not run the query to update data but it raice an error as below:

"Server: Msg 1101, Level 17, State 10, Line 1
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth."

HDD free space: 5GB
RAM: 1GB
CPU: 2.8MHz

What should I do?
Please advice me on this.

Thanks in advance,
TNLooks like your TempDb is running out of space.

Are you the database administrator?

The Fonzi approach (not reccomended) would be to restart the SQL Server Service on the server because the tempdb is recreated each time SQL Server is restarted.

In the Enterprise Manager you can right click on the tempdb and check the file growth propeties and adjust them as necessary.

Finally, I wonder what your query might be doing to fill up the tempdb. Do you want to post your script or tell us what you are trying to do?

Error when doing fuzzy lookup

I am trying to run a SSIS package that contains a fuzzy lookup. I am using a flat file with about 7 million records as the input. The reference table has about 2000 records. The package fails after about 40,000 records with the following information:

Warning: 0x8007000E at Data Flow Task, Fuzzy Lookup [228]: Not enough storage is available to complete this operation.
Warning: 0x800470E9 at Data Flow Task, DTS.Pipeline: A call to the ProcessInput method for input 229 on component "Fuzzy Lookup" (228) unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 2 before the call, and 1 after the call returned.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "Fuzzy Lookup" (228) failed with error code 0x8007000E. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0x8007000E.
Error: 0xC02020C4 at Data Flow Task, Flat File Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" has exited with error code 0xC0047039.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

-

I have tried many things - changing the BufferTempStoragePath path to a drive that has plenty space, changed the MaxInsertCommitSize to 5,000...

What else can I do?

Thanks!

Did you get this on a RTM build?

If yes, is it possible you apply SP1 to see whether that helps?

Thanks

wenyang

|||

Yes, it is on a RTM build.

The server does not have SP1 on it yet. Is there something else that I could try before that is installed?

Thanks!

|||

I know there was a memory issue got fixed in SP1 for FuzzyLookup, in which case the error looks very similar to yours, so I wanted you to try SP1.

For temp work arounds, you may also try one of the following two on your RTM

1) Increase your page file to >10GB

2) Mitigate the problem by splitting the input into smaller batches (e.g. 100k at a time) and tearing down the package in between each batch.

HTH

wenyang

|||

I have installed SP1, and am getting the same errors.

Any other suggestions other than the temp work arounds you mentioned? As I mentioned earlier, the process is stopping after only 40,000 records or so. This seems like a very small number and I'd hate to have to split the input up into smaller pieces than that.

Thanks!

|||

Does increase page file size help? If not, then we probably need to repro in house to investigate further.

Is it possible you log a bug with repro? (bug report place is http://lab.msdn.microsoft.com/productfeedback/default.aspx) We'll get back to you asap.

Thanks

Wenyang

|||

Sorry - I was told that SP1 had been installed before I wrote my previous message. It actually hadn't been installed at that point. Once that was successfully installed on Integration Services, the fuzzy lookup issues seem to have been resolved.

Thanks!

|||

Hi Wenyang,

I have installed SQL Server 2005 Service Pack 2 and unfortunately this error does not seem to have gone away.

Increasing my pagefile does not seemed to have helped the situation either ?

It seems to occur whenever I choose to perform a match on more than 10 columns within a Fuzzy Lookup ?

Can you please advise what I should do next/when this will be fixed ?

Many Thanks,

Gary

Error when doing fuzzy lookup

I am trying to run a SSIS package that contains a fuzzy lookup. I am using a flat file with about 7 million records as the input. The reference table has about 2000 records. The package fails after about 40,000 records with the following information:

Warning: 0x8007000E at Data Flow Task, Fuzzy Lookup [228]: Not enough storage is available to complete this operation.
Warning: 0x800470E9 at Data Flow Task, DTS.Pipeline: A call to the ProcessInput method for input 229 on component "Fuzzy Lookup" (228) unexpectedly kept a reference to the buffer it was passed. The refcount on that buffer was 2 before the call, and 1 after the call returned.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "Fuzzy Lookup" (228) failed with error code 0x8007000E. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0x8007000E.
Error: 0xC02020C4 at Data Flow Task, Flat File Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" has exited with error code 0xC0047039.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

-

I have tried many things - changing the BufferTempStoragePath path to a drive that has plenty space, changed the MaxInsertCommitSize to 5,000...

What else can I do?

Thanks!

Did you get this on a RTM build?

If yes, is it possible you apply SP1 to see whether that helps?

Thanks

wenyang

|||

Yes, it is on a RTM build.

The server does not have SP1 on it yet. Is there something else that I could try before that is installed?

Thanks!

|||

I know there was a memory issue got fixed in SP1 for FuzzyLookup, in which case the error looks very similar to yours, so I wanted you to try SP1.

For temp work arounds, you may also try one of the following two on your RTM

1) Increase your page file to >10GB

2) Mitigate the problem by splitting the input into smaller batches (e.g. 100k at a time) and tearing down the package in between each batch.

HTH

wenyang

|||

I have installed SP1, and am getting the same errors.

Any other suggestions other than the temp work arounds you mentioned? As I mentioned earlier, the process is stopping after only 40,000 records or so. This seems like a very small number and I'd hate to have to split the input up into smaller pieces than that.

Thanks!

|||

Does increase page file size help? If not, then we probably need to repro in house to investigate further.

Is it possible you log a bug with repro? (bug report place is http://lab.msdn.microsoft.com/productfeedback/default.aspx) We'll get back to you asap.

Thanks

Wenyang

|||

Sorry - I was told that SP1 had been installed before I wrote my previous message. It actually hadn't been installed at that point. Once that was successfully installed on Integration Services, the fuzzy lookup issues seem to have been resolved.

Thanks!

|||

Hi Wenyang,

I have installed SQL Server 2005 Service Pack 2 and unfortunately this error does not seem to have gone away.

Increasing my pagefile does not seemed to have helped the situation either ?

It seems to occur whenever I choose to perform a match on more than 10 columns within a Fuzzy Lookup ?

Can you please advise what I should do next/when this will be fixed ?

Many Thanks,

Gary

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshzt
Hi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt