Hi there. Just installed Reportserver. SP2 on windows 2003. SQL 2000 SP4
The //localhost/reportserver give's me XXX/ReportServer - /
----
Microsoft SQL Server Reporting Services Version 8.00.1038.00
But when connecting to //localhost/reports i get the followwing error.
"
The underlying connection was closed: Could not establish secure channel for
SSL/TLS."
Never installed ssl, and have tried all the security and other ideas so far.
Can anyone help.
Thanks
JohnJohn wrote:
> Hi there. Just installed Reportserver. SP2 on windows 2003. SQL 2000 SP4
> The //localhost/reportserver give's me XXX/ReportServer - /
> ----
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> But when connecting to //localhost/reports i get the followwing error.
> "
> The underlying connection was closed: Could not establish secure channel for
> SSL/TLS."
> Never installed ssl, and have tried all the security and other ideas so far.
> Can anyone help.
> Thanks
> John
>
if you have certificate from root,then you have to start trusting it
with you server too :)
try to install it under trusted root certification authorities.|||did you find a solution for this issue?
Grego
From http://www.developmentnow.com/g/115_2005_10_0_0_626044/Could-not-establish-secure-channel-for-SSLTLS-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
Showing posts with label reportserver. Show all posts
Showing posts with label reportserver. Show all posts
Saturday, February 25, 2012
Tuesday, February 14, 2012
Corrupted ReportServerTempDB
Hi,
Need help here. I have reporting services installed on a sql cluster
and backup running every night for the 2 databases: ReportServer and
ReportServerTempDB. However a few weeks ago, the backup started
failing because ReportServerTempDB failed the DBCC CheckDB test with
the following error message:
Incorrect PFS free space information for page (1:184) in object ID
2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
72057594043498496 (type LOB data).
Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>From what I've read, that usually means that the db is corrupted and I
should restore from the backup... but seeing that this is the
temporary db, would it be possible to just delete the corrupted on and
recreate the ReportServerTempDB? Any impact?
ThxHello,
Yes you can drop ReportServerTempDB database and then recreate it:
After creating a new database ReportServerTempDB, create a Role
called RSExecRole , then you can run the script CatalogTempDB.sql. to
recreate the missing ReportServerTempDB objects.
(Go to your original installation bits and grab the file named
CatalogTempDB.sql located in the directory ..\Setup\Report Server\Reporting
Services\ReportServer.)
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.
Regards,
Radoslaw Lebkowski
Uzytkownik <aifong@.gmail.com> napisal w wiadomosci
news:1170909371.919215.218860@.l53g2000cwa.googlegroups.com...
> Hi,
> Need help here. I have reporting services installed on a sql cluster
> and backup running every night for the 2 databases: ReportServer and
> ReportServerTempDB. However a few weeks ago, the backup started
> failing because ReportServerTempDB failed the DBCC CheckDB test with
> the following error message:
> Incorrect PFS free space information for page (1:184) in object ID
> 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> 72057594043498496 (type LOB data).
> Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>>From what I've read, that usually means that the db is corrupted and I
> should restore from the backup... but seeing that this is the
> temporary db, would it be possible to just delete the corrupted on and
> recreate the ReportServerTempDB? Any impact?
> Thx
>|||Hi Radoslaw,
Thanks! I just tested it on a separate installation and it works.
Just a note on the collation, it has to be exactly the same as
ReportServer DB otherwise it gives an error. Other than that, A-ok.
Thanks,
AF
On Feb 8, 8:27 pm, "Radoslaw Lebkowski" <rade...@.wp.pl> wrote:
> Hello,
> Yes you can drop ReportServerTempDB database and then recreate it:
> After creating a new database ReportServerTempDB, create a Role
> called RSExecRole , then you can run the script CatalogTempDB.sql. to
> recreate the missing ReportServerTempDB objects.
> (Go to your original installation bits and grab the file named
> CatalogTempDB.sql located in the directory ..\Setup\Report Server\Reporting
> Services\ReportServer.)
> 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.
> Regards,
> Radoslaw Lebkowski
> Uzytkownik <aif...@.gmail.com> napisal w wiadomoscinews:1170909371.919215.218860@.l53g2000cwa.googlegroups.com...
>
> > Hi,
> > Need help here. I have reporting services installed on a sql cluster
> > and backup running every night for the 2 databases: ReportServer and
> > ReportServerTempDB. However a few weeks ago, the backup started
> > failing because ReportServerTempDB failed the DBCC CheckDB test with
> > the following error message:
> > Incorrect PFS free space information for page (1:184) in object ID
> > 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> > 72057594043498496 (type LOB data).
> > Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
> >>From what I've read, that usually means that the db is corrupted and I
> > should restore from the backup... but seeing that this is the
> > temporary db, would it be possible to just delete the corrupted on and
> > recreate the ReportServerTempDB? Any impact?
> > Thx- Hide quoted text -
> - Show quoted text -
Need help here. I have reporting services installed on a sql cluster
and backup running every night for the 2 databases: ReportServer and
ReportServerTempDB. However a few weeks ago, the backup started
failing because ReportServerTempDB failed the DBCC CheckDB test with
the following error message:
Incorrect PFS free space information for page (1:184) in object ID
2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
72057594043498496 (type LOB data).
Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>From what I've read, that usually means that the db is corrupted and I
should restore from the backup... but seeing that this is the
temporary db, would it be possible to just delete the corrupted on and
recreate the ReportServerTempDB? Any impact?
ThxHello,
Yes you can drop ReportServerTempDB database and then recreate it:
After creating a new database ReportServerTempDB, create a Role
called RSExecRole , then you can run the script CatalogTempDB.sql. to
recreate the missing ReportServerTempDB objects.
(Go to your original installation bits and grab the file named
CatalogTempDB.sql located in the directory ..\Setup\Report Server\Reporting
Services\ReportServer.)
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.
Regards,
Radoslaw Lebkowski
Uzytkownik <aifong@.gmail.com> napisal w wiadomosci
news:1170909371.919215.218860@.l53g2000cwa.googlegroups.com...
> Hi,
> Need help here. I have reporting services installed on a sql cluster
> and backup running every night for the 2 databases: ReportServer and
> ReportServerTempDB. However a few weeks ago, the backup started
> failing because ReportServerTempDB failed the DBCC CheckDB test with
> the following error message:
> Incorrect PFS free space information for page (1:184) in object ID
> 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> 72057594043498496 (type LOB data).
> Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
>>From what I've read, that usually means that the db is corrupted and I
> should restore from the backup... but seeing that this is the
> temporary db, would it be possible to just delete the corrupted on and
> recreate the ReportServerTempDB? Any impact?
> Thx
>|||Hi Radoslaw,
Thanks! I just tested it on a separate installation and it works.
Just a note on the collation, it has to be exactly the same as
ReportServer DB otherwise it gives an error. Other than that, A-ok.
Thanks,
AF
On Feb 8, 8:27 pm, "Radoslaw Lebkowski" <rade...@.wp.pl> wrote:
> Hello,
> Yes you can drop ReportServerTempDB database and then recreate it:
> After creating a new database ReportServerTempDB, create a Role
> called RSExecRole , then you can run the script CatalogTempDB.sql. to
> recreate the missing ReportServerTempDB objects.
> (Go to your original installation bits and grab the file named
> CatalogTempDB.sql located in the directory ..\Setup\Report Server\Reporting
> Services\ReportServer.)
> 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.
> Regards,
> Radoslaw Lebkowski
> Uzytkownik <aif...@.gmail.com> napisal w wiadomoscinews:1170909371.919215.218860@.l53g2000cwa.googlegroups.com...
>
> > Hi,
> > Need help here. I have reporting services installed on a sql cluster
> > and backup running every night for the 2 databases: ReportServer and
> > ReportServerTempDB. However a few weeks ago, the backup started
> > failing because ReportServerTempDB failed the DBCC CheckDB test with
> > the following error message:
> > Incorrect PFS free space information for page (1:184) in object ID
> > 2105058535, index ID 1, partition ID 72057594038517760, alloc unit ID
> > 72057594043498496 (type LOB data).
> > Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
> >>From what I've read, that usually means that the db is corrupted and I
> > should restore from the backup... but seeing that this is the
> > temporary db, would it be possible to just delete the corrupted on and
> > recreate the ReportServerTempDB? Any impact?
> > Thx- Hide quoted text -
> - Show quoted text -
Subscribe to:
Posts (Atom)