November 17, 2010 at 3:12 am
We have a number of instances from sql server 7 to sql server 2008 r2. Some named some default. In sql 7.0/2000 you use to be able to switch off polling of registered servers, this was most helpful especailly when we had to pay each time and ISDN line was brought up. Since ADSL and Fibre it's not such an issue. But the main problem is the spamming of the event logs with useless information.
I am specifically talking about sql 2005 and 2008 and r2. We run the lastest service pack and I have followed the Buck Woody's KB from Microsoft on the fix for 2005/2008 ssms and this worked for my account or so I thought. I have been doing some in depth testing on this and found some strange behaviour.
Under my account which was an local admin which had server and sql server admin rights on our domain it looked like it was working, but I only had 2005 servers registered in ssms 2005.
When I changed my account to a standard user account and started using a admin account for the high privilege stuff i.e. server admin and sql admin, on my standard account it remained working. But I have noticed on my admin account, when used the run as command, polls some of the registered servers, but not all. My standard account does not poll any servers except on startup which both do, but they don't continue to.
On further testing I found that if I registered a particular sql 2000 server on my standard account it starts polling this server and I have try other sql 2000 server, but it doesn't poll them. I have taken into consideration which servers my standard account can connect to and has rights to, service pack levels and editions and versions, named instances and default instances, but I can't replicated the behaviour with any other servers. This server happen to be a default instance running on a standard port and was in a dmz.
I am about to release a policy for all our developers and DBAs so we can prevent this polling, but I have very little confidence in the Microsoft fix until i can get my our admin account working as it should.
Any ideas welcome.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply