Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterprise
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
Bing
Hi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged in
> using my domain account which is member of an admin group. But in Enterprise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and had
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
John
Showing posts with label admin. Show all posts
Showing posts with label admin. Show all posts
Friday, March 30, 2012
No items under SQL server group
Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterpris
e
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged
in
> using my domain account which is member of an admin group. But in Enterpr
ise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and h
ad
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
John
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterpris
e
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged
in
> using my domain account which is member of an admin group. But in Enterpr
ise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and h
ad
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
John
No items under SQL server group
Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterprise
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged in
> using my domain account which is member of an admin group. But in Enterprise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and had
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
Johnsql
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterprise
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged in
> using my domain account which is member of an admin group. But in Enterprise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and had
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
Johnsql
Wednesday, March 21, 2012
No administrator privileges
I've logged into our database server to update some reports and found
out that I go to manage RS I have no admin privileges! This happened
all of a sudden as a week ago with the same login details I could do it
just fine and now I just have vanilla screen for users with no rights.
I've most probably stuffed something up without realising it, please
help!Check the websites. Most likely you have turned anonymous on (this is an IIS
thing). If anonymous then you are anonymous, RS doesn't know you are an
admin.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ocbka1@.gmail.com> wrote in message
news:1145322356.507391.151480@.v46g2000cwv.googlegroups.com...
> I've logged into our database server to update some reports and found
> out that I go to manage RS I have no admin privileges! This happened
> all of a sudden as a week ago with the same login details I could do it
> just fine and now I just have vanilla screen for users with no rights.
> I've most probably stuffed something up without realising it, please
> help!
>|||Thanks!! I've taken anonymous access off but that also means that
whenever I try to access a report (web server is a different box) it's
asking me for username and password. What should I do?
out that I go to manage RS I have no admin privileges! This happened
all of a sudden as a week ago with the same login details I could do it
just fine and now I just have vanilla screen for users with no rights.
I've most probably stuffed something up without realising it, please
help!Check the websites. Most likely you have turned anonymous on (this is an IIS
thing). If anonymous then you are anonymous, RS doesn't know you are an
admin.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ocbka1@.gmail.com> wrote in message
news:1145322356.507391.151480@.v46g2000cwv.googlegroups.com...
> I've logged into our database server to update some reports and found
> out that I go to manage RS I have no admin privileges! This happened
> all of a sudden as a week ago with the same login details I could do it
> just fine and now I just have vanilla screen for users with no rights.
> I've most probably stuffed something up without realising it, please
> help!
>|||Thanks!! I've taken anonymous access off but that also means that
whenever I try to access a report (web server is a different box) it's
asking me for username and password. What should I do?
Subscribe to:
Posts (Atom)