Connection problem, please

I have a server, in datacenter, that have installed a SQL server 2000
standard version
then another PC, in company, need to connect to that SQL server through the
Enterprise Manager.
Althrough I have created both window account or SQL account, I still cannot
connect to that SQL server, it prompt me connOpen(), then access deny or the
server not exist...how to solve it?
thx a lot~Hello.
I don't have an answer to your question but I would advise
that you look at the following.
1) Does the person have access rights to the server (not
SQL) ?
2) Are you using NT Authorisation or mixed mode.
3) Can you user "see" the server though enterprise
manager ? (if not then its a network problem)
4) Does your user have access rights to the database they
are trying to connect to ?
I'm sorry I can't be of more help but there is a lot that
can go wrong.
Can you give actual error messages ?
Peter
>--Original Message--
>I have a server, in datacenter, that have installed a SQL
server 2000
>standard version
>then another PC, in company, need to connect to that SQL
server through the
>Enterprise Manager.
>Althrough I have created both window account or SQL
account, I still cannot
>connect to that SQL server, it prompt me connOpen(), then
access deny or the
>server not exist...how to solve it?
>thx a lot~
>
>.
>