Can't Add or Delete new role for new users

I've tried to add or delete a user to read report by using report manager.
User Home -> Properties -> New Role Assignment
Then enter user's doman and id information and check the role. However, it
shows ERROR.
The error message:
"Can't find the role '?' (rsRoleNotFound).
When i tried to delete one of the current user, it shows the same error
message.
The error message:
"Can't find the role '?' (rsRoleNotFound).
However, in my roles table, all roles information are all complete and
correct.
Can anyone tell me what's wrong?"roles" here refers to active directory user. You must add user you want to
the active directory (using control panel->management tools->computer
management->users)
than you can use the user you have added in the service now
"Lisa" wrote:
> I've tried to add or delete a user to read report by using report manager.
> User Home -> Properties -> New Role Assignment
> Then enter user's doman and id information and check the role. However, it
> shows ERROR.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> When i tried to delete one of the current user, it shows the same error
> message.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> However, in my roles table, all roles information are all complete and
> correct.
> Can anyone tell me what's wrong?
>
>
>|||Hi,
The user i want to add has already added in the management tools.
Is there anyother possiblie way to fix this?
"yuanxm" <yuanxm@.discussions.microsoft.com> ¦b¶l¥ó
news:95A7D902-5815-4F26-8A75-FFB17C05C974@.microsoft.com ¤¤¼¶¼g...
> "roles" here refers to active directory user. You must add user you want
to
> the active directory (using control panel->management tools->computer
> management->users)
> than you can use the user you have added in the service now
> "Lisa" wrote:
> > I've tried to add or delete a user to read report by using report
manager.
> > User Home -> Properties -> New Role Assignment
> > Then enter user's doman and id information and check the role. However,
it
> > shows ERROR.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> > When i tried to delete one of the current user, it shows the same error
> > message.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> >
> > However, in my roles table, all roles information are all complete and
> > correct.
> >
> > Can anyone tell me what's wrong?
> >
> >
> >
> >
> >

Can't access OLEDB datasource

The following problem is occuring when I try to access a
table either via an oledb connection or via a linked
server
I can enter the query in the rs/text box and run it
sucessfully. If I either goto edit the query via the
query tool or select the data option. Visual Studio
crashes.
This scenario reproduces the error
select * from link...table, however
this scenario works
select * from openquery(link,'select * from table')
I have downloaded sp1 for reporting services
thanks
DanAre you using the generic query designer, or are you using the graphical
query desinger?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:b92401c479a8$2a760220$a601280a@.phx.gbl...
> The following problem is occuring when I try to access a
> table either via an oledb connection or via a linked
> server
> I can enter the query in the rs/text box and run it
> sucessfully. If I either goto edit the query via the
> query tool or select the data option. Visual Studio
> crashes.
> This scenario reproduces the error
> select * from link...table, however
> this scenario works
> select * from openquery(link,'select * from table')
> I have downloaded sp1 for reporting services
> thanks
> Dan|||Thank you for the response, I can type in a query in the
generic designed, however if I select edit which is
supposed to launch the graphic tool, it crashes. This is
the same behavior whether I use the oledb interface or
try to access the same table via a linked-server
Regards
>--Original Message--
>Are you using the generic query designer, or are you
using the graphical
>query desinger?
>-Lukasz
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b92401c479a8$2a760220$a601280a@.phx.gbl...
>> The following problem is occuring when I try to access
a
>> table either via an oledb connection or via a linked
>> server
>> I can enter the query in the rs/text box and run it
>> sucessfully. If I either goto edit the query via the
>> query tool or select the data option. Visual Studio
>> crashes.
>> This scenario reproduces the error
>> select * from link...table, however
>> this scenario works
>> select * from openquery(link,'select * from table')
>> I have downloaded sp1 for reporting services
>> thanks
>> Dan
>
>.
>|||Unfortunately, the graphical query editor is a component of Visual Studio
which we reuse. If you send me your query, I can file a bug on their side.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"dan" <anonymous@.discussions.microsoft.com> wrote in message
news:befe01c479d1$f409b860$a501280a@.phx.gbl...
> Thank you for the response, I can type in a query in the
> generic designed, however if I select edit which is
> supposed to launch the graphic tool, it crashes. This is
> the same behavior whether I use the oledb interface or
> try to access the same table via a linked-server
> Regards
>>--Original Message--
>>Are you using the generic query designer, or are you
> using the graphical
>>query desinger?
>>-Lukasz
>>
>>--
>>This posting is provided "AS IS" with no warranties, and
> confers no rights.
>>
>>"Dan" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:b92401c479a8$2a760220$a601280a@.phx.gbl...
>> The following problem is occuring when I try to access
> a
>> table either via an oledb connection or via a linked
>> server
>> I can enter the query in the rs/text box and run it
>> sucessfully. If I either goto edit the query via the
>> query tool or select the data option. Visual Studio
>> crashes.
>> This scenario reproduces the error
>> select * from link...table, however
>> this scenario works
>> select * from openquery(link,'select * from table')
>> I have downloaded sp1 for reporting services
>> thanks
>> Dan
>>
>>.|||Thanks
Here is the example: SELECT * FROM NSXLINK...KNA1
NSXLINK is an OLEDB compliant linked server kna1 is the
table. If you select edit you get the error.
If however you submit the following query
SELECT * FROM OPENQUERY(NSXLINK,'SELECT * FROM NSXLINK')
it works. The same problem will appear if you use the
OLEDB provider directly, without the linked server
If you want I can get the error from the program that is
generated
thanks again
dan
>--Original Message--
>Unfortunately, the graphical query editor is a component
of Visual Studio
>which we reuse. If you send me your query, I can file
a bug on their side.
>-Lukasz
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"dan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:befe01c479d1$f409b860$a501280a@.phx.gbl...
>> Thank you for the response, I can type in a query in
the
>> generic designed, however if I select edit which is
>> supposed to launch the graphic tool, it crashes. This
is
>> the same behavior whether I use the oledb interface or
>> try to access the same table via a linked-server
>> Regards
>>--Original Message--
>>Are you using the generic query designer, or are you
>> using the graphical
>>query desinger?
>>-Lukasz
>>
>>--
>>This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>>
>>"Dan" <anonymous@.discussions.microsoft.com> wrote in
>> message
>>news:b92401c479a8$2a760220$a601280a@.phx.gbl...
>> The following problem is occuring when I try to
access
>> a
>> table either via an oledb connection or via a linked
>> server
>> I can enter the query in the rs/text box and run it
>> sucessfully. If I either goto edit the query via the
>> query tool or select the data option. Visual Studio
>> crashes.
>> This scenario reproduces the error
>> select * from link...table, however
>> this scenario works
>> select * from openquery(link,'select * from table')
>> I have downloaded sp1 for reporting services
>> thanks
>> Dan
>>
>>.
>
>.
>

cannot repair database.

I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
mode).
open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
sqlcmd.
type the following clause,
DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
go
I got 'repair statement not processed, database need to be in single user
mode' error messsage.
WHY? which one step I lost?
--FrankFrank Lee wrote:
> I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
> mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
> sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>
You don't need to start up SQL Server with the -m switch.
Go into Management Studio, right click on the CK database, click on
properties.
In the resulting dialog select the "Options" page. In the right pane,
scroll down to "State" and change "Restrict Access" to a value of "Single".
This will put the DATABASE into single user mode.
Alternatively, you could use ALTER DATABASE:
ALTER DATABASE CK
SET SINGLE_USER;
GO
and
ALTER DATABASE CK
SET MULTI_USER;
GO
to change it back.
Rob|||ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/92d4714b-95bf-46af-b05e-759a7164f937.htm
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Frank Lee" <Reply@.to.newsgroup> wrote in message
news:uzHfXT1DGHA.3988@.TK2MSFTNGP12.phx.gbl...
>I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
>mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to
> enter sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>|||>
> You don't need to start up SQL Server with the -m switch.
> Go into Management Studio, right click on the CK database, click on
> properties.
> In the resulting dialog select the "Options" page. In the right pane,
> scroll down to "State" and change "Restrict Access" to a value of
> "Single".
> This will put the DATABASE into single user mode.
> Alternatively, you could use ALTER DATABASE:
> ALTER DATABASE CK
> SET SINGLE_USER;
> GO
> and
> ALTER DATABASE CK
> SET MULTI_USER;
> GO
> to change it back.
>
> Rob
Thanks. It works for me.