Showing posts with label permissions. Show all posts
Showing posts with label permissions. Show all posts

Thursday, March 29, 2012

credentials and permissions for the account that runs reportServer

Hi all,
I'm having a tough time finding what kind of permissions are needed for the
account that runs the Report Server windows Service.
I have my Report Server on a Win2K workstation with IIS and SQL Server on a
different computer (win2k Server and SQL Server 2000 with Sp3a).
We were able to make the subscriptions (emails and file sharing) with the
user being in the domain admin group. Now we are trying to give a little
less permissions to that account, but all the subscriptions are now showing
errors (in the subscription page only, log files are all fine).
The user is a local administrator and is part of the system operator, domain
operator, domain user and user groups on the network.
Does that user need to be a domain administrator? If we have too I don't
really mind but it would be safer to have it with less powerfull rights.
Thanks in advance for your help!I have some more informations so maybe it will help you help me!
The jobs are being created in SQL server. I can see them in SQL Server
Agent. They are even marked as success.
The problem is that I don't receive the email or the file is not created in
the folder as expected. Also the subscription is not being updated in
reports manager. It is still showing as a new subscription as if it was not
executed.

Thursday, March 22, 2012

creating tbl permissions

In my ms sql database I had a corrupted tbl permissions In my ignorance I deleted it How can I re create it I know nothing about databasesMoved to SQL Server Forum .

Wednesday, March 7, 2012

creating new users with dbo permissions

I am trying to create a new user for a SQL Server database and use the credentials in an
ASP.NET app.

Problem is dbo permissions are not being applied to the database objects when I set up a
new user (Logins -> New Logins) with SQL Server Authentication, set the default database to
the database I want.

I then get an error message saying that the user has not been granted access to their default
database : DBNAME and therefore will not be able to gain access to their default database.

I'm not sure why this is as I am logged in as sa.

Anyway, when I ignore the error and set-up this new user through the Users section of the
database none of the dbo permissions carry over.

Can anyone help?
Cheers.SQL Server's default authentication is via Windows only and you have to invoke
authentication via SQL Server usernames/passwords by right clicking on the server name, selecting the Security tab and making the change.