SQLCacheDependency and ASP.NET dbo privladges

15 Dec 2006 7:44 PM

Smokey Grindle

didnt know if this went in ado.net or ASP.net, so had to cross post...

I have a ASP.NET site running on my "web" server named "web" and its running
a site that has a SqlCacheDependency on it and is looking for changes in my
database on my "SQL" server named "SQL".. now the document im looking at
says that the as.net worker process needs dbo privladges for sql server
cache dependency to work automatically... but doesnt say how to give those
privladges... my two servers are on two different systems, so they dont see
each other locally, how do I set up this privladge? thanks!

17 Dec 2006 8:27 PM

Jesús López

dbo privileges is more than needed, please look at this article:

http://www.simple-talk.com/content/print.aspx?article=263

Regards:

Jesús López

Show quote

"Smokey Grindle" <nospam@dontspamme.com> escribió en el mensaje
news:OkiG1FIIHHA.1912@TK2MSFTNGP03.phx.gbl...
> didnt know if this went in ado.net or ASP.net, so had to cross post...
>
> I have a ASP.NET site running on my "web" server named "web" and its
> running a site that has a SqlCacheDependency on it and is looking for
> changes in my database on my "SQL" server named "SQL".. now the document
> im looking at says that the as.net worker process needs dbo privladges for
> sql server cache dependency to work automatically... but doesnt say how to
> give those privladges... my two servers are on two different systems, so
> they dont see each other locally, how do I set up this privladge? thanks!
>

17 Dec 2006 8:45 PM

Smokey Grindel

thanks for the article, that will help out a lot!

Show quote

"Jesús López" <sqlranger.***@mvps.org> wrote in message
news:OVxjLnhIHHA.1912@TK2MSFTNGP03.phx.gbl...
> dbo privileges is more than needed, please look at this article:
>
> http://www.simple-talk.com/content/print.aspx?article=263
>
> Regards:
>
> Jesús López
>
>
>
>
> "Smokey Grindle" <nospam@dontspamme.com> escribió en el mensaje
> news:OkiG1FIIHHA.1912@TK2MSFTNGP03.phx.gbl...
>> didnt know if this went in ado.net or ASP.net, so had to cross post...
>>
>> I have a ASP.NET site running on my "web" server named "web" and its
>> running a site that has a SqlCacheDependency on it and is looking for
>> changes in my database on my "SQL" server named "SQL".. now the document
>> im looking at says that the as.net worker process needs dbo privladges
>> for sql server cache dependency to work automatically... but doesnt say
>> how to give those privladges... my two servers are on two different
>> systems, so they dont see each other locally, how do I set up this
>> privladge? thanks!
>>
>
>