Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Connection cannot be established in SQL 7.0 database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-04 : 11:26:33
Mr Lim writes "To whom it may concern,

Currently, I am using the below mentioned system:

Standalone SQL Server:
1) Pentium III 650 with 512MB SDRam PC100
2) Windows NT 4.0 Server(Service Pack 6)
3) SQL 7.0 database(Service Pack 3)

Recently these few days as I execute this SQL Enterprise Manager(at my standalone server, not from client to server) and click on my server name to view the database, a message will be prompted out and say:

"A connection cannot be established, Timeout expired"

Hence, I wouldn't be able to see all my databases,
and connection failed would be indicated. However, the SQL is
still running(with a green arrow indication, but there is no red curly line beside it)fine but can't be connected. Really crack my head... Have restart server, have stop the SQL and start again, but still cannot work.

However, if I install this SQL in my workstation and pointed out to my server database, I could view all the database.

Is there some linkage problem in my SQL 7.0 server???

Greatly appreciate your advise on this area.

Thank you very much and have a nice day.


Best Regards
Mr Lim"
   

- Advertisement -