Grant Database Access

I am setting up report services after I installed the report server add-ins
on sharepoint 2007.

at first step, Reporting services integration, I put
report server web service URL -- http://ssrsdev1/reportserver
authentication mode -- windows authentication
it went OK.

at second step, Grant Database Access,
I put ssrsdev1 for server name (default instance) and then click OK and then
I put the user name (a member of local admin group on ssrsdev1) and password,
but I always got errors says:
Unable to log on with the given username and password.
what wrong here? what should I check? I am sure the user and password is
right and I can log on to ssrsdev1 physically with admin right without any
problem.
thanks for any thought on this.
zwp

Is SharePoint 2007 also installed on ssrsdev1?

If not, is this member of local admin group on ssrsdev1 a domain user or a local user (on ssrsdev1)?

thanx,
Prash

|||

we installed sharepoint 2007 bianry on ssrsdev1 (report server with sp2). and the user is a domain user and a member of local admin group. Actually, the report server, sql server and sharepoint all run under domain user (also a member of local admin group). When we tried to use user name domain\user and we got a error says: the group name can't find; when we use user or user@.domain.com to connect, we got the error I posted before. We tried to reinstall the sharepoint 2007 and still got same problem.

Thanks in advance for your help.

D.

|||

In you care you should use <domain_name>\<user> format.

In any case, in "Grant Database Access" we essentially try to add the Reporting Services service accounts to the WSS_WPG windows group. The WSS_WPG windows group should have been created when you installed SharePoint.

Can you verfy whether ssrsdev1 has a WSS_WPG windows group?

thanx,
Prash

|||

the windows group are on both report servers (ssrsdev1 and it also is the content database server for sharepoint server) and sharepoint server (spserver). I have manually added the user account into this grouop in both server, but I still get the same error.

Actually, I installed and running everything (report server and its services, sql server, and sharepoint, etc.) with the same domain user which is a member of local admin group on both boxes, therefore, the user should have access to everything, but I don’t understand why I am still have the problem with ‘grant database access’. Is it a bug?

BTW, we use sharepoing 2007 and sp2 December 2006 CTP.

Thanks,

zwp

|||

I just posted a message. Sorry it was my bad. I might mistype something. It works now.

However, when I go to next step:

Set server defaults

I got error message:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

I wonder it comes from sharepoint IIS or report server IIS? the user (again) I used are the local admin on both box, why still "Unauthorized "?

BTW, in sp2 BOL, it says: Verify the installation

use this address:

http://example-server-name:8081/reportserver

the example-server-name is report server name or sharepoint server name? I have tried both but none of them work. Maybe it is the result of HTTP status 401 above or something else

thanks again.

zwp.

|||

http://example-server-name:<port>/reportserver

example-server-name = the server on which Report Server is installed

<port> = the actual TCP port that your web site containing the ReportServer virtual directory is setup for. Note: 8081 is just an example.

Hope this helps.

thanx,
Prash

|||

could someone let me know how to find user :'sharepoint\system' since I can't find it in computer manager. I bet it is a system account used by sharepoint but how to set the permission to it. I got following

The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation. > The permissions granted to user 'SHAREPOINT\system' are insufficient for performing this operation.

when I at screen:

Reporting Services Server Defaults

thanks.

|||

Generally you should open another thread for a different issue.

In any case, are you able to upload / view reports in other SharePoint web sites?

Additionally, are you using a built-in machine account, such as Network Service as the identity of the application pool that hosts the SharePoint Central Admin web site?

thanx,
Prash

|||

Hi,

I've experienced the same problem.

In "Grant Database Access" page, when I entered a domain user account e.g. domain-name\paul (with SQL server local admin right), it pop-up:

The group name could not be found

In my SharePoint Server, there is a WSS_WPG windows group which has my domain account e.g. domain-name\paul

My SQL server 2005 with SP 2 is installed in another server.

Any advice?

Paul

|||

The WSS_WPG Windows group needs to also be present on the Report Server machine you specify as the "Server Name" in the "Grant Database Access" web page.

HTH
Prash

|||

Thanks.

Actually, I can setup the SharePoint Integration in a single-box (MOSS+SQL). So, as you said, WSS_WPG is in the same machine. However, as my SQL server is installed in another server. What can I do? (I did create a group called WSS_WPG manually in the SQL server, but still failed)

Any idea?

Paul

|||

Correct if I am wrong, but it looks like Reporting Services is installed on your SQL Server machine. If yes, then you still need to install the SharePoint Object Model on the SQL Server machine.

For a multi-machine setup refer to "How to: Install the Windows SharePoint Services Object Model on a Report Server Computer" in SQL BOL.

HTH
Prash