| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2004-09-27 : 10:05:15
|
| When I came to work this morning and tried to log on using Terminal Services with my account to the production database server, I was quite amazed at the fact that my account was actually locked out. After doing *quite* a bit of snooping around the firewall, all sorts of logs and in every corner I could think of I actually found out by mere chance that it was Enterprise Manager that was causing it!! It tried to log on to the database with my workstation credentials constantly up to 4 times/sec!The thing is that I actually have the same account-name on my workstation as I use on the production database, but the passwords are not the same. And when I connect to the prod-db in EM I always use sql-server authentication, so I'm totally confused here. What is causing EM to go nuts trying to log me on with NT-authentication?? It starts as soon as I open the "SQL Server Group", I don't even have to connect to the prod-db...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
MuadDBA
628 Posts |
Posted - 2004-09-27 : 14:31:25
|
| I have has similar issues here, with some of the production team asking me why (I'm a developer now) I am logging into the production servers several times each minute. I have no idea what causes this, other than enterprise manager, even if I log in using SQL Auth. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-27 : 14:44:09
|
| In EM, go to Tools..General tab. Your machine is polling the SQL Servers for its state. You can change the polling interval in that option.Tara |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-09-27 : 14:46:22
|
| Do we need to poll... That is if the services are running and we use EM won't it just process the request?Surf On Dude! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-27 : 14:47:27
|
| The polling is just to check the status of the services, so you'll see green arrow or red dot for each SQL Server depending on the service state. Just depends if you want that option or not.Tara |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-09-27 : 14:50:54
|
Cool! I'm at home now and I don't have access to the prod-server right now, but I'm using my laptop at home also and it said to poll every 10 secs. I compleely removed it as I see this info to be totally useless, but I still don't get why it polled up to 4 times/sec. Guess it doesn't matter...I'll have to wait until tomorrow to see if that did the trick. But knowing tara, I'm sure it did  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-27 : 14:59:10
|
| I think this will help, but it may not solve the problem completely. I think that there was a bug related to this. Is your laptop patched with service pack 3a and security patch 818? Regardless if it has SQL Server server components installed, clients with SQL Client Tools should also be patched.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-09-27 : 15:44:02
|
| Changing the polling interval had no effect for me, perhaps I'll try the service pack. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-28 : 00:55:23
|
| what's the error message when you do try to logon? if you logon using a standard account, are you still being locked out? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-09-28 : 04:08:36
|
| Back at work and after rebooting and disabeling the poll and everything seems to be back to normal. I was not aware that EM did this on such a regular basis, and I'm having a hard time understanding what use this feature has at all. Oh well, thanx alot to tara who again helped me with a major headache! I don't know what I would have done without you guys...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
Obscure EM problem