Sql-server – Administrator cannot administer sql server reporting services

iis-7reporting-servicessql serverssrs-2008

I am running SQL Server Reporting Services on SQL Server 2008 Standard and trying to get the web pages to work.

What do I have to do to get RS (Report Manager, Reporting Services Connection), to see me as an admin in the first place so that I can make then change my role and look at the Web Service URL properly?

I have Windows authentication Enabled in II7 and I have anonymous authentication disabled.

I am logged in as a local Administrator (however the pages don't seem to realize that I am an admin).

Through the tables in ReportServer db, I can tell that BUILTIN\Administrators is in there.

I have my local machine in Trusted Sites in Internet Explorer.

Using Chrome instead of IE, I get similar results. I have not tried Firefox.

Most of the help I have found online assumes that you can add your login as an administrator explicitly from the perspective of RS. I cannot figure out how to do that because everyway I try to administer roles I cannot get to work….

At:

http://machine/ReportServer_DEPAHELIX

I get:

Reporting Services Error

The permissions granted to user 'Chris-PC\Chris' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

SQL Server Reporting Services

At:
http://machine/Reports_DEPAHELIX/Pages/Folder.aspx
I see only Home, with Home, My Subscriptions, Help and cannot really do anything. There are no reports there yet because when I try to deploy from BIDS, I get Error 1 The permissions granted to user 'Chris-PC\Chris' are insufficient for performing this operation. 0 0

At:
http://machine/Reports_DEPAHELIX/Pages/SystemSecurity.aspx
I see
You do not have permission to access this page.

And when I connect to Reporing Services through SQL Server Management Studio, I see Jobs, Security and Shared Schedules, and that's it. I can expand Security>Roles and see 5 built in roles, however
when I right click on a Role, the context menu has Properties grayed out.

What do I have to do to get RS to see me as an admin?

Best Answer

Appreciate you have a resolution; if anyone else has this problem; MS have put a step by step guide up on msdn. "Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008"

http://msdn.microsoft.com/en-us/library/bb630430.aspx

Syntax:

ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
WITH VALUES

Example:

ALTER TABLE SomeTable
        ADD SomeCol Bit NULL --Or NOT NULL.
 CONSTRAINT D_SomeTable_SomeCol --When Omitted a Default-Constraint Name is autogenerated.
    DEFAULT (0)--Optional Default-Constraint.
WITH VALUES --Add if Column is Nullable and you want the Default Value for Existing Records.

Notes:

Optional Constraint Name:
If you leave out CONSTRAINT D_SomeTable_SomeCol then SQL Server will autogenerate
a Default-Contraint with a funny Name like: DF__SomeTa__SomeC__4FB7FEF6

Optional With-Values Statement:
The WITH VALUES is only needed when your Column is Nullable
and you want the Default Value used for Existing Records.
If your Column is NOT NULL, then it will automatically use the Default Value
for all Existing Records, whether you specify WITH VALUES or not.

How Inserts work with a Default-Constraint:
If you insert a Record into SomeTable and do not Specify SomeCol's value, then it will Default to 0.
If you insert a Record and Specify SomeCol's value as NULL (and your column allows nulls),
then the Default-Constraint will not be used and NULL will be inserted as the Value.

Notes were based on everyone's great feedback below.
Special Thanks to:
@Yatrix, @WalterStabosz, @YahooSerious, and @StackMan for their Comments.

Sql – How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))

for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

gives me

2008-09-22 00:00:00.000

Pros:

No varchar<->datetime conversions required
No need to think about locale

Best Answer

Related Solutions

Sql – Add a column with a default value to an existing table in SQL Server

Syntax:

Example:

Notes:

Sql – How to return only the Date from a SQL Server DateTime datatype

Related Topic