April 7, 2010 at 1:01 pm
Greetings all 😀
Recently my company migrated from a SQL 2005 server to a SQL 2008 server (both are up and running concurrently on different machines). Reporting services and its subsequent reports are available through my company intranet via http://servername/reports
We still have a few users using the old server when everyone should be on the new server. I have sent out notifications as much as possible but inevitably we still those people who apparently to do not read ;-). Is there a way I can change the URL or better yet, a way I can restrict access to everyone but the servers administrator (me) ?
Link to my blog http://notyelf.com/
April 7, 2010 at 1:30 pm
shannonjk (4/7/2010)
Greetings all 😀Recently my company migrated from a SQL 2005 server to a SQL 2008 server (both are up and running concurrently on different machines). Reporting services and its subsequent reports are available through my company intranet via http://servername/reports
We still have a few users using the old server when everyone should be on the new server. I have sent out notifications as much as possible but inevitably we still those people who apparently to do not read ;-). Is there a way I can change the URL or better yet, a way I can restrict access to everyone but the servers administrator (me) ?
If your SSRS 2008 is running without IIS that may be the reason people are running the old version because the new one comes without response.redirect which comes from IIS and enables navigation. That is one of the reasons SSRS 2008 for most large implementation uses either SharePoint or IIS.
Kind regards,
Gift Peddie
April 7, 2010 at 1:47 pm
I don't see how redirection would come into play. Either users would be typing the new server name, or old server name when connecting. We do have a sharepoint site up now but not everyone uses this. All I need to know is how to disable people from accessing the old one which is 2005...
Link to my blog http://notyelf.com/
April 7, 2010 at 1:49 pm
Stop the service, when you need it start it up.
Take the reporting DB's off-line, when you need them bring them back.
Redirect in IIS to the current server (put up a page informing of redirect after 10 sec, that way people know that they are wrong)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
April 7, 2010 at 2:17 pm
shannonjk (4/7/2010)
Greetings all 😀Recently my company migrated from a SQL 2005 server to a SQL 2008 server (both are up and running concurrently on different machines). Reporting services and its subsequent reports are available through my company intranet via http://servername/reports
We still have a few users using the old server when everyone should be on the new server. I have sent out notifications as much as possible but inevitably we still those people who apparently to do not read ;-). Is there a way I can change the URL or better yet, a way I can restrict access to everyone but the servers administrator (me) ?
Provided you set up the '05 instance with security, just remove everyone's permissions from the server/folders/reports and keep only the users/groups that still use it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 7, 2010 at 3:17 pm
The '05 Instance has security, however I am not the reporting person I am the DBA, however seeing as our reporting person left 2 weeks ago...I have picked up a few more responsibilities 🙂
Which security principles affect who can connect to the url and execute reports?
Link to my blog http://notyelf.com/
April 8, 2010 at 6:25 am
shannonjk (4/7/2010)
The '05 Instance has security, however I am not the reporting person I am the DBA, however seeing as our reporting person left 2 weeks ago...I have picked up a few more responsibilities 🙂Which security principles affect who can connect to the url and execute reports?
Navigate to http://<REPLACE WITH YOUR URL>/Reports/Pages/Settings.aspx?SelectedSubTabId=SecurityLinkID
you should see the users and groups with their permissions there.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 8, 2010 at 8:33 am
The '05 Instance has security, however I am not the reporting person I am the DBA, however seeing as our reporting person left 2 weeks ago...I have picked up a few more responsibilities 🙂
Which security principles affect who can connect to the url and execute reports?
You or your reporting person must define SSRS users permissions and roles, so check you internal implementation docs for existing permissions. And get started with the link below if you need to add or remove permissions.
http://msdn.microsoft.com/en-us/library/ms156014.aspx
Kind regards,
Gift Peddie
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply