Browsing Database Returns "(No Items)"
Posted on 2003-02-24
I saw a posting earlier by Jon_Raymond (07/05/2002) with a similar issue but don't see an answer yet ...
Here's what's happening ...
In Enterprise Manager (EM), on a remote server registration, I can connect to the server without a problem but if I try to expand the databases folder, I get a long pause and then it shows "(No items)". I can go to Query Analyzer (QA) and successfully run "use database" command but if I try to run "select * from sysobjects where type = 'u'" I get the following error ...
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
If I use the object browser in QA, I can see the list of databases but if I try to expand any folder under the database (like "User Tables"), QA churns for a minute and then I get a
[Microsoft][ODBC SQL Server Driver]Timeout expired
I have tried this on separate machines connecting to the remote server including one that just had a fresh SQL Server install and SP3 upgrade.
I thought it might be related to updating to SP3 but since Jon saw this back in July 2002, I guess not.
I then thought it might be some port issue through the router (I'm connecting to a remote server over a VPN) but I could hit this server before okay and no router config has changed. I can browse another remote server on this side of the router though (as well as my local server).
Any ... and I mean ANY ... help will be greatly appreciated!