RE: Unable to connect to SQL Server 2005, the service is running..

The network is OK, i couldn't even connect to sQL from the server itself.

the protocol that are enabled is TCP/IP and named pipes.

Currently i only have one server at this time

Thanks
Joko

"Saleem Hakani" wrote:

Did you check the network connection? I've heard many customers complaining
the same and upon investigation it's found that their network admin resets
the network router. If the above is not the issue then it would be helpful to
know what netlib are you using? TCP/IP, Named Pipes? Are you experiencing
this on only one SQL Server on the same switch or other SQL Servers as well?

HTH

Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
SQLTips, SQL Automation Tools/Scripts, SQL Articles, SQL Blogs, SQL Forums,
etc


"Joko" wrote:

Every morning, i have been experiencing this problem with my test server.
i unable to connect to SQL using Management Studio, oSQL, ODBC, Query
Analyzer from other computer at all.

I migrated SQl server from sql 2000 into SQL 2005 two weeks ago
i have iinstalled service pack 2, change the remote connection enabled.
i looked at the SQL log and i don't see anything related why the server is
not responding.

Currently the only way to be able to connect to sQL is by rebooting the
server.

Any information?
Thank you very much for your help

.

Relevant Pages

  • RE: SQL Server 2000 SP4 - Intermittent timeout/connection issues
    ... With a network problem nothing is ever simple dealing with sql. ... Could you put an LMHosts file on the web servers to the sql server ...
    (microsoft.public.sqlserver.server)
  • Re: Irritating SQL 2000/2005 connection problem
    ... installed on our network anywhere. ... SqlConnection) to connect to a SQL 2000 database with a connection string ... When connecting to SQL ... Server 2005, this failure may be caused by the fact that under the default ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL2005 Failed when installing SP2
    ... Somehow the name of the Virtual Server already existed on the network. ... It may be that the system tried to start SQL on both nodes at the same time. ... I would move both instances to the same node and attempt to complete the SP install. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connection from remote computer to network SQL Server
    ... by default connectin to SQL Express from the network is disabled ... There is no firewall on the W2K machine acting as the SQL server. ... connection works. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Random NT Authority/Anonymous Login Errors - REALLY NEED HELP.
    ... After disabling the TCP/IP network settings in SQL Server and using Named ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet)
Loading