Link to home
Start Free TrialLog in
Avatar of acetate
acetate

asked on

SQL 2000 remote enterprise manager - how to save settings for multiple domain users???

hello,

i have SQL 2000 client connectivity tools loaded on a xp pro client. i want to setup databses for all domain users logging onto the pc. i logged on as administrator, setup and registered the databases, but when i log on as another user the setttings are lost. are the settings held in a file somewhere under the administrator profile on the client pc? how do i setup the enterprise manager once and  make sure its setup for all users logging onto the xp pro client?

anyone else have this situtation? please advise

thanks
Avatar of curtis591
curtis591

Does it work if you copy the file from the Documents and Settings\User\Application Data\Microsoft\MMC into the All Users directory with the same directory structure?
Avatar of acetate

ASKER

ok, i will try this one and let you know
Avatar of acetate

ASKER

ok, on my pc, i cut the file out of my profile and started up enterprise manager and my settings where still there, so i think this wont work
ASKER CERTIFIED SOLUTION
Avatar of SNilsson
SNilsson
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of acetate

ASKER

hi snilsson,

yes, thanks for that. i have found the server names is this key. now by question, how to i import these keys into the all users profile registry?

thanks
Avatar of acetate

ASKER

my users are restrcited users, so they cant import registry settings into there profiles also

You can do an export in the registry editor, then import it in each userprofile.

Maybe there is a way to do it for all profiles at once, but I dont how to automate that :(

Im sure there is some kind of free registry copy tool somwhere if you check around some.
Thank you acetate, sorry that I could not be of more help.

I have had this problem also a few month ago, I did not find any clear answer and I ended up with register it all over again in EM :(

If you do find a solid solution please do post here, so that others can be helped.
Avatar of acetate

ASKER

yes, no worries, at least i know it can be done if the users have access to the registry, i will manually setup too, but i will post up if i work it out
 thanks again