Problems Installing Reporting Services on Win2003

Hello All,
I have been trying to install reporting svcs EE on win2003 server for
the past 4 days. but not successful so far.
This is the set up i have.
win 2003, sql server 2000 EE and reporting svcs EE.
trying to create the RS databases on the local SQL server.
First I tried using the
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a Service Account.
Here it says i need this hot fix QFE 859 but couldnt find it on the MS
site.
Second Attempt
1. Select NT Authority\SYSTEM account
2. default names for the virtual dirs
3. local sql server instance and a SQL login account.
It completes most of the installation but throws up this error saying
cant connect to the databases.
I see the local sql server and see that the RS databases are created
I try to access the http://<server>/Report and ReportManager
I give the user/passwd, its authenticated and in the end I get a
message saying couldnt not connect to the database.
I would like to know if anyone faced similar issues and if there is way
around this.
Thanks
BofoThe NT Authority\SYSTEM account uses the Bultin\Administrator account to
login tin SQL. If this account is missing you would see this error. If the
account it there make sure it has access to the databases. For use, we used a
Domain User account for the install of RS and SQL.
"Win2003InstallIssues" wrote:
> Hello All,
> I have been trying to install reporting svcs EE on win2003 server for
> the past 4 days. but not successful so far.
> This is the set up i have.
> win 2003, sql server 2000 EE and reporting svcs EE.
> trying to create the RS databases on the local SQL server.
> First I tried using the
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a Service Account.
> Here it says i need this hot fix QFE 859 but couldnt find it on the MS
> site.
> Second Attempt
> 1. Select NT Authority\SYSTEM account
> 2. default names for the virtual dirs
> 3. local sql server instance and a SQL login account.
> It completes most of the installation but throws up this error saying
> cant connect to the databases.
> I see the local sql server and see that the RS databases are created
> I try to access the http://<server>/Report and ReportManager
> I give the user/passwd, its authenticated and in the end I get a
> message saying couldnt not connect to the database.
> I would like to know if anyone faced similar issues and if there is way
> around this.
> Thanks
> Bofo
>|||Thanks for the info. That was probably the problem. I used the NT
Authority\NETWORK SERVICE account and used a domain user account for
the ReportServer and seems to do fine.
at the end of the installation a couple of DOS windows pop-up
the first one says
"cannot connect to the database as the name of the server already
exists or a duplicate go to system utilities and change the name....
or something like that.
But the Reports and ReportServer urls seems to do fine.
Is this due to the fact that I have the SQL server and the RS running
from the same physical machine ?
Also would like to know what is the best way to setup the system. Like
having the SQL server on a seperate machine or it doesnt really matter.
Thanks
Bofo|||The RS databases have to be on SQL, whether or not ReportServer and Report
Manager are on the same machine does not matter.That is the good thing about
EE RS. You have flexibility in how you want to deploy your solutions. As an
example, we currently have RS, the RS databases and IIS on one server that
access another SQL Server for the reports. We will be moving to an App Center
load balanced IIS cluster, RS and databases in the middle and then the
external SQL Server for the data. This will give us the flexibility we need.
"Win2003InstallIssues" wrote:
> Thanks for the info. That was probably the problem. I used the NT
> Authority\NETWORK SERVICE account and used a domain user account for
> the ReportServer and seems to do fine.
> at the end of the installation a couple of DOS windows pop-up
> the first one says
> "cannot connect to the database as the name of the server already
> exists or a duplicate go to system utilities and change the name....
> or something like that.
> But the Reports and ReportServer urls seems to do fine.
> Is this due to the fact that I have the SQL server and the RS running
> from the same physical machine ?
> Also would like to know what is the best way to setup the system. Like
> having the SQL server on a seperate machine or it doesnt really matter.
> Thanks
> Bofo
>|||Hi, Thanks very much for the info.
I was able to install it successfully when I had the SQL server running
locally.
But I need to make to work having the SQL server on a different
machine.
Here is my scenario.
1. SQL server 2000 is running on a Win2003 Server which is NOT in my
domain and I want my RS databases on this machine.
2. Reporting services, IIS will run on my machine which is also running
Win2003 Server
My options during installation are
Windows Authenication and
for the reportServer a Service account (default) option
At the end of the installation I get a message saying that Reporting
Services cannot be initalized
I try to access the localhost/Reports
and I get the following error message
=============The report server cannot open a connection to the report server
database. A connection to the database is required for all requests and
processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=============
I would like to know if the problem is due to the fact that the SQL
server is running outside my domain ?
Also I would appreciate what are the best options to choose for the
account types, I read diff docs and each give a different opinion. I am
very new to this type of environment and feeling stupid for not being
able to make this work.
Thanks
Bofo|||Sorry it took so long to get back to you. To answer your questions.
Is there a trust relation between the two domains? This will be need to
ensure that authenication will work.
I would recommend that you setup IIS and RS to run under the account of a
Domain User with local admin on the servers. Then have the user IIS and RS
service is running under be set as trusted for delegation as well as the
servers. If you still get the "Login failed for user '(null)' error then we
need to make sure that the kerberos ticket is being passed. If it is not
being passed then you will have to manually create SPN entries for these
users and servers to ensure that the kerberos ticket is passed and received.
I do not know of any problems with the way you have it designed. Remember,
the more comlex the install the harder it is to troubleshoot.
"Win2003InstallIssues" wrote:
> Hi, Thanks very much for the info.
> I was able to install it successfully when I had the SQL server running
> locally.
> But I need to make to work having the SQL server on a different
> machine.
> Here is my scenario.
> 1. SQL server 2000 is running on a Win2003 Server which is NOT in my
> domain and I want my RS databases on this machine.
> 2. Reporting services, IIS will run on my machine which is also running
> Win2003 Server
> My options during installation are
> Windows Authenication and
> for the reportServer a Service account (default) option
> At the end of the installation I get a message saying that Reporting
> Services cannot be initalized
> I try to access the localhost/Reports
> and I get the following error message
> =============> The report server cannot open a connection to the report server
> database. A connection to the database is required for all requests and
> processing. (rsReportServerDatabaseUnavailable) Get Online Help Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =============> I would like to know if the problem is due to the fact that the SQL
> server is running outside my domain ?
> Also I would appreciate what are the best options to choose for the
> account types, I read diff docs and each give a different opinion. I am
> very new to this type of environment and feeling stupid for not being
> able to make this work.
> Thanks
> Bofo
>|||Hey !
thanks for the all the info. I got it going. the problem was that i
created the domain after SQL server was installed and also my co-worker
was using Windows Auth Only. So the problem with trusted connection.
Changed the option to Windows and SQL accounts and created a sql acc
with admin permissions and viola !
but i am stuck with SQL query issues now (I have already posted my
problem under another thread)
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/b0fb9b6091537e6f/1ac3d86d514559be
thanks
bofo

Problems during the deployment of a report

Hello,
I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
reporting services. When I started to do some test projects to see if
everything was working again and to see what the reporting services where I
ran into some problems:
- first I started a new reporting project and after setting up a test report
I tried to build the project what worked, but when it came to the stage of
deploying it during the build process it came with the error: " The
permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation.". After searching the Internet I didn't found a
sollution, so I tried the following:
- I started a new web application (as allways) placed a button and textbox
on it and ran it. It didn't work, it came with the following error "Error:
Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
that there was only a virtual directory but no application made for it
(properties "create" application). After doing this the web app worked.
So it looks like VS.NET 2003 doesn't have enhough rights to work properly
(because the reportingservices are still not working)? How can I fix this?
BTW:
- When I click within VS.NET on the internalt browser tab it display's mine
reports properly, I can browse through multiple pages, save my report to pdf.
- I posted this already to the dotnet.general newsgroup, and they told me to
post the question on this forum.
Thanks,
Charl1. I am getting the same error "The permissions granted to user
'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
performing this operation." I thought it was because we installed a
certifercate and applied SSL.
2. How do I use SSL in Interdev with Report Services?
"Charl" wrote:
> Hello,
> I just made a fresh install of Win2003 with VS.NET and SQL server 2000 with
> reporting services. When I started to do some test projects to see if
> everything was working again and to see what the reporting services where I
> ran into some problems:
> - first I started a new reporting project and after setting up a test report
> I tried to build the project what worked, but when it came to the stage of
> deploying it during the build process it came with the error: " The
> permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> performing this operation.". After searching the Internet I didn't found a
> sollution, so I tried the following:
> - I started a new web application (as allways) placed a button and textbox
> on it and ran it. It didn't work, it came with the following error "Error:
> Project Is Not Configured To Be Debugged". Looking in IIS admin I found out
> that there was only a virtual directory but no application made for it
> (properties "create" application). After doing this the web app worked.
> So it looks like VS.NET 2003 doesn't have enhough rights to work properly
> (because the reportingservices are still not working)? How can I fix this?
> BTW:
> - When I click within VS.NET on the internalt browser tab it display's mine
> reports properly, I can browse through multiple pages, save my report to pdf.
> - I posted this already to the dotnet.general newsgroup, and they told me to
> post the question on this forum.
> Thanks,
> Charl
>|||Hello Charl,
This issue can occur if the virutal folders of IIS for reporting service
allow anonymouse.
Please check the following settings:
Right click Reports /ReportServer in IIS->Properties->Directory Security
Make sure "Intergrated Windows authentication" is checked and "enable
anonymouse access" is unchecked.
For SSL setting, please refer to
Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/sslsetup.asp
Hope this helps.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| X-WBNR-Posting-Host: 144.141.194.3
| From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| Subject: RE: Problems during the deployment of a report
| Date: Wed, 26 Jan 2005 12:13:04 -0800
| Lines: 43
| Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| 1. I am getting the same error "The permissions granted to user
| 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| performing this operation." I thought it was because we installed a
| certifercate and applied SSL.
|
|
| 2. How do I use SSL in Interdev with Report Services?
|
|
| "Charl" wrote:
|
| > Hello,
| >
| > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
with
| > reporting services. When I started to do some test projects to see if
| > everything was working again and to see what the reporting services
where I
| > ran into some problems:
| >
| > - first I started a new reporting project and after setting up a test
report
| > I tried to build the project what worked, but when it came to the stage
of
| > deploying it during the build process it came with the error: " The
| > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
for
| > performing this operation.". After searching the Internet I didn't
found a
| > sollution, so I tried the following:
| >
| > - I started a new web application (as allways) placed a button and
textbox
| > on it and ran it. It didn't work, it came with the following error
"Error:
| > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
out
| > that there was only a virtual directory but no application made for it
| > (properties "create" application). After doing this the web app worked.
| > So it looks like VS.NET 2003 doesn't have enhough rights to work
properly
| > (because the reportingservices are still not working)? How can I fix
this?
| >
| > BTW:
| > - When I click within VS.NET on the internalt browser tab it display's
mine
| > reports properly, I can browse through multiple pages, save my report
to pdf.
| >
| > - I posted this already to the dotnet.general newsgroup, and they told
me to
| > post the question on this forum.
| >
| > Thanks,
| > Charl
| >
||||Thanks Peter,
This solved mine problem!
So what you are saying is that it isn't possible to use the reportingservice
with anonymouse access enabled? Because that is what I would like to do for
my reports?!?
Thanks,
Charl
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> This issue can occur if the virutal folders of IIS for reporting service
> allow anonymouse.
> Please check the following settings:
> Right click Reports /ReportServer in IIS->Properties->Directory Security
> Make sure "Intergrated Windows authentication" is checked and "enable
> anonymouse access" is unchecked.
> For SSL setting, please refer to
> Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> /sslsetup.asp
> Hope this helps.
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | X-WBNR-Posting-Host: 144.141.194.3
> | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | Subject: RE: Problems during the deployment of a report
> | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | Lines: 43
> | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | 1. I am getting the same error "The permissions granted to user
> | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | performing this operation." I thought it was because we installed a
> | certifercate and applied SSL.
> |
> |
> | 2. How do I use SSL in Interdev with Report Services?
> |
> |
> | "Charl" wrote:
> |
> | > Hello,
> | >
> | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> with
> | > reporting services. When I started to do some test projects to see if
> | > everything was working again and to see what the reporting services
> where I
> | > ran into some problems:
> | >
> | > - first I started a new reporting project and after setting up a test
> report
> | > I tried to build the project what worked, but when it came to the stage
> of
> | > deploying it during the build process it came with the error: " The
> | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> for
> | > performing this operation.". After searching the Internet I didn't
> found a
> | > sollution, so I tried the following:
> | >
> | > - I started a new web application (as allways) placed a button and
> textbox
> | > on it and ran it. It didn't work, it came with the following error
> "Error:
> | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> out
> | > that there was only a virtual directory but no application made for it
> | > (properties "create" application). After doing this the web app worked.
> | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> properly
> | > (because the reportingservices are still not working)? How can I fix
> this?
> | >
> | > BTW:
> | > - When I click within VS.NET on the internalt browser tab it display's
> mine
> | > reports properly, I can browse through multiple pages, save my report
> to pdf.
> | >
> | > - I posted this already to the dotnet.general newsgroup, and they told
> me to
> | > post the question on this forum.
> | >
> | > Thanks,
> | > Charl
> | >
> |
>|||HI...
We are usining both Annyonymous and Windows Integrations. This seems to
work. Are we doing something wrong?
:)
"Charl" wrote:
> Thanks Peter,
> This solved mine problem!
> So what you are saying is that it isn't possible to use the reportingservice
> with anonymouse access enabled? Because that is what I would like to do for
> my reports?!?
> Thanks,
> Charl
>
> "Peter Yang [MSFT]" wrote:
> > Hello Charl,
> >
> > This issue can occur if the virutal folders of IIS for reporting service
> > allow anonymouse.
> >
> > Please check the following settings:
> >
> > Right click Reports /ReportServer in IIS->Properties->Directory Security
> >
> > Make sure "Intergrated Windows authentication" is checked and "enable
> > anonymouse access" is unchecked.
> >
> > For SSL setting, please refer to
> >
> > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> > http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> > /sslsetup.asp
> >
> > Hope this helps.
> >
> > Thanks & Regards,
> >
> > Peter Yang
> > MCSE2000/2003, MCSA, MCDBA
> > Microsoft Online Partner Support
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > =====================================================> >
> > Business-Critical Phone Support (BCPS) provides you with technical phone
> > support at no charge during critical LAN outages or "business down"
> > situations. This benefit is available 24 hours a day, 7 days a week to all
> > Microsoft technology partners in the United States and Canada.
> >
> > This and other support options are available here:
> >
> > BCPS:
> > https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> >
> > Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> >
> > If you are outside the United States, please visit our International
> > Support page:
> > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> >
> > =====================================================> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > --
> > | Thread-Topic: Problems during the deployment of a report
> > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> > | X-WBNR-Posting-Host: 144.141.194.3
> > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> > | Subject: RE: Problems during the deployment of a report
> > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> > | Lines: 43
> > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> > | MIME-Version: 1.0
> > | Content-Type: text/plain;
> > | charset="Utf-8"
> > | Content-Transfer-Encoding: 7bit
> > | X-Newsreader: Microsoft CDO for Windows 2000
> > | Content-Class: urn:content-classes:message
> > | Importance: normal
> > | Priority: normal
> > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> > | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40960
> > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> > |
> > | 1. I am getting the same error "The permissions granted to user
> > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> > | performing this operation." I thought it was because we installed a
> > | certifercate and applied SSL.
> > |
> > |
> > | 2. How do I use SSL in Interdev with Report Services?
> > |
> > |
> > | "Charl" wrote:
> > |
> > | > Hello,
> > | >
> > | > I just made a fresh install of Win2003 with VS.NET and SQL server 2000
> > with
> > | > reporting services. When I started to do some test projects to see if
> > | > everything was working again and to see what the reporting services
> > where I
> > | > ran into some problems:
> > | >
> > | > - first I started a new reporting project and after setting up a test
> > report
> > | > I tried to build the project what worked, but when it came to the stage
> > of
> > | > deploying it during the build process it came with the error: " The
> > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient
> > for
> > | > performing this operation.". After searching the Internet I didn't
> > found a
> > | > sollution, so I tried the following:
> > | >
> > | > - I started a new web application (as allways) placed a button and
> > textbox
> > | > on it and ran it. It didn't work, it came with the following error
> > "Error:
> > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I found
> > out
> > | > that there was only a virtual directory but no application made for it
> > | > (properties "create" application). After doing this the web app worked.
> > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> > properly
> > | > (because the reportingservices are still not working)? How can I fix
> > this?
> > | >
> > | > BTW:
> > | > - When I click within VS.NET on the internalt browser tab it display's
> > mine
> > | > reports properly, I can browse through multiple pages, save my report
> > to pdf.
> > | >
> > | > - I posted this already to the dotnet.general newsgroup, and they told
> > me to
> > | > post the question on this forum.
> > | >
> > | > Thanks,
> > | > Charl
> > | >
> > |
> >
> >|||Hello Charl,
If you want to anonymouse to be able to run report properly, usually you
shall grant proper permission to ASP.net and USR_machinename accout.
- Chang the anonymous account to use IUSR_machinename
- Add aspnet/IUSR_machinename as a RM account and assigned browse, View
reports and View folder.
Usually you can check "enable anonymous access" in Reports virtual
directory but you shall not check it in ReportServer folder.
If the issue persists, try to add aspnet to the Admins group. Hope this
helps.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Problems during the deployment of a report
| thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==| X-WBNR-Posting-Host: 62.194.205.63
| From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
| References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
<ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
<5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
| Subject: RE: Problems during the deployment of a report
| Date: Thu, 27 Jan 2005 04:41:05 -0800
| Lines: 151
| Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks Peter,
|
| This solved mine problem!
| So what you are saying is that it isn't possible to use the
reportingservice
| with anonymouse access enabled? Because that is what I would like to do
for
| my reports?!?
|
| Thanks,
|
| Charl
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Charl,
| >
| > This issue can occur if the virutal folders of IIS for reporting
service
| > allow anonymouse.
| >
| > Please check the following settings:
| >
| > Right click Reports /ReportServer in IIS->Properties->Directory Security
| >
| > Make sure "Intergrated Windows authentication" is checked and "enable
| > anonymouse access" is unchecked.
| >
| > For SSL setting, please refer to
| >
| > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
| >
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
| > /sslsetup.asp
| >
| > Hope this helps.
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Problems during the deployment of a report
| > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==| > | X-WBNR-Posting-Host: 144.141.194.3
| > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
| > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
| > | Subject: RE: Problems during the deployment of a report
| > | Date: Wed, 26 Jan 2005 12:13:04 -0800
| > | Lines: 43
| > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40960
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | 1. I am getting the same error "The permissions granted to user
| > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
| > | performing this operation." I thought it was because we installed a
| > | certifercate and applied SSL.
| > |
| > |
| > | 2. How do I use SSL in Interdev with Report Services?
| > |
| > |
| > | "Charl" wrote:
| > |
| > | > Hello,
| > | >
| > | > I just made a fresh install of Win2003 with VS.NET and SQL server
2000
| > with
| > | > reporting services. When I started to do some test projects to see
if
| > | > everything was working again and to see what the reporting services
| > where I
| > | > ran into some problems:
| > | >
| > | > - first I started a new reporting project and after setting up a
test
| > report
| > | > I tried to build the project what worked, but when it came to the
stage
| > of
| > | > deploying it during the build process it came with the error: " The
| > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
insufficient
| > for
| > | > performing this operation.". After searching the Internet I didn't
| > found a
| > | > sollution, so I tried the following:
| > | >
| > | > - I started a new web application (as allways) placed a button and
| > textbox
| > | > on it and ran it. It didn't work, it came with the following error
| > "Error:
| > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
found
| > out
| > | > that there was only a virtual directory but no application made for
it
| > | > (properties "create" application). After doing this the web app
worked.
| > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
| > properly
| > | > (because the reportingservices are still not working)? How can I
fix
| > this?
| > | >
| > | > BTW:
| > | > - When I click within VS.NET on the internalt browser tab it
display's
| > mine
| > | > reports properly, I can browse through multiple pages, save my
report
| > to pdf.
| > | >
| > | > - I posted this already to the dotnet.general newsgroup, and they
told
| > me to
| > | > post the question on this forum.
| > | >
| > | > Thanks,
| > | > Charl
| > | >
| > |
| >
| >
||||i've a similiar problem the error message is "The permissions granted to user
'DOMAIN\USER are insufficient for performing this operation. (rsAccessDenied)
"
I've changed premission of the fisical directory "ReportingServices" to
everyone full control
and put the aspnet user in the administrators group but it didn't work.
Is there any documentention on how to set a reporting server to anonyous use?
"Peter Yang [MSFT]" wrote:
> Hello Charl,
> If you want to anonymouse to be able to run report properly, usually you
> shall grant proper permission to ASP.net and USR_machinename accout.
> - Chang the anonymous account to use IUSR_machinename
> - Add aspnet/IUSR_machinename as a RM account and assigned browse, View
> reports and View folder.
> Usually you can check "enable anonymous access" in Reports virtual
> directory but you shall not check it in ReportServer folder.
> If the issue persists, try to add aspnet to the Admins group. Hope this
> helps.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Problems during the deployment of a report
> | thread-index: AcUEbXeOmZUeArSJTFSbCQ/6IpLr7w==> | X-WBNR-Posting-Host: 62.194.205.63
> | From: "=?Utf-8?B?Q2hhcmw=?=" <Charl@.noemail.nospam>
> | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> <5AaE0XCBFHA.2732@.cpmsftngxa10.phx.gbl>
> | Subject: RE: Problems during the deployment of a report
> | Date: Thu, 27 Jan 2005 04:41:05 -0800
> | Lines: 151
> | Message-ID: <D24DA289-3C1A-4C11-B6CE-847A313DE4BE@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41027
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks Peter,
> |
> | This solved mine problem!
> | So what you are saying is that it isn't possible to use the
> reportingservice
> | with anonymouse access enabled? Because that is what I would like to do
> for
> | my reports?!?
> |
> | Thanks,
> |
> | Charl
> |
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello Charl,
> | >
> | > This issue can occur if the virutal folders of IIS for reporting
> service
> | > allow anonymouse.
> | >
> | > Please check the following settings:
> | >
> | > Right click Reports /ReportServer in IIS->Properties->Directory Security
> | >
> | > Make sure "Intergrated Windows authentication" is checked and "enable
> | > anonymouse access" is unchecked.
> | >
> | > For SSL setting, please refer to
> | >
> | > Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
> | >
> http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
> | > /sslsetup.asp
> | >
> | > Hope this helps.
> | >
> | > Thanks & Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > Business-Critical Phone Support (BCPS) provides you with technical
> phone
> | > support at no charge during critical LAN outages or "business down"
> | > situations. This benefit is available 24 hours a day, 7 days a week to
> all
> | > Microsoft technology partners in the United States and Canada.
> | >
> | > This and other support options are available here:
> | >
> | > BCPS:
> | >
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> | >
> | > Others:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/
> | >
> | > If you are outside the United States, please visit our International
> | > Support page:
> | > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | > --
> | > | Thread-Topic: Problems during the deployment of a report
> | > | thread-index: AcUD43GQazYXHSyvSkKGiJUt0NAIzw==> | > | X-WBNR-Posting-Host: 144.141.194.3
> | > | From: "=?Utf-8?B?UlMtR2lybA==?=" <RSGirl@.discussions.microsoft.com>
> | > | References: <84A55AEC-F91F-49D2-BFED-5474968DD8D3@.microsoft.com>
> | > | Subject: RE: Problems during the deployment of a report
> | > | Date: Wed, 26 Jan 2005 12:13:04 -0800
> | > | Lines: 43
> | > | Message-ID: <ABFED987-6704-4F7E-BA22-A4CC5893B14B@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:40960
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | 1. I am getting the same error "The permissions granted to user
> | > | 'MYDOMAIN\IUSR_MYDOMAIN' are insufficient for
> | > | performing this operation." I thought it was because we installed a
> | > | certifercate and applied SSL.
> | > |
> | > |
> | > | 2. How do I use SSL in Interdev with Report Services?
> | > |
> | > |
> | > | "Charl" wrote:
> | > |
> | > | > Hello,
> | > | >
> | > | > I just made a fresh install of Win2003 with VS.NET and SQL server
> 2000
> | > with
> | > | > reporting services. When I started to do some test projects to see
> if
> | > | > everything was working again and to see what the reporting services
> | > where I
> | > | > ran into some problems:
> | > | >
> | > | > - first I started a new reporting project and after setting up a
> test
> | > report
> | > | > I tried to build the project what worked, but when it came to the
> stage
> | > of
> | > | > deploying it during the build process it came with the error: " The
> | > | > permissions granted to user 'MYDOMAIN\IUSR_MYDOMAIN' are
> insufficient
> | > for
> | > | > performing this operation.". After searching the Internet I didn't
> | > found a
> | > | > sollution, so I tried the following:
> | > | >
> | > | > - I started a new web application (as allways) placed a button and
> | > textbox
> | > | > on it and ran it. It didn't work, it came with the following error
> | > "Error:
> | > | > Project Is Not Configured To Be Debugged". Looking in IIS admin I
> found
> | > out
> | > | > that there was only a virtual directory but no application made for
> it
> | > | > (properties "create" application). After doing this the web app
> worked.
> | > | > So it looks like VS.NET 2003 doesn't have enhough rights to work
> | > properly
> | > | > (because the reportingservices are still not working)? How can I
> fix
> | > this?
> | > | >
> | > | > BTW:
> | > | > - When I click within VS.NET on the internalt browser tab it
> display's
> | > mine
> | > | > reports properly, I can browse through multiple pages, save my
> report
> | > to pdf.
> | > | >
> | > | > - I posted this already to the dotnet.general newsgroup, and they
> told
> | > me to
> | > | > post the question on this forum.
> | > | >
> | > | > Thanks,
> | > | > Charl
> | > | >
> | > |
> | >
> | >
> |
>sql