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 |
|
JamesN
Starting Member
2 Posts |
 Posted - 2002-02-12 : 12:33:22
|
| Just recently its come to my attention that the company SQL server will only allow connections with Enterprise Manager via one machine! This is a strange problem considering any machine can connect with a query analyser session. No amount of fiddling has resolved this problem, does anyone have any ideas? The server is Win2K SP2 with SQL Server 2000 and has a 30 seat license...Thanks! |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-12 : 14:13:19
|
| Not without symptoms/error messages. Please post what you do, and the error messages you get.-Chad |
 |
|
|
JamesN
Starting Member
2 Posts |
Posted - 2002-02-12 : 17:33:44
|
| Sorry - the error message is a fairly generic "Timeout expired", occuring at the end of the new sql server registration process in Enterprise Manager. Other sql servers can be connected to fine though! |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-13 : 01:02:19
|
| What net libraries is the server listening on?What net libraries is the client attempting to connect on? Check the client network utility and make sure it is using a net lib that the server is listening on.ThenGo into SEM's 'Tools', 'Options', Advanced tab, and change theTIMEOUT value to 20 seconds.If that doesn't work, try:- Disable the Wizard by checking the box at the bottom of the screen.- This will bring up the register sql server screen.- Enter the Server name and use 'sa' to register the server.- The registration may fail to connect to the server, but it ask whether to go on with the registration or not.- Go ahead with the registration.- In the Enterprise Manager, right click on the server and chose 'Connect'HTH-Chad |
|
|
|
|
|
|
Enterprise Manager timeout