Anonymous Subscription not showing as an option

I am attempting to create an anonymous subscription on a new install of SQL
Server 2000 (new server). I have successfully done this other
instances/servers. Why does the publication, which allows anonymous
subscritions, not show in my options?
I can ping the server just fine. I am sure I am just overlooking something.
Thanks-Deb
Is the account your SQL Server agent is running under on the subscriber in
the PAL on the Publisher?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:EC90B821-98B5-47F8-83B7-39C412EDC86D@.microsoft.com...
>I am attempting to create an anonymous subscription on a new install of SQL
> Server 2000 (new server). I have successfully done this other
> instances/servers. Why does the publication, which allows anonymous
> subscritions, not show in my options?
> I can ping the server just fine. I am sure I am just overlooking
> something.
> --
> Thanks-Deb
|||Yes... it is. I also listed this new server as a subscriber under Publisher
and Distributor properties.
Deb
"Deb" wrote:

> I am attempting to create an anonymous subscription on a new install of SQL
> Server 2000 (new server). I have successfully done this other
> instances/servers. Why does the publication, which allows anonymous
> subscritions, not show in my options?
> I can ping the server just fine. I am sure I am just overlooking something.
> --
> Thanks-Deb
|||Yes...it is. I also listed the server under Subscribers in the Publisher and
Distributor properties tab.
Deb
"Hilary Cotter" wrote:

> Is the account your SQL Server agent is running under on the subscriber in
> the PAL on the Publisher?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:EC90B821-98B5-47F8-83B7-39C412EDC86D@.microsoft.com...
>
>
|||Is your subscriber by chance an MSDE subscriber?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:9D6E7DDD-6911-4E6A-BF9B-93001BEDADDC@.microsoft.com...[vbcol=seagreen]
> Yes...it is. I also listed the server under Subscribers in the Publisher
> and
> Distributor properties tab.
> --
> Deb
>
> "Hilary Cotter" wrote:
|||It should be able to see it then. Could you also try this - add the account
to the dbo group in the distribution database.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Deb" <Deb@.discussions.microsoft.com> wrote in message
news:2EB34604-83BE-4106-ABB9-3A88C2D2D941@.microsoft.com...[vbcol=seagreen]
> Yes... it is. I also listed this new server as a subscriber under
> Publisher
> and Distributor properties.
> --
> Deb
>
> "Deb" wrote:
|||I thought of that one as well. I added it just trying to cover my bases. No
go.
What I find interesting is I can see other Anonymous Snapshots available on
other servers and this user is not a part PAL or Sys Amin role on these
servers whatsoever.
Deb
"Hilary Cotter" wrote:

> It should be able to see it then. Could you also try this - add the account
> to the dbo group in the distribution database.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Deb" <Deb@.discussions.microsoft.com> wrote in message
> news:2EB34604-83BE-4106-ABB9-3A88C2D2D941@.microsoft.com...
>
>

Analysis Services Cube Measures showing #ERR

Hi,

We have a MS OLAP Cube using 10 dimensions and 1 fact table with measures as COUNT and DISTINCT COUNT.

When we processed the cube using Analysis Services, it was done but all the measures are showing #ERR as values. The cube is about 650MB in size and all the joins between Dimension and Fact tables seem to be OK.

What could be the possible reasons of getting #ERR in measures? Do all the datatypes and length of JOIN columns between dimension and fact HAVE TO BE the same??

Please provide any inputs as this is very urgent.
Thanks
Omkarid assume its some division by 0 error

you can deal with this by replacing a Zero with a NULL in whatever field you use as a denominator. (the bottom half of division-- i hope that was the right word)