Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Friday, March 23, 2012

Report Viewer display problem

Hi,
I use reportviewer.dll in my aspx page, and everything works fine on my
development pc where sqlserver, reporting service and visual studio
installed. But when i try to access this page from another pc, iframe which
holds reportviewer gives me "The page cannot be displayed. The page you are
looking for is currently unavailable.....". Other stuff like ascx,
menus,gif are working well. Any suggestions?
Thanks.Ever find a solution to this?
"saglamtimur" wrote:
> Hi,
> I use reportviewer.dll in my aspx page, and everything works fine on my
> development pc where sqlserver, reporting service and visual studio
> installed. But when i try to access this page from another pc, iframe which
> holds reportviewer gives me "The page cannot be displayed. The page you are
> looking for is currently unavailable.....". Other stuff like ascx,
> menus,gif are working well. Any suggestions?
> Thanks.
>
>

Friday, March 9, 2012

Report Server Subscriptions - Job Owner

Hi,
I am trying to setup a subscription but I keep running into problems.
I setup the subscription fine, I see that it creates a job in SQL
Server. It shows a specific domain account as the owner and I can't
figure out why. The problem is that this account is in a different
domain and it's having problems authenticating when it runs. I did use
this account for the services and whatnot when I originally set it up,
but I've changed the account that SQL Server and SQL Server Agent run
under, but it still uses this account as the owner. The only other
thing I can think of is that the database owner of
SystemCenterReporting is still this account. Is this why it's listing
this account as the owner of the job? Where else could it be?
Thanks,
Bill"zinck74" <zinck74@.hotmail.com> wrote in message
news:1105995617.343495.223770@.f14g2000cwb.googlegr oups.com...
> Hi,
> I am trying to setup a subscription but I keep running into problems.
> I setup the subscription fine, I see that it creates a job in SQL
> Server. It shows a specific domain account as the owner and I can't
> figure out why. The problem is that this account is in a different
> domain and it's having problems authenticating when it runs. I did use
> this account for the services and whatnot when I originally set it up,
> but I've changed the account that SQL Server and SQL Server Agent run
> under, but it still uses this account as the owner. The only other
> thing I can think of is that the database owner of
> SystemCenterReporting is still this account. Is this why it's listing
> this account as the owner of the job? Where else could it be?
> Thanks,
> Bill

I have no idea about Reporting Services, but the SQL job owner is the SQL
login which creates the job. If RS is running under a certain domain account
to access MSSQL, then I guess that would be the account which owns the
subscription job.

The MS RS Deployment Guide is a bit vague - it seems to recommend a domain
account for the RS service, but doesn't say exactly what permissions it
needs:

http://www.microsoft.com/technet/pr...oy/rsdepgd.mspx

You might get a better response in microsoft.public.sqlserver.reportingsvcs.

Simon|||Thanks. The answer ended up being running the rsconfig.exe utility.
Didn't know this existed, but the account used with this is who the
owner is of the job.