My Window XP professional PC has SQL 2000 Client tools
installed.
SQL Client tools : SQL 2000 SP3
SQL Servers : SQL 2000 SP3
I also registered a few SQL servers in the Enterprise
Manager. Whenever I logged off and logged back on again,
I lost all the servers registration.
I noticed that when I exited Enterprise Manager, it
modified the file "C:\Program Files\Microsoft SQL Server\80
\Tools\BINN\SQL Server Enterprise Manager.MSC"
Is there any other files to be modified to keep the
registered settings e.g registry etc ?
Any ideas to save the settings when I log back on again ?
Thanks.I don't think I am the administrator of my machine. All
the machines here have to be applied "Local security
policy".
And I needed to know what registry settings and files
needed to keep the SQL server registration settings of
Enterprise Manager. Thus I can tell the network
administrator of what kind of permissions I needed.
Showing posts with label registration. Show all posts
Showing posts with label registration. Show all posts
Wednesday, March 7, 2012
EM Deny Registration
How can one deny registration of a particular SQL Server
through Enterprise Manager and still be able to open a
query analyzer and access the target database of that
particular server (read only)? My problem is some users
had a green light from above to have an Enterprise
Manager installed on their server but yet have very
little experience navigating it. I am afraid if they
registered this particular server and accidentally open a
table (all rows). I can not deny them access completely
since they need to have read access from the database.Hi,
You cant restrict EM alone. If the user have access then they will be able
to register in EM.
Thanks
Hari
SQL Server MVP
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>|||LD
You can restict permissions to do any operations per database. Let me say if
the user has not permissions to operate with a database XXX ,so he will not
be able to get in vs EM.
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>
through Enterprise Manager and still be able to open a
query analyzer and access the target database of that
particular server (read only)? My problem is some users
had a green light from above to have an Enterprise
Manager installed on their server but yet have very
little experience navigating it. I am afraid if they
registered this particular server and accidentally open a
table (all rows). I can not deny them access completely
since they need to have read access from the database.Hi,
You cant restrict EM alone. If the user have access then they will be able
to register in EM.
Thanks
Hari
SQL Server MVP
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>|||LD
You can restict permissions to do any operations per database. Let me say if
the user has not permissions to operate with a database XXX ,so he will not
be able to get in vs EM.
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>
Subscribe to:
Posts (Atom)