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

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

Grant CREATE VIEW, CREATE PROCEDURE ...

Hi,

I have currently a problem with setting up the permissions for some developers. My configuration looks like this.

DB A is the productive database.

DB B is a kind of "development" database.

Now we have a couple of users call them BOB, DAVID, ...

who are members of the db role db_reader and db_writer for the productive db a but they should be allowed to do nearly everything on db b.

Therefor I added them to the db role db_owner for db b.

For testing purposes I tried to "CREATE" a view TEST as BOB in database B but I received the error message

'Msg 262, Level 14, State 1, Procedure Test, Line 3

CREATE VIEW permission denied in database 'b'.'

I cross checked the permissions on db level and I even granted all available permissions on db level but nevertheless I receive this error message.

What's my mistake?

Of course it worked fine when I give them sysadmin rights but then they have far too much permissions.

Regards,

Stefan

Hi Stefan,

If you made sure that you granted them the needed permissions, you possibly revoked/denied some permissions to them. Look at the database level, if they are able to create / alter / drop a view. Denieing overwrite any granted special rights.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

unfortunately no . I didn't revoke or deny any permissions. The specific users are members of db_owner ..and in addition I tried to grant them all permissions on the db level. There is no permission denied.

Might it be a problem that the default schema is dbo?

Regards,

Stefan

|||Which version of SQL Server are you using ? Can you post the header of your creation script here ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||Besideyour original problem, why didn′t you put him in the db_ddladmin group, that should be *normally* sufficient to create objects.

HTH, Jens Suessmeyer

http://www.sqlserver2005.de
|||

Hi Jens,

I'm using SQL Server 2005 in an Enterprise Edition.

Currently I was trying to set up a very small sample db with the same conditions on a Developer Edition on my notebook ...strange thing it worked with the membership in the role db_owner. Now I'm wondering where there is the difference ...since with my last attempt I granted the user on the "server" database all available server and db level permissions.

Question:

The orignal db has been migrated (by detach and attach) from SQL Server 2000 about a week ago. Could there be any condition that settings from the old 2000 DB might have a bad influence on the migrated 2005 version?

Regards,

Stefan

|||Hi,

not directly, but if you detach and attach a db, the server logins are created by default. So you have to drop and recreate the users again OR rempa the server logins to the database users.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

this morning I was trying to compare my development db with the server db and I was not able to find the differences in the permissions. Therefor ...and to avoid any long search for possible reasons I decided to drop all development users and to reset all server and db level permissions to standard. Afterwards I started setting all the permissions after our db documentation again ...and finally I succeded.

After having reset and set all permission from scratch and recreated the users it works now.

So I assume your first assumption was correct that somewhere/somehow one or more necessary permissions have been denied.

Thank you very much for your help,

Stefan

Global setting for business (5 day) versus calendar week

Is there a global setting to specify a business (5 day) versus a calendar (7
day) w for date calculations?> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?|||> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?
Oops - finger slippage. There is no setting, global or otherwise.|||Hi Ledd,
In relation to what though?
You could just check to see if the wday isn't a Saturday or Sunday by
using DATENAME( )
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Ledd" <ledd@.discussions.microsoft.com> wrote in message
news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?|||Thanks. Makes sense.
"Tony Rogerson" wrote:

> Hi Ledd,
> In relation to what though?
> You could just check to see if the wday isn't a Saturday or Sunday by
> using DATENAME( )
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Ledd" <ledd@.discussions.microsoft.com> wrote in message
> news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
>
>|||Create your own Calendar table to identify which days are working days.
Shouldn't be difficult to do calcs against that.
David Portas
SQL Server MVP
--|||How about a calendar table?
http://www.aspfaq.com/2519
"Ledd" <ledd@.discussions.microsoft.com> wrote in message
news:C1885745-46EF-4214-9190-26D8DF72F8DE@.microsoft.com...
> Is there a global setting to specify a business (5 day) versus a calendar
> (7
> day) w for date calculations?