RE: SQLCMD fails with login timeout expired.

Hello Morris,

First I'd like to confirm the instance name of the server. Is it
SQLExpress? If so, you shall use instance name 'Sqlservername\SQLEXPRESS'.
Please note sqlservername shall be the compupter name of your server.

It seems that you don't have TCPIP enabled for the instance. Did you check
the server confgiruation for the instance.

Also, please check the errorlog and make sure TCPIP is actually enabled:

C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG\errorlog

For exmaple, check if there is a line like following:

2007-07-12 03:17:05.25 Server Server is listening on [ 'any' <ipv4>
3167].

Is the SQLbrowser service running properly?

If the issue still occurs, please send the errorlog to me, and please
remove Online from my displayed email address.

I look forward to your update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.




.

Relevant Pages

  • =?Utf-8?Q?MSDE_2000_SP4_l=C3=A4=C3=9Ft_sich_unter_Wi?= =?Utf-8?Q?nXP_SP2_NICHT_installieren?
    ... "Das Setup-Programm konnte den Server nicht konfigurieren. ... Habe das Errorlog durchgeschaut; ... Dienstkontroll-Managers wird SQL Server beendet. ...
    (microsoft.public.de.german.windowsxp.applications)
  • =?Utf-8?Q?MSDE_2000_SP4_l=C3=A4=C3=9Ft_sich_unter_Wi?= =?Utf-8?Q?nXP_SP2_NICHT_installieren?
    ... "Das Setup-Programm konnte den Server nicht konfigurieren. ... Habe das Errorlog durchgeschaut; ... Dienstkontroll-Managers wird SQL Server beendet. ...
    (microsoft.public.de.sqlserver)
  • Re: Unable to connect to server
    ... I don't see MasterPlan starting up during server startup - take a look at ... >>What does your errorlog say? ... >>> restarting your SQL ...
    (microsoft.public.sqlserver.security)
  • Re: dbcc errorlog fails
    ... I tested the command on another server. ... The log size for errorlog. ... What process would be locking the errorlog file? ... > are viewing the logs in Enterprise Manager, ...
    (microsoft.public.sqlserver.server)
  • Re: SQLAgent$SBSMONITORING
    ... Copyright 1988-2003 Microsoft Corporation ... 2004-09-03 09:21:56.07 server All rights reserved. ... 2004-09-03 09:21:56.18 server SQL Server is starting at priority class ... > look at the ERRORLOG file to see if it gives an indication as to why it's ...
    (microsoft.public.backoffice.smallbiz2000)