| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-02-15 : 04:36:46
|
| Hello,I am currently creating reports using SSRS 2005 on my local machine.I think I will have to set up a report server machine so that each time I deploy the created reports from my machine to the report server.How do I create and setup the report server to hold the reports please?Thanks |
|
|
jhermiz
3564 Posts |
Posted - 2007-02-15 : 09:52:57
|
quote:
Originally posted by fmardani
Hello,I am currently creating reports using SSRS 2005 on my local machine.I think I will have to set up a report server machine so that each time I deploy the created reports from my machine to the report server.How do I create and setup the report server to hold the reports please?Thanks
Google How to setup Microsoft SQL Server Reporting Services.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-15 : 09:57:05
|
| I have setup the report server and created and ran reports on it.But other users can not browse to it.Not sure where and what to look for.Thanks |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-02-15 : 10:25:18
|
quote:
Originally posted by fmardani
I have setup the report server and created and ran reports on it.But other users can not browse to it.Not sure where and what to look for.Thanks
Did you read my post in the other thread about setting up security in RS? Site Settings in the RS Homepage, you need to specify users / groups (kind of like active directory), actually it uses your Active Directory accounts to access the reports. You just need to set this up. Disable anon access btw.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-15 : 11:46:07
|
| I am not sure if this makes a difference but we are using Novel and there is no Active Directory in our network I have been told.Any thoughts please? |
|
|
|
jhermiz
3564 Posts |
Posted - 2007-02-15 : 13:45:16
|
quote:
Originally posted by fmardani
I am not sure if this makes a difference but we are using Novel and there is no Active Directory in our network I have been told.Any thoughts please?
I am not familiar with Novel networks. However, you guys still have to have some place where users / groups are assigned right? If so you need to add these groups to the Reporting Services Site Settings (security rights). For instance you are on the Foobar domain and your name is frank and you want frank to see all the reports. Then you need to add Foobar\Frank to the security settings of RS, otherwise if you dont users will see the RS homepage but will NOT see any reports.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-16 : 02:54:07
|
| Every time someone tries to brose to the reports home page, they get a log on screen. Can this be avoided. i.e. can they just get in without having to log in?Thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-16 : 03:36:10
|
| Have you tried to install Community Technical Preview (CTP)? Aka SP2Peter LarssonHelsingborg, Sweden |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-16 : 03:40:23
|
| Do you mean SP2 for sql server 2005? If so what will that do please?Thanks |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-16 : 04:44:47
|
| Whent to that link, but do not see a download for SP2 for sql 2005 standard edition. Where is the download button please? |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-02-16 : 04:53:34
|
| Downloading now |
|
|
|
|
Report Server setup