Post reply

using full computer name as database engine-instance to login does not always work

  • September 9, 2010 at 9:16 am

    #226676

    Hello all admins,

    I am facing a strange situation which is described as following:

    I have some instances of SQL Server 2008 database engines and Reporting Services on a domain.

    1) Some of them can be used (localy and remotely) with both simple computer name AND fully qualified computer name (domain name included e.g: computername.domain.com or computername.domain.com\instancename when its not the default instance)

    2) Some of them can be used (localy and remotely) ONLY with fully qualified computer name (domain name incuded e.g: computername.domain.com or computername.domain.com\instancename when its not the default instance)

    3) Some of them can be used (localy and remotely) ONLY with simple computer name (without domain name incuded e.g: computername or computername\instancename when its not the default instance)

    I cannot understand why can't i use fully qualified computer name for some of them. Is it a DNS matter or SQL Server configuration? Is it something else i should check?

    Some are default instances and some are named instances, same problem. I was checking their confuguration to find some difference with the ones accepting connection with fully qualified computer name but nothing seems to be different on the SQL Server configuration side...

    Did anyone faced this problem before?

    Any answer would be much appriciated...

    Thomas

  • September 9, 2010 at 12:06 pm

    #1218831

    Hi,

    You should be able to connect using the fully qualified domain name. Check if you are writing the right domain name & if there are more than 1 domain then you should check that all domains are trusted by each other (take help by networking team for this information).

    Also did you try writing the entry in the host files of the servers?

    -Sujeet

    Sujeet Singh

  • September 10, 2010 at 2:47 am

    #1219039

    Hi Grasshoper,

    thank you for taking the time to reply.

    I would think of the same think as you say above. But the problem ocurs even when I am using Management Studio localy loged on the current machines having the instances installed...:w00t:

  • September 10, 2010 at 2:51 am

    #1219043

    what kind of error you getting?

    Have you tried by putting the name in [ ] if the name have space or some special characters like '-' or ......

    ----------
    Ashish

  • September 10, 2010 at 5:57 am

    #1219104

    problem solved

    they didn't have TCP/IP Enabled nor the Browser :$:-D

    Thank you anyway

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

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