Deploying Report asks for Reporting Services Login, but won't take

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.
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?