Can't access Reporting with Management Studio

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
"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 :)|||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 :)|||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 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
"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 :)
>> >
>>|||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
"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 :)
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks, that's what I will do.
Regards, Joel :)
"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 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
"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 :)
>|||Accessing Reporting Services through SQL Server Management Studio DOES have
some good uses.
Mainly, you can organise reports much easier than in Report Manager, you can
also create the rdl from the report.
Having said that, I live with out it because I nearly always hit connection
problems on different sites and I'm not sure of the correct way to set it up.
Anyone got an idiots guide to setting the security up so that this facility
can be done. I have full administrator rights.
Thanks
Chris McGuigan
"Alain Quesnel" wrote:
> 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
>
> "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 :)
> >>
> >
> >
>sql