Post reply

Not able to see the instance name in the list

  • October 17, 2011 at 9:19 am

    #244736

    Experts,

    Another team has installed SQL Server 2008 Database engine in one of the server.

    But the I am not able to see the instance name in the list.

    I opened the discovery report that's available in SQL 2008. Report says, The DB Engine is present.

    Can anyone tell me how can I connect to that instance.?

    What all could be the reasons for this issue..?

    Thanks in advance.

    Smith.

  • October 17, 2011 at 9:26 am

    #1395406

    But the I am not able to see the instance name in the list.

    Crosscheck if SQL Server Browser Service is running on the server.

    The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

    •Browsing a list of available servers

    •Connecting to the correct server instance

    •Connecting to dedicated administrator connection (DAC) endpoints

  • October 18, 2011 at 12:10 am

    #1395700

    Thanks.

    Browser service is started anyway.

    Curious, When there's only one instance, will that make any difference ?

    Thanks again,

    Smith.

  • October 18, 2011 at 12:53 am

    #1395711

    Curious, When there's only one instance, will that make any difference ?

    If the SQL Server Browser service is not running, you are still able to connect to SQL Server if you provide the correct port number or named pipe. For instance, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.

  • October 18, 2011 at 1:20 am

    #1395717

    Is it a default instance, or a named instance? SQL Server Browser will only resolve named instances, as far as I know.

    John

  • October 18, 2011 at 2:21 am

    #1395735

    John Mitchell-245523 (10/18/2011)

    Is it a default instance, or a named instance? SQL Server Browser will only resolve named instances, as far as I know.

    John

    It's default instance. Any other idea ?

  • October 18, 2011 at 2:32 am

    #1395737

    If it's not listening on the default port (1433) then, as Dev explained, you will need to supply the port number when you connect - something like this: MYSERVER,9999. If you don't believe in security by obscurity then you should always install SQL Server as a named instance to avoid this problem.

    John

  • October 18, 2011 at 5:29 am

    #1395823

    That'f fine. What I dont understand is, why is it not appearing in the "servers list" when I click open the Browse...

    Or Do you want me to confirm with the team if they have relay installed the DB Instance.? Or just they installed other features..?

    Will it be right if I ask them such a question.... they too are professionals.... 🙂

  • October 18, 2011 at 5:35 am

    #1395826

    I'm not an expert on how server discovery works, but I'd imagine that it interrogates SQL Server Browser and looks for anything listening on 1433. That would explain why your server is being missed.

    John

Viewing 9 posts - 1 through 8 (of 8 total)

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