Hi,
I need to restore a database to a new server. What are
the minimum permissions will I need to perform this task?
Thanks,
Diana
This is from Books Online:
Permissions
If the database being restored does not exist, the user must have CREATE
DATABASE permissions to be able to execute RESTORE. If the database exists,
RESTORE permissions default to members of the sysadmin and dbcreator fixed
server roles and the owner (dbo) of the database.
RESTORE permissions are given to roles in which membership information is
always readily available to the server. Because fixed database role
membership can be checked only when the database is accessible and
undamaged, which is not always the case when RESTORE is executed, members of
the db_owner fixed database role do not have RESTORE permissions.
Keith
"Diana" <anonymous@.discussions.microsoft.com> wrote in message
news:154201c4fd89$92d7a750$a501280a@.phx.gbl...
> Hi,
> I need to restore a database to a new server. What are
> the minimum permissions will I need to perform this task?
> Thanks,
> Diana
>
Showing posts with label perform. Show all posts
Showing posts with label perform. Show all posts
Friday, March 23, 2012
Tuesday, March 20, 2012
Permissions for tables and Sprocs
Hi everyone,
We are creating a new application in .net and i would like to deny
access of the tables to users, but allow them to perform routines by
stored procedures. I am using Sql2005, and was wondering if anyone had
some knowlegde about this and point me in the right direction? Has
anyone set this up before?
ThanksThis is standard practice. As long as you don't use dynamic SQL in the proce
dures and the procedure
and table has the same owner, then the user only need permissions to the pro
cedures. See
http://www.sommarskog.se/grantperm.html for some elaboration.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166175982.773661.294100@.73g2000cwn.googlegroups.com...
> Hi everyone,
> We are creating a new application in .net and i would like to deny
> access of the tables to users, but allow them to perform routines by
> stored procedures. I am using Sql2005, and was wondering if anyone had
> some knowlegde about this and point me in the right direction? Has
> anyone set this up before?
> Thanks
>|||Tibor Karaszi wrote:
> This is standard practice. As long as you don't use dynamic SQL in the pro
cedures and the procedure
> and table has the same owner, then the user only need permissions to the p
rocedures. See
> http://www.sommarskog.se/grantperm.html for some elaboration.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
Tibor,
Thanks for the quick reply, and i will look at the link you sent. One
problem though, we do use dynamic Sql within some of the sprocs, using
the execute_sql sproc?
Can you explain why this makes a difference?|||> Can you explain why this makes a difference?
that is just the way it is. SQL Server doesn't know what string you are abou
t to execute, so it
cannot allow the user of the proc to "execute just anything" without permiss
ion checking. I.e., a
conscious design decision. See the article, Erland mentions tow ways in 2005
to handle this
(signature and certificate or EXECUTE AS).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166180348.976164.146510@.16g2000cwy.googlegroups.com...
> Tibor Karaszi wrote:
> Tibor,
> Thanks for the quick reply, and i will look at the link you sent. One
> problem though, we do use dynamic Sql within some of the sprocs, using
> the execute_sql sproc?
> Can you explain why this makes a difference?
>|||Tibor,
I have read a couple articles now and feel that Execute As seems to be
the easiest option for the moment, and talks about setting up another
user to execute the code as. With this in mind, some articles say
about assigning this new user to a Role in the database, and th Role is
actually what is assigned the permissions. Do you agree with this?
Also, when they say role, do they mean a database role, or application
role? I am not sure i am understanding the differences between the
two, or why one should be used rather then the other.
Thanks again for all your help so far|||Database roles are containers for database users and other roles. Roles are
commonly used for security because you can grant permissions to the role
once and then control security for individual users using role membership.
Application roles are different beasts. An app role is a database security
context that can be activated in application code using sp_setapprole. Once
activated, it remains in effect until the connection is closed or
sp_unsetapprole is activated. App roles provide a means to elevate
permissions while a user is using an application and prevent direct ad-hoc
database access.
Regarding procedure permissions, like Tibor suggested, normal ownership
chaining works well except when you execute SQL dynamically or need to run
statements that require more permissions. In those cases, you can specify
an alternate security context using certificates or EXECUTE AS. You can
peruse Erland's article for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166184171.866934.154250@.80g2000cwy.googlegroups.com...
> Tibor,
> I have read a couple articles now and feel that Execute As seems to be
> the easiest option for the moment, and talks about setting up another
> user to execute the code as. With this in mind, some articles say
> about assigning this new user to a Role in the database, and th Role is
> actually what is assigned the permissions. Do you agree with this?
> Also, when they say role, do they mean a database role, or application
> role? I am not sure i am understanding the differences between the
> two, or why one should be used rather then the other.
> Thanks again for all your help so far
>
We are creating a new application in .net and i would like to deny
access of the tables to users, but allow them to perform routines by
stored procedures. I am using Sql2005, and was wondering if anyone had
some knowlegde about this and point me in the right direction? Has
anyone set this up before?
ThanksThis is standard practice. As long as you don't use dynamic SQL in the proce
dures and the procedure
and table has the same owner, then the user only need permissions to the pro
cedures. See
http://www.sommarskog.se/grantperm.html for some elaboration.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166175982.773661.294100@.73g2000cwn.googlegroups.com...
> Hi everyone,
> We are creating a new application in .net and i would like to deny
> access of the tables to users, but allow them to perform routines by
> stored procedures. I am using Sql2005, and was wondering if anyone had
> some knowlegde about this and point me in the right direction? Has
> anyone set this up before?
> Thanks
>|||Tibor Karaszi wrote:
> This is standard practice. As long as you don't use dynamic SQL in the pro
cedures and the procedure
> and table has the same owner, then the user only need permissions to the p
rocedures. See
> http://www.sommarskog.se/grantperm.html for some elaboration.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
Tibor,
Thanks for the quick reply, and i will look at the link you sent. One
problem though, we do use dynamic Sql within some of the sprocs, using
the execute_sql sproc?
Can you explain why this makes a difference?|||> Can you explain why this makes a difference?
that is just the way it is. SQL Server doesn't know what string you are abou
t to execute, so it
cannot allow the user of the proc to "execute just anything" without permiss
ion checking. I.e., a
conscious design decision. See the article, Erland mentions tow ways in 2005
to handle this
(signature and certificate or EXECUTE AS).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166180348.976164.146510@.16g2000cwy.googlegroups.com...
> Tibor Karaszi wrote:
> Tibor,
> Thanks for the quick reply, and i will look at the link you sent. One
> problem though, we do use dynamic Sql within some of the sprocs, using
> the execute_sql sproc?
> Can you explain why this makes a difference?
>|||Tibor,
I have read a couple articles now and feel that Execute As seems to be
the easiest option for the moment, and talks about setting up another
user to execute the code as. With this in mind, some articles say
about assigning this new user to a Role in the database, and th Role is
actually what is assigned the permissions. Do you agree with this?
Also, when they say role, do they mean a database role, or application
role? I am not sure i am understanding the differences between the
two, or why one should be used rather then the other.
Thanks again for all your help so far|||Database roles are containers for database users and other roles. Roles are
commonly used for security because you can grant permissions to the role
once and then control security for individual users using role membership.
Application roles are different beasts. An app role is a database security
context that can be activated in application code using sp_setapprole. Once
activated, it remains in effect until the connection is closed or
sp_unsetapprole is activated. App roles provide a means to elevate
permissions while a user is using an application and prevent direct ad-hoc
database access.
Regarding procedure permissions, like Tibor suggested, normal ownership
chaining works well except when you execute SQL dynamically or need to run
statements that require more permissions. In those cases, you can specify
an alternate security context using certificates or EXECUTE AS. You can
peruse Erland's article for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166184171.866934.154250@.80g2000cwy.googlegroups.com...
> Tibor,
> I have read a couple articles now and feel that Execute As seems to be
> the easiest option for the moment, and talks about setting up another
> user to execute the code as. With this in mind, some articles say
> about assigning this new user to a Role in the database, and th Role is
> actually what is assigned the permissions. Do you agree with this?
> Also, when they say role, do they mean a database role, or application
> role? I am not sure i am understanding the differences between the
> two, or why one should be used rather then the other.
> Thanks again for all your help so far
>
Labels:
application,
creating,
database,
denyaccess,
microsoft,
mysql,
net,
oracle,
perform,
permissions,
routines,
server,
sprocs,
sql,
tables,
users
Permissions for tables and Sprocs
Hi everyone,
We are creating a new application in .net and i would like to deny
access of the tables to users, but allow them to perform routines by
stored procedures. I am using Sql2005, and was wondering if anyone had
some knowlegde about this and point me in the right direction? Has
anyone set this up before?
ThanksThis is standard practice. As long as you don't use dynamic SQL in the procedures and the procedure
and table has the same owner, then the user only need permissions to the procedures. See
http://www.sommarskog.se/grantperm.html for some elaboration.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166175982.773661.294100@.73g2000cwn.googlegroups.com...
> Hi everyone,
> We are creating a new application in .net and i would like to deny
> access of the tables to users, but allow them to perform routines by
> stored procedures. I am using Sql2005, and was wondering if anyone had
> some knowlegde about this and point me in the right direction? Has
> anyone set this up before?
> Thanks
>|||Tibor Karaszi wrote:
> This is standard practice. As long as you don't use dynamic SQL in the procedures and the procedure
> and table has the same owner, then the user only need permissions to the procedures. See
> http://www.sommarskog.se/grantperm.html for some elaboration.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
Tibor,
Thanks for the quick reply, and i will look at the link you sent. One
problem though, we do use dynamic Sql within some of the sprocs, using
the execute_sql sproc?
Can you explain why this makes a difference?|||> Can you explain why this makes a difference?
that is just the way it is. SQL Server doesn't know what string you are about to execute, so it
cannot allow the user of the proc to "execute just anything" without permission checking. I.e., a
conscious design decision. See the article, Erland mentions tow ways in 2005 to handle this
(signature and certificate or EXECUTE AS).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166180348.976164.146510@.16g2000cwy.googlegroups.com...
> Tibor Karaszi wrote:
>> This is standard practice. As long as you don't use dynamic SQL in the procedures and the
>> procedure
>> and table has the same owner, then the user only need permissions to the procedures. See
>> http://www.sommarskog.se/grantperm.html for some elaboration.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
> Tibor,
> Thanks for the quick reply, and i will look at the link you sent. One
> problem though, we do use dynamic Sql within some of the sprocs, using
> the execute_sql sproc?
> Can you explain why this makes a difference?
>|||Tibor,
I have read a couple articles now and feel that Execute As seems to be
the easiest option for the moment, and talks about setting up another
user to execute the code as. With this in mind, some articles say
about assigning this new user to a Role in the database, and th Role is
actually what is assigned the permissions. Do you agree with this?
Also, when they say role, do they mean a database role, or application
role? I am not sure i am understanding the differences between the
two, or why one should be used rather then the other.
Thanks again for all your help so far|||Database roles are containers for database users and other roles. Roles are
commonly used for security because you can grant permissions to the role
once and then control security for individual users using role membership.
Application roles are different beasts. An app role is a database security
context that can be activated in application code using sp_setapprole. Once
activated, it remains in effect until the connection is closed or
sp_unsetapprole is activated. App roles provide a means to elevate
permissions while a user is using an application and prevent direct ad-hoc
database access.
Regarding procedure permissions, like Tibor suggested, normal ownership
chaining works well except when you execute SQL dynamically or need to run
statements that require more permissions. In those cases, you can specify
an alternate security context using certificates or EXECUTE AS. You can
peruse Erland's article for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166184171.866934.154250@.80g2000cwy.googlegroups.com...
> Tibor,
> I have read a couple articles now and feel that Execute As seems to be
> the easiest option for the moment, and talks about setting up another
> user to execute the code as. With this in mind, some articles say
> about assigning this new user to a Role in the database, and th Role is
> actually what is assigned the permissions. Do you agree with this?
> Also, when they say role, do they mean a database role, or application
> role? I am not sure i am understanding the differences between the
> two, or why one should be used rather then the other.
> Thanks again for all your help so far
>
We are creating a new application in .net and i would like to deny
access of the tables to users, but allow them to perform routines by
stored procedures. I am using Sql2005, and was wondering if anyone had
some knowlegde about this and point me in the right direction? Has
anyone set this up before?
ThanksThis is standard practice. As long as you don't use dynamic SQL in the procedures and the procedure
and table has the same owner, then the user only need permissions to the procedures. See
http://www.sommarskog.se/grantperm.html for some elaboration.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166175982.773661.294100@.73g2000cwn.googlegroups.com...
> Hi everyone,
> We are creating a new application in .net and i would like to deny
> access of the tables to users, but allow them to perform routines by
> stored procedures. I am using Sql2005, and was wondering if anyone had
> some knowlegde about this and point me in the right direction? Has
> anyone set this up before?
> Thanks
>|||Tibor Karaszi wrote:
> This is standard practice. As long as you don't use dynamic SQL in the procedures and the procedure
> and table has the same owner, then the user only need permissions to the procedures. See
> http://www.sommarskog.se/grantperm.html for some elaboration.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
Tibor,
Thanks for the quick reply, and i will look at the link you sent. One
problem though, we do use dynamic Sql within some of the sprocs, using
the execute_sql sproc?
Can you explain why this makes a difference?|||> Can you explain why this makes a difference?
that is just the way it is. SQL Server doesn't know what string you are about to execute, so it
cannot allow the user of the proc to "execute just anything" without permission checking. I.e., a
conscious design decision. See the article, Erland mentions tow ways in 2005 to handle this
(signature and certificate or EXECUTE AS).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166180348.976164.146510@.16g2000cwy.googlegroups.com...
> Tibor Karaszi wrote:
>> This is standard practice. As long as you don't use dynamic SQL in the procedures and the
>> procedure
>> and table has the same owner, then the user only need permissions to the procedures. See
>> http://www.sommarskog.se/grantperm.html for some elaboration.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
> Tibor,
> Thanks for the quick reply, and i will look at the link you sent. One
> problem though, we do use dynamic Sql within some of the sprocs, using
> the execute_sql sproc?
> Can you explain why this makes a difference?
>|||Tibor,
I have read a couple articles now and feel that Execute As seems to be
the easiest option for the moment, and talks about setting up another
user to execute the code as. With this in mind, some articles say
about assigning this new user to a Role in the database, and th Role is
actually what is assigned the permissions. Do you agree with this?
Also, when they say role, do they mean a database role, or application
role? I am not sure i am understanding the differences between the
two, or why one should be used rather then the other.
Thanks again for all your help so far|||Database roles are containers for database users and other roles. Roles are
commonly used for security because you can grant permissions to the role
once and then control security for individual users using role membership.
Application roles are different beasts. An app role is a database security
context that can be activated in application code using sp_setapprole. Once
activated, it remains in effect until the connection is closed or
sp_unsetapprole is activated. App roles provide a means to elevate
permissions while a user is using an application and prevent direct ad-hoc
database access.
Regarding procedure permissions, like Tibor suggested, normal ownership
chaining works well except when you execute SQL dynamically or need to run
statements that require more permissions. In those cases, you can specify
an alternate security context using certificates or EXECUTE AS. You can
peruse Erland's article for details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Nemisis" <darrens2005@.hotmail.com> wrote in message
news:1166184171.866934.154250@.80g2000cwy.googlegroups.com...
> Tibor,
> I have read a couple articles now and feel that Execute As seems to be
> the easiest option for the moment, and talks about setting up another
> user to execute the code as. With this in mind, some articles say
> about assigning this new user to a Role in the database, and th Role is
> actually what is assigned the permissions. Do you agree with this?
> Also, when they say role, do they mean a database role, or application
> role? I am not sure i am understanding the differences between the
> two, or why one should be used rather then the other.
> Thanks again for all your help so far
>
Labels:
access,
application,
creating,
database,
deny,
microsoft,
mysql,
net,
oracle,
perform,
permissions,
routines,
server,
sprocs,
sql,
tables,
users
Monday, March 12, 2012
Permissions Changed
Hello!
At some point over the weekend my user account (which is an admin
account) lost the ability to perform administrative tasks in SQL
Server 2000. I can no longer create a database, create users, modify
existing tables, etc. Three days ago I was able to create a database
with no problems. The network guy and I are trying to figure out what
caused this problem. It seems that all admin accounts have lost these
permissions. Does anyone have any suggestions what I can check for?
Thanks,
--
JerryCheck out your Logins in SQL Server, whether or not for instance the local Administrators group is
still there, and whether it is a member of the sysadmin server role.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> Hello!
> At some point over the weekend my user account (which is an admin
> account) lost the ability to perform administrative tasks in SQL
> Server 2000. I can no longer create a database, create users, modify
> existing tables, etc. Three days ago I was able to create a database
> with no problems. The network guy and I are trying to figure out what
> caused this problem. It seems that all admin accounts have lost these
> permissions. Does anyone have any suggestions what I can check for?
> Thanks,
> --
> Jerry
>|||Your account could be removed from Domain Admins or Local Admins group.
It seems that you still are able to login to your SQL Server. In a false
scenario, you might be a member of Domain Users and Domain Admins groups.
And these groups may have logins in SQL Server. Let's assume that Domain
Users login has only public role and Domain Admins login has sysadmin role.
If you are removed from Domain Admins Windows Group, then you lost your
sysadmin role right and now you login to your SQL Server only as using
public role. (I setup a role like this cause you mentioned about a network
and I thought there could be a domain in your environment)
Your situation must be something like this. Check out your logins as Tiber
also mentioned.
--
Ekrem Önsoy
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> Hello!
> At some point over the weekend my user account (which is an admin
> account) lost the ability to perform administrative tasks in SQL
> Server 2000. I can no longer create a database, create users, modify
> existing tables, etc. Three days ago I was able to create a database
> with no problems. The network guy and I are trying to figure out what
> caused this problem. It seems that all admin accounts have lost these
> permissions. Does anyone have any suggestions what I can check for?
> Thanks,
> --
> Jerry
>|||Thanks for the reply. I checked and the admin group that was set up
for me is still in the SQL Users list. Unfortunately my account no
longer has the permissions it needs to check if it's in the sysadmins
group.
--
Jerry
On Oct 2, 3:46 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Check out your Logins in SQL Server, whether or not for instance the local Administrators group is
> still there, and whether it is a member of the sysadmin server role.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> > Hello!
> > At some point over the weekend my user account (which is an admin
> > account) lost the ability to perform administrative tasks in SQL
> > Server 2000. I can no longer create a database, create users, modify
> > existing tables, etc. Three days ago I was able to create a database
> > with no problems. The network guy and I are trying to figure out what
> > caused this problem. It seems that all admin accounts have lost these
> > permissions. Does anyone have any suggestions what I can check for?
>|||We have an admin group set up that is a part of the Windows
Administrators group. We're going to try to see if this group is a
part of the sysadmins role in SQL Server.
--
Jerry
On Oct 3, 3:29 am, Ekrem =D6nsoy <ek...@.btegitim.com> wrote:
> Your account could be removed from Domain Admins or Local Admins group.
> It seems that you still are able to login to your SQL Server. In a false
> scenario, you might be a member of Domain Users and Domain Admins groups.
> And these groups may have logins in SQL Server. Let's assume that Domain
> Users login has only public role and Domain Admins login has sysadmin rol=e=2E
> If you are removed from Domain Admins Windows Group, then you lost your
> sysadmin role right and now you login to your SQL Server only as using
> public role. (I setup a role like this cause you mentioned about a network
> and I thought there could be a domain in your environment)
> Your situation must be something like this. Check out your logins as Tiber
> also mentioned.
> --
> Ekrem =D6nsoy
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> > Hello!
> > At some point over the weekend my user account (which is an admin
> > account) lost the ability to perform administrative tasks in SQL
> > Server 2000. I can no longer create a database, create users, modify
> > existing tables, etc. Three days ago I was able to create a database
> > with no problems. The network guy and I are trying to figure out what
> > caused this problem. It seems that all admin accounts have lost these
> > permissions. Does anyone have any suggestions what I can check for?
>|||> Unfortunately my account no
> longer has the permissions it needs to check if it's in the sysadmins
> group.
It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you are
logged in though this Windows group). So you need to go and find somebody who has privileges to
check this...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> Thanks for the reply. I checked and the admin group that was set up
> for me is still in the SQL Users list. Unfortunately my account no
> longer has the permissions it needs to check if it's in the sysadmins
> group.
> --
> Jerry
> On Oct 2, 3:46 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Check out your Logins in SQL Server, whether or not for instance the local Administrators group
>> is
>> still there, and whether it is a member of the sysadmin server role.
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Jerry" <jerrya...@.gmail.com> wrote in message
>> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
>> > Hello!
>> > At some point over the weekend my user account (which is an admin
>> > account) lost the ability to perform administrative tasks in SQL
>> > Server 2000. I can no longer create a database, create users, modify
>> > existing tables, etc. Three days ago I was able to create a database
>> > with no problems. The network guy and I are trying to figure out what
>> > caused this problem. It seems that all admin accounts have lost these
>> > permissions. Does anyone have any suggestions what I can check for?
>|||Tibor,
I found an account to get in and did find that the group was not in
the sysadmin role. This was in the sysadmin role on Friday but on
Monday it wasn't there. Do you have any ideas what might have caused
this?
Thanks for your advice.
--
Jerry
On Oct 4, 7:50 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Unfortunately my account no
> > longer has the permissions it needs to check if it's in the sysadmins
> > group.
> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you are
> logged in though this Windows group). So you need to go and find somebody who has privileges to
> check this...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> > Thanks for the reply. I checked and the admin group that was set up
> > for me is still in the SQL Users list. Unfortunately my account no
> > longer has the permissions it needs to check if it's in the sysadmins
> > group.
> > --
> > Jerry
> > On Oct 2, 3:46 pm, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators group
> >> is
> >> still there, and whether it is a member of the sysadmin server role.
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> >> > Hello!
> >> > At some point over the weekend my user account (which is an admin
> >> > account) lost the ability to perform administrative tasks in SQL
> >> > Server 2000. I can no longer create a database, create users, modify
> >> > existing tables, etc. Three days ago I was able to create a database
> >> > with no problems. The network guy and I are trying to figure out what
> >> > caused this problem. It seems that all admin accounts have lost these
> >> > permissions. Does anyone have any suggestions what I can check for?|||> Do you have any ideas what might have caused
> this?
Most probably somebody removed it and:
* Don't remember it
* Didn't understand what he/she was doing
* Don't dare to come forward
I don't recall whether these events are logged to the default profiler trace (see the trc files in
same folder as where you find the errorlog file), but it is worth a shot to see if you find this
event there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191505654.310090.315540@.k79g2000hse.googlegroups.com...
> Tibor,
> I found an account to get in and did find that the group was not in
> the sysadmin role. This was in the sysadmin role on Friday but on
> Monday it wasn't there. Do you have any ideas what might have caused
> this?
> Thanks for your advice.
> --
> Jerry
>
> On Oct 4, 7:50 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> > Unfortunately my account no
>> > longer has the permissions it needs to check if it's in the sysadmins
>> > group.
>> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you
>> are
>> logged in though this Windows group). So you need to go and find somebody who has privileges to
>> check this...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Jerry" <jerrya...@.gmail.com> wrote in message
>> news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
>> > Thanks for the reply. I checked and the admin group that was set up
>> > for me is still in the SQL Users list. Unfortunately my account no
>> > longer has the permissions it needs to check if it's in the sysadmins
>> > group.
>> > --
>> > Jerry
>> > On Oct 2, 3:46 pm, "Tibor Karaszi"
>> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators
>> >> group
>> >> is
>> >> still there, and whether it is a member of the sysadmin server role.
>> >> --
>> >> Tibor Karaszi, SQL Server
>> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
>> >> "Jerry" <jerrya...@.gmail.com> wrote in message
>> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
>> >> > Hello!
>> >> > At some point over the weekend my user account (which is an admin
>> >> > account) lost the ability to perform administrative tasks in SQL
>> >> > Server 2000. I can no longer create a database, create users, modify
>> >> > existing tables, etc. Three days ago I was able to create a database
>> >> > with no problems. The network guy and I are trying to figure out what
>> >> > caused this problem. It seems that all admin accounts have lost these
>> >> > permissions. Does anyone have any suggestions what I can check for?
>|||I'll take a look. I'm suspecting it was someone who didn't know what
they did.
On Oct 4, 9:56 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Do you have any ideas what might have caused
> > this?
> Most probably somebody removed it and:
> * Don't remember it
> * Didn't understand what he/she was doing
> * Don't dare to come forward
> I don't recall whether these events are logged to the default profiler trace (see the trc files in
> same folder as where you find the errorlog file), but it is worth a shot to see if you find this
> event there.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191505654.310090.315540@.k79g2000hse.googlegroups.com...
> > Tibor,
> > I found an account to get in and did find that the group was not in
> > the sysadmin role. This was in the sysadmin role on Friday but on
> > Monday it wasn't there. Do you have any ideas what might have caused
> > this?
> > Thanks for your advice.
> > --
> > Jerry
> > On Oct 4, 7:50 am, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> > Unfortunately my account no
> >> > longer has the permissions it needs to check if it's in the sysadmins
> >> > group.
> >> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you
> >> are
> >> logged in though this Windows group). So you need to go and find somebody who has privileges to
> >> check this...
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >>news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> >> > Thanks for the reply. I checked and the admin group that was set up
> >> > for me is still in the SQL Users list. Unfortunately my account no
> >> > longer has the permissions it needs to check if it's in the sysadmins
> >> > group.
> >> > --
> >> > Jerry
> >> > On Oct 2, 3:46 pm, "Tibor Karaszi"
> >> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators
> >> >> group
> >> >> is
> >> >> still there, and whether it is a member of the sysadmin server role.
> >> >> --
> >> >> Tibor Karaszi, SQL Server
> >> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> >> >> > Hello!
> >> >> > At some point over the weekend my user account (which is an admin
> >> >> > account) lost the ability to perform administrative tasks in SQL
> >> >> > Server 2000. I can no longer create a database, create users, modify
> >> >> > existing tables, etc. Three days ago I was able to create a database
> >> >> > with no problems. The network guy and I are trying to figure out what
> >> >> > caused this problem. It seems that all admin accounts have lost these
> >> >> > permissions. Does anyone have any suggestions what I can check for?
At some point over the weekend my user account (which is an admin
account) lost the ability to perform administrative tasks in SQL
Server 2000. I can no longer create a database, create users, modify
existing tables, etc. Three days ago I was able to create a database
with no problems. The network guy and I are trying to figure out what
caused this problem. It seems that all admin accounts have lost these
permissions. Does anyone have any suggestions what I can check for?
Thanks,
--
JerryCheck out your Logins in SQL Server, whether or not for instance the local Administrators group is
still there, and whether it is a member of the sysadmin server role.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> Hello!
> At some point over the weekend my user account (which is an admin
> account) lost the ability to perform administrative tasks in SQL
> Server 2000. I can no longer create a database, create users, modify
> existing tables, etc. Three days ago I was able to create a database
> with no problems. The network guy and I are trying to figure out what
> caused this problem. It seems that all admin accounts have lost these
> permissions. Does anyone have any suggestions what I can check for?
> Thanks,
> --
> Jerry
>|||Your account could be removed from Domain Admins or Local Admins group.
It seems that you still are able to login to your SQL Server. In a false
scenario, you might be a member of Domain Users and Domain Admins groups.
And these groups may have logins in SQL Server. Let's assume that Domain
Users login has only public role and Domain Admins login has sysadmin role.
If you are removed from Domain Admins Windows Group, then you lost your
sysadmin role right and now you login to your SQL Server only as using
public role. (I setup a role like this cause you mentioned about a network
and I thought there could be a domain in your environment)
Your situation must be something like this. Check out your logins as Tiber
also mentioned.
--
Ekrem Önsoy
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> Hello!
> At some point over the weekend my user account (which is an admin
> account) lost the ability to perform administrative tasks in SQL
> Server 2000. I can no longer create a database, create users, modify
> existing tables, etc. Three days ago I was able to create a database
> with no problems. The network guy and I are trying to figure out what
> caused this problem. It seems that all admin accounts have lost these
> permissions. Does anyone have any suggestions what I can check for?
> Thanks,
> --
> Jerry
>|||Thanks for the reply. I checked and the admin group that was set up
for me is still in the SQL Users list. Unfortunately my account no
longer has the permissions it needs to check if it's in the sysadmins
group.
--
Jerry
On Oct 2, 3:46 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Check out your Logins in SQL Server, whether or not for instance the local Administrators group is
> still there, and whether it is a member of the sysadmin server role.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> > Hello!
> > At some point over the weekend my user account (which is an admin
> > account) lost the ability to perform administrative tasks in SQL
> > Server 2000. I can no longer create a database, create users, modify
> > existing tables, etc. Three days ago I was able to create a database
> > with no problems. The network guy and I are trying to figure out what
> > caused this problem. It seems that all admin accounts have lost these
> > permissions. Does anyone have any suggestions what I can check for?
>|||We have an admin group set up that is a part of the Windows
Administrators group. We're going to try to see if this group is a
part of the sysadmins role in SQL Server.
--
Jerry
On Oct 3, 3:29 am, Ekrem =D6nsoy <ek...@.btegitim.com> wrote:
> Your account could be removed from Domain Admins or Local Admins group.
> It seems that you still are able to login to your SQL Server. In a false
> scenario, you might be a member of Domain Users and Domain Admins groups.
> And these groups may have logins in SQL Server. Let's assume that Domain
> Users login has only public role and Domain Admins login has sysadmin rol=e=2E
> If you are removed from Domain Admins Windows Group, then you lost your
> sysadmin role right and now you login to your SQL Server only as using
> public role. (I setup a role like this cause you mentioned about a network
> and I thought there could be a domain in your environment)
> Your situation must be something like this. Check out your logins as Tiber
> also mentioned.
> --
> Ekrem =D6nsoy
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> > Hello!
> > At some point over the weekend my user account (which is an admin
> > account) lost the ability to perform administrative tasks in SQL
> > Server 2000. I can no longer create a database, create users, modify
> > existing tables, etc. Three days ago I was able to create a database
> > with no problems. The network guy and I are trying to figure out what
> > caused this problem. It seems that all admin accounts have lost these
> > permissions. Does anyone have any suggestions what I can check for?
>|||> Unfortunately my account no
> longer has the permissions it needs to check if it's in the sysadmins
> group.
It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you are
logged in though this Windows group). So you need to go and find somebody who has privileges to
check this...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> Thanks for the reply. I checked and the admin group that was set up
> for me is still in the SQL Users list. Unfortunately my account no
> longer has the permissions it needs to check if it's in the sysadmins
> group.
> --
> Jerry
> On Oct 2, 3:46 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Check out your Logins in SQL Server, whether or not for instance the local Administrators group
>> is
>> still there, and whether it is a member of the sysadmin server role.
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Jerry" <jerrya...@.gmail.com> wrote in message
>> news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
>> > Hello!
>> > At some point over the weekend my user account (which is an admin
>> > account) lost the ability to perform administrative tasks in SQL
>> > Server 2000. I can no longer create a database, create users, modify
>> > existing tables, etc. Three days ago I was able to create a database
>> > with no problems. The network guy and I are trying to figure out what
>> > caused this problem. It seems that all admin accounts have lost these
>> > permissions. Does anyone have any suggestions what I can check for?
>|||Tibor,
I found an account to get in and did find that the group was not in
the sysadmin role. This was in the sysadmin role on Friday but on
Monday it wasn't there. Do you have any ideas what might have caused
this?
Thanks for your advice.
--
Jerry
On Oct 4, 7:50 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Unfortunately my account no
> > longer has the permissions it needs to check if it's in the sysadmins
> > group.
> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you are
> logged in though this Windows group). So you need to go and find somebody who has privileges to
> check this...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> > Thanks for the reply. I checked and the admin group that was set up
> > for me is still in the SQL Users list. Unfortunately my account no
> > longer has the permissions it needs to check if it's in the sysadmins
> > group.
> > --
> > Jerry
> > On Oct 2, 3:46 pm, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators group
> >> is
> >> still there, and whether it is a member of the sysadmin server role.
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> >> > Hello!
> >> > At some point over the weekend my user account (which is an admin
> >> > account) lost the ability to perform administrative tasks in SQL
> >> > Server 2000. I can no longer create a database, create users, modify
> >> > existing tables, etc. Three days ago I was able to create a database
> >> > with no problems. The network guy and I are trying to figure out what
> >> > caused this problem. It seems that all admin accounts have lost these
> >> > permissions. Does anyone have any suggestions what I can check for?|||> Do you have any ideas what might have caused
> this?
Most probably somebody removed it and:
* Don't remember it
* Didn't understand what he/she was doing
* Don't dare to come forward
I don't recall whether these events are logged to the default profiler trace (see the trc files in
same folder as where you find the errorlog file), but it is worth a shot to see if you find this
event there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry" <jerryalan@.gmail.com> wrote in message
news:1191505654.310090.315540@.k79g2000hse.googlegroups.com...
> Tibor,
> I found an account to get in and did find that the group was not in
> the sysadmin role. This was in the sysadmin role on Friday but on
> Monday it wasn't there. Do you have any ideas what might have caused
> this?
> Thanks for your advice.
> --
> Jerry
>
> On Oct 4, 7:50 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> > Unfortunately my account no
>> > longer has the permissions it needs to check if it's in the sysadmins
>> > group.
>> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you
>> are
>> logged in though this Windows group). So you need to go and find somebody who has privileges to
>> check this...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Jerry" <jerrya...@.gmail.com> wrote in message
>> news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
>> > Thanks for the reply. I checked and the admin group that was set up
>> > for me is still in the SQL Users list. Unfortunately my account no
>> > longer has the permissions it needs to check if it's in the sysadmins
>> > group.
>> > --
>> > Jerry
>> > On Oct 2, 3:46 pm, "Tibor Karaszi"
>> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators
>> >> group
>> >> is
>> >> still there, and whether it is a member of the sysadmin server role.
>> >> --
>> >> Tibor Karaszi, SQL Server
>> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
>> >> "Jerry" <jerrya...@.gmail.com> wrote in message
>> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
>> >> > Hello!
>> >> > At some point over the weekend my user account (which is an admin
>> >> > account) lost the ability to perform administrative tasks in SQL
>> >> > Server 2000. I can no longer create a database, create users, modify
>> >> > existing tables, etc. Three days ago I was able to create a database
>> >> > with no problems. The network guy and I are trying to figure out what
>> >> > caused this problem. It seems that all admin accounts have lost these
>> >> > permissions. Does anyone have any suggestions what I can check for?
>|||I'll take a look. I'm suspecting it was someone who didn't know what
they did.
On Oct 4, 9:56 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> > Do you have any ideas what might have caused
> > this?
> Most probably somebody removed it and:
> * Don't remember it
> * Didn't understand what he/she was doing
> * Don't dare to come forward
> I don't recall whether these events are logged to the default profiler trace (see the trc files in
> same folder as where you find the errorlog file), but it is worth a shot to see if you find this
> event there.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Jerry" <jerrya...@.gmail.com> wrote in message
> news:1191505654.310090.315540@.k79g2000hse.googlegroups.com...
> > Tibor,
> > I found an account to get in and did find that the group was not in
> > the sysadmin role. This was in the sysadmin role on Friday but on
> > Monday it wasn't there. Do you have any ideas what might have caused
> > this?
> > Thanks for your advice.
> > --
> > Jerry
> > On Oct 4, 7:50 am, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> > Unfortunately my account no
> >> > longer has the permissions it needs to check if it's in the sysadmins
> >> > group.
> >> It seems it isn't in the sysadmin group, or you would have been able to check that (assuming you
> >> are
> >> logged in though this Windows group). So you need to go and find somebody who has privileges to
> >> check this...
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >>news:1191500677.281166.191150@.w3g2000hsg.googlegroups.com...
> >> > Thanks for the reply. I checked and the admin group that was set up
> >> > for me is still in the SQL Users list. Unfortunately my account no
> >> > longer has the permissions it needs to check if it's in the sysadmins
> >> > group.
> >> > --
> >> > Jerry
> >> > On Oct 2, 3:46 pm, "Tibor Karaszi"
> >> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> >> Check out your Logins in SQL Server, whether or not for instance the local Administrators
> >> >> group
> >> >> is
> >> >> still there, and whether it is a member of the sysadmin server role.
> >> >> --
> >> >> Tibor Karaszi, SQL Server
> >> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> >> "Jerry" <jerrya...@.gmail.com> wrote in message
> >> >>news:1191357676.328164.54550@.50g2000hsm.googlegroups.com...
> >> >> > Hello!
> >> >> > At some point over the weekend my user account (which is an admin
> >> >> > account) lost the ability to perform administrative tasks in SQL
> >> >> > Server 2000. I can no longer create a database, create users, modify
> >> >> > existing tables, etc. Three days ago I was able to create a database
> >> >> > with no problems. The network guy and I are trying to figure out what
> >> >> > caused this problem. It seems that all admin accounts have lost these
> >> >> > permissions. Does anyone have any suggestions what I can check for?
Labels:
ability,
admin,
administrative,
database,
microsoft,
mysql,
oracle,
perform,
permissions,
point,
server,
sql,
tasks,
user,
weekend
Permissions and Administration
Do you have to be a member of the local win2K administrators group in-order
to perform administration functions and create folders in Reporting Services?Any user can be given permissions to administer Reporting Services. If
using Forms Authentication, you don't have Windows users at all. In that
case, you can set a default administrator account in the
RSReportServer.config file (replace "USERNAMEHERE"):
<Security>
<Extension Name="Forms"
Type="RSCustomSecurity.Authorization,
ReportingServices.RSCustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>USERNAMEHERE</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
I haven't tried setting the AdminConfiguration UserName for when Extension
Name="Windows", but it may be worth a shot.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> Do you have to be a member of the local win2K administrators group
> in-order
> to perform administration functions and create folders in Reporting
> Services?|||When we installed RS on a production server, we can't see the contents or
properties tab on the home page. We also do not see the New Folder or New
Data Source or Upload Files buttons and therefore can not create folders.
We had the NT administrator go into Site Settings page and add our NT
accounts on the System Role Assignments page as systems administrators, but
that did not help either. This works fine on our development server but were
also in the local admin group on that server.
"Jeff A. Stucker" wrote:
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>
>|||Hi,
I have the exact same issue. I have tried the suggested workaround below,
but the problem presists. Do you have any other ideas?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||I have the exact same issue.
I have tried the workaround below, but problem persists.
pls help.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||No I have not found the answer for this. I am starting to believe this
product is more trouble than it's worth. If I figure this out I'll let you
know.
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I have resolved this issue.
Follow these steps.
1. have an windows administrator go to to the report server web page.
click sitesetting and add you Windowns account as a systems administrator.
2. Have the windows administrator then got to the home page press new
folder and create your new folder, The have them add your windows local group
or domain account as a content manager for this new folder.
Once this is complete you should see this folder on the home page as well as
the New folder, New Data Source asnd Upload buttons.
Andy
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I logged on as the local administrator and yes I got to the home page and
added my domain account as a systems adminstrator.
I could see all the tabs.
But then logging on as myself, I still only see the 'contents' tab.
I went back as adminstrator to check, and as adminstrator I can only see the
contents tab !!!
I am really stumped by this - it is like you say a "very difficult" product.
Do you (or anyone) have any ideas , I'm desperate.
"ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> I have resolved this issue.
> Follow these steps.
> 1. have an windows administrator go to to the report server web page.
> click sitesetting and add you Windowns account as a systems administrator.
> 2. Have the windows administrator then got to the home page press new
> folder and create your new folder, The have them add your windows local
group
> or domain account as a content manager for this new folder.
> Once this is complete you should see this folder on the home page as well
as
> the New folder, New Data Source asnd Upload buttons.
> Andy
> "RIchard Baldock" wrote:
> > I have the exact same issue.
> > I have tried the workaround below, but problem persists.
> > pls help.
> >
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Any user can be given permissions to administer Reporting Services.
If
> > > using Forms Authentication, you don't have Windows users at all. In
that
> > > case, you can set a default administrator account in the
> > > RSReportServer.config file (replace "USERNAMEHERE"):
> > >
> > > <Security>
> > > <Extension Name="Forms"
> > > Type="RSCustomSecurity.Authorization,
> > > ReportingServices.RSCustomSecurity" >
> > > <Configuration>
> > > <AdminConfiguration>
> > > <UserName>USERNAMEHERE</UserName>
> > > </AdminConfiguration>
> > > </Configuration>
> > > </Extension>
> > > </Security>
> > >
> > > I haven't tried setting the AdminConfiguration UserName for when
Extension
> > > Name="Windows", but it may be worth a shot.
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > Do you have to be a member of the local win2K administrators group
> > > > in-order
> > > > to perform administration functions and create folders in Reporting
> > > > Services?
> > >
> > >
> >
> >
> >|||I have "solved" this.
1. If you would like to see & use all the TABS on the "/Reports" Virtual
directory - disable anonymous access on both the "/Reports" and
"/Reportserver" Virtual directories.
Or
2. If you need to provide anonymous access to your "/Reportserver " virtual
directory then you will not be able to see & use all the TABS on "/Reports"
virtual directory simultaneously.
The obvious workaround is point 1 above. These can be shuffled as required.
Shitty but true. I guess this release was not "intended" to be used over web
etc ?
"RIchard Baldock" <RIchardBaldock@.community.nospam> wrote in message
news:e9SGPKb4EHA.3644@.tk2msftngp13.phx.gbl...
> I logged on as the local administrator and yes I got to the home page and
> added my domain account as a systems adminstrator.
> I could see all the tabs.
> But then logging on as myself, I still only see the 'contents' tab.
> I went back as adminstrator to check, and as adminstrator I can only see
the
> contents tab !!!
> I am really stumped by this - it is like you say a "very difficult"
product.
> Do you (or anyone) have any ideas , I'm desperate.
>
> "ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
> news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> > I have resolved this issue.
> >
> > Follow these steps.
> >
> > 1. have an windows administrator go to to the report server web page.
> > click sitesetting and add you Windowns account as a systems
administrator.
> >
> > 2. Have the windows administrator then got to the home page press new
> > folder and create your new folder, The have them add your windows local
> group
> > or domain account as a content manager for this new folder.
> >
> > Once this is complete you should see this folder on the home page as
well
> as
> > the New folder, New Data Source asnd Upload buttons.
> >
> > Andy
> >
> > "RIchard Baldock" wrote:
> >
> > > I have the exact same issue.
> > > I have tried the workaround below, but problem persists.
> > > pls help.
> > >
> > >
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Any user can be given permissions to administer Reporting Services.
> If
> > > > using Forms Authentication, you don't have Windows users at all. In
> that
> > > > case, you can set a default administrator account in the
> > > > RSReportServer.config file (replace "USERNAMEHERE"):
> > > >
> > > > <Security>
> > > > <Extension Name="Forms"
> > > > Type="RSCustomSecurity.Authorization,
> > > > ReportingServices.RSCustomSecurity" >
> > > > <Configuration>
> > > > <AdminConfiguration>
> > > > <UserName>USERNAMEHERE</UserName>
> > > > </AdminConfiguration>
> > > > </Configuration>
> > > > </Extension>
> > > > </Security>
> > > >
> > > > I haven't tried setting the AdminConfiguration UserName for when
> Extension
> > > > Name="Windows", but it may be worth a shot.
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > > Do you have to be a member of the local win2K administrators group
> > > > > in-order
> > > > > to perform administration functions and create folders in
Reporting
> > > > > Services?
> > > >
> > > >
> > >
> > >
> > >
>
to perform administration functions and create folders in Reporting Services?Any user can be given permissions to administer Reporting Services. If
using Forms Authentication, you don't have Windows users at all. In that
case, you can set a default administrator account in the
RSReportServer.config file (replace "USERNAMEHERE"):
<Security>
<Extension Name="Forms"
Type="RSCustomSecurity.Authorization,
ReportingServices.RSCustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>USERNAMEHERE</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
I haven't tried setting the AdminConfiguration UserName for when Extension
Name="Windows", but it may be worth a shot.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Andy998" <Andy998@.discussions.microsoft.com> wrote in message
news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> Do you have to be a member of the local win2K administrators group
> in-order
> to perform administration functions and create folders in Reporting
> Services?|||When we installed RS on a production server, we can't see the contents or
properties tab on the home page. We also do not see the New Folder or New
Data Source or Upload Files buttons and therefore can not create folders.
We had the NT administrator go into Site Settings page and add our NT
accounts on the System Role Assignments page as systems administrators, but
that did not help either. This works fine on our development server but were
also in the local admin group on that server.
"Jeff A. Stucker" wrote:
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>
>|||Hi,
I have the exact same issue. I have tried the suggested workaround below,
but the problem presists. Do you have any other ideas?
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||I have the exact same issue.
I have tried the workaround below, but problem persists.
pls help.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> Any user can be given permissions to administer Reporting Services. If
> using Forms Authentication, you don't have Windows users at all. In that
> case, you can set a default administrator account in the
> RSReportServer.config file (replace "USERNAMEHERE"):
> <Security>
> <Extension Name="Forms"
> Type="RSCustomSecurity.Authorization,
> ReportingServices.RSCustomSecurity" >
> <Configuration>
> <AdminConfiguration>
> <UserName>USERNAMEHERE</UserName>
> </AdminConfiguration>
> </Configuration>
> </Extension>
> </Security>
> I haven't tried setting the AdminConfiguration UserName for when Extension
> Name="Windows", but it may be worth a shot.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > Do you have to be a member of the local win2K administrators group
> > in-order
> > to perform administration functions and create folders in Reporting
> > Services?
>|||No I have not found the answer for this. I am starting to believe this
product is more trouble than it's worth. If I figure this out I'll let you
know.
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I have resolved this issue.
Follow these steps.
1. have an windows administrator go to to the report server web page.
click sitesetting and add you Windowns account as a systems administrator.
2. Have the windows administrator then got to the home page press new
folder and create your new folder, The have them add your windows local group
or domain account as a content manager for this new folder.
Once this is complete you should see this folder on the home page as well as
the New folder, New Data Source asnd Upload buttons.
Andy
"RIchard Baldock" wrote:
> I have the exact same issue.
> I have tried the workaround below, but problem persists.
> pls help.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > Any user can be given permissions to administer Reporting Services. If
> > using Forms Authentication, you don't have Windows users at all. In that
> > case, you can set a default administrator account in the
> > RSReportServer.config file (replace "USERNAMEHERE"):
> >
> > <Security>
> > <Extension Name="Forms"
> > Type="RSCustomSecurity.Authorization,
> > ReportingServices.RSCustomSecurity" >
> > <Configuration>
> > <AdminConfiguration>
> > <UserName>USERNAMEHERE</UserName>
> > </AdminConfiguration>
> > </Configuration>
> > </Extension>
> > </Security>
> >
> > I haven't tried setting the AdminConfiguration UserName for when Extension
> > Name="Windows", but it may be worth a shot.
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > Do you have to be a member of the local win2K administrators group
> > > in-order
> > > to perform administration functions and create folders in Reporting
> > > Services?
> >
> >
>
>|||I logged on as the local administrator and yes I got to the home page and
added my domain account as a systems adminstrator.
I could see all the tabs.
But then logging on as myself, I still only see the 'contents' tab.
I went back as adminstrator to check, and as adminstrator I can only see the
contents tab !!!
I am really stumped by this - it is like you say a "very difficult" product.
Do you (or anyone) have any ideas , I'm desperate.
"ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> I have resolved this issue.
> Follow these steps.
> 1. have an windows administrator go to to the report server web page.
> click sitesetting and add you Windowns account as a systems administrator.
> 2. Have the windows administrator then got to the home page press new
> folder and create your new folder, The have them add your windows local
group
> or domain account as a content manager for this new folder.
> Once this is complete you should see this folder on the home page as well
as
> the New folder, New Data Source asnd Upload buttons.
> Andy
> "RIchard Baldock" wrote:
> > I have the exact same issue.
> > I have tried the workaround below, but problem persists.
> > pls help.
> >
> >
> > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > Any user can be given permissions to administer Reporting Services.
If
> > > using Forms Authentication, you don't have Windows users at all. In
that
> > > case, you can set a default administrator account in the
> > > RSReportServer.config file (replace "USERNAMEHERE"):
> > >
> > > <Security>
> > > <Extension Name="Forms"
> > > Type="RSCustomSecurity.Authorization,
> > > ReportingServices.RSCustomSecurity" >
> > > <Configuration>
> > > <AdminConfiguration>
> > > <UserName>USERNAMEHERE</UserName>
> > > </AdminConfiguration>
> > > </Configuration>
> > > </Extension>
> > > </Security>
> > >
> > > I haven't tried setting the AdminConfiguration UserName for when
Extension
> > > Name="Windows", but it may be worth a shot.
> > > --
> > > Cheers,
> > >
> > > '(' Jeff A. Stucker
> > > \
> > >
> > > Business Intelligence
> > > www.criadvantage.com
> > > ---
> > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > Do you have to be a member of the local win2K administrators group
> > > > in-order
> > > > to perform administration functions and create folders in Reporting
> > > > Services?
> > >
> > >
> >
> >
> >|||I have "solved" this.
1. If you would like to see & use all the TABS on the "/Reports" Virtual
directory - disable anonymous access on both the "/Reports" and
"/Reportserver" Virtual directories.
Or
2. If you need to provide anonymous access to your "/Reportserver " virtual
directory then you will not be able to see & use all the TABS on "/Reports"
virtual directory simultaneously.
The obvious workaround is point 1 above. These can be shuffled as required.
Shitty but true. I guess this release was not "intended" to be used over web
etc ?
"RIchard Baldock" <RIchardBaldock@.community.nospam> wrote in message
news:e9SGPKb4EHA.3644@.tk2msftngp13.phx.gbl...
> I logged on as the local administrator and yes I got to the home page and
> added my domain account as a systems adminstrator.
> I could see all the tabs.
> But then logging on as myself, I still only see the 'contents' tab.
> I went back as adminstrator to check, and as adminstrator I can only see
the
> contents tab !!!
> I am really stumped by this - it is like you say a "very difficult"
product.
> Do you (or anyone) have any ideas , I'm desperate.
>
> "ANDY998" <ANDY998@.discussions.microsoft.com> wrote in message
> news:284DD604-9DFE-4448-BF9A-D6D2DD03277E@.microsoft.com...
> > I have resolved this issue.
> >
> > Follow these steps.
> >
> > 1. have an windows administrator go to to the report server web page.
> > click sitesetting and add you Windowns account as a systems
administrator.
> >
> > 2. Have the windows administrator then got to the home page press new
> > folder and create your new folder, The have them add your windows local
> group
> > or domain account as a content manager for this new folder.
> >
> > Once this is complete you should see this folder on the home page as
well
> as
> > the New folder, New Data Source asnd Upload buttons.
> >
> > Andy
> >
> > "RIchard Baldock" wrote:
> >
> > > I have the exact same issue.
> > > I have tried the workaround below, but problem persists.
> > > pls help.
> > >
> > >
> > > "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > > news:OjW8H8i3EHA.2592@.TK2MSFTNGP09.phx.gbl...
> > > > Any user can be given permissions to administer Reporting Services.
> If
> > > > using Forms Authentication, you don't have Windows users at all. In
> that
> > > > case, you can set a default administrator account in the
> > > > RSReportServer.config file (replace "USERNAMEHERE"):
> > > >
> > > > <Security>
> > > > <Extension Name="Forms"
> > > > Type="RSCustomSecurity.Authorization,
> > > > ReportingServices.RSCustomSecurity" >
> > > > <Configuration>
> > > > <AdminConfiguration>
> > > > <UserName>USERNAMEHERE</UserName>
> > > > </AdminConfiguration>
> > > > </Configuration>
> > > > </Extension>
> > > > </Security>
> > > >
> > > > I haven't tried setting the AdminConfiguration UserName for when
> Extension
> > > > Name="Windows", but it may be worth a shot.
> > > > --
> > > > Cheers,
> > > >
> > > > '(' Jeff A. Stucker
> > > > \
> > > >
> > > > Business Intelligence
> > > > www.criadvantage.com
> > > > ---
> > > > "Andy998" <Andy998@.discussions.microsoft.com> wrote in message
> > > > news:5E59ADDF-629E-45E7-BEE8-BC1206B3733E@.microsoft.com...
> > > > > Do you have to be a member of the local win2K administrators group
> > > > > in-order
> > > > > to perform administration functions and create folders in
Reporting
> > > > > Services?
> > > >
> > > >
> > >
> > >
> > >
>
Labels:
administration,
administrators,
create,
database,
folders,
functions,
group,
in-order,
local,
member,
microsoft,
mysql,
oracle,
perform,
permissions,
reporting,
server,
sql,
win2k
Subscribe to:
Posts (Atom)