Post reply

SQL enterprise amanher

  • March 12, 2009 at 3:25 am

    #127020

    I am able to logon to sql server using localhost, or ., but if I am using the hostname of the server, I am not able to. Get an 'connection actively refused' messahe !

    I am using SQL 2K5 enterprise SP2.

    Any suggestions ?

    Juwel

  • March 12, 2009 at 4:23 am

    #958160

    Hi Juwel

    I know this from other versions of SQL Server. Have a look to the SQL Server Configuration Manager at:

    "Start"->"Programs"->"Microsoft SQL Server 2005"->"Configuration Tools"->"SQL Server Configuration Manager".

    On left tree go to "SQL Server 2005 Network Configuration"->"Protocols for MSSQLSERVER" and ensure that "TCP/IP" is enabled. If not enable it and restart the SQL Server service.

    Greets

    Flo

  • March 12, 2009 at 5:45 am

    #958209

    Hi Flo,

    Thanks for the reply. I have checked config manager and network settings. TCP/IP is enabled and on dynamic ports. is there any place where I can check for the HOSTNAME apart from HOSTS file of server ?

    Thanks in advnace,

    Juwel

  • March 12, 2009 at 5:49 am

    #958215

    Hi Juwel

    Try this on your SQL Server (connected over local host 😉 )

    PRINT @@SERVERNAME

    Greets

    Flo

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply