MS SQL Server - New Install

Author

New Install - [WildPacket]

WILDPACKET

2006-10-24, 6:30 pm

I am new with SQL 2000. Last night I installed SQL 2000 and attached a
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.

DB2DOTNETCZAR via SQLMonster.com

2006-10-24, 6:31 pm

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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200609/1

Sponsored Links