|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2000 - Setting EM to check status of serversHello all,
Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can leave it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check when I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to connect?". Is there any way to set EM on my machine to do this? I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show the current status of the server. -- Thanks for any help anyone can provide, Conan Kelly Probably because of the windows permissions against the machine you connect to (allowed to see
service state etc). -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... > Hello all, > > Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the > "status" circle blank. I can leave it open all day long and it will never > check/"poll"/what-have-you the server to see what the status is. It will only check when I click > on the server I want to use. Sometimes I get the error message "...not known to be running, do > you still want to connect?". > > Is there any way to set EM on my machine to do this? > > I think on my boss's machine it will check/poll the servers after a couple of secs and the status > circles will update to show the current status of the server. > > -- > Thanks for any help anyone can provide, > > Conan Kelly > Tibor,
Thank you for the feed back. > Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct this? Do I need to change Policies? ...on my machine? ... on the server? Thanks again for all of your help, Conan Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... > Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >> Hello all, >> >> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can leave >> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check when >> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >> connect?". >> >> Is there any way to set EM on my machine to do this? >> >> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show the >> current status of the server. >> >> -- >> Thanks for any help anyone can provide, >> >> Conan Kelly >> > Yes, talk to the network admin. I'm not enough windows person to answer this. It could be that you
have a firewall that doesn't let through the type of traffic used by windows to see whether services are started (I assume RPC), for instance. Basically, this is a Windows issue. The Windows account you are using and your network config need to be able to see the state of services on the remote machine. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%236tOXMn3GHA.2096@TK2MSFTNGP05.phx.gbl... > Tibor, > > Thank you for the feed back. > >> Probably because of the windows permissions against the machine you connect to (allowed to see >> service state etc). > > What do you mean by this? The permissions settings on my work station or the settings on the > server? I'm guessing that this is something that only my network admin is able to fix this. What > settings on which machine need to be changed in order to correct this? Do I need to change > Policies? ...on my machine? ... on the server? > > Thanks again for all of your help, > > Conan > > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message > news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >> Probably because of the windows permissions against the machine you connect to (allowed to see >> service state etc). >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message >> news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>> Hello all, >>> >>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the >>> "status" circle blank. I can leave it open all day long and it will never >>> check/"poll"/what-have-you the server to see what the status is. It will only check when I >>> click on the server I want to use. Sometimes I get the error message "...not known to be >>> running, do you still want to connect?". >>> >>> Is there any way to set EM on my machine to do this? >>> >>> I think on my boss's machine it will check/poll the servers after a couple of secs and the >>> status circles will update to show the current status of the server. >>> >>> -- >>> Thanks for any help anyone can provide, >>> >>> Conan Kelly >>> >> > > It would be the permissions you have used in Enterprise
Manager to register the server and the permissions for that on the server you registered. -Sue On Fri, 22 Sep 2006 11:15:31 -0700, "Conan Kelly" <CTBarbarin at msn dot com> wrote: Show quote >Tibor, > >Thank you for the feed back. > >> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). > >What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is >something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct >this? Do I need to change Policies? ...on my machine? ... on the server? > >Thanks again for all of your help, > >Conan > > > >"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>> Hello all, >>> >>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can leave >>> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check when >>> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >>> connect?". >>> >>> Is there any way to set EM on my machine to do this? >>> >>> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show the >>> current status of the server. >>> >>> -- >>> Thanks for any help anyone can provide, >>> >>> Conan Kelly >>> >> > Sue,
Thank you for the feedback. I'm still not quite sure what you mean. If you can provide step-by-step instructions for solving this issue, that would be greatly appreciated. Thanks again for all of your help, Conan Kelly Show quote "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:1hg8h2p0rp40610cv1i4sva5cfc2q57lal@4ax.com... > It would be the permissions you have used in Enterprise > Manager to register the server and the permissions for that > on the server you registered. > > -Sue > > On Fri, 22 Sep 2006 11:15:31 -0700, "Conan Kelly" > <CTBarbarin at msn dot com> wrote: > >>Tibor, >> >>Thank you for the feed back. >> >>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >> >>What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is >>something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct >>this? Do I need to change Policies? ...on my machine? ... on the server? >> >>Thanks again for all of your help, >> >>Conan >> >> >> >>"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://www.solidqualitylearning.com/ >>> >>> >>> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>>> Hello all, >>>> >>>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can >>>> leave >>>> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check >>>> when >>>> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >>>> connect?". >>>> >>>> Is there any way to set EM on my machine to do this? >>>> >>>> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show >>>> the >>>> current status of the server. >>>> >>>> -- >>>> Thanks for any help anyone can provide, >>>> >>>> Conan Kelly >>>> >>> >> > You have a login that use you to register the SQL Server.
That login does not have permissions to poll the services on the registered server. If my windows login is Domain\SomeUser and If I register a server named SomeServer and using a windows authentication then SomeUser needs permissions on SomeServer to poll the services. You can also have other network components in there that affects this - particularly firewalls as Tibor mentioned. You need to check with your network group. -Sue On Fri, 22 Sep 2006 13:17:20 -0700, "Conan Kelly" <CTBarbarin at msn dot com> wrote: Show quote >Sue, > >Thank you for the feedback. > >I'm still not quite sure what you mean. If you can provide step-by-step instructions for solving this issue, that would be greatly >appreciated. > >Thanks again for all of your help, > >Conan Kelly > > >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:1hg8h2p0rp40610cv1i4sva5cfc2q57lal@4ax.com... >> It would be the permissions you have used in Enterprise >> Manager to register the server and the permissions for that >> on the server you registered. >> >> -Sue >> >> On Fri, 22 Sep 2006 11:15:31 -0700, "Conan Kelly" >> <CTBarbarin at msn dot com> wrote: >> >>>Tibor, >>> >>>Thank you for the feed back. >>> >>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>> >>>What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is >>>something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct >>>this? Do I need to change Policies? ...on my machine? ... on the server? >>> >>>Thanks again for all of your help, >>> >>>Conan >>> >>> >>> >>>"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>>> >>>> -- >>>> Tibor Karaszi, SQL Server MVP >>>> http://www.karaszi.com/sqlserver/default.asp >>>> http://www.solidqualitylearning.com/ >>>> >>>> >>>> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>>>> Hello all, >>>>> >>>>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can >>>>> leave >>>>> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check >>>>> when >>>>> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >>>>> connect?". >>>>> >>>>> Is there any way to set EM on my machine to do this? >>>>> >>>>> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show >>>>> the >>>>> current status of the server. >>>>> >>>>> -- >>>>> Thanks for any help anyone can provide, >>>>> >>>>> Conan Kelly >>>>> >>>> >>> >> > Sue,
Thanks again for your help > You need to check with your network group. I'm asking for instructions because we are a small business (6 users) and we can do some network administration ourselves if we have the instructions to do so (my boss has an admin login and he knows the password to the main admin login). Besides, if we can save a few bucks by doing it ourselves rather than call our networking people out, all the better. Otherwise, I'll have to put this on a list and try to remember to have them look at it the next time they are here (will be a lot longer before this issue is resolved). If I can get detailed instructions, then I can take it to my boss and have him do it for me. > then SomeUser needs permissions on SomeServer to poll the how do we give SomeUser the permissions to poll the services on SomeServer? Is this a local policy on SomeServer that needs to be > services. changed? (If so, what policy is it?) Is it something in Active Directory U's & C's that needs to be changed? Do we need to use Group Policy Editor to do this? After we check/adjust permissions, then we'll look into firewalls and other network components. Thanks again for all of your help, Conan Show quote "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:4nh8h2phvb2tubkq1l0cfuimd54etet9r3@4ax.com... > You have a login that use you to register the SQL Server. > That login does not have permissions to poll the services on > the registered server. > If my windows login is Domain\SomeUser and If I register a > server named SomeServer and using a windows authentication > then SomeUser needs permissions on SomeServer to poll the > services. > You can also have other network components in there that > affects this - particularly firewalls as Tibor mentioned. > You need to check with your network group. > > -Sue > > On Fri, 22 Sep 2006 13:17:20 -0700, "Conan Kelly" > <CTBarbarin at msn dot com> wrote: > >>Sue, >> >>Thank you for the feedback. >> >>I'm still not quite sure what you mean. If you can provide step-by-step instructions for solving this issue, that would be >>greatly >>appreciated. >> >>Thanks again for all of your help, >> >>Conan Kelly >> >> >>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:1hg8h2p0rp40610cv1i4sva5cfc2q57lal@4ax.com... >>> It would be the permissions you have used in Enterprise >>> Manager to register the server and the permissions for that >>> on the server you registered. >>> >>> -Sue >>> >>> On Fri, 22 Sep 2006 11:15:31 -0700, "Conan Kelly" >>> <CTBarbarin at msn dot com> wrote: >>> >>>>Tibor, >>>> >>>>Thank you for the feed back. >>>> >>>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>>> >>>>What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is >>>>something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct >>>>this? Do I need to change Policies? ...on my machine? ... on the server? >>>> >>>>Thanks again for all of your help, >>>> >>>>Conan >>>> >>>> >>>> >>>>"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message >>>>news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >>>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>>>> >>>>> -- >>>>> Tibor Karaszi, SQL Server MVP >>>>> http://www.karaszi.com/sqlserver/default.asp >>>>> http://www.solidqualitylearning.com/ >>>>> >>>>> >>>>> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>>>>> Hello all, >>>>>> >>>>>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can >>>>>> leave >>>>>> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check >>>>>> when >>>>>> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >>>>>> connect?". >>>>>> >>>>>> Is there any way to set EM on my machine to do this? >>>>>> >>>>>> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show >>>>>> the >>>>>> current status of the server. >>>>>> >>>>>> -- >>>>>> Thanks for any help anyone can provide, >>>>>> >>>>>> Conan Kelly >>>>>> >>>>> >>>> >>> >> > Conan Kelly (CTBarbarin at msn dot com) writes:
> I'm asking for instructions because we are a small business (6 users) I guess people here are reluctanct to give you detailed instructions, > and we can do some network administration ourselves if we have the > instructions to do so (my boss has an admin login and he knows the > password to the main admin login). Besides, if we can save a few bucks > by doing it ourselves rather than call our networking people out, all > the better. Otherwise, I'll have to put this on a list and try to > remember to have them look at it the next time they are here (will be a > lot longer before this issue is resolved). If I can get detailed > instructions, then I can take it to my boss and have him do it for me. because there are so many ifs and buts. Your network staff knows how your network is configured, and people here don't. Add to that, we are mainly SQL Server people, and this requires knowledge about Windows networking which definitely not an area I have expertise in. But before you call in the network people, right-click the server and select "Edit SQL Server Registration Properties" and check that "Display SQL Server state in console" is checked. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx It gets a bit more convoluted than that depending on a lot
of things. Easiest way if you want it working like your bosses is to set your account and registrations up like your bosses. -Sue On Fri, 22 Sep 2006 14:51:25 -0700, "Conan Kelly" <CTBarbarin at msn dot com> wrote: Show quote >Sue, > >Thanks again for your help > >> You need to check with your network group. > >I'm asking for instructions because we are a small business (6 users) and we can do some network administration ourselves if we have >the instructions to do so (my boss has an admin login and he knows the password to the main admin login). Besides, if we can save a >few bucks by doing it ourselves rather than call our networking people out, all the better. Otherwise, I'll have to put this on a >list and try to remember to have them look at it the next time they are here (will be a lot longer before this issue is resolved). >If I can get detailed instructions, then I can take it to my boss and have him do it for me. > >> then SomeUser needs permissions on SomeServer to poll the >> services. > >how do we give SomeUser the permissions to poll the services on SomeServer? Is this a local policy on SomeServer that needs to be >changed? (If so, what policy is it?) Is it something in Active Directory U's & C's that needs to be changed? Do we need to use >Group Policy Editor to do this? > >After we check/adjust permissions, then we'll look into firewalls and other network components. > >Thanks again for all of your help, > >Conan > > > >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:4nh8h2phvb2tubkq1l0cfuimd54etet9r3@4ax.com... >> You have a login that use you to register the SQL Server. >> That login does not have permissions to poll the services on >> the registered server. >> If my windows login is Domain\SomeUser and If I register a >> server named SomeServer and using a windows authentication >> then SomeUser needs permissions on SomeServer to poll the >> services. >> You can also have other network components in there that >> affects this - particularly firewalls as Tibor mentioned. >> You need to check with your network group. >> >> -Sue >> >> On Fri, 22 Sep 2006 13:17:20 -0700, "Conan Kelly" >> <CTBarbarin at msn dot com> wrote: >> >>>Sue, >>> >>>Thank you for the feedback. >>> >>>I'm still not quite sure what you mean. If you can provide step-by-step instructions for solving this issue, that would be >>>greatly >>>appreciated. >>> >>>Thanks again for all of your help, >>> >>>Conan Kelly >>> >>> >>>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message news:1hg8h2p0rp40610cv1i4sva5cfc2q57lal@4ax.com... >>>> It would be the permissions you have used in Enterprise >>>> Manager to register the server and the permissions for that >>>> on the server you registered. >>>> >>>> -Sue >>>> >>>> On Fri, 22 Sep 2006 11:15:31 -0700, "Conan Kelly" >>>> <CTBarbarin at msn dot com> wrote: >>>> >>>>>Tibor, >>>>> >>>>>Thank you for the feed back. >>>>> >>>>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>>>> >>>>>What do you mean by this? The permissions settings on my work station or the settings on the server? I'm guessing that this is >>>>>something that only my network admin is able to fix this. What settings on which machine need to be changed in order to correct >>>>>this? Do I need to change Policies? ...on my machine? ... on the server? >>>>> >>>>>Thanks again for all of your help, >>>>> >>>>>Conan >>>>> >>>>> >>>>> >>>>>"Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message >>>>>news:uO0hZ7m3GHA.1040@TK2MSFTNGP06.phx.gbl... >>>>>> Probably because of the windows permissions against the machine you connect to (allowed to see service state etc). >>>>>> >>>>>> -- >>>>>> Tibor Karaszi, SQL Server MVP >>>>>> http://www.karaszi.com/sqlserver/default.asp >>>>>> http://www.solidqualitylearning.com/ >>>>>> >>>>>> >>>>>> "Conan Kelly" <CTBarbarin at msn dot com> wrote in message news:%23C5CRtm3GHA.2196@TK2MSFTNGP06.phx.gbl... >>>>>>> Hello all, >>>>>>> >>>>>>> Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank. I can >>>>>>> leave >>>>>>> it open all day long and it will never check/"poll"/what-have-you the server to see what the status is. It will only check >>>>>>> when >>>>>>> I click on the server I want to use. Sometimes I get the error message "...not known to be running, do you still want to >>>>>>> connect?". >>>>>>> >>>>>>> Is there any way to set EM on my machine to do this? >>>>>>> >>>>>>> I think on my boss's machine it will check/poll the servers after a couple of secs and the status circles will update to show >>>>>>> the >>>>>>> current status of the server. >>>>>>> >>>>>>> -- >>>>>>> Thanks for any help anyone can provide, >>>>>>> >>>>>>> Conan Kelly >>>>>>> >>>>>> >>>>> >>>> >>> >> >  |
|||||||||||||||||||||||
Other interesting topics