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
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
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?
ASKER
ok, i will try this one and let you know
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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.
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.
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
thanks again