Can't print from SSRS on Citrix

Hi,
We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
click the print icon in SSRS, I get an Internet Explorer Security Warning
asking if I want to install Microsoft SQL Server. When I click "Don't
Install" I get the message, "Unable to load client print control." It seems
like there's a component that needs to be installed to enable printing from
SSRS, but I don't know what it is. Can anyone point me in the right
direction here?
--
Thanks,
JeffI think the IE security Warning refers to installing SSRS's report
preview/print activeX control, not the SQL Server itself. When you use IE to
open a report and try to print it the first time, that preview/print ActiveX
control must be downloaded to the computer where IE run and installed. So,
you need to go ahead to allow the installation once for all.
"Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> Hi,
> We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> click the print icon in SSRS, I get an Internet Explorer Security Warning
> asking if I want to install Microsoft SQL Server. When I click "Don't
> Install" I get the message, "Unable to load client print control." It
> seems
> like there's a component that needs to be installed to enable printing
> from
> SSRS, but I don't know what it is. Can anyone point me in the right
> direction here?
> --
> Thanks,
> Jeff|||Thanks Norman!
--
Thanks,
Jeff
"Norman Yuan" wrote:
> I think the IE security Warning refers to installing SSRS's report
> preview/print activeX control, not the SQL Server itself. When you use IE to
> open a report and try to print it the first time, that preview/print ActiveX
> control must be downloaded to the computer where IE run and installed. So,
> you need to go ahead to allow the installation once for all.
> "Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
> news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> > Hi,
> >
> > We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> > click the print icon in SSRS, I get an Internet Explorer Security Warning
> > asking if I want to install Microsoft SQL Server. When I click "Don't
> > Install" I get the message, "Unable to load client print control." It
> > seems
> > like there's a component that needs to be installed to enable printing
> > from
> > SSRS, but I don't know what it is. Can anyone point me in the right
> > direction here?
> > --
> > Thanks,
> >
> > Jeff
>
>

cant open databases folder

Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on???
Please email response to nkulshresh@.hotmail.com as well as posting to
group.

Thanks,
Navin[posted and mailed, please reply in news]

Navin Kulshreshtha (amador612@.hotmail.com) writes:
> Hello, I just installed SQL Server 2000 on my home computer and am
> connecting to a remote SQL server over the Internet. I can log into
> the server just fine and see 7 folders including the 'Databases'
> folder. I can open up all of the other 6 folders but for some crazy
> reason when I double click on the 'Databases' folder, I can't open it!
> The hourglass appears and Enterprise Manager basically locks up. Does
> anyone know what's going on???

It could be that autoclose is turned for one or more databasees. Connect
with Query Analyzer, and run an sp_help and check the options columns.

Also check that you have not enabled ODBC tracing on your machine.

> Please email response to nkulshresh@.hotmail.com as well as posting to
> group.

If you want replies to a certain address, please put it in the Reply-To
field of your posting.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp