Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2003-03-04 : 06:29:15
|
| Right guys here's the situation, can anybody advise.We deploy enterprise manager plus other client tools over a citrix client server neighbourhood. (People basically run the tools from the server which also has the rest of SQLServer 2000 on it).Ok a few weeks ago we started to get some problems with enterprise manager, so we re-installed the client tools. This has resolved all problems for anybody who can log on to the NT server as adminstrator.However if users log on to the server as a different user (which is what everybody does), we get lots of errors when people try to use enterprise manager.When a user logs on to the SQLServer through enterprise manager, it gives a message about not being able to find something.DTS basically crashes enterprise manager,if we do a return all rows through enterprise manager, we get an error that says "Unknown error"It all feels like an access problem to a dll or another code module. Does anybody have any ideas how we can fix this, Without rebuilding the server?RobEdited by - robwhittaker on 03/04/2003 06:32:32 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-04 : 07:23:40
|
| Is EM still being run through Citrix? If it is, I'm more inclined to think that the problem lies there, or in some weird interacation between the two. It's not like Citrix runs everything perfectly. And if the admins can run EM without any problems, then it might be some obscure rights issue (registry settings, file/folder permissions, network rights, etc.) |
 |
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2003-03-04 : 12:08:51
|
| It's worked fine through citrix for over a year, I think that bit is a bit of a redherring.If I log on to the NT server directly, not through citrix, just as a normal user I get the same errors. However if I log on to the box as administrator all is fine. This does suggest it's a rights issue. I was more wondering if anybody else has had a similar problem, so that I know what libraries etc to look at. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-04 : 15:14:00
|
| I hope that when you use EM to return all rows that you are doing this on a non-production database. You should never return all rows from production for a table using EM. You shouldn't do it using QA either, but EM is the worse of the two.Tara |
|
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2003-03-05 : 04:19:49
|
| I tend not to use EM at all, but one of the programmers we have use it to load(DTS) data in to a database once a month. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-10 : 23:33:40
|
| The actual errors would help diagnose the problem.-Chad |
|
|
|
|
|
|
|
|
I hate enterprise manager