2000 AS SP4 RepositoryUser and OLAP Admins Group

Installed SQL 2000 Analysis Services and AS SP4 into existing SQL 2000 server
in prep for Project Server 2007 install. SP4 readme says add Olap
Administrators Group to RepositoryUser role. How? I can see the
RepositoryUser role under msdb. In Properties, Standard is selected as Database
role type (and grayed out -- can't change). If I click Add and try to add a
user the only users I can choose are guest and TargetServersRole, and there's
no way to browse for others.

OLAP Admins Group is not in msdb's Users. In fact, it is not listed as an
SQL Login. If it was supposed to be added into SQL during install that did
not happen. (The group does exist in the server's Local Groups; I already
added the service account to it.) Googling turned up no info. Can someone
provide step-by-step -- e.g. do I create an SQL Login for the OLAP Admins
Group then add the group to the msdb database and will that make it available
to choose in RepositoryUser role? (I'm surmising here with my limited
knowledge of SQL)

Thanks,
jremmc

Hi Jremmc,
Thank you for using Microsoft Managed TechNet Newsgroup. I am glad to work with you
on this issue.

Regarding your question, I understand that you want to know how to add OLAP
Administrators group to the database role RepositoryUser for msdb.
If I have misunderstood, please let me know.

OLAP Administrators group is a Windows user group, while RepositoryUser is a database
role in msdb. To associate them, you need to first create a SQL login and then assign the
database role to the mapped user in msdb.

For the detailed steps, you can refer to the following:
1. Open SQL Server Enterprise Manager, expand Security folder, right click Logins, click
New Login...;
2. Click the button [...] right aside the Name field, select "OLAP Administrators", click Add
and click OK;
3. Switch to the Database Access tab, check msdb, check RepositoryUser and click OK.

Hope this helps. Please feel free to let me know if you have any other questions or
concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg-at-microsoft.com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,

Thanks. That did it (after checking off msdb in Permissions tab on the Login
Properties).

btw, you might recall I had issue where Enterprise Manager did not reflect
SP4 level. I reapplied SP4 right before installing AS and EM still did not
reflect SP4 level. Oh well. Query Analyzer does show SQL at SP4 level.

jremmc

""Charles Wang [MSFT]"" wrote:

> Hi Jremmc,
> Thank you for using Microsoft Managed TechNet Newsgroup. I am glad to work with you
> on this issue.
>
> Regarding your question, I understand that you want to know how to add OLAP
> Administrators group to the database role RepositoryUser for msdb.
> If I have misunderstood, please let me know.
>
> OLAP Administrators group is a Windows user group, while RepositoryUser is a database
> role in msdb. To associate them, you need to first create a SQL login and then assign the
> database role to the mapped user in msdb.
>
> For the detailed steps, you can refer to the following:
> 1. Open SQL Server Enterprise Manager, expand Security folder, right click Logins, click
> New Login...;
> 2. Click the button [...] right aside the Name field, select "OLAP Administrators", click Add
> and click OK;
> 3. Switch to the Database Access tab, check msdb, check RepositoryUser and click OK.
>
> Hope this helps. Please feel free to let me know if you have any other questions or
> concerns. Have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== =========
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg-at-microsoft.com.
> ================================================== =========
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscripti...#notifications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscripti...t/default.aspx.
> ================================================== ==========
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== =======
>
>

Hi Jremmc,
Appreciate your response and I am glad to hear that the suggestions helped.

Regarding your other issue with SQL Server Enterprise Manager, I would like to know how you check the version of Enterprise Manager. Generally there are two ways of reading EM info via
about:
1. Open EM, click Help and click "About Microsoft SQL Enterprise Manager...";
2. Open EM, right click "Microsoft SQL Servers" group, click "About SQL Server Enterprise Manager".

The first method only shows the major version such as "Version: 8.0" while the second method shows the full version information such as "Version 8.00.2039". Please check if you use the
second method to check the version of EM.

Please feel free to let me know if you have any other questions or concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg-at-microsoft.com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,

Method 2 shows SP4 level. Thanks!

jremmc

""Charles Wang [MSFT]"" wrote:

> Hi Jremmc,
> Appreciate your response and I am glad to hear that the suggestions helped.
>
> Regarding your other issue with SQL Server Enterprise Manager, I would like to know how you check the version of Enterprise Manager. Generally there are two ways of reading EM info via
> about:
> 1. Open EM, click Help and click "About Microsoft SQL Enterprise Manager...";
> 2. Open EM, right click "Microsoft SQL Servers" group, click "About SQL Server Enterprise Manager".
>
> The first method only shows the major version such as "Version: 8.0" while the second method shows the full version information such as "Version 8.00.2039". Please check if you use the
> second method to check the version of EM.
>
> Please feel free to let me know if you have any other questions or concerns. Have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== =======
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg-at-microsoft.com.
> ================================================== =======
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== =======
>
>
>
>