database which went well. Whiel doing all this I was logged in as the domain
administrator.
If I log in as the Administrator adn open the SQL Enterprise Manager I see
all the DBs but when I logon with my account which also has admin rigths and
I open the SQL Enterprise Manager I see no DBs no nothing ... ?
How can I see all with my person ADM account?
Advise Please.
Thank you in advance.
Hi,
I am afraid, that you must register your local server with Enterprise Manager.
Next when installing SQL Server 2000, you must have chosen Domain Account\
User.
This will prevent access to other users from accessing SQL Server.
Try to login back as an Administrator and under Security Add your ADM
username under the list of users.
And make sure that under Database Access, you choose the database that the
user needs access.
Things should work fine ;)
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
No comments:
Post a Comment