none
What is the name of my SQL/Server?

Answers

  • Unfortunately you don't provide enough info about what exercise you are doing so let me guess:

    - based on the http link, I think you need to replace it with your computer name or IP and NOT the sql server name which may be different from the computer name.
    - as for the computer name, use HOSTNAME or IPCONFIG from command prompt or go to Control Panel/System.
    - port number 8080 is also configurable: it depends on what port has been specified when configuring it. Most likely it is the same port 8080.

    Thanks,

    Varsham Papikian, New England SQL Server User Group Executive Board, USA
    New England SQL Server User Group; My LinkedIn page
    Please remember to click the "Mark as Answer" button if a post helps you!
    Friday, January 22, 2010 12:57 AM
  • If I look at the resulting string, I think the server name (HOST_NAME()) needed:

    select @@servername
    
    http://SRV\INSTANCE:8080/NorthwindDataCacheSyncService/
    
    
    SELECT HOST_NAME()
    
    http://SRV:8080/NorthwindDataCacheSyncService/
    



    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Friday, January 22, 2010 6:40 AM
    Moderator

All replies

  • Unfortunately you don't provide enough info about what exercise you are doing so let me guess:

    - based on the http link, I think you need to replace it with your computer name or IP and NOT the sql server name which may be different from the computer name.
    - as for the computer name, use HOSTNAME or IPCONFIG from command prompt or go to Control Panel/System.
    - port number 8080 is also configurable: it depends on what port has been specified when configuring it. Most likely it is the same port 8080.

    Thanks,

    Varsham Papikian, New England SQL Server User Group Executive Board, USA
    New England SQL Server User Group; My LinkedIn page
    Please remember to click the "Mark as Answer" button if a post helps you!
    Friday, January 22, 2010 12:57 AM
  • Try

    select @@ServerName
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Friday, January 22, 2010 2:49 AM
    Moderator
  • If I look at the resulting string, I think the server name (HOST_NAME()) needed:

    select @@servername
    
    http://SRV\INSTANCE:8080/NorthwindDataCacheSyncService/
    
    
    SELECT HOST_NAME()
    
    http://SRV:8080/NorthwindDataCacheSyncService/
    



    Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
    Friday, January 22, 2010 6:40 AM
    Moderator