Problem with logon SQL Server (MSDE)

Hi
I am working on a replication database system, I will use SQL Server Enterprise at the main database and I'm planning to have remote databases with MSDE, I installed MSDE in a remote computer using a valid logon account for the domain in the domain controller (I had it connected for the set up). If I disconnect the computer from the network an restart the machine the Sql Server won't start with the cache information.

How can I solve this problem?MSDE Doesn't support a login from the network; only from the local computer.

Am I right?

Problem with LoadReport web method

Hi,

I'm working on a reporting client for Reporting Services 2005 using SOAP. The problem I'm having is that for reports with multiple pages or a document map, the LoadReport web method, always says they have 0 pages or no document map.

To simplify the problem, i created a simple console app that just calls LoadReport on the /AdventureWorks Sample Reports/Product Catalog report to see if HasDocumentMap is true (it should be but isn't).

Any suggestions?

Kwan

I figured it out and it makes sense. The information is available only after you call Render.

So call, Render, then GetExecutionInfo to get the correct values for HasDocumentMap and NumPages.

Problem with left join

Hi,
I have a query that is supposed to return records and make a left join where
one field is not null, but for some reason is not working properly and
returns the records even though they are null.
SELECT *
FROM cases a
left join activities as w on a.id = w.caseid AND w.Dateinitiated = (Select
MAX(y.Dateinitiated)
From Activities y Where y.caseid = a.id AND y.ActType ='HISTORY' and
y.dateinitiated IS NOT NULL and y.processtep IS NOT NULL)
Any help is greately appreciated.
AleksBetter if you post some ddl, sample data and expected result.
Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
AMB
"Aleks" wrote:

> Hi,
> I have a query that is supposed to return records and make a left join whe
re
> one field is not null, but for some reason is not working properly and
> returns the records even though they are null.
> --
> SELECT *
> FROM cases a
> left join activities as w on a.id = w.caseid AND w.Dateinitiated = (Select
> MAX(y.Dateinitiated)
> From Activities y Where y.caseid = a.id AND y.ActType ='HISTORY' and
> y.dateinitiated IS NOT NULL and y.processtep IS NOT NULL)
> --
> Any help is greately appreciated.
> Aleks
>
>|||Aleks,
The reason the query seems to be returnning records from Activities,
where the Dateinitiated column is null, is because you have specified an
Outer Join.
When you specify An Outer Join, Al records from the Outer table are
returned, even when there is no match on the other side. You actually are
NOT returning any data from Activities Table where Dateinitiated column is
null. If you look at those rows, you'll probably notice that all the field
s
from Activities table are null there...
"Aleks" wrote:

> Hi,
> I have a query that is supposed to return records and make a left join whe
re
> one field is not null, but for some reason is not working properly and
> returns the records even though they are null.
> --
> SELECT *
> FROM cases a
> left join activities as w on a.id = w.caseid AND w.Dateinitiated = (Select
> MAX(y.Dateinitiated)
> From Activities y Where y.caseid = a.id AND y.ActType ='HISTORY' and
> y.dateinitiated IS NOT NULL and y.processtep IS NOT NULL)
> --
> Any help is greately appreciated.
> Aleks
>
>

problem with key encryption

Hello,

I am using report server sql express.

The report was working until yesturday.Sudenly the report did'nt work and give an error :

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

I delete the key and change the data source.Now it works fine!

My problem is that this is not the first time that it happens!!!

I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!!

i would like this not to happen anymore!!

What do i have to do to avoid this?

Please help me it's urgent

Thanks alot

Did you reset (not change, but reset) the password for the user that the Report Server windows service is running as? This would cause this message. Did you change the user that the report service is running as?|||

Hi

Thank you for your answer,when i installed reporting service, i installed the default installation so that now i have in the report server window service account this configurations:

service name: ReportServer$SQLEXPRESS

service account: NT AUTHORITY\NetworkService

built in account: network service.

Does it cause a problem that it's a built in account network service? i have a network.what configuration do i have to change so that i will never get the error that i got?

For answering your question i didn't change or reset the password i don't even know how to do that!

Help me please!

Thanks in advance

|||You should only get this error when you change the service account via the service control panel and not through the report server config tool. What you can try now is running the Report Server Configuration Manager and select the Encryption Keys tab. Then select Delete. This will mean that you will need to re-enter any data source credential information, but should at least bring your server back up.

problem with key encryption

Hello,

I am using report server sql express.

The report was working until yesturday.Sudenly the report did'nt work and give an error :

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

I delete the key and change the data source.Now it works fine!

My problem is that this is not the first time that it happens!!!

I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!!

i would like this not to happen anymore!!

What do i have to do to avoid this?

Please help me it's urgent

Thanks alot

Did you reset (not change, but reset) the password for the user that the Report Server windows service is running as? This would cause this message. Did you change the user that the report service is running as?|||

Hi

Thank you for your answer,when i installed reporting service, i installed the default installation so that now i have in the report server window service account this configurations:

service name: ReportServer$SQLEXPRESS

service account: NT AUTHORITY\NetworkService

built in account: network service.

Does it cause a problem that it's a built in account network service? i have a network.what configuration do i have to change so that i will never get the error that i got?

For answering your question i didn't change or reset the password i don't even know how to do that!

Help me please!

Thanks in advance

|||You should only get this error when you change the service account via the service control panel and not through the report server config tool. What you can try now is running the Report Server Configuration Manager and select the Encryption Keys tab. Then select Delete. This will mean that you will need to re-enter any data source credential information, but should at least bring your server back up.|||Did you resolve your issue with this problem. We are having the same problem every time we reboot our servers. we have to reapply the key each time. Very troubling!

problem with formauthentication

Hi,
i am working with RS form authentication.I fallowed all the steps as in MSDN
guide.
But when i am trying to open ReportManager ,I am getting the error like.
Unable to communicate with report server. Please verify that the report
server is operational.
While i tried to open ReportServer it is saying like
Security Exception
Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
I am keep on tring for 4hrs but i am not getting.
plz anybody can helpme
Thanks!Re-check the following:
Make sure you have Enterprise or Development edition of Reporting Services
(Standard edition doesn't support custom security extensions)
Make sure you are logging in with the same user name specified in the
<UserName> element in the RSReportServer.config
Make sure you correctly modified the rssrvpolicy.config as per the
instructions
Make sure you take a break before trying the above.
--
Adrian M.
MCP
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> Hi,
> i am working with RS form authentication.I fallowed all the steps as in
> MSDN
> guide.
> But when i am trying to open ReportManager ,I am getting the error like.
> Unable to communicate with report server. Please verify that the report
> server is operational.
> While i tried to open ReportServer it is saying like
> Security Exception
> Description: The application attempted to perform an operation not allowed
> by the security policy. To grant this application the required permission
> please contact your system administrator or change the application's trust
> level in the configuration file.
> I am keep on tring for 4hrs but i am not getting.
> plz anybody can helpme
> Thanks!
>
>
>|||Hi Adrian thanks for ur help
i did some mistakes in rssrvpolicy.config .i rectified that one but again i
am getting errors so i will try again the whole process.
Thanks!
"Adrian M." wrote:
> Re-check the following:
> Make sure you have Enterprise or Development edition of Reporting Services
> (Standard edition doesn't support custom security extensions)
> Make sure you are logging in with the same user name specified in the
> <UserName> element in the RSReportServer.config
> Make sure you correctly modified the rssrvpolicy.config as per the
> instructions
> Make sure you take a break before trying the above.
> --
> Adrian M.
> MCP
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> >
> > Hi,
> > i am working with RS form authentication.I fallowed all the steps as in
> > MSDN
> > guide.
> >
> > But when i am trying to open ReportManager ,I am getting the error like.
> >
> > Unable to communicate with report server. Please verify that the report
> > server is operational.
> >
> > While i tried to open ReportServer it is saying like
> >
> > Security Exception
> > Description: The application attempted to perform an operation not allowed
> > by the security policy. To grant this application the required permission
> > please contact your system administrator or change the application's trust
> > level in the configuration file.
> >
> > I am keep on tring for 4hrs but i am not getting.
> >
> > plz anybody can helpme
> >
> > Thanks!
> >
> >
> >
> >
> >
> >
>
>|||When I first set up Forms Auth, I had to go over that white paper 3 times
before I got everything just right!...
--
Adrian M.
MCP
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
> Hi Adrian thanks for ur help
> i did some mistakes in rssrvpolicy.config .i rectified that one but again
> i
> am getting errors so i will try again the whole process.
> Thanks!
> "Adrian M." wrote:
>> Re-check the following:
>> Make sure you have Enterprise or Development edition of Reporting
>> Services
>> (Standard edition doesn't support custom security extensions)
>> Make sure you are logging in with the same user name specified in the
>> <UserName> element in the RSReportServer.config
>> Make sure you correctly modified the rssrvpolicy.config as per the
>> instructions
>> Make sure you take a break before trying the above.
>> --
>> Adrian M.
>> MCP
>> "simmi" <simmi@.discussions.microsoft.com> wrote in message
>> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
>> >
>> > Hi,
>> > i am working with RS form authentication.I fallowed all the steps as in
>> > MSDN
>> > guide.
>> >
>> > But when i am trying to open ReportManager ,I am getting the error
>> > like.
>> >
>> > Unable to communicate with report server. Please verify that the
>> > report
>> > server is operational.
>> >
>> > While i tried to open ReportServer it is saying like
>> >
>> > Security Exception
>> > Description: The application attempted to perform an operation not
>> > allowed
>> > by the security policy. To grant this application the required
>> > permission
>> > please contact your system administrator or change the application's
>> > trust
>> > level in the configuration file.
>> >
>> > I am keep on tring for 4hrs but i am not getting.
>> >
>> > plz anybody can helpme
>> >
>> > Thanks!
>> >
>> >
>> >
>> >
>> >
>> >
>>|||Hi now i succeeded in just getting of ReportManager,ReportServer browsers.
Now problem r
1)After i registerd name and password i can't able to logon into
reportmanager.
I am getting error like
" The request failed with HTTP status 401: Access Denied. "
2)I am loging on to reportserver but i can't view the reports .
Here error is like
The encrypted value for configuration setting
UnattendedExecutionAccount\UserName cannot be decrypted.
(rsFailedToDecryptConfigInformation) Get Online Help
Invalid length for a Base-64 char array.
Now where i made mistake.
if u know plz help me
Thanks!
simmi
"Adrian M." wrote:
> When I first set up Forms Auth, I had to go over that white paper 3 times
> before I got everything just right!...
> --
> Adrian M.
> MCP
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
> > Hi Adrian thanks for ur help
> > i did some mistakes in rssrvpolicy.config .i rectified that one but again
> > i
> > am getting errors so i will try again the whole process.
> > Thanks!
> >
> > "Adrian M." wrote:
> >
> >> Re-check the following:
> >>
> >> Make sure you have Enterprise or Development edition of Reporting
> >> Services
> >> (Standard edition doesn't support custom security extensions)
> >> Make sure you are logging in with the same user name specified in the
> >> <UserName> element in the RSReportServer.config
> >> Make sure you correctly modified the rssrvpolicy.config as per the
> >> instructions
> >>
> >> Make sure you take a break before trying the above.
> >> --
> >> Adrian M.
> >> MCP
> >>
> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> >> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> >> >
> >> > Hi,
> >> > i am working with RS form authentication.I fallowed all the steps as in
> >> > MSDN
> >> > guide.
> >> >
> >> > But when i am trying to open ReportManager ,I am getting the error
> >> > like.
> >> >
> >> > Unable to communicate with report server. Please verify that the
> >> > report
> >> > server is operational.
> >> >
> >> > While i tried to open ReportServer it is saying like
> >> >
> >> > Security Exception
> >> > Description: The application attempted to perform an operation not
> >> > allowed
> >> > by the security policy. To grant this application the required
> >> > permission
> >> > please contact your system administrator or change the application's
> >> > trust
> >> > level in the configuration file.
> >> >
> >> > I am keep on tring for 4hrs but i am not getting.
> >> >
> >> > plz anybody can helpme
> >> >
> >> > Thanks!
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>|||See if the following helps you:
http://prologika.com/blog/archive/2004/12/31/197.aspx
--
Adrian M.
MCP
"simmi" <simmi@.discussions.microsoft.com> wrote in message
news:924F7BD2-9E0D-4987-BE2B-36ACF290918B@.microsoft.com...
> Hi now i succeeded in just getting of ReportManager,ReportServer browsers.
> Now problem r
> 1)After i registerd name and password i can't able to logon into
> reportmanager.
> I am getting error like
> " The request failed with HTTP status 401: Access Denied. "
> 2)I am loging on to reportserver but i can't view the reports .
> Here error is like
> The encrypted value for configuration setting
> UnattendedExecutionAccount\UserName cannot be decrypted.
> (rsFailedToDecryptConfigInformation) Get Online Help
> Invalid length for a Base-64 char array.
> Now where i made mistake.
> if u know plz help me
>
> Thanks!
> simmi
>
>
> "Adrian M." wrote:
>> When I first set up Forms Auth, I had to go over that white paper 3 times
>> before I got everything just right!...
>> --
>> Adrian M.
>> MCP
>> "simmi" <simmi@.discussions.microsoft.com> wrote in message
>> news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
>> > Hi Adrian thanks for ur help
>> > i did some mistakes in rssrvpolicy.config .i rectified that one but
>> > again
>> > i
>> > am getting errors so i will try again the whole process.
>> > Thanks!
>> >
>> > "Adrian M." wrote:
>> >
>> >> Re-check the following:
>> >>
>> >> Make sure you have Enterprise or Development edition of Reporting
>> >> Services
>> >> (Standard edition doesn't support custom security extensions)
>> >> Make sure you are logging in with the same user name specified in the
>> >> <UserName> element in the RSReportServer.config
>> >> Make sure you correctly modified the rssrvpolicy.config as per the
>> >> instructions
>> >>
>> >> Make sure you take a break before trying the above.
>> >> --
>> >> Adrian M.
>> >> MCP
>> >>
>> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
>> >> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
>> >> >
>> >> > Hi,
>> >> > i am working with RS form authentication.I fallowed all the steps as
>> >> > in
>> >> > MSDN
>> >> > guide.
>> >> >
>> >> > But when i am trying to open ReportManager ,I am getting the error
>> >> > like.
>> >> >
>> >> > Unable to communicate with report server. Please verify that the
>> >> > report
>> >> > server is operational.
>> >> >
>> >> > While i tried to open ReportServer it is saying like
>> >> >
>> >> > Security Exception
>> >> > Description: The application attempted to perform an operation not
>> >> > allowed
>> >> > by the security policy. To grant this application the required
>> >> > permission
>> >> > please contact your system administrator or change the application's
>> >> > trust
>> >> > level in the configuration file.
>> >> >
>> >> > I am keep on tring for 4hrs but i am not getting.
>> >> >
>> >> > plz anybody can helpme
>> >> >
>> >> > Thanks!
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||Hi Adrian ,
thanks for ur help.
i will try this problem today.
Thanks!
"Adrian M." wrote:
> See if the following helps you:
> http://prologika.com/blog/archive/2004/12/31/197.aspx
> --
> Adrian M.
> MCP
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:924F7BD2-9E0D-4987-BE2B-36ACF290918B@.microsoft.com...
> > Hi now i succeeded in just getting of ReportManager,ReportServer browsers.
> > Now problem r
> >
> > 1)After i registerd name and password i can't able to logon into
> > reportmanager.
> >
> > I am getting error like
> >
> > " The request failed with HTTP status 401: Access Denied. "
> >
> > 2)I am loging on to reportserver but i can't view the reports .
> >
> > Here error is like
> >
> > The encrypted value for configuration setting
> > UnattendedExecutionAccount\UserName cannot be decrypted.
> > (rsFailedToDecryptConfigInformation) Get Online Help
> > Invalid length for a Base-64 char array.
> >
> > Now where i made mistake.
> >
> > if u know plz help me
> >
> >
> > Thanks!
> > simmi
> >
> >
> >
> >
> > "Adrian M." wrote:
> >
> >> When I first set up Forms Auth, I had to go over that white paper 3 times
> >> before I got everything just right!...
> >>
> >> --
> >> Adrian M.
> >> MCP
> >>
> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> >> news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
> >> > Hi Adrian thanks for ur help
> >> > i did some mistakes in rssrvpolicy.config .i rectified that one but
> >> > again
> >> > i
> >> > am getting errors so i will try again the whole process.
> >> > Thanks!
> >> >
> >> > "Adrian M." wrote:
> >> >
> >> >> Re-check the following:
> >> >>
> >> >> Make sure you have Enterprise or Development edition of Reporting
> >> >> Services
> >> >> (Standard edition doesn't support custom security extensions)
> >> >> Make sure you are logging in with the same user name specified in the
> >> >> <UserName> element in the RSReportServer.config
> >> >> Make sure you correctly modified the rssrvpolicy.config as per the
> >> >> instructions
> >> >>
> >> >> Make sure you take a break before trying the above.
> >> >> --
> >> >> Adrian M.
> >> >> MCP
> >> >>
> >> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> >> >> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> >> >> >
> >> >> > Hi,
> >> >> > i am working with RS form authentication.I fallowed all the steps as
> >> >> > in
> >> >> > MSDN
> >> >> > guide.
> >> >> >
> >> >> > But when i am trying to open ReportManager ,I am getting the error
> >> >> > like.
> >> >> >
> >> >> > Unable to communicate with report server. Please verify that the
> >> >> > report
> >> >> > server is operational.
> >> >> >
> >> >> > While i tried to open ReportServer it is saying like
> >> >> >
> >> >> > Security Exception
> >> >> > Description: The application attempted to perform an operation not
> >> >> > allowed
> >> >> > by the security policy. To grant this application the required
> >> >> > permission
> >> >> > please contact your system administrator or change the application's
> >> >> > trust
> >> >> > level in the configuration file.
> >> >> >
> >> >> > I am keep on tring for 4hrs but i am not getting.
> >> >> >
> >> >> > plz anybody can helpme
> >> >> >
> >> >> > Thanks!
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi,
i am again getting the problem while oppenning the reportmanager like
"The request failed with HTTP status 401: Access Denied. "
Reportserver browser is working correctly
so can u help me
Thanks
"Adrian M." wrote:
> See if the following helps you:
> http://prologika.com/blog/archive/2004/12/31/197.aspx
> --
> Adrian M.
> MCP
> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> news:924F7BD2-9E0D-4987-BE2B-36ACF290918B@.microsoft.com...
> > Hi now i succeeded in just getting of ReportManager,ReportServer browsers.
> > Now problem r
> >
> > 1)After i registerd name and password i can't able to logon into
> > reportmanager.
> >
> > I am getting error like
> >
> > " The request failed with HTTP status 401: Access Denied. "
> >
> > 2)I am loging on to reportserver but i can't view the reports .
> >
> > Here error is like
> >
> > The encrypted value for configuration setting
> > UnattendedExecutionAccount\UserName cannot be decrypted.
> > (rsFailedToDecryptConfigInformation) Get Online Help
> > Invalid length for a Base-64 char array.
> >
> > Now where i made mistake.
> >
> > if u know plz help me
> >
> >
> > Thanks!
> > simmi
> >
> >
> >
> >
> > "Adrian M." wrote:
> >
> >> When I first set up Forms Auth, I had to go over that white paper 3 times
> >> before I got everything just right!...
> >>
> >> --
> >> Adrian M.
> >> MCP
> >>
> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> >> news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
> >> > Hi Adrian thanks for ur help
> >> > i did some mistakes in rssrvpolicy.config .i rectified that one but
> >> > again
> >> > i
> >> > am getting errors so i will try again the whole process.
> >> > Thanks!
> >> >
> >> > "Adrian M." wrote:
> >> >
> >> >> Re-check the following:
> >> >>
> >> >> Make sure you have Enterprise or Development edition of Reporting
> >> >> Services
> >> >> (Standard edition doesn't support custom security extensions)
> >> >> Make sure you are logging in with the same user name specified in the
> >> >> <UserName> element in the RSReportServer.config
> >> >> Make sure you correctly modified the rssrvpolicy.config as per the
> >> >> instructions
> >> >>
> >> >> Make sure you take a break before trying the above.
> >> >> --
> >> >> Adrian M.
> >> >> MCP
> >> >>
> >> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> >> >> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> >> >> >
> >> >> > Hi,
> >> >> > i am working with RS form authentication.I fallowed all the steps as
> >> >> > in
> >> >> > MSDN
> >> >> > guide.
> >> >> >
> >> >> > But when i am trying to open ReportManager ,I am getting the error
> >> >> > like.
> >> >> >
> >> >> > Unable to communicate with report server. Please verify that the
> >> >> > report
> >> >> > server is operational.
> >> >> >
> >> >> > While i tried to open ReportServer it is saying like
> >> >> >
> >> >> > Security Exception
> >> >> > Description: The application attempted to perform an operation not
> >> >> > allowed
> >> >> > by the security policy. To grant this application the required
> >> >> > permission
> >> >> > please contact your system administrator or change the application's
> >> >> > trust
> >> >> > level in the configuration file.
> >> >> >
> >> >> > I am keep on tring for 4hrs but i am not getting.
> >> >> >
> >> >> > plz anybody can helpme
> >> >> >
> >> >> > Thanks!
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have the same problem, has anyone found a solution? Thanks
simmi wrote:
> Hi,
> i am again getting the problem while oppenning the reportmanager like
> "The request failed with HTTP status 401: Access Denied. "
> Reportserver browser is working correctly
> so can u help me
> Thanks
>
> "Adrian M." wrote:
> > See if the following helps you:
> > http://prologika.com/blog/archive/2004/12/31/197.aspx
> >
> > --
> > Adrian M.
> > MCP
> >
> > "simmi" <simmi@.discussions.microsoft.com> wrote in message
> > news:924F7BD2-9E0D-4987-BE2B-36ACF290918B@.microsoft.com...
> > > Hi now i succeeded in just getting of ReportManager,ReportServer
browsers.
> > > Now problem r
> > >
> > > 1)After i registerd name and password i can't able to logon into
> > > reportmanager.
> > >
> > > I am getting error like
> > >
> > > " The request failed with HTTP status 401: Access Denied. "
> > >
> > > 2)I am loging on to reportserver but i can't view the reports .
> > >
> > > Here error is like
> > >
> > > The encrypted value for configuration setting
> > > UnattendedExecutionAccount\UserName cannot be decrypted.
> > > (rsFailedToDecryptConfigInformation) Get Online Help
> > > Invalid length for a Base-64 char array.
> > >
> > > Now where i made mistake.
> > >
> > > if u know plz help me
> > >
> > >
> > > Thanks!
> > > simmi
> > >
> > >
> > >
> > >
> > > "Adrian M." wrote:
> > >
> > >> When I first set up Forms Auth, I had to go over that white
paper 3 times
> > >> before I got everything just right!...
> > >>
> > >> --
> > >> Adrian M.
> > >> MCP
> > >>
> > >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> > >> news:F8336A93-6389-4061-8FCC-03EA5F9B2836@.microsoft.com...
> > >> > Hi Adrian thanks for ur help
> > >> > i did some mistakes in rssrvpolicy.config .i rectified that
one but
> > >> > again
> > >> > i
> > >> > am getting errors so i will try again the whole process.
> > >> > Thanks!
> > >> >
> > >> > "Adrian M." wrote:
> > >> >
> > >> >> Re-check the following:
> > >> >>
> > >> >> Make sure you have Enterprise or Development edition of
Reporting
> > >> >> Services
> > >> >> (Standard edition doesn't support custom security extensions)
> > >> >> Make sure you are logging in with the same user name
specified in the
> > >> >> <UserName> element in the RSReportServer.config
> > >> >> Make sure you correctly modified the rssrvpolicy.config as
per the
> > >> >> instructions
> > >> >>
> > >> >> Make sure you take a break before trying the above.
> > >> >> --
> > >> >> Adrian M.
> > >> >> MCP
> > >> >>
> > >> >> "simmi" <simmi@.discussions.microsoft.com> wrote in message
> > >> >> news:BCCAAEF8-2C99-4856-9B77-A9455EEDFC49@.microsoft.com...
> > >> >> >
> > >> >> > Hi,
> > >> >> > i am working with RS form authentication.I fallowed all the
steps as
> > >> >> > in
> > >> >> > MSDN
> > >> >> > guide.
> > >> >> >
> > >> >> > But when i am trying to open ReportManager ,I am getting
the error
> > >> >> > like.
> > >> >> >
> > >> >> > Unable to communicate with report server. Please verify
that the
> > >> >> > report
> > >> >> > server is operational.
> > >> >> >
> > >> >> > While i tried to open ReportServer it is saying like
> > >> >> >
> > >> >> > Security Exception
> > >> >> > Description: The application attempted to perform an
operation not
> > >> >> > allowed
> > >> >> > by the security policy. To grant this application the
required
> > >> >> > permission
> > >> >> > please contact your system administrator or change the
application's
> > >> >> > trust
> > >> >> > level in the configuration file.
> > >> >> >
> > >> >> > I am keep on tring for 4hrs but i am not getting.
> > >> >> >
> > >> >> > plz anybody can helpme
> > >> >> >
> > >> >> > Thanks!
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

problem with distribution agent-

Can anyone help me on this'
I have a transactional replication going on from Server A to server B
(Sql Server 2005)
The replication was working well till yesterday..
But now, the replicated transactions are not getting applied at the
subscriber. When I see the Log reader agent, its working
fine...delivering the transactions to the distributor. When I see the
replication monitor status ..it says 'delivering replicated
transactions'...however the number of undistriuted transactions is very
high..its getting bigger and bigger..not decreasing...I dont see any
errors..So my guess is the distribution agent is not working eventhough
its says 'delivering replicated transactions'..Other thing is if i see
the replication monitor it says status excellent...and latency as 00
..but i dont see the latest data at the subscriber..the subscriber is
way behind the publisher..
can anyone help me on this' how do i resolve this problem? I
stopped the distribution agent and again started it..but it dint
help...what should i do'
thanksIf replication monitor says the health is excellent it means that it thinks
everything is working well.
Issue this command in your distribution database to see what commands are in
the queue
sp_browsereplcmds
You may find that you have done a mass update which affects several thousand
or million rows which have created this large queue.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Vishal" <rvishal1305@.gmail.com> wrote in message
news:1162009320.010431.7230@.b28g2000cwb.googlegroups.com...
> Can anyone help me on this'
> I have a transactional replication going on from Server A to server B
> (Sql Server 2005)
> The replication was working well till yesterday..
> But now, the replicated transactions are not getting applied at the
> subscriber. When I see the Log reader agent, its working
> fine...delivering the transactions to the distributor. When I see the
> replication monitor status ..it says 'delivering replicated
> transactions'...however the number of undistriuted transactions is very
> high..its getting bigger and bigger..not decreasing...I dont see any
> errors..So my guess is the distribution agent is not working eventhough
> its says 'delivering replicated transactions'..Other thing is if i see
> the replication monitor it says status excellent...and latency as 00
> ..but i dont see the latest data at the subscriber..the subscriber is
> way behind the publisher..
> can anyone help me on this' how do i resolve this problem? I
> stopped the distribution agent and again started it..but it dint
> help...what should i do'
> thanks
>

problem with distribution agent-

Can anyone help me on this'
I have a transactional replication going on from Server A to server B
(Sql Server 2005)
The replication was working well till yesterday..
But now, the replicated transactions are not getting applied at the
subscriber. When I see the Log reader agent, its working
fine...delivering the transactions to the distributor. When I see the
replication monitor status ..it says 'delivering replicated
transactions'...however the number of undistriuted transactions is very
high..its getting bigger and bigger..not decreasing...I dont see any
errors..So my guess is the distribution agent is not working eventhough
its says 'delivering replicated transactions'..Other thing is if i see
the replication monitor it says status excellent...and latency as 00
..but i dont see the latest data at the subscriber..the subscriber is
way behind the publisher..
can anyone help me on this' how do i resolve this problem? I
stopped the distribution agent and again started it..but it dint
help...what should i do'
thanksIf replication monitor says the health is excellent it means that it thinks
everything is working well.
Issue this command in your distribution database to see what commands are in
the queue
sp_browsereplcmds
You may find that you have done a mass update which affects several thousand
or million rows which have created this large queue.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Vishal" <rvishal1305@.gmail.com> wrote in message
news:1162009320.010431.7230@.b28g2000cwb.googlegroups.com...
> Can anyone help me on this'
> I have a transactional replication going on from Server A to server B
> (Sql Server 2005)
> The replication was working well till yesterday..
> But now, the replicated transactions are not getting applied at the
> subscriber. When I see the Log reader agent, its working
> fine...delivering the transactions to the distributor. When I see the
> replication monitor status ..it says 'delivering replicated
> transactions'...however the number of undistriuted transactions is very
> high..its getting bigger and bigger..not decreasing...I dont see any
> errors..So my guess is the distribution agent is not working eventhough
> its says 'delivering replicated transactions'..Other thing is if i see
> the replication monitor it says status excellent...and latency as 00
> ..but i dont see the latest data at the subscriber..the subscriber is
> way behind the publisher..
> can anyone help me on this' how do i resolve this problem? I
> stopped the distribution agent and again started it..but it dint
> help...what should i do'
> thanks
>

Problem with distribution agent

Can anyone help me on this?

I have a transactional replication going on from Server A to server B (Sql Server 2005)

The replication was working well till yesterday..

But now, the replicated transactions are not getting applied at the subscriber. When I see the Log reader agent, its working fine...delivering the transactions to the distributor. When I see the replication monitor status ..it says 'delivering replicated transactions'...however the number of undistriuted transactions is very high..its getting bigger and bigger..not decreasing...I dont see any errors..So my guess is the distribution agent is not working eventhough its says 'delivering replicated transactions'..Other thing is if i see the replication monitor it says status excellent...and latency as 00 ..but i dont see the latest data at the subscriber..the subscriber is way behind the publisher..

can anyone help me on this? how do i resolve this problem? I stopped the distribution agent and again started it..but it dint help...what should i do?

thanks

Are any changes being applied at all? Or did you just complete some very large batch process, like an update of 1 million records inside a single transaction?|||

Thanks for ur reply..

I dont think the changes are being applied...in last 20 -24 hrs..the data at the subscriber is same...i dont see new records at the subscriber in last 20-24 hrs..undistributed transactions count keep on increasing..(now its 22074840 ...time needed to apply these transactions keeps on increasing...now its (18 hrs )..

I am not sure whether we updated large records in a single transaction...but even if we had updated...subscriber should catch up with the publisher in 20-24 hrs ..Does it take so long to apply those changes at the subscriber?

what should i do to resolve this issue? how do i force those undistributed transactions to be applied at the subscriber?

log reader is working fine...replication status is excellent.latency is 00...only thing is the replicated transactions are not getting applied at the subscriber..the distribution database is at the subscriber (i.e. subscriber is also distibutor)...

Could you plzz help me to solve this problem

Thanks

|||

Hard to say what the problem is, have you done any investigation at hte subsriber, is anything blocking the distribution agent? You can also stop the distribution agent and run it from the command line with an increased OutputVerboseLevel, it might give you some more information.

Otherwise I'm not really sure what the issue is without more information. You can try profiling the subscriber to see if the distribution agent is even connected.

|||

Hi, vjai!

I have almost the same problem. Did you look at MSdistribution_history on distributor?

select * from MSdistribution_history
order by [time] desc

|||

I am having the same problem. The only thing that fixed it was re-starting the SQL Service and then re-starting the distribution agent. This is not a solution that we can do during business hours though. Does any body have any other suggestions on how to resolve this?

thanks,

Amir

|||I agree it's not a good workaround, however without identifying the problem it's hard for us to offer a proper solution.|||

From my experience, this kind of problem occurs whenever we do massive updates in a single batch and also if there are triggers on the subscriber. In my case, i had a update trigger at the subscriber and whenever i do large number of updates on that table (on publisher) in a single batch , I get this problem.

|||OK, so it's not a distribution agent problem then? Just like at the publisher, the transaction isn't committed until the end, so same goes at the subscriber. If the trigger is causing performance issues - it's probably firing once for every update - your transaction size is probably growing very large. You can work around this by committing smaller transactions at the publisher, or investigate the subscriber to see if there's something in the trigger that can be optimized, or maybe it's a hardware issue.

Problem with distribution agent

Can anyone help me on this?

I have a transactional replication going on from Server A to server B (Sql Server 2005)

The replication was working well till yesterday..

But now, the replicated transactions are not getting applied at the subscriber. When I see the Log reader agent, its working fine...delivering the transactions to the distributor. When I see the replication monitor status ..it says 'delivering replicated transactions'...however the number of undistriuted transactions is very high..its getting bigger and bigger..not decreasing...I dont see any errors..So my guess is the distribution agent is not working eventhough its says 'delivering replicated transactions'..Other thing is if i see the replication monitor it says status excellent...and latency as 00 ..but i dont see the latest data at the subscriber..the subscriber is way behind the publisher..

can anyone help me on this? how do i resolve this problem? I stopped the distribution agent and again started it..but it dint help...what should i do?

thanks

Are any changes being applied at all? Or did you just complete some very large batch process, like an update of 1 million records inside a single transaction?|||

Thanks for ur reply..

I dont think the changes are being applied...in last 20 -24 hrs..the data at the subscriber is same...i dont see new records at the subscriber in last 20-24 hrs..undistributed transactions count keep on increasing..(now its 22074840 ...time needed to apply these transactions keeps on increasing...now its (18 hrs )..

I am not sure whether we updated large records in a single transaction...but even if we had updated...subscriber should catch up with the publisher in 20-24 hrs ..Does it take so long to apply those changes at the subscriber?

what should i do to resolve this issue? how do i force those undistributed transactions to be applied at the subscriber?

log reader is working fine...replication status is excellent.latency is 00...only thing is the replicated transactions are not getting applied at the subscriber..the distribution database is at the subscriber (i.e. subscriber is also distibutor)...

Could you plzz help me to solve this problem

Thanks

|||

Hard to say what the problem is, have you done any investigation at hte subsriber, is anything blocking the distribution agent? You can also stop the distribution agent and run it from the command line with an increased OutputVerboseLevel, it might give you some more information.

Otherwise I'm not really sure what the issue is without more information. You can try profiling the subscriber to see if the distribution agent is even connected.

|||

Hi, vjai!

I have almost the same problem. Did you look at MSdistribution_history on distributor?

select * from MSdistribution_history
order by [time] desc

|||

I am having the same problem. The only thing that fixed it was re-starting the SQL Service and then re-starting the distribution agent. This is not a solution that we can do during business hours though. Does any body have any other suggestions on how to resolve this?

thanks,

Amir

|||I agree it's not a good workaround, however without identifying the problem it's hard for us to offer a proper solution.|||

From my experience, this kind of problem occurs whenever we do massive updates in a single batch and also if there are triggers on the subscriber. In my case, i had a update trigger at the subscriber and whenever i do large number of updates on that table (on publisher) in a single batch , I get this problem.

|||OK, so it's not a distribution agent problem then? Just like at the publisher, the transaction isn't committed until the end, so same goes at the subscriber. If the trigger is causing performance issues - it's probably firing once for every update - your transaction size is probably growing very large. You can work around this by committing smaller transactions at the publisher, or investigate the subscriber to see if there's something in the trigger that can be optimized, or maybe it's a hardware issue.

Problem with Dependencies and the error "Cannot find the remote service"

Hello all.

We are a small taskforce currently working on a system of which utilizes the SQL notification service. For this we are using dependencies provided by SqlDependency. The dependency is set up as follows:

//Where dbo.MTable is the table and guid is the unique key of the records. We //want to listen to individual records and not the entire table

SqlCommand listenCommand = new SqlCommand( "SELECT ID FROM dbo.MTable WHERE ID = " + "@.guid", connection );

listenCommand.Parameters.AddWithValue( "@.guid", guid );

depend = new SqlDependency( listenCommand, null, 0 );

depend.OnChange += onChangeEventHandler;

If you’re not so bold as to look in the database server log, and you do not care about log growth of cataclysmic proportions which will inevitably crash the server, it will work fine. The problem is, as hinted above, that the server log is filled with error messages.

Error Code: 8490

Description: “Cannot find the remote service : because it does not exist.”

Here is an example of before mentioned messages:

The query notification dialog on conversation handle '{F53C37DE-E66A-DA11-90A1-00105AC00126}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;SqlQueryNotificationService-cc3933a7-f97f-45b4-822f-f326f9f6e373&apos; because it does not exist.</Description></Error>'.

We have realized that listening on an entire table does not provoke this error. Furthermore, experiments have shown that the error only appears after we have shut down our system.

On shutdown, we call the following method:

SqlDependency.Stop( connection.ConnectionString );

This seems to stop the database from sending out notifications when we listen to an entire table, but not when we listen to individual records. Are we using the service in an incorrect manner or is there an error in the Stop method?

We have discovered a hotfix, but it is not exactly a beautiful solution:

SqlDependency.Start( connection.ConnectionString );

SqlCommand listenCommand = new SqlCommand( "SELECT * FROM MTable", connection );

depend = new SqlDependency( listenCommand );

SqlDependency.Stop( m_ConnectionString );

We have found that by ‘restarting’ the SqlDependency and giving it a new dependency where it listens to the entire table and THEN stopping it, the error does not appear. Our theory is that the new start and dependency overwrites the old ones.

I believe you have posted this issue to the wrong forum. SqlDependency is not a part of the Notification Services, despite the similar name. You might try a SQL 2005 forum instead.

Problem with Database: " No value given for one or more required parameters."

I am working on my first project, and using Visual Web Developer 2005, and I am having one heck of a time with one of my pages.

I am making a makeshift shoppingcart program for one of my classes, and I can't get the checkout page to work. All my other pages work just fine, and this is the only one that won't work.

I am hoping someone is able to help me

I am attaching what I think is causing the problem, hopefully someone might see something amiss:

These are my AccessDataSources
<asp:AccessDataSource ID="adsAddNewOrder" runat="server" DataFile="~/App_Data/GoalieStore.mdb" InsertCommand="INSERT INTO Orders(OrderID,CustomerID,SalesTaxRate,Shipping) VALUES (?,?,0.14,25)" SelectCommand="SELECT OrderID, CustomerID FROM Orders"></asp:AccessDataSource>
<asp:AccessDataSource ID="adsAddNewOrderDetails" runat="server" DataFile="~/App_Data/GoalieStore.mdb"
InsertCommand="INSERT INTO OrderDetails(ProductID,OrderID,Quantity) SELECT ProductID,OrderID,Quantity FROM Cart WHERE (CustomerID = ?)"
SelectCommand="SELECT ProductID, OrderID FROM OrderDetails"></asp:AccessDataSource>
<asp:AccessDataSource ID="adsClearCart" runat="server" DataFile="~/App_Data/GoalieStore.mdb"
DeleteCommand="DELETE * FROM Cart WHERE (CustomerID = ?)" SelectCommand="SELECT Cart.* FROM Cart">
</asp:AccessDataSource>

and I have VB.Net code as follows:
Protected Sub ClearCart()
'Create a Delete Query Parameter using a Session variable tag
Dim paramCID As New SessionParameter
paramCID.SessionField = "CustomerID"

adsClearCart.DeleteParameters.Clear() 'clear all existing Delete Query parameters
adsClearCart.DeleteParameters.Add(paramCID) 'add the Session variable Parameter
adsClearCart.Delete() 'run the query
End Sub

Protected Sub btnNewOrder_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim paramCID As New SessionParameter
paramCID.SessionField = "CustomerID"
Dim paramOID As New SessionParameter
paramOID.SessionField = "OrderID"
'add the parameters to the Order table Insert Query and run the Query
adsAddNewOrder.InsertParameters.Clear()
adsAddNewOrder.InsertParameters.Add(paramOID)
adsAddNewOrder.InsertParameters.Add(paramCID)
adsAddNewOrder.Insert()
'add the parameter to the OrderDetails table Insert Query and run the Query
adsAddNewOrderDetails.InsertParameters.Clear()
adsAddNewOrderDetails.InsertParameters.Add(paramCID)
adsAddNewOrderDetails.Insert()
'Clear Cart
ClearCart()
Server.Transfer("confirm.aspx")
End Sub

The user presses a button to confirm there order, and thats when I get the error "No Value given for one or more required parameters."

Hope someone can help!
Thanks,
Greg

As you said that is a problem from confirm.aspx

http://forums.asp.net/thread/1472678.aspx

Thanks