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?
Showing posts with label asks. Show all posts
Showing posts with label asks. Show all posts
Friday, March 9, 2012
Sunday, February 19, 2012
Deploy from visual studio doesn't work
Hello, I created a new Rs server, but when I try to deploy from visual studio, it asks me for username and password multiple times and never deploys.
I am an administrator on the RS server, even on the report folders.
I can access via IE to the report manager.
When you access the Report Manager or Report Server (http://servername/ReportServer) via IE, does IE ask you to authenticate? In addition, what deployment settings have been specified in the BIDS project properties?|||I have the same problem. I can download reports with IE. IE don't ask me for my login or password (it uses the windows session login).
But when I will deploy reports with Visual Studio, the software ask me for my login and password.
I can fill all the possibility (domain\login, login, upper case, lower case, ...) the studio ask me always for my login.
Cant' visual studio use the windows session for login?
Or must I have a particular role?
Regards,
|||VS.NET shouldn't ask you for user id and password. Probably, there is something wrong with your domain setup. What server ahve you specified on the project properties? Did you use the server name or IP address? What happens when you deploy to localhost?|||I can deploy on a local server.
I use the server name.
The server and my computer (on which is install VS.NET) are on the same domain.
|||Then, for some reason, the server is rejecting the Windows integrated security handshake. Using a trace listener, such as tcpTrace, will help you see the error page returned from the server. I am suprised though that this doesn't happen when you use IE to browse the server, e.g. http://server/reports. If IE doesn't prompt you then I am out of options.|||The strange this is that I disabled the proxy settings on Internet Explorer and now I can deploy from visual studio.|||You may try putting that server name in the IE trusted zone.|||I will first say that I use SQL Server for the first time.
I have understand my problem and logicaly resolv it. There is two URL, one for the Web site (In my case http://server/Reports) and an other one for the web service (in my case http://server/ReportManager).
So I have tried to deploy report using the Web site URL. When I use the web service URL all it's done.
Thank you every one for our answer.
|||I'm pretty new to Reporting Services and Sharepoint. I am having the same problem, with the Reporting Services login box displaying continuosly during deploy.
Although I have read this thread, and made the changes (or attempted but did it incorrectly) I am still having difficulty. I am running RS in integrated mode (with Sharepoint).
I can browse out to Report Services (IE6) http://servername:8080/reportserver. There is a directory there that matches the server name. Browsing into that folder I see directories for each of the sharepoint subsites including one called "MYReports" which is where I set up Reporting Services. When I browse into that folder there is one for Report Services Reports (which is the library I set up to hold all the reports). When I browse into that folder I see the reports I have gotten into Sharepoint by uploading them from Sharepoint. At this point the path shown (on the screen - not in the website address portion - that one has lots of strange characters in it) is http://servername/MyReports/Report Services Reports.
The url to get the main Sharepoint site is: http://servername/default.aspx
When I set the TargetServerUrl to http://servername:8080/reportserver - it tells me (essentially) that that isn't supported in integrated with sharepoint mode. When I use http://servername:8080 I get the repeated login prompts.
I have the TargetReportFolder set to: http://servername:8080/MyReports/Report Services Reports/ (just like when I browse there)
the targetDataSourceFolder is set to: http://servername:8080/MyReports/Report Services Reports/Data Sources (a folder to store all the data sources in).
Any help with what I am doing wrong is appreciated.
Shirley
|||
In SharePoint Integrated mode you need TargetReportFolder and TargetDataSourceFolder to point directly to SharePoint Document Library URLs.
You may want to use the following approach:
TargetServerURL http://servername/
TargetReportFolder http://servername/MyReports/Report Services Reports/
TargetDataSourceFolder http://servername/MyReports/Report Services Reports/Data Sources
Additionally, does info in the following thread help?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1156609&SiteID=1
HTH
Prash
Deploy from visual studio doesn't work
Hello, I created a new Rs server, but when I try to deploy from visual studio, it asks me for username and password multiple times and never deploys.
I am an administrator on the RS server, even on the report folders.
I can access via IE to the report manager.
When you access the Report Manager or Report Server (http://servername/ReportServer) via IE, does IE ask you to authenticate? In addition, what deployment settings have been specified in the BIDS project properties?|||I have the same problem. I can download reports with IE. IE don't ask me for my login or password (it uses the windows session login).
But when I will deploy reports with Visual Studio, the software ask me for my login and password.
I can fill all the possibility (domain\login, login, upper case, lower case, ...) the studio ask me always for my login.
Cant' visual studio use the windows session for login?
Or must I have a particular role?
Regards,
|||VS.NET shouldn't ask you for user id and password. Probably, there is something wrong with your domain setup. What server ahve you specified on the project properties? Did you use the server name or IP address? What happens when you deploy to localhost?|||I can deploy on a local server.
I use the server name.
The server and my computer (on which is install VS.NET) are on the same domain.
|||Then, for some reason, the server is rejecting the Windows integrated security handshake. Using a trace listener, such as tcpTrace, will help you see the error page returned from the server. I am suprised though that this doesn't happen when you use IE to browse the server, e.g. http://server/reports. If IE doesn't prompt you then I am out of options.|||The strange this is that I disabled the proxy settings on Internet Explorer and now I can deploy from visual studio.|||You may try putting that server name in the IE trusted zone.|||I will first say that I use SQL Server for the first time.
I have understand my problem and logicaly resolv it. There is two URL, one for the Web site (In my case http://server/Reports) and an other one for the web service (in my case http://server/ReportManager).
So I have tried to deploy report using the Web site URL. When I use the web service URL all it's done.
Thank you every one for our answer.
|||I'm pretty new to Reporting Services and Sharepoint. I am having the same problem, with the Reporting Services login box displaying continuosly during deploy.
Although I have read this thread, and made the changes (or attempted but did it incorrectly) I am still having difficulty. I am running RS in integrated mode (with Sharepoint).
I can browse out to Report Services (IE6) http://servername:8080/reportserver. There is a directory there that matches the server name. Browsing into that folder I see directories for each of the sharepoint subsites including one called "MYReports" which is where I set up Reporting Services. When I browse into that folder there is one for Report Services Reports (which is the library I set up to hold all the reports). When I browse into that folder I see the reports I have gotten into Sharepoint by uploading them from Sharepoint. At this point the path shown (on the screen - not in the website address portion - that one has lots of strange characters in it) is http://servername/MyReports/Report Services Reports.
The url to get the main Sharepoint site is: http://servername/default.aspx
When I set the TargetServerUrl to http://servername:8080/reportserver - it tells me (essentially) that that isn't supported in integrated with sharepoint mode. When I use http://servername:8080 I get the repeated login prompts.
I have the TargetReportFolder set to: http://servername:8080/MyReports/Report Services Reports/ (just like when I browse there)
the targetDataSourceFolder is set to: http://servername:8080/MyReports/Report Services Reports/Data Sources (a folder to store all the data sources in).
Any help with what I am doing wrong is appreciated.
Shirley
|||
In SharePoint Integrated mode you need TargetReportFolder and TargetDataSourceFolder to point directly to SharePoint Document Library URLs.
You may want to use the following approach:
TargetServerURL http://servername/
TargetReportFolder http://servername/MyReports/Report Services Reports/
TargetDataSourceFolder http://servername/MyReports/Report Services Reports/Data Sources
Additionally, does info in the following thread help?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1156609&SiteID=1
HTH
Prash
Deploy from visual studio doesnt work
Hello, I created a new Rs server, but when I try to deploy from visual studio, it asks me for username and password multiple times and never deploys.
I am an administrator on the RS server, even on the report folders.
I can access via IE to the report manager.
When you access the Report Manager or Report Server (http://servername/ReportServer) via IE, does IE ask you to authenticate? In addition, what deployment settings have been specified in the BIDS project properties?|||I have the same problem. I can download reports with IE. IE don't ask me for my login or password (it uses the windows session login).
But when I will deploy reports with Visual Studio, the software ask me for my login and password.
I can fill all the possibility (domain\login, login, upper case, lower case, ...) the studio ask me always for my login.
Cant' visual studio use the windows session for login?
Or must I have a particular role?
Regards,
|||VS.NET shouldn't ask you for user id and password. Probably, there is something wrong with your domain setup. What server ahve you specified on the project properties? Did you use the server name or IP address? What happens when you deploy to localhost?|||I can deploy on a local server.
I use the server name.
The server and my computer (on which is install VS.NET) are on the same domain.
|||Then, for some reason, the server is rejecting the Windows integrated security handshake. Using a trace listener, such as tcpTrace, will help you see the error page returned from the server. I am suprised though that this doesn't happen when you use IE to browse the server, e.g. http://server/reports. If IE doesn't prompt you then I am out of options.|||The strange this is that I disabled the proxy settings on Internet Explorer and now I can deploy from visual studio.|||You may try putting that server name in the IE trusted zone.|||I will first say that I use SQL Server for the first time.
I have understand my problem and logicaly resolv it. There is two URL, one for the Web site (In my case http://server/Reports) and an other one for the web service (in my case http://server/ReportManager).
So I have tried to deploy report using the Web site URL. When I use the web service URL all it's done.
Thank you every one for our answer.
|||I'm pretty new to Reporting Services and Sharepoint. I am having the same problem, with the Reporting Services login box displaying continuosly during deploy.
Although I have read this thread, and made the changes (or attempted but did it incorrectly) I am still having difficulty. I am running RS in integrated mode (with Sharepoint).
I can browse out to Report Services (IE6) http://servername:8080/reportserver. There is a directory there that matches the server name. Browsing into that folder I see directories for each of the sharepoint subsites including one called "MYReports" which is where I set up Reporting Services. When I browse into that folder there is one for Report Services Reports (which is the library I set up to hold all the reports). When I browse into that folder I see the reports I have gotten into Sharepoint by uploading them from Sharepoint. At this point the path shown (on the screen - not in the website address portion - that one has lots of strange characters in it) is http://servername/MyReports/Report Services Reports.
The url to get the main Sharepoint site is: http://servername/default.aspx
When I set the TargetServerUrl to http://servername:8080/reportserver - it tells me (essentially) that that isn't supported in integrated with sharepoint mode. When I use http://servername:8080 I get the repeated login prompts.
I have the TargetReportFolder set to: http://servername:8080/MyReports/Report Services Reports/ (just like when I browse there)
the targetDataSourceFolder is set to: http://servername:8080/MyReports/Report Services Reports/Data Sources (a folder to store all the data sources in).
Any help with what I am doing wrong is appreciated.
Shirley
|||
In SharePoint Integrated mode you need TargetReportFolder and TargetDataSourceFolder to point directly to SharePoint Document Library URLs.
You may want to use the following approach:
TargetServerURL http://servername/
TargetReportFolder http://servername/MyReports/Report Services Reports/
TargetDataSourceFolder http://servername/MyReports/Report Services Reports/Data Sources
Additionally, does info in the following thread help?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1156609&SiteID=1
HTH
Prash
Deploy Asks for Username and Password - Can't Deploy
Today I installed SP2 on my client and rebooted.
Since then, when I try to deploy from Visual Studio, I get a box that pops
up that asks for a username and password. I tried entering everything under
the sun but I can't get past it.
The user I am logged in as is part of the Administrators group on the RS
server. Beyond that, none of the server config has changed.
What is going on here? I can't deploy!
Thanks,
HunterI experience this problem too. I even created a new user name under the
security properties tab, for my user account, "Administrator"
"Hunter Hillegas" wrote:
> Today I installed SP2 on my client and rebooted.
> Since then, when I try to deploy from Visual Studio, I get a box that pops
> up that asks for a username and password. I tried entering everything under
> the sun but I can't get past it.
> The user I am logged in as is part of the Administrators group on the RS
> server. Beyond that, none of the server config has changed.
> What is going on here? I can't deploy!
> Thanks,
> Hunter|||Try this
"create a DWORD entry called DisableLoopbackCheck to
HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"
I hope, this helps.
Barbaros Saglamtimur
MCDBA, MCAD
"Chiara" <Chiara@.discussions.microsoft.com> wrote in message
news:66581066-291D-47A1-A577-38E89BA9E6A3@.microsoft.com...
>I experience this problem too. I even created a new user name under the
> security properties tab, for my user account, "Administrator"
> "Hunter Hillegas" wrote:
>> Today I installed SP2 on my client and rebooted.
>> Since then, when I try to deploy from Visual Studio, I get a box that
>> pops
>> up that asks for a username and password. I tried entering everything
>> under
>> the sun but I can't get past it.
>> The user I am logged in as is part of the Administrators group on the RS
>> server. Beyond that, none of the server config has changed.
>> What is going on here? I can't deploy!
>> Thanks,
>> Hunter|||Thanks for posting this. I gave it a try but I am still greeted with the same
password prompt that accepts no credentials.
Any other ideas out there?
"saglamtimur" wrote:
> Try this
> "create a DWORD entry called DisableLoopbackCheck to
> HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"
>
> I hope, this helps.
> Barbaros Saglamtimur
> MCDBA, MCAD
>
> "Chiara" <Chiara@.discussions.microsoft.com> wrote in message
> news:66581066-291D-47A1-A577-38E89BA9E6A3@.microsoft.com...
> >I experience this problem too. I even created a new user name under the
> > security properties tab, for my user account, "Administrator"
> >
> > "Hunter Hillegas" wrote:
> >
> >> Today I installed SP2 on my client and rebooted.
> >>
> >> Since then, when I try to deploy from Visual Studio, I get a box that
> >> pops
> >> up that asks for a username and password. I tried entering everything
> >> under
> >> the sun but I can't get past it.
> >>
> >> The user I am logged in as is part of the Administrators group on the RS
> >> server. Beyond that, none of the server config has changed.
> >>
> >> What is going on here? I can't deploy!
> >>
> >> Thanks,
> >> Hunter
>
>
Since then, when I try to deploy from Visual Studio, I get a box that pops
up that asks for a username and password. I tried entering everything under
the sun but I can't get past it.
The user I am logged in as is part of the Administrators group on the RS
server. Beyond that, none of the server config has changed.
What is going on here? I can't deploy!
Thanks,
HunterI experience this problem too. I even created a new user name under the
security properties tab, for my user account, "Administrator"
"Hunter Hillegas" wrote:
> Today I installed SP2 on my client and rebooted.
> Since then, when I try to deploy from Visual Studio, I get a box that pops
> up that asks for a username and password. I tried entering everything under
> the sun but I can't get past it.
> The user I am logged in as is part of the Administrators group on the RS
> server. Beyond that, none of the server config has changed.
> What is going on here? I can't deploy!
> Thanks,
> Hunter|||Try this
"create a DWORD entry called DisableLoopbackCheck to
HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"
I hope, this helps.
Barbaros Saglamtimur
MCDBA, MCAD
"Chiara" <Chiara@.discussions.microsoft.com> wrote in message
news:66581066-291D-47A1-A577-38E89BA9E6A3@.microsoft.com...
>I experience this problem too. I even created a new user name under the
> security properties tab, for my user account, "Administrator"
> "Hunter Hillegas" wrote:
>> Today I installed SP2 on my client and rebooted.
>> Since then, when I try to deploy from Visual Studio, I get a box that
>> pops
>> up that asks for a username and password. I tried entering everything
>> under
>> the sun but I can't get past it.
>> The user I am logged in as is part of the Administrators group on the RS
>> server. Beyond that, none of the server config has changed.
>> What is going on here? I can't deploy!
>> Thanks,
>> Hunter|||Thanks for posting this. I gave it a try but I am still greeted with the same
password prompt that accepts no credentials.
Any other ideas out there?
"saglamtimur" wrote:
> Try this
> "create a DWORD entry called DisableLoopbackCheck to
> HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"
>
> I hope, this helps.
> Barbaros Saglamtimur
> MCDBA, MCAD
>
> "Chiara" <Chiara@.discussions.microsoft.com> wrote in message
> news:66581066-291D-47A1-A577-38E89BA9E6A3@.microsoft.com...
> >I experience this problem too. I even created a new user name under the
> > security properties tab, for my user account, "Administrator"
> >
> > "Hunter Hillegas" wrote:
> >
> >> Today I installed SP2 on my client and rebooted.
> >>
> >> Since then, when I try to deploy from Visual Studio, I get a box that
> >> pops
> >> up that asks for a username and password. I tried entering everything
> >> under
> >> the sun but I can't get past it.
> >>
> >> The user I am logged in as is part of the Administrators group on the RS
> >> server. Beyond that, none of the server config has changed.
> >>
> >> What is going on here? I can't deploy!
> >>
> >> Thanks,
> >> Hunter
>
>
Subscribe to:
Posts (Atom)