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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2002-09-10 : 09:44:15
|
| Mr Lim writes "To whom it may concern,Recently when I try to connect my SQL 7.0 database(in my standalone server) , it does not allow me to do that. A dialog window stated: "A connection cannot be established- Timeout expired".However, the SQL database is started but the problem is it can't establish an connection. There is a green arrow(indicate started) but can't see the red curly line(no connection established). Consequently, I can't see all my database folder, management folder and etc...I tried to install the service pack 3, but got this error message:"Error running script upgrade.sql(1)" in the process.The installation is incompleted and exit itself from the process(installation).Urgently looking a solution. Really crack my head.Please kindly advise me on this issue. If possible and convenience, please forward the advice to myemail: kokhong_lim@dimerco.com.Appreciate your help and guidance.Thank you very much.RegardsMr Lim" |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-09-10 : 10:40:24
|
| Go in enterprise manager, click tools then option, go to advanced and set a connection time-out of 3000, that's the limit |
 |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|