Thursday, March 29, 2012
Deserialization failed: The element has invalid child element
which version is current?
b) anyone know what this means:
c:\documents and settings\administrator\my documents\visual studio
projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
\takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
Deserialization failed: The element 'http://schemas.microsoft.com/
sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
(571, 23).On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> a) how do I know which version of SSRS designer I have? how do I know
> which version is current?
> b) anyone know what this means:
> c:\documents and settings\administrator\my documents\visual studio
> projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> Deserialization failed: The element 'http://schemas.microsoft.com/
> sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> (571, 23).
In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
Studio' to get the version number, service pack, etc. Don't quote me
on this, but I believe that the latest version is 9.0.3042.
This thread may offer some insight into your error:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/232cb81b9f1f1328/5bb841311ab856ac?lnk=st&q=The+element+%27http%3A%2F%2Fschemas.microsoft.com%2Fsqlserver%2Freporting%2F2003+has+invalid+child+element&rnum=1#5bb841311ab856ac
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I meant for SQL 2000 on the version thing
I've got 8.0.0.760 on the visual studio side.. or something around 700
I assume that this is not SP2 for SSRS 2000?
On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
> > a) how do I know which version of SSRS designer I have? how do I know
> > which version is current?
> > b) anyone know what this means:
> > c:\documents and settings\administrator\my documents\visual studio
> > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > Deserialization failed: The element 'http://schemas.microsoft.com/
> > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > (571, 23).
> In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> Studio' to get the version number, service pack, etc. Don't quote me
> on this, but I believe that the latest version is 9.0.3042.
> This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
wrote:
> I meant for SQL 2000 on the version thing
> I've got 8.0.0.760 on the visual studio side.. or something around 700
> I assume that this is not SP2 for SSRS 2000?
> On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > wrote:
> > > a) how do I know which version of SSRS designer I have? how do I know
> > > which version is current?
> > > b) anyone know what this means:
> > > c:\documents and settings\administrator\my documents\visual studio
> > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > (571, 23).
> > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > Studio' to get the version number, service pack, etc. Don't quote me
> > on this, but I believe that the latest version is 9.0.3042.
> > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You should be using either SP3 or SP3a, according to your version.
This link should be useful:
http://support.microsoft.com/kb/321185
Regards,
Enrique Martinez
Sr. Software Consultant|||yeah.. but that is the SP for the database-- not for the reporting
services side
I'll find it soon I guess
thanks
On Apr 4, 11:07 am, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Apr 4, 11:45 am, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> wrote:
>
>
> > I meant for SQL 2000 on the version thing
> > I've got 8.0.0.760 on the visual studio side.. or something around 700
> > I assume that this is not SP2 for SSRS 2000?
> > On Apr 3, 5:50 pm, "EMartinez" <emartinez...@.gmail.com> wrote:
> > > On Apr 3, 7:29 pm, "aaron.ke...@.gmail.com" <aaron.ke...@.gmail.com>
> > > wrote:
> > > > a) how do I know which version of SSRS designer I have? how do I know
> > > > which version is current?
> > > > b) anyone know what this means:
> > > > c:\documents and settings\administrator\my documents\visual studio
> > > > projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive
> > > > \takeonefivefive\rptReviewingMembersLetterFUN.rdl(571):
> > > > Deserialization failed: The element 'http://schemas.microsoft.com/
> > > > sqlserver/reporting/2003/10/reportdefinition:Value' has invalid child
> > > > element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/
> > > > reportdefinition:Enteranyadditionalcomments'. An error occurred at ,
> > > > (571, 23).
> > > In Visual Studio, select the 'Help' tab and 'About Microsoft Visual
> > > Studio' to get the version number, service pack, etc. Don't quote me
> > > on this, but I believe that the latest version is 9.0.3042.
> > > This thread may offer some insight into your error:http://groups.google.com/group/microsoft.public.sqlserver.reportingsv...
> > > Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You should be using either SP3 or SP3a, according to your version.
> This link should be useful:http://support.microsoft.com/kb/321185
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
Sunday, March 25, 2012
Deployment Version Problem
Server2003 production environment.
Both computers are running SQL Server 2005 with SP1 installed.
We have tried to deploy by (1) a deploy over the network and (2) a database
backup of the ReportServer database and then a restore to the Server 2003
system.
Both methods give us exactly the same error...
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'Unknown'. The expected
version is 'C.0.8.43'. To continue, update the version of the report server
database and verify access rights.
Why are we getting this error?
Regards,
GaryHi Gary,
Thank you for your posting!
Based on my research and experience, I think you need to reinstall the SP1
on the Server 2003 box.
Please let me know if you get any error message when you reinstall the SP1.
You could send the setup error log to me if you get any error. By default,
the error log file folder is C:\WINDOWS\Hotfix
Please let me know the result. Thank you!
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 Gary,
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.|||Wei,
It turned out that [apparently] the person who installed sp1 was not a
"member of the SQL Server Administrators Group" and when we followed the
recommeded fix in configuration manager the problem went away.
A mystery that remains for me is that I can't find a "SQL Server
Administrators Group". Do you know exactly what that is? Is it a user with
sysadmin privlidges?
Gary
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:t1rUdcOoGHA.2024@.TK2MSFTNGXA01.phx.gbl...
> Hi Gary,
> 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 Gary,
Thank you for the update and glad to hear the issue has been resolved.
I think the SQL Server Administrators Group means the SQL Server sysadmin
group. Members of the sysadmin fixed server role can perform any activity
in the server. By default, all members of the Windows
BUILTIN\Administrators group, the local administrator's group, are members
of the sysadmin fixed server role.
If you have any questions or concern, please feel free to let me know.
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.
Wednesday, March 21, 2012
Deployment / Version Questions
SQL Server 2000. I'm confused though as to how I can write everything on my
laptop, then copy to their server. I have an MSDN subscription and did not
realize that I cannot install the Enterprise Edition of SQL Server on XP
Pro. I can install the development edition, but am I then going to run into
problems trying to copy it over to their server?
My experience lies in Informix / DB2 and Java / JDBC, so this is new
territory for me and I appreciate the help.
Derrick LathemHi
On your the destination you will have to install a new copy of SQL that is
correctly licenced. In general I don't think your MSDN licence will not
cover their systems, although you may be able to distribute MSDE. You should
read http://www.microsoft.com/sql/techin...eskChooseEd.asp to
see which edition is most appropriate for your needs. For MSDE check out the
web site http://www.microsoft.com/sql/MSDE/
To get your database onto the destination system there are several ways, the
easiest is probably to detach/attach the database, but you could use one of
several other methods see:
http://support.microsoft.com/defaul...b;en-us;Q314546
You should also make sure that the logins are correctly set up on the
destination system.
John
"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem|||To add to John's response, the SQL Server Developer edition provides the
same features as the Enterprise edition but is licensed only for development
use. This is the appropriate choice for development if you are targeting a
server edition of SQL Server. It is included with MSDN Universal and
Enterprise subscriptions or can be acquired separately for about $50.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"lathem" <lathem@.ns.mindspring.com> wrote in message
news:yA3Ob.11830$i4.10805@.newsread1.news.atl.earth link.net...
> I'm going to write an application for a friend's business using VS .NET
and
> SQL Server 2000. I'm confused though as to how I can write everything on
my
> laptop, then copy to their server. I have an MSDN subscription and did
not
> realize that I cannot install the Enterprise Edition of SQL Server on XP
> Pro. I can install the development edition, but am I then going to run
into
> problems trying to copy it over to their server?
> My experience lies in Informix / DB2 and Java / JDBC, so this is new
> territory for me and I appreciate the help.
> Derrick Lathem
Monday, March 19, 2012
Deploying updated report but still seeing old version
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >
Deploying the Personal Web Site
Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.
My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".
CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?
CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.
POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.
Color me "confused in Kauai" ... :) KevInKauai
Hi,
1.For your first question,the difference between "Personal" and "LocalSqlServer" is like the following:
Personal connectionStrings:"Data Source=localhost;Initial Catalog=CatelogName;uid=sa;password=XXX" (For other editions than the Express edition)
LocalSqlServer connectionString:"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" . (For SqlServer Express Edition)
2.For your second question,you can change the customErrors settings into the following mode if your hoster provide the authority.
<customErrors mode="off"/>
Thanks.
|||Thanks, Jin !
My "VB guru days" were back with VB6 and I've taken a long hiatus, so I guess I'm suffering from object (or abject!) confusion. I've been trying to find the uttimate object reference but have only come up with this: http://quickstarts.asp.net/QuickStartv20/util/classbrowser.aspx
I've gone through all but the last 2 of the LearningVisualStudio (Express) videos and there really was never an application deployed in all of that.
Color me -- STILL WAY CONFUSED!
:) mahalos ... KevInKauai
Friday, March 9, 2012
Deploying Report asks for Reporting Services Login, but won't take
Report Services. I have SQL Server 2005 (full version, not the express
version) installed on the same computer. I think I did a farm install, but
installed everything on one computer. I do plan on using some linked servers
to this 2005 box to pull in data from elsewhere. My report views perfectly
in SQLServer Business Intelligence Dev.
I must have accounts set up wrong somewhere, because when I go to deploy a
report it keeps popping up a Reporting Services Login Dialog box. No matter
what account I put in, or in what format (with or without the domain portion
of the account) it just blinks and comes back to the reporting services login
dialog box.
When I try uploading from Sharepoint into the doc lib,
I have searched through other similar sounding posts, and through the
documentation and I can't figure this one out.
Here is some pertinent info:
In Reporting Services Configuration Manager:
Windows Service Identity: The service Account is set to a domain acct
(domainname\SQLSrvcA), and Windows acct is selected, with the same acct name
specified.
Web Service identity: ASP.Net Service Acct = (tried both NT
Authority\Network Service and with domainname\SQLSrvcA)
Database Setup: Credential type is Windows Credentials, with the account
name: domainname\SQLSrvcA
The link on the Sharepoint Integration page works.
I do not have Kerberos setup. Using NTLM.
Anonymous Access is turned off.
Domainname\SQLSrvcA has been added to the local admin group.
Domainname\SQLSrvcA has been added as a top level Sharepoint Site Collection
Administrator, and Full Control, Design, Contribute, Read rights.
In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
reportservertemp db, on the reportservertemp db this acct also has RSExecRole
rights. This account is also dbo for the SharePoint_AdminContent db, public
and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo for
the SharepointContent db.
The SQL Server properties are set for both SQL and Windows authentication.
SQL2005 Surface Area Feature Config shows Windows Integrated Security
enabled. (have also tested with it disabled and had the same results).
I did use the "default website", but changed the port to 8080. Going to
http:/servername:8080/reportserver works.
In IIS, looking at the properties for the default website, Anonymous access
is not enabled, and integrated windows authentication is on.
I am working on building this Shareoint site out as a portal. Folks will
only be able to get to it from within our domain. I want them to be able to
go straight to sharepoint without logging in (which was working before I
installed Reporting services). I then want them to be able to pick reports
and run them without any further authentication requests.
Thank you all for any assistance you can provide.
ShirleyWith integrated security it is looking for you (when deploying). Is your
account setup in the local administrators group on the server?
Also, I recommend against using linked servers. There is no need to do this.
Instead you have the data source setup to the server you want to pull the
data from.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> Recently setup my first Sharepoint (wss 3.0, sp2) site including
> integrated
> Report Services. I have SQL Server 2005 (full version, not the express
> version) installed on the same computer. I think I did a farm install,
> but
> installed everything on one computer. I do plan on using some linked
> servers
> to this 2005 box to pull in data from elsewhere. My report views
> perfectly
> in SQLServer Business Intelligence Dev.
> I must have accounts set up wrong somewhere, because when I go to deploy a
> report it keeps popping up a Reporting Services Login Dialog box. No
> matter
> what account I put in, or in what format (with or without the domain
> portion
> of the account) it just blinks and comes back to the reporting services
> login
> dialog box.
> When I try uploading from Sharepoint into the doc lib,
> I have searched through other similar sounding posts, and through the
> documentation and I can't figure this one out.
> Here is some pertinent info:
> In Reporting Services Configuration Manager:
> Windows Service Identity: The service Account is set to a domain acct
> (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> name
> specified.
> Web Service identity: ASP.Net Service Acct = (tried both NT
> Authority\Network Service and with domainname\SQLSrvcA)
> Database Setup: Credential type is Windows Credentials, with the account
> name: domainname\SQLSrvcA
>
> The link on the Sharepoint Integration page works.
> I do not have Kerberos setup. Using NTLM.
> Anonymous Access is turned off.
> Domainname\SQLSrvcA has been added to the local admin group.
> Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> Collection
> Administrator, and Full Control, Design, Contribute, Read rights.
> In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> reportservertemp db, on the reportservertemp db this acct also has
> RSExecRole
> rights. This account is also dbo for the SharePoint_AdminContent db,
> public
> and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> for
> the SharepointContent db.
> The SQL Server properties are set for both SQL and Windows authentication.
> SQL2005 Surface Area Feature Config shows Windows Integrated Security
> enabled. (have also tested with it disabled and had the same results).
>
> I did use the "default website", but changed the port to 8080. Going to
> http:/servername:8080/reportserver works.
> In IIS, looking at the properties for the default website, Anonymous
> access
> is not enabled, and integrated windows authentication is on.
>
> I am working on building this Shareoint site out as a portal. Folks will
> only be able to get to it from within our domain. I want them to be able
> to
> go straight to sharepoint without logging in (which was working before I
> installed Reporting services). I then want them to be able to pick reports
> and run them without any further authentication requests.
> Thank you all for any assistance you can provide.
> Shirley
>|||I have put in my own account (which is a domain admin acct, and a local admin
acct) but it still doesn't take it, it just blinks and gives me the dialog
box back.
"Bruce L-C [MVP]" wrote:
> With integrated security it is looking for you (when deploying). Is your
> account setup in the local administrators group on the server?
> Also, I recommend against using linked servers. There is no need to do this.
> Instead you have the data source setup to the server you want to pull the
> data from.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > integrated
> > Report Services. I have SQL Server 2005 (full version, not the express
> > version) installed on the same computer. I think I did a farm install,
> > but
> > installed everything on one computer. I do plan on using some linked
> > servers
> > to this 2005 box to pull in data from elsewhere. My report views
> > perfectly
> > in SQLServer Business Intelligence Dev.
> >
> > I must have accounts set up wrong somewhere, because when I go to deploy a
> > report it keeps popping up a Reporting Services Login Dialog box. No
> > matter
> > what account I put in, or in what format (with or without the domain
> > portion
> > of the account) it just blinks and comes back to the reporting services
> > login
> > dialog box.
> >
> > When I try uploading from Sharepoint into the doc lib,
> > I have searched through other similar sounding posts, and through the
> > documentation and I can't figure this one out.
> >
> > Here is some pertinent info:
> > In Reporting Services Configuration Manager:
> > Windows Service Identity: The service Account is set to a domain acct
> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> > name
> > specified.
> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > Authority\Network Service and with domainname\SQLSrvcA)
> > Database Setup: Credential type is Windows Credentials, with the account
> > name: domainname\SQLSrvcA
> >
> >
> > The link on the Sharepoint Integration page works.
> > I do not have Kerberos setup. Using NTLM.
> > Anonymous Access is turned off.
> > Domainname\SQLSrvcA has been added to the local admin group.
> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > Collection
> > Administrator, and Full Control, Design, Contribute, Read rights.
> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> > reportservertemp db, on the reportservertemp db this acct also has
> > RSExecRole
> > rights. This account is also dbo for the SharePoint_AdminContent db,
> > public
> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> > for
> > the SharepointContent db.
> >
> > The SQL Server properties are set for both SQL and Windows authentication.
> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> > enabled. (have also tested with it disabled and had the same results).
> >
> >
> > I did use the "default website", but changed the port to 8080. Going to
> > http:/servername:8080/reportserver works.
> >
> > In IIS, looking at the properties for the default website, Anonymous
> > access
> > is not enabled, and integrated windows authentication is on.
> >
> >
> > I am working on building this Shareoint site out as a portal. Folks will
> > only be able to get to it from within our domain. I want them to be able
> > to
> > go straight to sharepoint without logging in (which was working before I
> > installed Reporting services). I then want them to be able to pick reports
> > and run them without any further authentication requests.
> >
> > Thank you all for any assistance you can provide.
> > Shirley
> >
> >
>
>|||Let's back up and make sure you have RS installed properly. Even without any
report deployed you should be able to get to the reportserver. Make sure
that works for you:
http://yourserver/Reports/Pages/Folder.aspx
Does this come up?
Also, do you have a fixed IP address for the server?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>I have put in my own account (which is a domain admin acct, and a local
>admin
> acct) but it still doesn't take it, it just blinks and gives me the dialog
> box back.
>
> "Bruce L-C [MVP]" wrote:
>> With integrated security it is looking for you (when deploying). Is your
>> account setup in the local administrators group on the server?
>> Also, I recommend against using linked servers. There is no need to do
>> this.
>> Instead you have the data source setup to the server you want to pull the
>> data from.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> > integrated
>> > Report Services. I have SQL Server 2005 (full version, not the express
>> > version) installed on the same computer. I think I did a farm
>> > install,
>> > but
>> > installed everything on one computer. I do plan on using some linked
>> > servers
>> > to this 2005 box to pull in data from elsewhere. My report views
>> > perfectly
>> > in SQLServer Business Intelligence Dev.
>> >
>> > I must have accounts set up wrong somewhere, because when I go to
>> > deploy a
>> > report it keeps popping up a Reporting Services Login Dialog box. No
>> > matter
>> > what account I put in, or in what format (with or without the domain
>> > portion
>> > of the account) it just blinks and comes back to the reporting services
>> > login
>> > dialog box.
>> >
>> > When I try uploading from Sharepoint into the doc lib,
>> > I have searched through other similar sounding posts, and through the
>> > documentation and I can't figure this one out.
>> >
>> > Here is some pertinent info:
>> > In Reporting Services Configuration Manager:
>> > Windows Service Identity: The service Account is set to a domain acct
>> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
>> > name
>> > specified.
>> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > Authority\Network Service and with domainname\SQLSrvcA)
>> > Database Setup: Credential type is Windows Credentials, with the
>> > account
>> > name: domainname\SQLSrvcA
>> >
>> >
>> > The link on the Sharepoint Integration page works.
>> > I do not have Kerberos setup. Using NTLM.
>> > Anonymous Access is turned off.
>> > Domainname\SQLSrvcA has been added to the local admin group.
>> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> > Collection
>> > Administrator, and Full Control, Design, Contribute, Read rights.
>> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
>> > reportservertemp db, on the reportservertemp db this acct also has
>> > RSExecRole
>> > rights. This account is also dbo for the SharePoint_AdminContent db,
>> > public
>> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
>> > dbo
>> > for
>> > the SharepointContent db.
>> >
>> > The SQL Server properties are set for both SQL and Windows
>> > authentication.
>> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
>> > enabled. (have also tested with it disabled and had the same results).
>> >
>> >
>> > I did use the "default website", but changed the port to 8080. Going
>> > to
>> > http:/servername:8080/reportserver works.
>> >
>> > In IIS, looking at the properties for the default website, Anonymous
>> > access
>> > is not enabled, and integrated windows authentication is on.
>> >
>> >
>> > I am working on building this Shareoint site out as a portal. Folks
>> > will
>> > only be able to get to it from within our domain. I want them to be
>> > able
>> > to
>> > go straight to sharepoint without logging in (which was working before
>> > I
>> > installed Reporting services). I then want them to be able to pick
>> > reports
>> > and run them without any further authentication requests.
>> >
>> > Thank you all for any assistance you can provide.
>> > Shirley
>> >
>> >
>>|||"Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a list of folders that are from various Sharepoint sites under our top level sites.
"Bruce L-C [MVP]" wrote:
> Let's back up and make sure you have RS installed properly. Even without any
> report deployed you should be able to get to the reportserver. Make sure
> that works for you:
> http://yourserver/Reports/Pages/Folder.aspx
> Does this come up?
> Also, do you have a fixed IP address for the server?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >I have put in my own account (which is a domain admin acct, and a local
> >admin
> > acct) but it still doesn't take it, it just blinks and gives me the dialog
> > box back.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> With integrated security it is looking for you (when deploying). Is your
> >> account setup in the local administrators group on the server?
> >>
> >> Also, I recommend against using linked servers. There is no need to do
> >> this.
> >> Instead you have the data source setup to the server you want to pull the
> >> data from.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> > integrated
> >> > Report Services. I have SQL Server 2005 (full version, not the express
> >> > version) installed on the same computer. I think I did a farm
> >> > install,
> >> > but
> >> > installed everything on one computer. I do plan on using some linked
> >> > servers
> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> > perfectly
> >> > in SQLServer Business Intelligence Dev.
> >> >
> >> > I must have accounts set up wrong somewhere, because when I go to
> >> > deploy a
> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> > matter
> >> > what account I put in, or in what format (with or without the domain
> >> > portion
> >> > of the account) it just blinks and comes back to the reporting services
> >> > login
> >> > dialog box.
> >> >
> >> > When I try uploading from Sharepoint into the doc lib,
> >> > I have searched through other similar sounding posts, and through the
> >> > documentation and I can't figure this one out.
> >> >
> >> > Here is some pertinent info:
> >> > In Reporting Services Configuration Manager:
> >> > Windows Service Identity: The service Account is set to a domain acct
> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> >> > name
> >> > specified.
> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> > Database Setup: Credential type is Windows Credentials, with the
> >> > account
> >> > name: domainname\SQLSrvcA
> >> >
> >> >
> >> > The link on the Sharepoint Integration page works.
> >> > I do not have Kerberos setup. Using NTLM.
> >> > Anonymous Access is turned off.
> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> > Collection
> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> > RSExecRole
> >> > rights. This account is also dbo for the SharePoint_AdminContent db,
> >> > public
> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
> >> > dbo
> >> > for
> >> > the SharepointContent db.
> >> >
> >> > The SQL Server properties are set for both SQL and Windows
> >> > authentication.
> >> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> >> > enabled. (have also tested with it disabled and had the same results).
> >> >
> >> >
> >> > I did use the "default website", but changed the port to 8080. Going
> >> > to
> >> > http:/servername:8080/reportserver works.
> >> >
> >> > In IIS, looking at the properties for the default website, Anonymous
> >> > access
> >> > is not enabled, and integrated windows authentication is on.
> >> >
> >> >
> >> > I am working on building this Shareoint site out as a portal. Folks
> >> > will
> >> > only be able to get to it from within our domain. I want them to be
> >> > able
> >> > to
> >> > go straight to sharepoint without logging in (which was working before
> >> > I
> >> > installed Reporting services). I then want them to be able to pick
> >> > reports
> >> > and run them without any further authentication requests.
> >> >
> >> > Thank you all for any assistance you can provide.
> >> > Shirley
> >> >
> >> >
> >>
> >>
> >>
>
>|||reportserver is the RS application itself. However, just seeing the folder
list this way is not a good test. Report Manager is the portal that ships
with RS. Make sure this works for you.
http://yourserver/Reports/Pages/Folder.aspx
One other thing. Have you configured your VS project on where you are
supposed to deploy to?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> "Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a
>> > list of folders that are from various Sharepoint sites under our top
>> > level sites.
>
> "Bruce L-C [MVP]" wrote:
>> Let's back up and make sure you have RS installed properly. Even without
>> any
>> report deployed you should be able to get to the reportserver. Make sure
>> that works for you:
>> http://yourserver/Reports/Pages/Folder.aspx
>> Does this come up?
>> Also, do you have a fixed IP address for the server?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> >I have put in my own account (which is a domain admin acct, and a local
>> >admin
>> > acct) but it still doesn't take it, it just blinks and gives me the
>> > dialog
>> > box back.
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> With integrated security it is looking for you (when deploying). Is
>> >> your
>> >> account setup in the local administrators group on the server?
>> >>
>> >> Also, I recommend against using linked servers. There is no need to do
>> >> this.
>> >> Instead you have the data source setup to the server you want to pull
>> >> the
>> >> data from.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> >> > integrated
>> >> > Report Services. I have SQL Server 2005 (full version, not the
>> >> > express
>> >> > version) installed on the same computer. I think I did a farm
>> >> > install,
>> >> > but
>> >> > installed everything on one computer. I do plan on using some
>> >> > linked
>> >> > servers
>> >> > to this 2005 box to pull in data from elsewhere. My report views
>> >> > perfectly
>> >> > in SQLServer Business Intelligence Dev.
>> >> >
>> >> > I must have accounts set up wrong somewhere, because when I go to
>> >> > deploy a
>> >> > report it keeps popping up a Reporting Services Login Dialog box. No
>> >> > matter
>> >> > what account I put in, or in what format (with or without the domain
>> >> > portion
>> >> > of the account) it just blinks and comes back to the reporting
>> >> > services
>> >> > login
>> >> > dialog box.
>> >> >
>> >> > When I try uploading from Sharepoint into the doc lib,
>> >> > I have searched through other similar sounding posts, and through
>> >> > the
>> >> > documentation and I can't figure this one out.
>> >> >
>> >> > Here is some pertinent info:
>> >> > In Reporting Services Configuration Manager:
>> >> > Windows Service Identity: The service Account is set to a domain
>> >> > acct
>> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
>> >> > acct
>> >> > name
>> >> > specified.
>> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> >> > Database Setup: Credential type is Windows Credentials, with the
>> >> > account
>> >> > name: domainname\SQLSrvcA
>> >> >
>> >> >
>> >> > The link on the Sharepoint Integration page works.
>> >> > I do not have Kerberos setup. Using NTLM.
>> >> > Anonymous Access is turned off.
>> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> >> > Collection
>> >> > Administrator, and Full Control, Design, Contribute, Read rights.
>> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
>> >> > the
>> >> > reportservertemp db, on the reportservertemp db this acct also has
>> >> > RSExecRole
>> >> > rights. This account is also dbo for the SharePoint_AdminContent
>> >> > db,
>> >> > public
>> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
>> >> > db,
>> >> > dbo
>> >> > for
>> >> > the SharepointContent db.
>> >> >
>> >> > The SQL Server properties are set for both SQL and Windows
>> >> > authentication.
>> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> >> > Security
>> >> > enabled. (have also tested with it disabled and had the same
>> >> > results).
>> >> >
>> >> >
>> >> > I did use the "default website", but changed the port to 8080.
>> >> > Going
>> >> > to
>> >> > http:/servername:8080/reportserver works.
>> >> >
>> >> > In IIS, looking at the properties for the default website, Anonymous
>> >> > access
>> >> > is not enabled, and integrated windows authentication is on.
>> >> >
>> >> >
>> >> > I am working on building this Shareoint site out as a portal. Folks
>> >> > will
>> >> > only be able to get to it from within our domain. I want them to be
>> >> > able
>> >> > to
>> >> > go straight to sharepoint without logging in (which was working
>> >> > before
>> >> > I
>> >> > installed Reporting services). I then want them to be able to pick
>> >> > reports
>> >> > and run them without any further authentication requests.
>> >> >
>> >> > Thank you all for any assistance you can provide.
>> >> > Shirley
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||My understanding is that once you install RS in Sharepoint integrated mode,
that Report Manager is no longer accessible. That RS management is only
accessible via Sharepoint.
?
Shirley
"Bruce L-C [MVP]" wrote:
> reportserver is the RS application itself. However, just seeing the folder
> list this way is not a good test. Report Manager is the portal that ships
> with RS. Make sure this works for you.
> http://yourserver/Reports/Pages/Folder.aspx
> One other thing. Have you configured your VS project on where you are
> supposed to deploy to?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > "Going
> >> > to
> >> > http:/servername:8080/reportserver works." And I can browse into a
> >> > list of folders that are from various Sharepoint sites under our top
> >> > level sites.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Let's back up and make sure you have RS installed properly. Even without
> >> any
> >> report deployed you should be able to get to the reportserver. Make sure
> >> that works for you:
> >>
> >> http://yourserver/Reports/Pages/Folder.aspx
> >>
> >> Does this come up?
> >>
> >> Also, do you have a fixed IP address for the server?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >> >I have put in my own account (which is a domain admin acct, and a local
> >> >admin
> >> > acct) but it still doesn't take it, it just blinks and gives me the
> >> > dialog
> >> > box back.
> >> >
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> With integrated security it is looking for you (when deploying). Is
> >> >> your
> >> >> account setup in the local administrators group on the server?
> >> >>
> >> >> Also, I recommend against using linked servers. There is no need to do
> >> >> this.
> >> >> Instead you have the data source setup to the server you want to pull
> >> >> the
> >> >> data from.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> >> > integrated
> >> >> > Report Services. I have SQL Server 2005 (full version, not the
> >> >> > express
> >> >> > version) installed on the same computer. I think I did a farm
> >> >> > install,
> >> >> > but
> >> >> > installed everything on one computer. I do plan on using some
> >> >> > linked
> >> >> > servers
> >> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> >> > perfectly
> >> >> > in SQLServer Business Intelligence Dev.
> >> >> >
> >> >> > I must have accounts set up wrong somewhere, because when I go to
> >> >> > deploy a
> >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> >> > matter
> >> >> > what account I put in, or in what format (with or without the domain
> >> >> > portion
> >> >> > of the account) it just blinks and comes back to the reporting
> >> >> > services
> >> >> > login
> >> >> > dialog box.
> >> >> >
> >> >> > When I try uploading from Sharepoint into the doc lib,
> >> >> > I have searched through other similar sounding posts, and through
> >> >> > the
> >> >> > documentation and I can't figure this one out.
> >> >> >
> >> >> > Here is some pertinent info:
> >> >> > In Reporting Services Configuration Manager:
> >> >> > Windows Service Identity: The service Account is set to a domain
> >> >> > acct
> >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> >> >> > acct
> >> >> > name
> >> >> > specified.
> >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> >> > Database Setup: Credential type is Windows Credentials, with the
> >> >> > account
> >> >> > name: domainname\SQLSrvcA
> >> >> >
> >> >> >
> >> >> > The link on the Sharepoint Integration page works.
> >> >> > I do not have Kerberos setup. Using NTLM.
> >> >> > Anonymous Access is turned off.
> >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> >> > Collection
> >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> >> >> > the
> >> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> >> > RSExecRole
> >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> >> >> > db,
> >> >> > public
> >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> >> >> > db,
> >> >> > dbo
> >> >> > for
> >> >> > the SharepointContent db.
> >> >> >
> >> >> > The SQL Server properties are set for both SQL and Windows
> >> >> > authentication.
> >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> >> >> > Security
> >> >> > enabled. (have also tested with it disabled and had the same
> >> >> > results).
> >> >> >
> >> >> >
> >> >> > I did use the "default website", but changed the port to 8080.
> >> >> > Going
> >> >> > to
> >> >> > http:/servername:8080/reportserver works.
> >> >> >
> >> >> > In IIS, looking at the properties for the default website, Anonymous
> >> >> > access
> >> >> > is not enabled, and integrated windows authentication is on.
> >> >> >
> >> >> >
> >> >> > I am working on building this Shareoint site out as a portal. Folks
> >> >> > will
> >> >> > only be able to get to it from within our domain. I want them to be
> >> >> > able
> >> >> > to
> >> >> > go straight to sharepoint without logging in (which was working
> >> >> > before
> >> >> > I
> >> >> > installed Reporting services). I then want them to be able to pick
> >> >> > reports
> >> >> > and run them without any further authentication requests.
> >> >> >
> >> >> > Thank you all for any assistance you can provide.
> >> >> > Shirley
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have attempted accessing the link/path you suggested and get the following:
"The operation is not supported on a report server that is configured to run
in Sharepoint integrated mode."
"ShirleyH" wrote:
> My understanding is that once you install RS in Sharepoint integrated mode,
> that Report Manager is no longer accessible. That RS management is only
> accessible via Sharepoint.
> ?
> Shirley
> "Bruce L-C [MVP]" wrote:
> > reportserver is the RS application itself. However, just seeing the folder
> > list this way is not a good test. Report Manager is the portal that ships
> > with RS. Make sure this works for you.
> >
> > http://yourserver/Reports/Pages/Folder.aspx
> >
> > One other thing. Have you configured your VS project on where you are
> > supposed to deploy to?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > > "Going
> > >> > to
> > >> > http:/servername:8080/reportserver works." And I can browse into a
> > >> > list of folders that are from various Sharepoint sites under our top
> > >> > level sites.
> > >
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> Let's back up and make sure you have RS installed properly. Even without
> > >> any
> > >> report deployed you should be able to get to the reportserver. Make sure
> > >> that works for you:
> > >>
> > >> http://yourserver/Reports/Pages/Folder.aspx
> > >>
> > >> Does this come up?
> > >>
> > >> Also, do you have a fixed IP address for the server?
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> > >> >I have put in my own account (which is a domain admin acct, and a local
> > >> >admin
> > >> > acct) but it still doesn't take it, it just blinks and gives me the
> > >> > dialog
> > >> > box back.
> > >> >
> > >> >
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> With integrated security it is looking for you (when deploying). Is
> > >> >> your
> > >> >> account setup in the local administrators group on the server?
> > >> >>
> > >> >> Also, I recommend against using linked servers. There is no need to do
> > >> >> this.
> > >> >> Instead you have the data source setup to the server you want to pull
> > >> >> the
> > >> >> data from.
> > >> >>
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > >> >> > integrated
> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
> > >> >> > express
> > >> >> > version) installed on the same computer. I think I did a farm
> > >> >> > install,
> > >> >> > but
> > >> >> > installed everything on one computer. I do plan on using some
> > >> >> > linked
> > >> >> > servers
> > >> >> > to this 2005 box to pull in data from elsewhere. My report views
> > >> >> > perfectly
> > >> >> > in SQLServer Business Intelligence Dev.
> > >> >> >
> > >> >> > I must have accounts set up wrong somewhere, because when I go to
> > >> >> > deploy a
> > >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> > >> >> > matter
> > >> >> > what account I put in, or in what format (with or without the domain
> > >> >> > portion
> > >> >> > of the account) it just blinks and comes back to the reporting
> > >> >> > services
> > >> >> > login
> > >> >> > dialog box.
> > >> >> >
> > >> >> > When I try uploading from Sharepoint into the doc lib,
> > >> >> > I have searched through other similar sounding posts, and through
> > >> >> > the
> > >> >> > documentation and I can't figure this one out.
> > >> >> >
> > >> >> > Here is some pertinent info:
> > >> >> > In Reporting Services Configuration Manager:
> > >> >> > Windows Service Identity: The service Account is set to a domain
> > >> >> > acct
> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> > >> >> > acct
> > >> >> > name
> > >> >> > specified.
> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> > >> >> > Database Setup: Credential type is Windows Credentials, with the
> > >> >> > account
> > >> >> > name: domainname\SQLSrvcA
> > >> >> >
> > >> >> >
> > >> >> > The link on the Sharepoint Integration page works.
> > >> >> > I do not have Kerberos setup. Using NTLM.
> > >> >> > Anonymous Access is turned off.
> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > >> >> > Collection
> > >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> > >> >> > the
> > >> >> > reportservertemp db, on the reportservertemp db this acct also has
> > >> >> > RSExecRole
> > >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> > >> >> > db,
> > >> >> > public
> > >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> > >> >> > db,
> > >> >> > dbo
> > >> >> > for
> > >> >> > the SharepointContent db.
> > >> >> >
> > >> >> > The SQL Server properties are set for both SQL and Windows
> > >> >> > authentication.
> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> > >> >> > Security
> > >> >> > enabled. (have also tested with it disabled and had the same
> > >> >> > results).
> > >> >> >
> > >> >> >
> > >> >> > I did use the "default website", but changed the port to 8080.
> > >> >> > Going
> > >> >> > to
> > >> >> > http:/servername:8080/reportserver works.
> > >> >> >
> > >> >> > In IIS, looking at the properties for the default website, Anonymous
> > >> >> > access
> > >> >> > is not enabled, and integrated windows authentication is on.
> > >> >> >
> > >> >> >
> > >> >> > I am working on building this Shareoint site out as a portal. Folks
> > >> >> > will
> > >> >> > only be able to get to it from within our domain. I want them to be
> > >> >> > able
> > >> >> > to
> > >> >> > go straight to sharepoint without logging in (which was working
> > >> >> > before
> > >> >> > I
> > >> >> > installed Reporting services). I then want them to be able to pick
> > >> >> > reports
> > >> >> > and run them without any further authentication requests.
> > >> >> >
> > >> >> > Thank you all for any assistance you can provide.
> > >> >> > Shirley
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Ahh, sorry, I didn't realize this (I don't run Sharepoint). This very well
could be a sharepoint / reporting services integration issue.
I'm afraid I can't help you with this. I'm out of ideas.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:9E350FCD-D4DE-4E80-9BD9-09EB7ADFF0AA@.microsoft.com...
>I have attempted accessing the link/path you suggested and get the
>following:
> "The operation is not supported on a report server that is configured to
> run
> in Sharepoint integrated mode."
> "ShirleyH" wrote:
>> My understanding is that once you install RS in Sharepoint integrated
>> mode,
>> that Report Manager is no longer accessible. That RS management is only
>> accessible via Sharepoint.
>> ?
>> Shirley
>> "Bruce L-C [MVP]" wrote:
>> > reportserver is the RS application itself. However, just seeing the
>> > folder
>> > list this way is not a good test. Report Manager is the portal that
>> > ships
>> > with RS. Make sure this works for you.
>> >
>> > http://yourserver/Reports/Pages/Folder.aspx
>> >
>> > One other thing. Have you configured your VS project on where you are
>> > supposed to deploy to?
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> >
>> >
>> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
>> > > "Going
>> > >> > to
>> > >> > http:/servername:8080/reportserver works." And I can browse into
>> > >> > a
>> > >> > list of folders that are from various Sharepoint sites under our
>> > >> > top
>> > >> > level sites.
>> > >
>> > >
>> > >
>> > > "Bruce L-C [MVP]" wrote:
>> > >
>> > >> Let's back up and make sure you have RS installed properly. Even
>> > >> without
>> > >> any
>> > >> report deployed you should be able to get to the reportserver. Make
>> > >> sure
>> > >> that works for you:
>> > >>
>> > >> http://yourserver/Reports/Pages/Folder.aspx
>> > >>
>> > >> Does this come up?
>> > >>
>> > >> Also, do you have a fixed IP address for the server?
>> > >>
>> > >>
>> > >> --
>> > >> Bruce Loehle-Conger
>> > >> MVP SQL Server Reporting Services
>> > >>
>> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> > >> >I have put in my own account (which is a domain admin acct, and a
>> > >> >local
>> > >> >admin
>> > >> > acct) but it still doesn't take it, it just blinks and gives me
>> > >> > the
>> > >> > dialog
>> > >> > box back.
>> > >> >
>> > >> >
>> > >> >
>> > >> > "Bruce L-C [MVP]" wrote:
>> > >> >
>> > >> >> With integrated security it is looking for you (when deploying).
>> > >> >> Is
>> > >> >> your
>> > >> >> account setup in the local administrators group on the server?
>> > >> >>
>> > >> >> Also, I recommend against using linked servers. There is no need
>> > >> >> to do
>> > >> >> this.
>> > >> >> Instead you have the data source setup to the server you want to
>> > >> >> pull
>> > >> >> the
>> > >> >> data from.
>> > >> >>
>> > >> >>
>> > >> >> --
>> > >> >> Bruce Loehle-Conger
>> > >> >> MVP SQL Server Reporting Services
>> > >> >>
>> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site
>> > >> >> > including
>> > >> >> > integrated
>> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
>> > >> >> > express
>> > >> >> > version) installed on the same computer. I think I did a farm
>> > >> >> > install,
>> > >> >> > but
>> > >> >> > installed everything on one computer. I do plan on using some
>> > >> >> > linked
>> > >> >> > servers
>> > >> >> > to this 2005 box to pull in data from elsewhere. My report
>> > >> >> > views
>> > >> >> > perfectly
>> > >> >> > in SQLServer Business Intelligence Dev.
>> > >> >> >
>> > >> >> > I must have accounts set up wrong somewhere, because when I go
>> > >> >> > to
>> > >> >> > deploy a
>> > >> >> > report it keeps popping up a Reporting Services Login Dialog
>> > >> >> > box. No
>> > >> >> > matter
>> > >> >> > what account I put in, or in what format (with or without the
>> > >> >> > domain
>> > >> >> > portion
>> > >> >> > of the account) it just blinks and comes back to the reporting
>> > >> >> > services
>> > >> >> > login
>> > >> >> > dialog box.
>> > >> >> >
>> > >> >> > When I try uploading from Sharepoint into the doc lib,
>> > >> >> > I have searched through other similar sounding posts, and
>> > >> >> > through
>> > >> >> > the
>> > >> >> > documentation and I can't figure this one out.
>> > >> >> >
>> > >> >> > Here is some pertinent info:
>> > >> >> > In Reporting Services Configuration Manager:
>> > >> >> > Windows Service Identity: The service Account is set to a
>> > >> >> > domain
>> > >> >> > acct
>> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the
>> > >> >> > same
>> > >> >> > acct
>> > >> >> > name
>> > >> >> > specified.
>> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> > >> >> > Database Setup: Credential type is Windows Credentials, with
>> > >> >> > the
>> > >> >> > account
>> > >> >> > name: domainname\SQLSrvcA
>> > >> >> >
>> > >> >> >
>> > >> >> > The link on the Sharepoint Integration page works.
>> > >> >> > I do not have Kerberos setup. Using NTLM.
>> > >> >> > Anonymous Access is turned off.
>> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint
>> > >> >> > Site
>> > >> >> > Collection
>> > >> >> > Administrator, and Full Control, Design, Contribute, Read
>> > >> >> > rights.
>> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver
>> > >> >> > db,
>> > >> >> > the
>> > >> >> > reportservertemp db, on the reportservertemp db this acct also
>> > >> >> > has
>> > >> >> > RSExecRole
>> > >> >> > rights. This account is also dbo for the
>> > >> >> > SharePoint_AdminContent
>> > >> >> > db,
>> > >> >> > public
>> > >> >> > and WSS_Content_Application_Pools rights to the
>> > >> >> > Sharepoint_Config
>> > >> >> > db,
>> > >> >> > dbo
>> > >> >> > for
>> > >> >> > the SharepointContent db.
>> > >> >> >
>> > >> >> > The SQL Server properties are set for both SQL and Windows
>> > >> >> > authentication.
>> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> > >> >> > Security
>> > >> >> > enabled. (have also tested with it disabled and had the same
>> > >> >> > results).
>> > >> >> >
>> > >> >> >
>> > >> >> > I did use the "default website", but changed the port to 8080.
>> > >> >> > Going
>> > >> >> > to
>> > >> >> > http:/servername:8080/reportserver works.
>> > >> >> >
>> > >> >> > In IIS, looking at the properties for the default website,
>> > >> >> > Anonymous
>> > >> >> > access
>> > >> >> > is not enabled, and integrated windows authentication is on.
>> > >> >> >
>> > >> >> >
>> > >> >> > I am working on building this Shareoint site out as a portal.
>> > >> >> > Folks
>> > >> >> > will
>> > >> >> > only be able to get to it from within our domain. I want them
>> > >> >> > to be
>> > >> >> > able
>> > >> >> > to
>> > >> >> > go straight to sharepoint without logging in (which was working
>> > >> >> > before
>> > >> >> > I
>> > >> >> > installed Reporting services). I then want them to be able to
>> > >> >> > pick
>> > >> >> > reports
>> > >> >> > and run them without any further authentication requests.
>> > >> >> >
>> > >> >> > Thank you all for any assistance you can provide.
>> > >> >> > Shirley
>> > >> >> >
>> > >> >> >
>> > >> >>
>> > >> >>
>> > >> >>
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||having the same issue with same set-up type credentials for the admin
in SharePoint and SQL... known issue, but was wondering if you had
anyone help you resolve it|||"Juan.Carlos.Novoa@.gmail.com" wrote:
> having the same issue with same set-up type credentials for the admin
> in SharePoint and SQL... known issue, but was wondering if you had
> anyone help you resolve it
>
I am also having the smae issue. Has there been any solution determined on
this?