Showing posts with label deployment. Show all posts
Showing posts with label deployment. Show all posts

Monday, March 26, 2012

problems during the deployment phase

I used the Business Intelligence Studio to make a report. I also enabled the tcp/ip protocol but during the deployment of the report i get the following error. I can see the report in Preview-Layout mode but i can t run the project. Could you help me

Thanks In Advance

===================================

A connection could not be made to the report server http://localhost/ReportServer$DVLP002_SQL2005/Reports. (Microsoft Report Designer)

===================================

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

It sounds like the specified ReportServerUrl is incorrect in your VS solution. You want to publish reports to the RS server web service - not to the RS report manager.

You should set the ReportServerUrl to: http://localhost/ReportServer$DVLP002_SQL2005

-- Robert

|||

Everything now is OK

Thank You Very Much

Nick Macis

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

Friday, March 9, 2012

Problem: Deployment works, but processing does not

Hi,

I am working with the 'Using SQL Server Data Mining" book, and am trying to deploy and process the 'MovieClick' example in chapter 3. Here is my problem: I am able to create the Data source, the source view, the data mining structure and data mining models (Decision trees and Bayes). When I select 'Buil - Deploy solution' all scripts are successfully deployed to the server, but once the processing start the application nothing happens. I see the that BI is trying to do something, or waiting for something. I can see a text that '0 cases are read'. The app does not time out, and i have to cancel the deployment.

Please let me know how to address this. I have followed the instructions in the book step-by-step (twice already), and I have the same problem. I have done the 'Adventure Works' data mining tutorials, and they work ok.

Any hint?

Thanks,

Doriak

Update on this issue.

I have tried the same project with the same instructions on a different machine, and I have the same issue. What it is worse, is that now once BI tries to kick the processing and it does not work, Visual Studio freezes so that I have to kill the process.

Doriak

|||

Hi,

Could somebody please help clarifying this?

Thanks,

Doriak

|||

You might be hitting a bug that occurs on single-proc systems. You can work around by changing some server settings using SQL Server Mgmt Studio. See this thread for details: http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/2131.aspx

|||

Raman,

Thank you for the answer. The link you provided helped me to resolve the configuration issue. I am also working with a 1 CPU system for development purposes. I would like only to ask the team to provide updated documentation on configuration for typical scenarios as this was nowether to find in the BOL.

Thank you again. And now, back to mining :)

Doriak