Hello All,
I have to restart SQL Server 2000 every week or it hangs
the website made in ASP. Restarting fixes the problem.
Does anyone have an idea, why it happens?
Thanks,
Tanyasounds to me like connection creep (Orphaned sessions).
GAJsql
Showing posts with label website. Show all posts
Showing posts with label website. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
RSClientPrint
Hi all,
I wanted to use the RSClientPrint.dll on my website for printing server documents on the client. But I can nowhere find the dll (activeX).
Can someone provide me with that dll or send me a message where to find it, and will it work without Reporting Services?
TIA,
Dirk Ooms
You can find the dll embedded in the rsclientprint.cab file of your Reporting Services installation. Or, if you install the active-x control, you can find the dll in %windir%\Downloaded Program Files. Make sure you install all of the files (.dll, .rll and .ini) if using the print control directly.|||Maybe I was looking in the wrong direction,
I found the DLL but I wanted to use it to print word documents on the client from a web browser.
Is this possible or can you only print Reports created by Reporting Services with it?
The print method is described as:
public abstract new void Print ( System.String reportServerUrl , System.String reportPath , System.String reportName )
Member of RSClientPrintLib.IRSClientPrint
Is there a possibility for printing word documents with this functionality or do I have to look for an other solution?
For the moment I'm converting the word files to pdf, showing the pdf in an other screen and then the user has to push the print button.
But if possible I would like to avoid the conversion, and provide the user automatically with the print option screen to print a document on his local printer without having to open that document on screen.
Any suggestions are welcome!
|||The client print from Reporting Services is for reports. You will not be able to use it in the manner you are suggesting.RSClientPrint
Hi all,
I wanted to use the RSClientPrint.dll on my website for printing server documents on the client. But I can nowhere find the dll (activeX).
Can someone provide me with that dll or send me a message where to find it, and will it work without Reporting Services?
TIA,
Dirk Ooms
You can find the dll embedded in the rsclientprint.cab file of your Reporting Services installation. Or, if you install the active-x control, you can find the dll in %windir%\Downloaded Program Files. Make sure you install all of the files (.dll, .rll and .ini) if using the print control directly.|||Maybe I was looking in the wrong direction,
I found the DLL but I wanted to use it to print word documents on the client from a web browser.
Is this possible or can you only print Reports created by Reporting Services with it?
The print method is described as:
public abstract new void Print ( System.String reportServerUrl , System.String reportPath , System.String reportName )
Member of RSClientPrintLib.IRSClientPrint
Is there a possibility for printing word documents with this functionality or do I have to look for an other solution?
For the moment I'm converting the word files to pdf, showing the pdf in an other screen and then the user has to push the print button.
But if possible I would like to avoid the conversion, and provide the user automatically with the print option screen to print a document on his local printer without having to open that document on screen.
Any suggestions are welcome!
|||The client print from Reporting Services is for reports. You will not be able to use it in the manner you are suggesting.rsAccessDenied and
I have installed Reporting Services on a production server that host a
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
website using SQL Express. I have set up RS in the RS configuration manager
and got green button all the way down
Requesting http://www.xx.dk/reports replies:
The request failed with HTTP status 400: Bad Request.
Requesting http://www.xx.dk/reportserver replies:
The permissions granted to user 'TF4\ms' are insufficient for performing
this operation. (rsAccessDenied)
Any idea what the problem might be ?
--
Paul SHello Paul,
Based on my research, please check the following settings:
1. Make sure you disable the Anynomous Access on IIS for the reporting
services virtual directory.
2. Make sure you enable Windows Authentication on IIS
3. Make sure you have use the rsconfig utility to connect to the correct
SQL Instance for the report server.
4. Make sure you are using a correct identity for the application pool the
reporting services using. Please try to use a domain account with local
admin privilage to have a check.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||1)
Anynomous Access is disabled for the reportServer dir. and the reports dir.
but not for the parent dir - the original dir for the website.
2)
Windows Authentication is enabled for the reports and the reportserver dir.
3)
I only have one - it's correct
4)
The application pool for both the ReportServer and the Report manager is
DefaultAppPool
ps. In database setup the credentials type is Service credentials
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> Based on my research, please check the following settings:
> 1. Make sure you disable the Anynomous Access on IIS for the reporting
> services virtual directory.
> 2. Make sure you enable Windows Authentication on IIS
> 3. Make sure you have use the rsconfig utility to connect to the correct
> SQL Instance for the report server.
> 4. Make sure you are using a correct identity for the application pool the
> reporting services using. Please try to use a domain account with local
> admin privilage to have a check.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hello Paul,
1. Please run the rsconfig utility to specify a new connection to the sql
server:
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
2. Please recreate an application pool for the report server and use a
domain account which have local admin privilage as the identity to have a
try.
Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu
Your suggestions gave the follwing:
1)
No Reporting Services instance found on localhost.
2)
I created a new user with local admin rights and used him when I created a
new app pool for the reports server - the report manager still uses
DefaultAppPool.
Why is it talking about localhost - I'm not using localhost. The values
specifid in the RS Configuration manager for Report Server Virtual Directory
is:
Name: ReportServer, Website xxx
accessing http://www.xxx.dk/reports gives
The request failed with HTTP status 400: Bad Request.
acessing http://www.xxx.dk/reportserver still gives The permissions granted
to user 'TF4\ms' are insufficient for performing this operation.
(rsAccessDenied)|||Hello Paul,
I would like to get the RSWebApplication.config file and
rsreportserver.config file in the report manager and report server folder.
By default, these two folders is located at :C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\
Also, please send me the screenshot for the Configuration Tool. Make sure
you have a default instance installed in the server.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you. To get my real email addresss, please
remove the ONLINE in my display mail.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I've send you the information needed
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Paul,
From your rsreportserver.config file, I did not see the LogonUser
credential is applied. So please use the rsconfig utility to specify the
credential to connect to SQL Server Report Server.
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hello Wei
I get an error message saying
'No reporting services instance found on localhost'
when I run the rsconfig utility
I have been going through this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=143931&SiteID=1
but I have the folders mentioned.
Paul S
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> From your rsreportserver.config file, I did not see the LogonUser
> credential is applied. So please use the rsconfig utility to specify the
> credential to connect to SQL Server Report Server.
> rsconfig -c -s <SQLSERVERNAME> -d reportserver -a SQL -u SA -p <SAPASSWORD>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================.
>|||Hello Paul,
According to your email, I found that you are going to configure your
Express instance in your computer.
Please try the following:
rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
<SAPASSWORD>
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Issuing that command was what gave me the
'No reporting services instance found on localhost'
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hello Paul,
> According to your email, I found that you are going to configure your
> Express instance in your computer.
> Please try the following:
> rsconfig -c -s <SQLSERVERNAME>\Express -d reportserver -a SQL -u SA -p
> <SAPASSWORD>
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> =====================================================> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
> We also love to hear your product feedback!
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello Paul,
I would like to know how many instances you installed in the machine.
Pleas run the MPS Report .
--
a. Download MPSReport tool from below URL:
<
http://download.microsoft.com/download/b/b/1/bb139fcb-4aac-4fe5-a579-30b0bd9
15706/MPSRPT_SETUPPerf.EXE>
b. Execute the tool on the computer, and if you are prompted "Include the
MSINFO32 report?", please type Y.
c. Please send the result file (CAB file) to me
To reach me, please remove the ONLINE in my display email address.
For detailed information about the MPS Report Tools, please refer to the
following link:
Microsoft Product Support's Reporting Tools
<http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F
-88B7-F9C79B7306C0&displaylang=en>
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi
I have just send you the described CAB file
--
Paul S
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
Tuesday, March 20, 2012
RS2000 on multiple websites, customize look and feel, turn off admin
I'm brand new to SSRS and just installed RS2000. I have seen numerous posts/articles about how to set up RS2000 on the non-default website, but haven't been able to figure out if you can install it on multiple websites on the same server.
Here's my situation: we have multiple clients who run our software on the same server. Each client has their own db and their own website in IIS. I'd like to provide each client with access to reports through their own website that report on their own database. Is this possible at all? From what I'm finding, I don't think it is (it seems SSRS can only be installed on one site), but figured I would ask to determine whether I should explore the use of SSRS any further. If it isn't possible in RS2000, is it possible in RS2005?
I also have two other questions that I would need to figure out an answer to if it is possible to run RS2000 on multiple websites. First, is there a way to customize the look and feel of the reports? In other words, is there a way to add a header/leftnav/footer? It seems that I could use a frameset to load my header, footer, and leftnav, and then just point my main frame to the /reports/ or /reporserver virtual dirs. Is there a better way than that?
Secondly, is there a way to turn off access to most of the admin features available through the /reports/ directory. For example, we wouldn't want our clients to have access to "New Data Source", "Site Settings", etc. We'd just want them to access the reports we generate. It seems we could point them to the /reportserver/ directory and just put some custom pages in there to point at the reports (I just get a directory listing by default). Is there another way to do this?
Thanks,
Dave
This helps:
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/default.aspx
Subscribe to:
Comments (Atom)