locked
Remote login IN SQL Server 202 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Iwant to Enable Remote login in SQL Server 2012 (OS windows 7) and i have  Enabale TCP/IP In Configuration Manager and port 1433 from window firewall with advance security .ip of my server computer is 192.168.5.250 . now when i pass servername with port ( Sever -   192.168.5.250 , 1433 ) then it is login sucessfully but without port ( Server - 192.168.5.250 ) it is not connecting  . What should be problem ?

    Prem Shah

    Saturday, January 23, 2016 4:46 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    I think  SQL Server Browser is not running on your machine,  start SQL Browser Service

    Thanks

    Shabeer

    • Proposed as answer by Papy Normand Saturday, January 23, 2016 9:00 PM
    • Marked as answer by Eric__Zhang Monday, February 15, 2016 9:55 AM
    Saturday, January 23, 2016 5:04 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    I think  SQL Server Browser is not running on your machine,  start SQL Browser Service

    Thanks

    Shabeer

    • Proposed as answer by Papy Normand Saturday, January 23, 2016 9:00 PM
    • Marked as answer by Eric__Zhang Monday, February 15, 2016 9:55 AM
    Saturday, January 23, 2016 5:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Iwant to Enable Remote login in SQL Server 2012 (OS windows 7) and i have  Enabale TCP/IP In Configuration Manager and port 1433 from window firewall with advance security .ip of my server computer is 192.168.5.250 . now when i pass servername with port ( Sever -   192.168.5.250 , 1433 ) then it is login sucessfully but without port ( Server - 192.168.5.250 ) it is not connecting  . What should be problem ?

    Prem Shah

    SQL server is open through 1433 port, for having connection to the database.

    Many Thanks & Best Regards, Hua Min

    Saturday, January 23, 2016 6:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    What does the error message say?

    Actually, I have tried to reproduce the issue. But the issue cannot be reproduced as both login way will succeed or fail at the same firewall setting.

    One of my setting will work: Inbound Rules> New Rule> Rule Type:Port>Protocal and ports: 1433>Action: Allow the connection>Profile(select all)>Name

    • Edited by Riaon Tuesday, January 26, 2016 8:29 AM
    Tuesday, January 26, 2016 3:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Prem Shah,

    To exclude certain causes, please also enable port 1434.

    Sam Zha
    TechNet Community Support

    Wednesday, January 27, 2016 3:13 PM