Re: SQL Server 2000 SP4 client connection problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sorry. I can't think of any more troubleshooting steps short of calling Customer Support.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Charles Calvert" <cbciv@xxxxxxxxx> wrote in message news:te9us35insoighok3nt2eohd4ssi5uugl1@xxxxxxxxxx
On Fri, 29 Feb 2008 09:25:21 -0800, "Rick Byham, \(MSFT\)"
<rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
<1B5E3165-0528-47F5-B916-FA74AAA1DEC4@xxxxxxxxxxxxx>:

Have you checked for other errors in both the Windows event log and the SQL
Server log particularly on the SQL Server computer?

I did and found nothing.

In Management Studio on the SQL Server computer, connect Object Explorer,
right-click the server name, and then click Properties.
On the Security tab, select login auditing; Both failed and successful
logins. Try connecting again, and check both logs.

I'm using 2000, but found the equivalent setting in Enterprise
Manager, set it, restarted and tried again.

The login was recorded as being successful in the server's event log
and the SQL Server log. Even after terminating the hung Query
Analyzer process on ClientB, there were no errors in the server's
event log or SQL Server log.

I have noted one thing; when Query Analyzer gets hung on ClientB, the
server can't seem to create any new Windows Explorer windows or
Management Console windows (such as the event viewer) until the Query
Analyzer process is terminated. This makes me wonder if SQL Server is
locking a mutex or other synchronization object on the server and not
letting go until the connection has completed.

I had another idea. I tried the following:

osql -E -S [ip address] -d master -Q "SELECT name FROM sysobjects"

It also hung, so the trusted vs. untrusted connection doesn't seem to
make a difference.
--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research

.

Relevant Pages

  • Re: SQL Server 2000 SP4 client connection problem
    ... Server log particularly on the SQL Server computer? ... Analyzer process on ClientB, there were no errors in the server's ... server can't seem to create any new Windows Explorer windows or ...
    (microsoft.public.sqlserver.connect)
  • Re: Errors during DTS package
    ... The server log is just ... >>index corruption within SQL Server. ... >>Greg Linwood ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • why the jobs did not run?
    ... Its job history ... shows the last full backup was done successfully on 1/2. ... I've checked the server log. ... Seems the SQL server was restarted on 1/6. ...
    (microsoft.public.sqlserver.server)
  • Re: why the jobs did not run?
    ... is SQL server agent running? ... > I've checked the server log. ... Seems the SQL server was restarted on 1/6. ...
    (microsoft.public.sqlserver.server)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)