|
|
You're in the
sql server reporting services
group:Can't access Reporting with Management Studio
sql server reporting services:
Did you check SQL Server Configuration Manager to see if the Reporting
Services service is started? It could also be a rights issue. Do you have sysadmin rights on your MSSQL server? -- Alain Quesnel alainsansspam@logiquel.com www.logiquel.com [quoted text, click to view] "Joel" <Joel@discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... > Bonjour! > > I can't have access with my management studio to Reporting services > (2005)installed on my web server. (Cannot connect to...)Do my developpers > needs special rights? > > Regards, Joel :)
Whoa! To deploy a report to RS does not need sysadmin rights. There is no
way that developers should have sysadmin rights on SQL server. RS does everything based on its roles. The local administrators role on the server (server not SQL Server) automatically puts all users in that role with the rights to do anything (subscriptions, deploy reports etc) to Reporting Services. However, individual users or groups can be added to roles. In Report Manager, be at Home. Click on the Properties tab, Click New Role Assignments. Try Content Manager or Publisher. One of those roles will work. All other folders inherit from home. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... > Did you check SQL Server Configuration Manager to see if the Reporting > Services service is started? It could also be a rights issue. Do you have > sysadmin rights on your MSSQL server? > > -- > > Alain Quesnel > alainsansspam@logiquel.com > > www.logiquel.com > > > "Joel" <Joel@discussions.microsoft.com> wrote in message > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... >> Bonjour! >> >> I can't have access with my management studio to Reporting services >> (2005)installed on my web server. (Cannot connect to...)Do my developpers >> needs special rights? >> >> Regards, Joel :) >
Bonjour!
I can't have access with my management studio to Reporting services (2005)installed on my web server. (Cannot connect to...)Do my developpers needs special rights?
Thanks Guys, when we are with the browser on Reports Server, they can deploy
and access it, I made a special role for them, but with management studio we cannot connect to it at all. Joel:) [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no > way that developers should have sysadmin rights on SQL server. RS does > everything based on its roles. > > The local administrators role on the server (server not SQL Server) > automatically puts all users in that role with the rights to do anything > (subscriptions, deploy reports etc) to Reporting Services. However, > individual users or groups can be added to roles. > > In Report Manager, be at Home. Click on the Properties tab, Click New Role > Assignments. Try Content Manager or Publisher. One of those roles will work. > > All other folders inherit from home. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > > "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message > news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... > > Did you check SQL Server Configuration Manager to see if the Reporting > > Services service is started? It could also be a rights issue. Do you have > > sysadmin rights on your MSSQL server? > > > > -- > > > > Alain Quesnel > > alainsansspam@logiquel.com > > > > www.logiquel.com > > > > > > "Joel" <Joel@discussions.microsoft.com> wrote in message > > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... > >> Bonjour! > >> > >> I can't have access with my management studio to Reporting services > >> (2005)installed on my web server. (Cannot connect to...)Do my developpers > >> needs special rights? > >> > >> Regards, Joel :) > > > >
What do you mean access? You should be able to design reports without any
access to RS. It is only when deploying that you need special rights. Either they need to be part of the local administrators group on the server where RS is running OR they need to be put into the appropriate role (read up on roles for Reporting Services). -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Joel" <Joel@discussions.microsoft.com> wrote in message news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... > Bonjour! > > I can't have access with my management studio to Reporting services > (2005)installed on my web server. (Cannot connect to...)Do my developpers > needs special rights? > > Regards, Joel :)
Yes that's what I do. My little issue here is not in Visual Studio, it is
when I try to connect to report server with MS SQL Server management studio, on my test server that I have, everything on one box, it is connecting but with my prod it doesn't. My prod is different, the Reporting is installed on a web server with the database on another server. Regards, Joel :) [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Have you specified the path to deploy to? Right mouse click on the project > in BI Studio/VS. You need to set the target server URL to something like > this: > http://yourserver/ReportServer > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Joel" <Joel@discussions.microsoft.com> wrote in message > news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@microsoft.com... > > Thanks Guys, when we are with the browser on Reports Server, they can > > deploy > > and access it, I made a special role for them, but with management studio > > we > > cannot connect to it at all. > > > > Joel:) > > > > "Bruce L-C [MVP]" wrote: > > > >> Whoa! To deploy a report to RS does not need sysadmin rights. There is no > >> way that developers should have sysadmin rights on SQL server. RS does > >> everything based on its roles. > >> > >> The local administrators role on the server (server not SQL Server) > >> automatically puts all users in that role with the rights to do anything > >> (subscriptions, deploy reports etc) to Reporting Services. However, > >> individual users or groups can be added to roles. > >> > >> In Report Manager, be at Home. Click on the Properties tab, Click New > >> Role > >> Assignments. Try Content Manager or Publisher. One of those roles will > >> work. > >> > >> All other folders inherit from home. > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> > >> > >> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message > >> news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... > >> > Did you check SQL Server Configuration Manager to see if the Reporting > >> > Services service is started? It could also be a rights issue. Do you > >> > have > >> > sysadmin rights on your MSSQL server? > >> > > >> > -- > >> > > >> > Alain Quesnel > >> > alainsansspam@logiquel.com > >> > > >> > www.logiquel.com > >> > > >> > > >> > "Joel" <Joel@discussions.microsoft.com> wrote in message > >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... > >> >> Bonjour! > >> >> > >> >> I can't have access with my management studio to Reporting services > >> >> (2005)installed on my web server. (Cannot connect to...)Do my > >> >> developpers > >> >> needs special rights? > >> >> > >> >> Regards, Joel :) > >> > > >> > >> > >> > >
Have you specified the path to deploy to? Right mouse click on the project
in BI Studio/VS. You need to set the target server URL to something like this: http://yourserver/ReportServer -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Joel" <Joel@discussions.microsoft.com> wrote in message news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@microsoft.com... > Thanks Guys, when we are with the browser on Reports Server, they can > deploy > and access it, I made a special role for them, but with management studio > we > cannot connect to it at all. > > Joel:) > > "Bruce L-C [MVP]" wrote: > >> Whoa! To deploy a report to RS does not need sysadmin rights. There is no >> way that developers should have sysadmin rights on SQL server. RS does >> everything based on its roles. >> >> The local administrators role on the server (server not SQL Server) >> automatically puts all users in that role with the rights to do anything >> (subscriptions, deploy reports etc) to Reporting Services. However, >> individual users or groups can be added to roles. >> >> In Report Manager, be at Home. Click on the Properties tab, Click New >> Role >> Assignments. Try Content Manager or Publisher. One of those roles will >> work. >> >> All other folders inherit from home. >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> >> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message >> news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... >> > Did you check SQL Server Configuration Manager to see if the Reporting >> > Services service is started? It could also be a rights issue. Do you >> > have >> > sysadmin rights on your MSSQL server? >> > >> > -- >> > >> > Alain Quesnel >> > alainsansspam@logiquel.com >> > >> > www.logiquel.com >> > >> > >> > "Joel" <Joel@discussions.microsoft.com> wrote in message >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... >> >> Bonjour! >> >> >> >> I can't have access with my management studio to Reporting services >> >> (2005)installed on my web server. (Cannot connect to...)Do my >> >> developpers >> >> needs special rights? >> >> >> >> Regards, Joel :) >> > >> >> >>
Thanks, that's what I will do.
Regards, Joel :) [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I'm sorry. You asked about the developers so I immediately thought the issue > was not being able to deploy. Hence the thrust of all my posts. I never use > Management studio for anything with RS. I pulled it up just to see what it > offers and it does very little. It shows you some things but Report Manager > can easily do everything and more than what you can do with Management > Studio. > > The other poster mentioned sysadmin rights on SQL Server. I don't think this > is necessary because when I look at what information is provided and changes > allowed, it is all straight Reporting Services. If you want developers to be > doing this (adding roles for instance) then have them either be in the local > administrators account on the server that is hosting Reporting Services or > add their account to the System Administrator role. > > I suggest first making sure the developers can do what they need to do with > Report Manager. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Joel" <Joel@discussions.microsoft.com> wrote in message > news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@microsoft.com... > > Yes that's what I do. My little issue here is not in Visual Studio, it is > > when I try to connect to report server with MS SQL Server management > > studio, > > on my test server that I have, everything on one box, it is connecting but > > with my prod it doesn't. My prod is different, the Reporting is installed > > on > > a web server with the database on another server. > > > > Regards, Joel :) > > > > "Bruce L-C [MVP]" wrote: > > > >> Have you specified the path to deploy to? Right mouse click on the > >> project > >> in BI Studio/VS. You need to set the target server URL to something like > >> this: > >> http://yourserver/ReportServer > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Joel" <Joel@discussions.microsoft.com> wrote in message > >> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@microsoft.com... > >> > Thanks Guys, when we are with the browser on Reports Server, they can > >> > deploy > >> > and access it, I made a special role for them, but with management > >> > studio > >> > we > >> > cannot connect to it at all. > >> > > >> > Joel:) > >> > > >> > "Bruce L-C [MVP]" wrote: > >> > > >> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is > >> >> no > >> >> way that developers should have sysadmin rights on SQL server. RS does > >> >> everything based on its roles. > >> >> > >> >> The local administrators role on the server (server not SQL Server) > >> >> automatically puts all users in that role with the rights to do > >> >> anything > >> >> (subscriptions, deploy reports etc) to Reporting Services. However, > >> >> individual users or groups can be added to roles. > >> >> > >> >> In Report Manager, be at Home. Click on the Properties tab, Click New > >> >> Role > >> >> Assignments. Try Content Manager or Publisher. One of those roles will > >> >> work. > >> >> > >> >> All other folders inherit from home. > >> >> > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > >> >> > >> >> > >> >> > >> >> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message > >> >> news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... > >> >> > Did you check SQL Server Configuration Manager to see if the > >> >> > Reporting > >> >> > Services service is started? It could also be a rights issue. Do you > >> >> > have > >> >> > sysadmin rights on your MSSQL server? > >> >> > > >> >> > -- > >> >> > > >> >> > Alain Quesnel > >> >> > alainsansspam@logiquel.com > >> >> > > >> >> > www.logiquel.com > >> >> > > >> >> > > >> >> > "Joel" <Joel@discussions.microsoft.com> wrote in message > >> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... > >> >> >> Bonjour! > >> >> >> > >> >> >> I can't have access with my management studio to Reporting services > >> >> >> (2005)installed on my web server. (Cannot connect to...)Do my > >> >> >> developpers > >> >> >> needs special rights? > >> >> >> > >> >> >> Regards, Joel :) > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > >
I'm sorry. You asked about the developers so I immediately thought the issue
was not being able to deploy. Hence the thrust of all my posts. I never use Management studio for anything with RS. I pulled it up just to see what it offers and it does very little. It shows you some things but Report Manager can easily do everything and more than what you can do with Management Studio. The other poster mentioned sysadmin rights on SQL Server. I don't think this is necessary because when I look at what information is provided and changes allowed, it is all straight Reporting Services. If you want developers to be doing this (adding roles for instance) then have them either be in the local administrators account on the server that is hosting Reporting Services or add their account to the System Administrator role. I suggest first making sure the developers can do what they need to do with Report Manager. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Joel" <Joel@discussions.microsoft.com> wrote in message news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@microsoft.com... > Yes that's what I do. My little issue here is not in Visual Studio, it is > when I try to connect to report server with MS SQL Server management > studio, > on my test server that I have, everything on one box, it is connecting but > with my prod it doesn't. My prod is different, the Reporting is installed > on > a web server with the database on another server. > > Regards, Joel :) > > "Bruce L-C [MVP]" wrote: > >> Have you specified the path to deploy to? Right mouse click on the >> project >> in BI Studio/VS. You need to set the target server URL to something like >> this: >> http://yourserver/ReportServer >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Joel" <Joel@discussions.microsoft.com> wrote in message >> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@microsoft.com... >> > Thanks Guys, when we are with the browser on Reports Server, they can >> > deploy >> > and access it, I made a special role for them, but with management >> > studio >> > we >> > cannot connect to it at all. >> > >> > Joel:) >> > >> > "Bruce L-C [MVP]" wrote: >> > >> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is >> >> no >> >> way that developers should have sysadmin rights on SQL server. RS does >> >> everything based on its roles. >> >> >> >> The local administrators role on the server (server not SQL Server) >> >> automatically puts all users in that role with the rights to do >> >> anything >> >> (subscriptions, deploy reports etc) to Reporting Services. However, >> >> individual users or groups can be added to roles. >> >> >> >> In Report Manager, be at Home. Click on the Properties tab, Click New >> >> Role >> >> Assignments. Try Content Manager or Publisher. One of those roles will >> >> work. >> >> >> >> All other folders inherit from home. >> >> >> >> -- >> >> Bruce Loehle-Conger >> >> MVP SQL Server Reporting Services >> >> >> >> >> >> >> >> "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message >> >> news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... >> >> > Did you check SQL Server Configuration Manager to see if the >> >> > Reporting >> >> > Services service is started? It could also be a rights issue. Do you >> >> > have >> >> > sysadmin rights on your MSSQL server? >> >> > >> >> > -- >> >> > >> >> > Alain Quesnel >> >> > alainsansspam@logiquel.com >> >> > >> >> > www.logiquel.com >> >> > >> >> > >> >> > "Joel" <Joel@discussions.microsoft.com> wrote in message >> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... >> >> >> Bonjour! >> >> >> >> >> >> I can't have access with my management studio to Reporting services >> >> >> (2005)installed on my web server. (Cannot connect to...)Do my >> >> >> developpers >> >> >> needs special rights? >> >> >> >> >> >> Regards, Joel :) >> >> > >> >> >> >> >> >> >> >> >>
I agree that developers shoudn't have sa rights. I just wanted to know if he
could access SSRS through Management Studio with such rights. I've had a similar issue that had to do with renaming a machine that hosts SSRS. I still can't make the SSRS webserver work with a new machine name. -- Alain Quesnel alainsansspam@logiquel.com www.logiquel.com [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
news:O1BeNPKHIHA.4228@TK2MSFTNGP02.phx.gbl... > Whoa! To deploy a report to RS does not need sysadmin rights. There is no > way that developers should have sysadmin rights on SQL server. RS does > everything based on its roles. > > The local administrators role on the server (server not SQL Server) > automatically puts all users in that role with the rights to do anything > (subscriptions, deploy reports etc) to Reporting Services. However, > individual users or groups can be added to roles. > > In Report Manager, be at Home. Click on the Properties tab, Click New Role > Assignments. Try Content Manager or Publisher. One of those roles will > work. > > All other folders inherit from home. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > > "Alain Quesnel" <alainsansspam@logiquel.com> wrote in message > news:uAqaWJKHIHA.4228@TK2MSFTNGP02.phx.gbl... >> Did you check SQL Server Configuration Manager to see if the Reporting >> Services service is started? It could also be a rights issue. Do you have >> sysadmin rights on your MSSQL server? >> >> -- >> >> Alain Quesnel >> alainsansspam@logiquel.com >> >> www.logiquel.com >> >> >> "Joel" <Joel@discussions.microsoft.com> wrote in message >> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@microsoft.com... >>> Bonjour! >>> >>> I can't have access with my management studio to Reporting services >>> (2005)installed on my web server. (Cannot connect to...)Do my >>> developpers >>> needs special rights? >>> >>> Regards, Joel :) >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |