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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-03-21 : 07:14:01
|
| Hi,I am using SQL Server 7.I am trying to register one remote server.While registering it shows error like General Network error or Timeout expired.I am trying to do this with ipAddress.Thanx in advance---------------------------Sandesh - The Messanger |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-21 : 07:29:59
|
| Can you ping the IP address ?Damian |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-21 : 18:44:04
|
| Is that specific SQL Server listening on the default port? If not, then you will need to create an alias to it. Can anyone else, who is on the same network as you, register the server? If not, then can you even ping the IP address? If not, then contact your network administrator.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-03-21 : 19:01:51
|
| If you are trying to add a remote server in Enterprise Manager, you might need to increase the connection timeout. In Enterprise Manager, Click on Tool...Options. When the comes up, click on the Advanced tab to configure connection timeout.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2003-03-22 : 00:11:57
|
| Markin: Yes, I can ping that IPAddress.Tara : I am trying with alias only. And no body is having SQL server client to try to register the remote server. so cant check that possibility.Michael : Yes, i am trying to register it from enterprise manager. I think your guess is right, becoz while registering it shows timeout expire within fraction of second. But i didnt find that option to increase connection time out (I am using SQL Server 7).How can i increase connection time out?Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-23 : 20:17:09
|
| You said you are using IP Address, then told Tara you are using an alias.Which is it ?You might just need to register the alias in the network utility.Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-24 : 12:28:19
|
| To increase timeout in Enterprise Manager, go to Tools, then Options, then Advanced. Modify the Login time-out value. In one environment that I used to support, I had to have the time-out value be 60 seconds just to connect to it. I'm pretty happy that I don't have to support that environment anymore because 60 seconds is a long time to wait, especially for the customers.Tara |
|
|
|
|
|
|
|
|
Remote Server Registration