enable caching error during sql dependency registration

Hey, I can't enable caching on my local computer..I use d

aspnet_regsql -S "localhost\SQLEXPRESS" -E -d books -ed

and

aspnet_regsql -S "Admin\SQLEXPRESS" -E -d books -ed

to try to start but i get a login error...

cannot open database "books" requested by login. The login failed. Login failed for user Computer2/Admin
unable to connect to SQL database for cache dependency registration

I tested connection with vwd and sql express management and it connects so I don't know what i'm doing wrong since I followed the direction and I googled for answer but not coming up with anything that's helping me..anyone have this problem and know how to resolve so i can cache some data output on my project

So you're encountering connection failure when you tried to connect to SQL Express instance in aspnet_regsql, right? I see you use Windows Authentication to connect to SQL, so first make sure there is a database named books on the SQLEXPRESS instance, and the login you're using (Windows logon account in this case) has permissions on the books database (you can simply add the account to the db_owner role on the books database).

BTW, why not aspnet_sql without parameter? Then you have a friendly GUI and the registration will become much easier.

|||

Well..I'm not sure how it worked out but this is what i basically did...attached database to sql express management...then detached...then called it like before but with its full map of c:/website/blah/books.mdf and that worked but I don't think it should have...and to answer post above i just followed examples located on microsoft.com...i don't know about asp_sql gui...didn't know they had one in cmd lines...anyhow..this is my first windows server so it's a bit of a learning curve..still learning how to use ashx and httphandlers...well..to the next problem now...weeeeeeeeeeeee

Empty Report manager page

When I go to http://localhost/Reports I see the page (subscription,
home, ...) but I don't see any tools nor reports.
I have anonymous authentication set to off in IIS for that directory,
and only have integrated authentication turned on. I logged in with
administrator account.
Is there any other way of setting users and roles without using the
'manage reports' page? That way I could make sure administrators has
the correct role.
Thanks in advance,
Stijn Verrept.Are you an administrator on the actual server machine?
Chris
Stijn Verrept wrote:
> When I go to http://localhost/Reports I see the page (subscription,
> home, ...) but I don't see any tools nor reports.
> I have anonymous authentication set to off in IIS for that directory,
> and only have integrated authentication turned on. I logged in with
> administrator account.
> Is there any other way of setting users and roles without using the
> 'manage reports' page? That way I could make sure administrators has
> the correct role.
>
> Thanks in advance,
> Stijn Verrept.|||Chris McGuigan wrote:
> Are you an administrator on the actual server machine?
> Chris
Thanks for the reply, I'm getting desperate :). Yes I am, the server
is a domain controller BTW. I had access earlier but now I don't have
access anymore for some reason, maybe I set something incorrect?|||It does sound like the RS server doesn't recognise you as an
administrator.
I have to say that I did a recent installation on a domain controller
and it went terribly. The main problem seemed to be that the
installation couldn't create the ASPNet user which is essential.
I had to set ASPNet up by hand and had to raise it to administrator
level.
Having said that, your issue seems different. Is it possible that you
changed the role of the administrator in RS so that it didn't have full
rights anymore? If thats a possibility then you will probably have to
reinstall.
Have you had reports running on this installation. If not and you are
trying to set it up for the first time, I would strongly advise you NOT
to put it on a domain controller.
Chris
Stijn Verrept wrote:
> Chris McGuigan wrote:
> > Are you an administrator on the actual server machine?
> >
> > Chris
> Thanks for the reply, I'm getting desperate :). Yes I am, the server
> is a domain controller BTW. I had access earlier but now I don't have
> access anymore for some reason, maybe I set something incorrect?|||Try this url;
http://SERVERNAME/Reports/Pages/SystemSecurity.aspx
If you get access denied, this will prove whether or not you are an
administrator as far as RS is concerned.
Chris
Chris McGuigan wrote:
> It does sound like the RS server doesn't recognise you as an
> administrator.
> I have to say that I did a recent installation on a domain controller
> and it went terribly. The main problem seemed to be that the
> installation couldn't create the ASPNet user which is essential.
> I had to set ASPNet up by hand and had to raise it to administrator
> level.
> Having said that, your issue seems different. Is it possible that you
> changed the role of the administrator in RS so that it didn't have
> full rights anymore? If thats a possibility then you will probably
> have to reinstall.
> Have you had reports running on this installation. If not and you are
> trying to set it up for the first time, I would strongly advise you
> NOT to put it on a domain controller.
> Chris
>
> Stijn Verrept wrote:
> > Chris McGuigan wrote:
> >
> > > Are you an administrator on the actual server machine?
> > >
> > > Chris
> >
> > Thanks for the reply, I'm getting desperate :). Yes I am, the
> > server is a domain controller BTW. I had access earlier but now I
> > don't have access anymore for some reason, maybe I set something
> > incorrect?|||One other thing to consider. Did you enable anonymous access on your
webserver? If anonymous access is enabled then all users are the same (they
are anonymous) and RS does not know you are the administrator. Disable
anonymous access.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:OmiivhMpFHA.272@.TK2MSFTNGP15.phx.gbl...
> It does sound like the RS server doesn't recognise you as an
> administrator.
> I have to say that I did a recent installation on a domain controller
> and it went terribly. The main problem seemed to be that the
> installation couldn't create the ASPNet user which is essential.
> I had to set ASPNet up by hand and had to raise it to administrator
> level.
> Having said that, your issue seems different. Is it possible that you
> changed the role of the administrator in RS so that it didn't have full
> rights anymore? If thats a possibility then you will probably have to
> reinstall.
> Have you had reports running on this installation. If not and you are
> trying to set it up for the first time, I would strongly advise you NOT
> to put it on a domain controller.
> Chris
>
> Stijn Verrept wrote:
>> Chris McGuigan wrote:
>> > Are you an administrator on the actual server machine?
>> >
>> > Chris
>> Thanks for the reply, I'm getting desperate :). Yes I am, the server
>> is a domain controller BTW. I had access earlier but now I don't have
>> access anymore for some reason, maybe I set something incorrect?
>|||I get "You do not have permission to access this page." and I'm logged
in as administrator.|||Bruce L-C [MVP] wrote:
> One other thing to consider. Did you enable anonymous access on your
> webserver? If anonymous access is enabled then all users are the same
> (they are anonymous) and RS does not know you are the administrator.
> Disable anonymous access.
No I only have integrated authentication turned on (mentionned this in
original mail), however, the browser doesn't popup the login screen. I
immediatly get: "You do not have permission to access this page." when
trying to access the page Chris gave me.|||I went back and looked at your original message. You only mentioned the
Reports website, what about Reportserver web. The Reports (report manager)
web is a portal into the reportserver. You need anonymous off for both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stijn Verrept" <stjin@.entrysoft.com> wrote in message
news:OMadnSiPYfnzbJjeRVnytA@.scarlet.biz...
> Bruce L-C [MVP] wrote:
>> One other thing to consider. Did you enable anonymous access on your
>> webserver? If anonymous access is enabled then all users are the same
>> (they are anonymous) and RS does not know you are the administrator.
>> Disable anonymous access.
> No I only have integrated authentication turned on (mentionned this in
> original mail), however, the browser doesn't popup the login screen. I
> immediatly get: "You do not have permission to access this page." when
> trying to access the page Chris gave me.|||Bruce L-C [MVP] wrote:
> I went back and looked at your original message. You only mentioned
> the Reports website, what about Reportserver web. The Reports (report
> manager) web is a portal into the reportserver. You need anonymous
> off for both.
YES!!! Good job mate! That did it, nice observing :). I put it to
anonymous so that anyone can look at report.
Thanks a lot!
Stijn Verrept.