locked
SQL remote port problem RRS feed

  • Question

  • Hi,

    I have installed the SQL server 2008 R2 and have already one instance SQLEXPRESS installed on the same server but my problem is,

    When i am connecting remotely to SQLEXpress it automatically connects by just providing the IP Address or  or host name

    but when i am trying to connect to MSSQLSERVER i have provide 10.11.12.13\MSSQLSERVER,1433

    can you please tell me why this is happening and i want my MSSQLSERVER instance connects only after enterning ip can we do this.

    Thanks,

    Akshay V


    Akshay Vithalkar
    (MCTS) | Windows Server 2008 R2 Server Virtualization
    (MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
    (MCTS) | Windows Server 2008 R2 Active Directory, Configuration
    (MCITP)| Windows Server 2008 Server Administrator
    (MCSA) | WindowsServer2008;

    Tuesday, May 28, 2013 2:07 PM

Answers

  • Hello,

    Please use

    for your default instance:  10.11.12.13
    for your express instance:  10.11.12.13\SQLEXPRESS

    as server name. For a named instance you have to add the instance name with a backslash to the machine name, for a default instance not.


    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Friday, May 31, 2013 10:51 AM
    • Marked as answer by Fanny Liu Tuesday, June 4, 2013 10:20 AM
    Wednesday, May 29, 2013 5:04 AM

All replies

  • When i am connecting remotely to SQLEXpress it automatically connects by just providing the IP Address or  or host name

    This could be your default instance which listens on 1433. Default instance can be connected by just specifiying hostyname.

    but when i am trying to connect to MSSQLSERVER i have provide 10.11.12.13\MSSQLSERVER, 1433

    You are trying 1433 port. Are you sure your named instance listens on 1433? 


    Srinivasan

    Wednesday, May 29, 2013 4:15 AM
  • Hi,

    Yes MSSQLSERVER is a default instance but there is already one instance running as SQLEXPRESS which is installed by Visual Studio 2008 and that's the reason it treating SQLEXPRESS as a default instance.

    Thanks,


    Akshay Vithalkar
    (MCTS) | Windows Server 2008 R2 Server Virtualization
    (MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
    (MCTS) | Windows Server 2008 R2 Active Directory, Configuration
    (MCITP)| Windows Server 2008 Server Administrator
    (MCSA) | WindowsServer2008;

    Wednesday, May 29, 2013 4:45 AM
  • Hello,

    Please use

    for your default instance:  10.11.12.13
    for your express instance:  10.11.12.13\SQLEXPRESS

    as server name. For a named instance you have to add the instance name with a backslash to the machine name, for a default instance not.


    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Friday, May 31, 2013 10:51 AM
    • Marked as answer by Fanny Liu Tuesday, June 4, 2013 10:20 AM
    Wednesday, May 29, 2013 5:04 AM
  • Hi Olaf,

    This works for me.

    Thanks,

    Akshay V


    Akshay Vithalkar
    (MCTS) | Windows Server 2008 R2 Server Virtualization
    (MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
    (MCTS) | Windows Server 2008 R2 Active Directory, Configuration
    (MCITP)| Windows Server 2008 Server Administrator
    (MCSA) | WindowsServer2008;

    Tuesday, June 4, 2013 10:25 AM