ADO can run, EnterpriseManager cannot ?

Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data!!
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer" on the server. Either with sa or Windows-Authenticate. (I user the
administrator to login to the server).
Please tell me how to run up the Enterprise Manager? Thanks a lot.Hi
Check that your machine where EM and QA are installed on can actually ping
the SQL Server.
If ADO can connect, so can EM and QA, as long as it can talk to the server.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Can you post the exact error message. Also check out this kb.
http://support.microsoft.com/kb/287932
--
-oj
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> Dear all,
> I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> Using
> this user name and password, and with ADO, I established our website.
> Now the website is still working well,can input data,show data!!
> But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> the
> administrator to login to the server).
> Please tell me how to run up the Enterprise Manager? Thanks a lot.
>|||Thanks to Mike and oj,
I'm running EM and QA on the webserver(With administrator account), not on
the client PC.
The EM and QA can work well before.
One thing is, the webserver may be infected by virus of Spida Worm.
Currently, when I try to run EM or QA, then a long time waiting. Then told
me: connection failed,...
But the website system is still working well.
"oj" wrote:
> Can you post the exact error message. Also check out this kb.
> http://support.microsoft.com/kb/287932
> --
> -oj
>
> "goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
> news:AEC9DFD6-73EE-4D45-8808-EEC0E90583FB@.microsoft.com...
> > Dear all,
> > I'm using SQl Server 2K on a webserver and the sa password is "abcde".
> > Using
> > this user name and password, and with ADO, I established our website.
> > Now the website is still working well,can input data,show data!!
> >
> > But I cannot login to this SQL Server with "Enterprise Manager" or "Query
> > Analyzer" on the server. Either with sa or Windows-Authenticate. (I user
> > the
> > administrator to login to the server).
> >
> > Please tell me how to run up the Enterprise Manager? Thanks a lot.
> >
> >
>
>