permissions MDF LDF

Hi all
My question is , What permissions do you grant to the MDF / LDF files ,
bear in mind I want maximum security
all the best !
mastar
The service account needs read and write access. That should be all a
vanilla installation needs. However, I would also give local administrators
and system access as well. They could get access if they really wanted it
and it may save problems down the road.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"mastar" <mastarezma@.hotmail.com> wrote in message
news:9F37950E-4359-43B8-90F6-D05FFE13B1C8@.microsoft.com...
> Hi all
> My question is , What permissions do you grant to the MDF / LDF files ,
> bear in mind I want maximum security
> all the best !
> --
> mastar

Permissions

hi all

my computer = NZ3 (sql Server)
my computer = the report server

I can design / view / publish to local host (myserver)
others in domain can only view local host (myserver) and no content

so to test added one person - as content manager
he can now see all reports - but when he goes to run
gets the error cannot create a connection to the datasource?

I am using sql server 2005 standard

where else should I be changing or setting permissions

thanks
jewel

Hi,

seems that you are using Integrated Authentication. Although the user can manage the content (the actual report / permissions etc) he does not have access to the database. If you want to grant him access to the appropiate tables with the data, you will have to priviledge him on the database, otherwise he won′t be able to connect nor access the database. Open the SSMS and navigate to the security node of the server. Add the Windows user as a login and grant him the appropiate rights in the database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

thanks Jens

that enabled him to see now cool.

So when I have a group set up - do I have to add each one in the Security Logins to enable this to work?

thanks

Jewel

|||

Hi,

yes you need to Map those Windows User group to Security Node and then Assign them proper privilage for Database and Objects of Database for access as per the Role/Group.

Hemantgiri S. Goswami