locked
what is MS SQL DB host name and DB port number ? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    i just installed HP quality center and ms sql 2008.Now hp quality center need to connect to my my ms sql database its asking me for database host name and data base port number.please help me out how can i find that.

    Thanks

    Friday, April 25, 2014 6:52 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Click Start >> Run
    For SQL Server 2005 Type "SQLServerManager.msc" and click OK
    For SQL Server 2008 Type "SQLServerManager10.msc" and click OK

    This will Open the SQL Server Configuration Manager for you.
    Now in the Left Pane, expand "SQL Server Network Configuration" and click on "Protocols for <InstanceName>"
    Now In the right pane, right-click on the "TCP/IP" protocol and go to properties - In the bottom there is TCP port - 1433(This is default) if your sql instance is other than default it will be dynamic port.

    For host name RUN>>CMD>hostname>> this will provide host name of the server.

    • Proposed as answer by Shanky_621MVP Friday, April 25, 2014 7:23 PM
    • Marked as answer by tracycai Monday, May 5, 2014 10:07 AM
    Friday, April 25, 2014 7:23 PM