all groups > sql server reporting services > july 2006 >
You're in the

sql server reporting services

group:

rs2000 user in master database



rs2000 user in master database cltdba
7/24/2006 1:24:01 PM
sql server reporting services: Our database security standards require only dbo and guest users be in the
master database.

However, Reporting Services creates a user (rs2000) in the master database.
Is it possible to remove this user from the master database without affecting
functionality? If not, does anyone have suggestions for tightening down
Re: rs2000 user in master database Bruce L-C [MVP]
7/25/2006 9:38:06 AM
If RS created this it is how you installed it. I do not have any additional
users added to master database.

Only suggestion I could make is to try deleting it and if it causes a
problem put it back. All I know is, it is not a standard part of the install
(that I can see).

One caveat, my RS 2000 has been upgraded to RS 2005.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

Re: rs2000 user in master database cltdba
7/25/2006 11:18:02 AM
Thank you for the info. If I read your reply correctly;

The original install was RS 2000 (since upgraded to RS 2005).
During original install, no user (i.e. rs2000) was created in the master DB.

Are these true statements?



[quoted text, click to view]
Re: rs2000 user in master database Bruce L-C [MVP]
7/25/2006 1:42:39 PM
I don't think a user was created at that time. I never looked previously so
I wouldn't know. What I can say is that in my situation (a 2000 upgraded to
2005) that there is no special user. I have dbo and guest in master and that
is it.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

AddThis Social Bookmark Button